Problem connecting to ODBC database
- To: mathgroup at smc.vnet.net
- Subject: [mg65898] Problem connecting to ODBC database
- From: "Kunz, Christopher L" <clkunz at sandia.gov>
- Date: Fri, 21 Apr 2006 01:33:48 -0400 (EDT)
- Sender: owner-wri-mathgroup at wolfram.com
I've registered an SQL Server database in ODBC and I'm trying to connect to it using Mathematica. I've defined the connection, but when I try to connect I get the error message:"JDBC::error: JDBC error: [Microsoft][ODBC Driver Manager] Data s...t found and no default driver specified". I have jdk 1.50 installed. Unfortunately the error message doesn't help me much, and the help file doesn't have much in the way of troubleshooting for DB connections. Can anyone point me in the correct direction? Thanks, Chris Kunz