Wanted: Connection String for ODBC

S

Siegfried Heintze

I'm trying to debug my ASP.NET application. As stated in another posting,
the application works fine as long as my other Perl clients using ODBC are
not simultaneously populating the database.

Since multiple perl clients are able to simultaneously read and write
records (without using transactions) I know it is possible. Since the perl
is using ODBC, I thought I should use ODBC instead of oledb.

So now I'm just trying to get it to work without perl running. In this
situation, it works with OleDb and it should work in ODBC, correct?

Here is my connection string:

string[] strConn = new string[]{@"Driver={Microsoft Access
Driver (*.mdb)};Dbq=""C:\Inetpub\heintze\keyword-job-search\",
@"job-search.mdb", @""";Uid=Admin;Pwd=;"};


Thanks,
Siegfried

I'm getting this error message getting on the fill function for the data
adapter:
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable
to open registry key 'Temporary (volatile) Jet DSN for process 0x15a0 Thread
0x16b4 DBC 0x1588024 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager]
Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Microsoft
Access Driver]General error Unable to open registry key 'Temporary
(volatile) Jet DSN for process 0x15a0 Thread 0x16b4 DBC 0x1588024 Jet'.
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Not a valid file
name. ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x15a0
Thread 0x16b4 DBC 0x1588024 Jet'. ERROR [HY000] [Microsoft][ODBC Microsoft
Access Driver]General error Unable to open registry key 'Temporary
(volatile) Jet DSN for process 0x15a0 Thread 0x16b4 DBC 0x1588024 Jet'.
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Not a valid file
name.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top