Hi,

i have successfuly connected to my sql server with

"objConn.Open "DRIVER={SQL Server};SERVER=xxxxxxxxxxxx; UID=xxxxxxxxxx;PWD=xxxxxxxxx;DATABASE=xxxxxxxxxxxxx"

however this means that my user id and password and all that are sitting hard coded in my code and thats just Dumb.

my boss wants me to make an ODBC and some how replace the above code with it can this be done and if so how

Thanks for your feed back,