Re: Databaselink and MySQL
- To: mathgroup at smc.vnet.net
- Subject: [mg72882] Re: [mg72873] Databaselink and MySQL
- From: Chris Williamson <chrisw at wolfram.com>
- Date: Wed, 24 Jan 2007 05:26:03 -0500 (EST)
- References: <200701231026.FAA09263@smc.vnet.net>
First your conf file should contain the location of your server such... SQLConnection[JDBC["mysql", "myhost:3306/testdb"], "Name" -> "MySQL test", "Description" -> "test connection to MySQL database", "Username" -> "root", "Password" -> "$Prompt", "RelativePath" -> False, "Version" -> 1.] Next try putting your conf file in $UserBaseDirectory/DatabaseResources. Then use the name to call OpenSQLConnection["MySQL test"]. Chris Stern wrote: > I am trying to connect to a MySQL database using Mathematica's > databaselink library. I can connect to the test databases provided > with Mathematica (which are HSQL databases), and my MySQL databases > work well on their own, but when I try to connect to the MySQL > database from Mathematica, I get errors. > > My connection file looks like this: SQLConnection[JDBC["mysql", > ToFileName["C:\Program Files\MySQL\MySQL Server 5.0\data", > "dbsterntest"]], "Name" -> "MySQL test", "Description" -> "test > connection to MySQL database", "Username" -> "root", "Password" -> > "$Prompt", "RelativePath" -> False, "Version" -> 1.] > > I have also tried with the OpenSQLConnection command directly, > OpenSQLConnection[JDBC["mysql","C:\Program Files\MySQL\MySQL Server > 5.0\data\dbsterntest"],Username->"root",Password->"$Prompt"] > > In both cases, I get the following error: JDBC::error: JDBC error: > Cannot load connection class because of underlying \ exception: > 'java.lang.NumberFormatException: For input string: "\Program \ > Files\MySQL\MySQL Server 5.0\data\dbsterntest"'. > > Help? > >
- References:
- Databaselink and MySQL
- From: Stern <nycstern@gmail.com>
- Databaselink and MySQL