trying to use odbcDirect

[davejam]

Hi all,

I am trying to remove linked tables from my application (audit requirement) and so need to setup using odbcDirect.

My backend is oracle and have the ora10g driver installed on my machine.

Have only just started playing with this but having issues when connecting to database - an odbc error has occured!!

strDSN = "server"
strUsrName = "uname"
strPwd = "pword"


Set odbcConn = odbcWksp.OpenConnection("Connection1", dbDriverComplete, True, "ODBC;DRIVER={Microsoft ODBC for Oracle};UID=" & strUsrName & ";PWD=" & strPwd & ";SERVER=myConn;DSN=" & strDSN)

I have specified myConn as a connection within TNSnames.ora although not sure what the syntax is to this...

so it seems to run through properly but then when i try to open a recordset i get - odbc call failed

myConn = 
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = servername)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = tnsName)
    )
  )

can anyone see where i may be going wrong with this as time is running out!!!

Thank you

davejam

 

[PHV]

Have a look here:

http://www.connectionstrings.com/?carrier=oracle

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886