-
Connection string for Access Database (LogParser)
I have seen a few posts about LogParser here, so wonder if someone can help...
I am using the SQL output format through the LogParser COM API. In general, I can use a connection statement like:
oOutputFormat.oConnString = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & strMDBFile & ";"
and that works just fine.
One one computer, though (using WinXP-SP2), the attempt to execute the query fails with the error:
Error executing query: Error connecting to ODBC Server
SQL State: IM006
Native Error: 0
Error Message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
The ODBC Data Source Administrator certainly shows the Microsoft Access Driver, at version 4.00.6304.00. The only strange thing I can see about it is that the File is shown as "ODBCJT32" with no date. That is different from, for example, the "Microsoft Access-Treiber" driver, where the file is shown as "ODBCJT32.DLL" with a date of 4Aug04.
An attempt to run the query with
oOutputFormat.oConnString = "Driver={Microsoft Access-Treiber (*.mdb)};Dbq=" & strMDBFile & ";"
works correctly.
So....
Do I have a problem with the ODBC driver?
How would I go about re-installing it?
(I have searched Microsoft's site for a download, but the only reference I found suggests it is part of WinXP).
(For those not familiar with LogParser - it is a bit long in the tooth now, and does not appear to be able to use any of the more recent APIs for connecting to a database. For example, I have tried Provider= Microsoft.Jet.OLEDB.4.0 but with no luck at all.)
Thanks!
Geoffrey
-
I use logparser on a regular basis with the first driver you mentioned w/no issues, so I suspect re-installing/updating MDAC on the machine in question will fix things.
There is a Provider-based add-in for log-parser, but it is not well documented and since the logparser forum got integrated into a .NET forum there is not a lot of support in general. Stan
-
Thanks stanl.
Pardon the naive question, but how do I go about reinstalling/updating MDAC. When I look at the Microsoft sites there are many references that indicate support for ODBCJT32.DLL has been dropped from recent MDAC releases. A reinstallation of the version I have would be fine! Any pointers would be welcome, thanks.
Geoffrey.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules