This is probably fairly easy, which makes the problem all the more frustrating. I am attempting to connect to an Oracle RDBMS using the Microsoft for ODBC Driver.
For some reason I am getting the syntax wrong in the connection string; different variation produce misleading error messages such as "TNS could not resolve service name" - which it defintely can using any other application; or "Invalid username/password" etc.
The following are examples of some variations I have tried (Note this is
VBScript for ASP, but that should be irrelevant):
set myconnection = Server.CreateObject("ADODB.Connection")
myconnection.Open "server=myserv;" & _ "uid=power;pwd=power;database=myserv"
myconnection.Open "Data source=myserver& _ "uid=power;pwd=power"
myconnection.Open "DSN=myserver;" & _ "uid=power;pwd=MANAGER"
And any number of others - there must be something simple I am missing.....