Sounds like your DSN is the problem rather than your code. What Settings do you have in your DSN. Have you created your fileDSN yourself or have you copied it from another machine? I suspect that within your DSN you are referencing a server which has not been registered through the "Client Network Utility" which you can find in Start->Programs-.Microsoft Sql Server. This maps up the IP address of your server to an alias. This alias need to be used in your DSN. I suggest you look at your DSN and see if the alias used then is present in your client network utility. Better still create a new one which will allow you to test the connection before completion.