SQL About AMO: path

Showing posts with label path. Show all posts

Sunday, March 25, 2012

Access Database

When i set up an odbc connection to a access database on a network path. I
get an error saying the path is invalid. I am running SP2 . I can use the
same odbc datasource to connect using excel on the report server but not
using any reports.When you are running the report in production remember the path is relative
to the report server, not your workstation. perhaps that is the problem
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ganesh" <Ganesh@.discussions.microsoft.com> wrote in message
news:8F43DC51-A2AF-46CE-962A-995CDD504BF8@.microsoft.com...
> When i set up an odbc connection to a access database on a network path. I
> get an error saying the path is invalid. I am running SP2 . I can use the
> same odbc datasource to connect using excel on the report server but not
> using any reports.|||i use the unc path to the shared folder on the network. It works fine from
the designer.
"Wayne Snyder" wrote:
> When you are running the report in production remember the path is relative
> to the report server, not your workstation. perhaps that is the problem
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Ganesh" <Ganesh@.discussions.microsoft.com> wrote in message
> news:8F43DC51-A2AF-46CE-962A-995CDD504BF8@.microsoft.com...
> > When i set up an odbc connection to a access database on a network path. I
> > get an error saying the path is invalid. I am running SP2 . I can use the
> > same odbc datasource to connect using excel on the report server but not
> > using any reports.
>
>|||Yes, but does the account the report is running under have rights to that
unc path?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ganesh" <Ganesh@.discussions.microsoft.com> wrote in message
news:1FD8B93F-0179-4892-A787-11E3C904CB1A@.microsoft.com...
>i use the unc path to the shared folder on the network. It works fine from
> the designer.
> "Wayne Snyder" wrote:
>> When you are running the report in production remember the path is
>> relative
>> to the report server, not your workstation. perhaps that is the problem
>> --
>> Wayne Snyder, MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> www.mariner-usa.com
>> (Please respond only to the newsgroups.)
>> I support the Professional Association of SQL Server (PASS) and it's
>> community of SQL Server professionals.
>> www.sqlpass.org
>> "Ganesh" <Ganesh@.discussions.microsoft.com> wrote in message
>> news:8F43DC51-A2AF-46CE-962A-995CDD504BF8@.microsoft.com...
>> > When i set up an odbc connection to a access database on a network
>> > path. I
>> > get an error saying the path is invalid. I am running SP2 . I can use
>> > the
>> > same odbc datasource to connect using excel on the report server but
>> > not
>> > using any reports.
>>|||I have a similar problem, which is almost certainly a permissions problem in
the target shared directory. When you say "Account the report is running
under" are you talking about stored credentials in the RDS (which do not seem
to work) or a SYSTEM account that RS is using to try to access this shared
dir. I have had no luck whatsoever so any assistance tyou could render would
be most appreciated.
Thanks
Mark
"Bruce L-C [MVP]" wrote:
> Yes, but does the account the report is running under have rights to that
> unc path?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ganesh" <Ganesh@.discussions.microsoft.com> wrote in message
> news:1FD8B93F-0179-4892-A787-11E3C904CB1A@.microsoft.com...
> >i use the unc path to the shared folder on the network. It works fine from
> > the designer.
> >
> > "Wayne Snyder" wrote:
> >
> >> When you are running the report in production remember the path is
> >> relative
> >> to the report server, not your workstation. perhaps that is the problem
> >>
> >> --
> >> Wayne Snyder, MCDBA, SQL Server MVP
> >> Mariner, Charlotte, NC
> >> www.mariner-usa.com
> >> (Please respond only to the newsgroups.)
> >>
> >> I support the Professional Association of SQL Server (PASS) and it's
> >> community of SQL Server professionals.
> >> www.sqlpass.org
> >>
> >> "Ganesh" <Ganesh@.discussions.microsoft.com> wrote in message
> >> news:8F43DC51-A2AF-46CE-962A-995CDD504BF8@.microsoft.com...
> >> > When i set up an odbc connection to a access database on a network
> >> > path. I
> >> > get an error saying the path is invalid. I am running SP2 . I can use
> >> > the
> >> > same odbc datasource to connect using excel on the report server but
> >> > not
> >> > using any reports.
> >>
> >>
> >>
>
>sql

