ASP.NET Oledb data connection

[Guest]

When I try to build a oedb data connection, I got an error message saying
"Invalid path or you have to connect to the server the database is resided".
I can see dataset through Data - Preview dataset. I don't what could be the
problem. Can soemone please help me with this ASP.net beginner's question?

Thanks in advance for any help!

 

[Guest]

Hi,

Is the data source an Access or Excel file?

 

[Jan Bannister]

Hi Rakesh,

ODBC will connect to both of those sources.

Hope that helps,
Jan

 

[Jan Bannister]

How are you an MVP???

 

[Cor Ligthert [MVP]]

Frank,

About what you ask are thousand possibilities how you do this. By instance
the programming language, however maybe more important, how do you make the
code for the connection. Do you use a designer and than how?

As you said you are a beginner, do I suppose that you use the dataadapter,
which is a wizard. Did you do all the tests which are in that?

Cor

 

[Guest]

Dear Jan,

I wanted to find whether he was using a file or non-file based data source
or not.

If it something like Access or XLS, then security permissions come into play.

 

[Jan Bannister]

Hey Rakesh,

Since both of the sources you mentioned are files then there is no way
(and should be no way) to circumvent file access issues.

Jan

 

[Guest]

Dear Jan,

You understood my post wrong. Sorry if the message wasn't clear.

Frank says, he is using OleDb and the error message also mentions about
'path'. In many cases, if it's an OleDb connection, the data source could be
an Access or Excel file.

I wanted to find out whether Frank is using either Access/Excel or a
non-file based data source.

If it's Access/Excel, then OleDb needs to create temporary files to open the
data source. Unless ASPNET or the impersonated user has modify privilages to
folders having these files, you will get an error. I have mentioned this here:
http://msmvps.com/rakeshrajan/archive/2005/07/04/56461.aspx

I just wanted to check whether Frank was facing something related to this.

 

[Jan Bannister]

My Mistake Rakesh,

The previouse questio ndidn't appear in my view of the thread.

Jan

 

[Guest]

Sorry. Please accept my apology for late response. I was away this weekend.
The database is in Access.
Thanks!

 

[Guest]

Sorry for late response. Thanks for your help!
After I put my ACCESS database in c:\innetpub, I can access the database
successfuly. But I wonder why I can not to connect to network drive even the
test connection is successed when I tried wizard. Now I hardcoded path in
connection string.

 

[Cor Ligthert [MVP]]

Frank,

For a access database you probably want to update. Beside that you need
therefore to get on the drive, does the accessfile as well needs almost full
rights,

I hope this helps,

Cor