comp.lang.idl-pvwave archive: archive » IDL Dataminer and MySQL problem

Home » Public Forums » archive » IDL Dataminer and MySQL problem

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

IDL Dataminer and MySQL problem [message #49751]

Wed, 16 August 2006 02:27

Wox
Messages: 184
Registered: August 2006

Senior Member

I'm trying to connect to a MySQL database from within IDL.

I could make it work on a windows PC after installing the appropriate
driver (MyODBC), but on a Linux PC (fedora), I'm having problems that
I couldn't google.

After installing the driver, I could connect to the database with
odbc3m. Following check with odbc3i gives this driver information:
odbc3i -q -d -n"MySQL ODBC 3.51 Driver"

Name............: MySQL ODBC 3.51 Driver
DRIVER..........: /usr/lib/libmyodbc3.so
SETUP...........: /usr/lib/libmyodbc3S.so

So I added the following information to odbc.ini:
[ODBC Data Sources]
...
MyODBC=MySQL ODBC 3.51 Driver

...
[MyODBC]
Driver = /usr/lib/libmyodbc3.so
Description = MySQL ODBC 3.51 Driver

Then I tried in IDL to connect like this:

objDB->Connect,connection="DRIVER={MySQL ODBC 3.51
Driver};SERVER=***;DATABASE=***; USER=***;PASSWORD=***;OPTION=3;"

and this gives the following error message (with verbose=1):

% IDLDBDATABASE::CONNECT: ODBC SQL
Function=SQLDriverConnect,STATE=631,CODE=0,
523 630

If you look for the error codes (e.g.
http://www.winsyslog.com/en/FAQ/odbc-error-codes.php ), 631 is not
mentioned. So I don't know what's going on.

Any ideas anyone?

Regards.
Wout.

Report message to a moderator

[Message index]

		IDL Dataminer and MySQL problem By: Wox on Wed, 16 August 2006 02:27
		Re: IDL Dataminer and MySQL problem By: codepod on Thu, 17 August 2006 12:46
		Re: IDL Dataminer and MySQL problem By: Marshall Perrin on Sat, 19 August 2006 13:58
		Re: IDL Dataminer and MySQL problem By: Wox on Sun, 20 August 2006 04:51

Previous Topic:	Algorithm for lat/lon searching
Next Topic:	3D arrow.pro

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Oct 10 15:23:09 PDT 2025

Total time taken to generate the page: 1.12379 seconds