Thursday, March 8, 2012

Absolute path information is required. (mscorlib)

Installed SQL2005 Advisor on a XP Professional machine.
I get this message when I launch the program.
Absolute path information is required. (mscorlib)
Please help, I need to resolve it.I did a quick search and could not find that exact error msg but it looks
like a problem with the .net framework install. You might try uninstalling
the .net framework and reinstalling it. Make sure you are using the latest
version of the Advisor tool and the latest .net2.0 framework, not any Betas.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> Installed SQL2005 Advisor on a XP Professional machine.
> I get this message when I launch the program.
> Absolute path information is required. (mscorlib)
> Please help, I need to resolve it.|||Thank you, I did the same thing as well. I am running the most current
versions of both. Uninstalled netframework and reinstalled. Same issue.
If anyone else has a hine please feel free.
"Andrew J. Kelly" wrote:
> I did a quick search and could not find that exact error msg but it looks
> like a problem with the .net framework install. You might try uninstalling
> the .net framework and reinstalling it. Make sure you are using the latest
> version of the Advisor tool and the latest .net2.0 framework, not any Betas.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> > Installed SQL2005 Advisor on a XP Professional machine.
> >
> > I get this message when I launch the program.
> >
> > Absolute path information is required. (mscorlib)
> >
> > Please help, I need to resolve it.
>
>|||Sounds like a bug then. You may need to give MS PSS a call. If it is a bug
they will refund your money. But otherwise it will cost about $225.
--
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:BD75850A-7A5D-461D-BCF8-E1B4FBCD66FE@.microsoft.com...
> Thank you, I did the same thing as well. I am running the most current
> versions of both. Uninstalled netframework and reinstalled. Same issue.
> If anyone else has a hine please feel free.
> "Andrew J. Kelly" wrote:
>> I did a quick search and could not find that exact error msg but it looks
>> like a problem with the .net framework install. You might try
>> uninstalling
>> the .net framework and reinstalling it. Make sure you are using the
>> latest
>> version of the Advisor tool and the latest .net2.0 framework, not any
>> Betas.
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in
>> message
>> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
>> > Installed SQL2005 Advisor on a XP Professional machine.
>> >
>> > I get this message when I launch the program.
>> >
>> > Absolute path information is required. (mscorlib)
>> >
>> > Please help, I need to resolve it.
>>

Absolute path information is required. (mscorlib)

absolute path information is required

