Maybe there's someone here who can help answer this...
If so Thanks in Advance -Chris
Begin forwarded message:
From: Chris Hinrichs <[EMAIL PROTECTED]> Date: Thu Mar 6, 2003 10:44:29 AM America/Chicago To: [EMAIL PROTECTED] Subject: MyODBC, DBD::ODBC
Hi,
I'm looking for causes as to why isql gives the following error:
[izzy:/usr/lib] chris# isql -v myodbc3
[unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
++++++++
Here's the background:
I'm running MacOS 10.2, and I need to connect to a TSM server via ODBC, and I want to do that with DBD::ODBC via perl. But before I can do that I need to get unixODBC/MyODBC working.
Before, I tried installing iODBC, and I did get odbctest, (iODBC's version of isql) to work with that. However when I installed unixodbc, and subsequently recompiled MyODBC to use unixODBC, iODBC's odbctest stopped working, (As you would expect,) but interestingly it stopped working in such a way that it gave the exact same error message:
[izzy:/usr/lib] chris# odbctest DSN=myodbc3
iODBC Demonstration program
This program shows an interactive SQL processor
[iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded, SQLSTATE=IM002
++++++
I guess the similarity in error messages is because it's defined in the ODBC protocol itself...(?)
Now the problem I am having is that the above error message coming from isql looks like it can't find the odbc.ini file, because it says it can't find a default, instead of complaining about it being malformed, or the lib file not being recognizable. I put the exact same copy of odbc.ini in /etc, ~root, (I'm running as root for the time being,) and in ~root/Library/ODBC. I tried setting the ODBCINI and ODBCSYSINI environment variables, but that had no effect.
Here is my odbc.ini file:
[myodbc3] Driver = /usr/lib/libmyodbc3.dylib Description = MySQL ODBC 3.51 Driver DSN SERVER = localhost PORT = 3306 USER = root Password = raboof Database = test OPTION = 3 SOCKET =
[Default] Driver = /usr/lib/libmyodbc3.dylib Description = MySQL ODBC 3.51 Driver DSN SERVER = localhost PORT = 3306 USER = root Password = raboof Database = test OPTION = 3 SOCKET =
++++++++
I am also wondering if odbcinst.ini has anything to do with it at all...
Any advice at all is greatly appreciated. I've been banging my head against this for over 3 weeks now, and I'd like to find some answers.
Chris Hinrichs