ADO to dBASE5 via ASP over Win2K Server network

[PaulMcGuinness]

Help please!

I am using the following connection string to access a dBASE5 (Goldmine) database over the LAN using ADO within an ASP script:-
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=S:\Goldmine;Extended Properties=dBASE 5.0;"

With this string I get:-

Error Type:
Microsoft JET Database Engine (0x80004005)
'S:\Goldmine' 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.
/faults/editfault2.asp, line 77



However, It all works fine if I copy the dBASE files to the local machine and change the connection string to:-

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath(".\&quot & ";Extended Properties=dBASE 5.0;"


The machine definately has an S:\ drive, and on the target system (Win2K Server) I have set the "Computer" on which the web-server is running to have full rights to that directory.

 

[krisbrixon]

That looks about right if the server has the drive mapping of S:

Here are some links for dBase and ADO maybe one might spark an idea:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q238431

http://msdn.microsoft.com/library/d...m/odbcjetdbase_programming_considerations.asp

http://www.able-consulting.com/ADO_Conn.htm#ODBCDriverForDBASE

You might try a ASP or ADO forum.

Kris