hi,

how do i setup a dsn connection on my server so i can query the database on my webiste.

The server is running win2k

Assuming you have access to the GUI you can find it in :

Settings --> Control Panel --> Adminstrative tools --> Data Sources

Then go into the system DSN tag, pick a database driver and tell it the path to the database.

Thats it !

If you don't have that sort of access to the server you need to speak to the admin and get him to do it.

One thing with DSN's they ARE case sensitive, if you ask someone else to set it up make sure they enter the DSN EXACTLY the same way you call it in your scripts.