Posted on 2005-04-26
My web hosting company is telling me I should switch to a DSN-less connection for performance issues. I'd like to try, but I don't know how to create the connection. Here's what I have right now. I've created an ODBC connection for SQL Server on my machine. I created a Microsoft Access 2003 DB which links to the SQL DB using the ODBC connection. What is the code that I would use to create a DSN-less connection, and where do I insert this within my Access DB??