How do i setup an ODBC DSN on linux

[Haraldo]

Redhat version 9

The problem is this: (setting the scene)

I have developed a web site with database functionality and my brother is offering me his Linux server running apache to serve my pages. So i have setup the correct myODBC driver to attach to his MySQL database and transfered my tables accross etc.

Now, i need him to setup his machine correctly so i can either connect to my database via a connection string or via a DSN. He has myODBC and unixODBC on his machine but has no idea how to setup a DSN (has something to do with the .odbc.ini file). I'm lost cause i know next to nothing about linux.

Basically what does he have to setup on his machine to allow me to connect via a connection string or via DSN, whatever is easiest?

Thanks for you time, i appreciate any ideas as there is very little i can find on the net.

Thanks
H

 

[MorpheusNL]

It helps to state what kind of Programming Language you're using to write the pages

Perl ? PHP ?
(both have builtin functionality to connect to MySQL)
See

http://www.cpan.org

and

http://www.php.net

 

[Haraldo]

Using ASP, vbscript...

Thanks

 

[MorpheusNL]

ASP Running on a Linux Server ????????

 

[Haraldo]

The linux server is running apache. I am already serving ASP pages on it although my most recent site is using a database. This is where the connection string is needed or a DSN. Since A DSN is a microsoft thing there is little info on how to setup a DSN on Linux. Does linux, mysql, or apache need to be configured in a way that it will understand my connection string?

Thanks,
H

 

[MorpheusNL]

To my knowledge a standard Linux Server with Apache does not support ASP.

Are you using Chilisoft ASP ?

You better take a good look at PHP
MySQL and PHP are very close, and it's fairly easy to make pages that collect/send data from/to a MySQL database.

For the ODBC Connection I can give you this url:

http://www.unixodbc.org/unixODBCsetup.html

(BTW: PHP also has ODBC extensions )