Hi all,
When i transfer my c#.net project to other computer,the report part of my project that worked correctly in my computer,did not work and give me this error :
"absolute path information is required"
what is my problem? i use access database for my reports
I try to create a blank report with no database,but i get this error again.
thanks for your help.Would you please send your code for loading, showing report.
I want to know, if you used untypedreport or typedReport,
WebApplication or windows application.|||public class ReportForm : System.Windows.Forms.Form
{
Thread waitThread;

ProgressBarForm pb;

private CrystalDecisions.Windows.Forms.CrystalReportViewer reportViewer;

private Reports.PulseReport pulseRpt = new Swiching.Reports.PulseReport();
private Reports.AllPulseReport allpulseRpt = new Swiching.Reports.AllPulseReport();
...
...
...

public ReportForm(string type)
{
InitializeComponent();
this.reportViewer.ReportSource = this.pulseRpt;
}

public ReportForm(string type,FileConnect.customer[] p,string bdLabel)
{
InitializeComponent();

waitThread = new Thread(new ThreadStart(wait));
waitThread.Start();
int temp;

TextObject beginRp = (TextObject)this.allpulseRpt.Section1.ReportObjects["beginRp"];
beginRp.Text = bdLabel;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =@."......Data Source=""Swiching.mdb""......";
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
conn.Open();
string ffirst = Config.GetNum("FirstNum");
string fcap = Config.GetNum("CapNum");

for(int counter = 0;counter < int.Parse(fcap);counter++)
{
temp = int.Parse(ffirst)+counter;
cmd.CommandText = @."insert into pulse values("+temp.ToString()+","+p[counter].city.ToString()+","+p[counter].intercity.ToString(+","+p [counter].national.ToString()+")";
cmd.ExecuteNonQuery();

}
conn.Close();
this.reportViewer.ReportSource = this.allpulseRpt;

}

private void wait()
{
pb = new ProgressBarForm();
pb.ShowDialog();
}

private void ReportForm_Load(object sender, System.EventArgs e)
{
pb.Close();
}

}

When i transfer my project to other computers and call ReportForm with each of above constructors i get "absolute path infomation is required" error.|||Hi.
Where do you load report? Is it typedReport?
I read your code. But I didn't understand where you set datasource of report. It seems you connect to database directlly.

I am sorry. I don't know reason. But you can examin
Initialize reportClass PulseReport in constructor, no difinition.
Try showing report without any datbase fields.
Trace code to find exact line of error
load report by using path, not instance of typedreportdocument.|||Try hardcoding the path into your connection string
Data Source=""Swiching.mdb""......";

should be

Data Source=""D:/anywhere/data/Swiching.mdb""......";|||Hi all and thanks for your reply

I add following code after InitializeComponent() :

crConnectionInfo.ServerName = Application.StartupPath + @."\swiching.mdb";
crDatabase = allpulseRpt.Database;
crTables = crDatabase.Tables;
for (int i = 0; i < crTables.Count; i++)
{
crTable = crTables [i];
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
rTable.ApplyLogOnInfo(crTableLogOnInfo);
}

Then I try to install my program on 6 computers and i found that only two computers have this problem and my report run correctly on other computers !!!
All computers have Windows XP SP2.

Dear zdehkordi ,i load report by following code in other form :

if(type == 1)
{
ReportForm rf = new ReportForm("AllPulse",p,bdLabel,edLabel);
rf.Show();
}|||Sounds like the directory structure is different on those two computers.
How does it differ from the others?
Are all the components in the right place?
Is Application.StartPath declared and valid?

Saturday, February 11, 2012

About Endpoints

When I constructed my endpoint:

CREATE ENDPOINT MyNewEndPoint
STATE = STARTED
AS HTTP
(
PATH = '/MyEndpoint',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = 'arkansas'
)
FOR SOAP
(
WEBMETHOD 'GetSession'
(NAME='MyDB.dbo.spGetSession'),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = 'MyDB',
NAMESPACE = 'http://MyDB/MyEndpoint'
)

the site is hardcoded. But, when I'm getting ready to deploy I'll need the site to be my production site. Is there an easier way to accomplish this then to edit the script each time before delpoyment?

TIA,
Dave C.

Hi Dave,

I assume you have some kind of a setup script or procedure? If that's the case, you could do this:

(a) Create the endpoint always with the hardcoded script above

(b) Bootstrap a small script execution with an ALTER ENDPOINT statement. For instance use SQLCMD.EXE like this:

SQLCMD.EXE -E -S. -Q"ALTER ENDPOINT MyNewEndPoint..."

or -of course- you could simply create the endpoint this way.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

About Endpoints

When I constructed my endpoint:

TIA,
Dave C.

Hi Dave,

I assume you have some kind of a setup script or procedure? If that's the case, you could do this:

(a) Create the endpoint always with the hardcoded script above

(b) Bootstrap a small script execution with an ALTER ENDPOINT statement. For instance use SQLCMD.EXE like this:

SQLCMD.EXE -E -S. -Q"ALTER ENDPOINT MyNewEndPoint..."

or -of course- you could simply create the endpoint this way.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Sunday, March 25, 2012

Access Database

Thursday, March 8, 2012

Absolute path information is required. (mscorlib)

Absolute path information is required. (mscorlib)

Absolute path information is required. (mscorlib)

absolute path information is required

Saturday, February 11, 2012

About Endpoints

About Endpoints

SQL About AMO

Blog Archive

About Me