Re: Witango-Talk: SUN/Tango2k/ODBC

Mon, 06 Jan 2003 09:27:38 -0800

I have MySQL running on Solaris - no problem. I can connect from my development machine to the database - no problem. The machine has unixODBC installed and I can connect to the datasource with both isql the command line app and datamanager their gui. I have created the .odbc.ini file in the tango home directory and the LD_LIBRARY_PATH as well as the other enviornment variables (see attached) any idea what I am missing?

Attachment: odbcinst.ini
Description: application/text

Attachment: profile
Description: Binary data

Attachment: odbc.ini
Description: application/text

On Friday, January 3, 2003, at 10:27  AM, Jesse Parker wrote:
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


---

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]

Reply via email to