Dim strConn 'strConn = "Provider=SQLOLEDB; Data Source=" & _ ' Request.ServerVariables("SERVER_NAME") & _ ' "; Initial Catalog=pubs; User ID=sa; Password=" ' ODBC DSN-less connection... ''strConn = "Driver={SQL SERVER};SERVER=LOCALHOST;DATABASE=Test;UID=SA;PWD=;" 'strConn = "Provider={SQL SERVER};Persist Security Info=True;UID=UserID;PWD=Password;Initial Catalog=QMDS;Data Source=TVS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SomeID;Use Encryption for Data=False;Tag with column collation when possible=False" strConn = "Driver={SQL SERVER};SERVER=VSQ;DATABASE=Test;UID=UserID;PWD=Password;" 'strConn = "Driver={SQL SERVER};SERVER=TDEV;DATABASE=Test;UID=UserID;PWD=Password;" 'OLEDB DSN-less connection... 'strConn = "Provider=SQLOLEDB.1;Server=TDEV;Database=Test;UID=sa;PWD=;"Try using each one to see the difference by commenting out all but the one in use. It includes OLEDB and ODBC with DSN-less connections.