Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2010

[Date Index] [Thread Index] [Author Index]

Search the Archive

Access connection failure in a Windows 7 64 bits system

  • To: mathgroup at smc.vnet.net
  • Subject: [mg110814] Access connection failure in a Windows 7 64 bits system
  • From: Lepond <luism.romero at gmail.com>
  • Date: Wed, 7 Jul 2010 07:44:42 -0400 (EDT)

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?


  • Prev by Date: Re: Change Default Button Method
  • Next by Date: Re: The side-effects of mixing TraditionalForm inside expressions.
  • Previous by thread: Re: The side-effects of mixing TraditionalForm inside
  • Next by thread: Re: PlotLegend-> and DateListPlot[]...incompatible or