Setting up ODBC DSN on Linux or connection string for ASP web site

[Haraldo]

I need to know the connection string preferably to connect me to my MySQL database which is running on a linux/apache server.

I have spent a couple of days changing my connection string within dreamweaver to no avail. Would anyone know what needs to be configured on the linux server for my connection string to work?

We have myODBC driver and unixODBC driver installed but i am unable to get the connection string to function. I would use a dsn but this is almost unheard of on a unix/linux machine. Plus i have no idea how to setup the '.odbc.ini' file correctly.

Thanks, Any ideas would be appreciated,
H

 

[rac2]

Me neither but our sys admins do.

[datasourcename]
Driver          = /usr/local/lib/libtdsodbc.so
Description     = Your database description
Trace           = No
Server          = databaseserver.domain.com
Database        = BigDB
Port            = 1433
TDS_Version     = 7.0

I believe that the name in the square brackets is the DSN, so use DSN="datasourcename" in the connection string.

Hope this helps.