ODBC on Solaris is configured through $HOME/.odbc.ini . There won't be a sample configuration for MySQL in there, so you'll need to do some experimenting. Follow the format of the file meticulously.
Make sure your LD_LIBRARY_PATH is set to include the directory where all the libODBC...so files are, and the directory where you keep your MySQL driver. There should be a little test program in /var/PVSWtango/odbc/bin (?) called odbctest (?). Make sure you can get a valid handle with this test program, then stop the Tango server and re-start. .odbc.ini is read only once, during startup. By the way, I've never used MySQL from Tango on Solaris, but I think it's probably possible. On Fri, 3 Jan 2003, Jon van der Raadt wrote: > I am unable to connect to my MySQL database from the Tango Server on > the sun box: > > Error > An error occurred while processing your request: > > File: Login.taf > Position: Search > Class: DBMS > Main Error Number: 80 > > > S1000 > File: Login.taf > Position: Search > Class: Internal > Main Error Number: -4 > > Unable to connect to the specified data source. > Verify that data source is properly configured and that database server > is online. > > I have been able to connect to the database with isql on the local > machine and from another machine via odbc. Does anyone know what I am > missing. The Tango documentation is sketchy here. How does the server > (on Unix) know where to look for the odbc stuff? I have placed a > symbolic link to the odbc.ini in the tango users home directory but > that has not helped... > > Jon > --- > > Jon van der Raadt > > TeamOnly > Web Solutions > > 412, Alastair Ross Technology Centre > 3553 - 31 Street NW > Calgary, Alberta Canada T2L 2K7 > > http://www.teamonly.net > > > Office: (403) 286-5586 > Fax: (403) 286-5576 > > Cell: (403) 863-6304 > Email: [EMAIL PROTECTED] > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
