Forum Discussion

jmancor's avatar
jmancor
Occasional Contributor
15 years ago

Oracle connection

Hey everyone! I've been surfing either the internet and some TC7 books but somehow nobody has ever written something about this feature. How can i connect to an Oracle database in order to r...
mazhar555's avatar
mazhar555
Contributor
15 years ago
Hi, i am facing an exception "[Microsoft][ODBS Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" with the following script



Sub TestProc


  Set oraConnection = ADO.CreateADOConnection


  oraConnection.ConnectionString = _

  "Driver = Oracle in Home1; Data Source=JANUSDRIVER; User Id=userID;Password=userPassword;" 

  'Also used the following string

  ' "Data Source=JANUSDRIVER; User Id=userID;Password=userPassword;" 

  ' Suppress the login dialog box

  'oraConnection.LoginPrompt = False

  oraConnection.Open


  oraConnection.Close

End Sub



i have also used DDT.ADOConnection but facing the same problem