Ok I know what a DSNless connection is .. Its a very easy way to let hackers find your database How the hell do I make a DSN connection .. What program should I use for ODBC .. What is ODBC How do I use it
DSNless is NOT an easy way for people to find your database. Anyone can still find your database with DSN if you put it in an obvious place and name it an obvious name. The best option is to move the database to another location and rename it to an obscure name. Move it to a location which is not web-accessible if possible. That's the most secure option. DSN-less is actually faster than DSN.
That being said, if you want to create a DSN, you have two possible routes. If your host provides you with a control panel, you can probably create one there. If not, then contact your host and have them create one for you.
Use the same connection string you're using now, but change the hardcoded directory and database information with the DSN name and you should be good to go (I think)...
Dave Maxwell -------------- When's the next meeting of Snitzaholics Anonymous