Prev: hello group
Next: Problem with a diagram
From: Lepond on 7 Jul 2010 07:43
This connection
OpenSQLConnection[ JDBC["Microsoft Access(ODBC)",
FileNameJoin[{NotebookDirectory[], "MyAccessDatabase.mdb"}]],
"Catalog" -> Automatic, "Description" -> None, "Password" -> None,
"Name" -> "manualA", "ReadOnly" -> True, "RelativePath" -> False,
"UseConnectionPool" -> False, "Username" -> None, "Version" -> 2.`]
works right in my PC with Windows Vista 32 bits and my old laptop with
Windows XP.
But the problem crops up when I try it in my new laptop with Windows 7
64 bits, there is a connection failure and next message is shown
=93JDBC::error: [Microsoft] [ODBC Drivers Manager] Database source name
not found and no default driver specified=94 (free translation from
spanish)
I get the same result (error and message) trying the connection using
the GUI with OpenSQLConnection[].
Access 2003 is installed in all the systems.
Import["MyAccessDatabase.mdb",=85] works, but only with tables and I
need to make a lot of SQL queries.
Any suggestions?

 | 
Pages: 1
Prev: hello group
Next: Problem with a diagram