ODBC connection question

[reisende]

Hi everybody.

I just have a question about a system DSN I've set up.

We have an employee list in a DBF table I'm trying to access that resides on one of our file servers.

I created a system DNS to connect to it and a data link file to test the connection, which works fine.

When I try to create an ADODB connection in an ASP page, however, I get the following error:

[tt]Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC dBase Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/dbf_test.asp, line 28[/tt]

It will work when I copy the table to my local C: drive and change the DNS to reflect that directory, but I will eventually need to connect to this via network.

All of our computers and servers have network drives mapped and the one I need is X:. Is there a known issue about system DNS and mapped drives? I wouldn't think so since it gives you the option to choose them.

Thanks in advance.

 

[spod]

The msft knowledge base comes up with this handy cause of the error:

The path that the Web server is reading is not a valid path. Often, this occurs when the Global.asa file is being used, and the connection string is created on a computer other than the Web server. If the path is a mapped drive letter, it is probably only valid for the client computer that created the connection string.

Does that help?

 

[reisende]

That's odd because I'm using IIS on my local machine and I created everything (DSN, connection string, etc) on it. That would make sense if I was moving or copying the connection string to another server or work station.

I'll try working with one of our test servers and see if it's just my machine acting stupid .