Recent content by cyborg

Hmm, well put it this way. If I change the DSN to the actual server address in the connection string: strConnection = "Driver={Microsoft ODBC for Oracle}; SERVER=P007.ORACLEDB.UPS.COM;Uid=username;Pwd=password;" It pretty much runs the code fine but asks me for a username and password to the...

I have been searching for the whole day for the answer to this issue but I can't seem to figure it out :confused: Here is my code: Sub autoUpdate() 'Connection Variables 'Dim strConn As String Dim strConnection, conn 'Set conn = Server.CreateObject("ADODB.Connection") Set conn = New...