I solved the problem myself.
I had to change the service entry in tnsnames.ora from just hsodbc to hsodbc.machinename. Apparently the domain is mandatory.
TNB
Hi
I am trying to setup generic connectity in Oracle 8.17 to connect to an sqlserver database from within sqlplus. The Steps I have used is:
1. Install Generic Connectivity (already with oracle server)
2. check data dictionary tables (ok)
3. Setup ODBC sql driver from Microsoft (2000.80.194)...
Great!!! It works now!!
The adodb.recordset had to be declared as a variant in my vb ActiveX as well. After that your Delphi code example worked perfectly.
Thanks a lot!
Thomas Bak
I have created an activex dll in visual basic 6. The Activex returns in a procedure an adodb.recordset.
This recordset causes problems to read from Delphi 5. The other activex functions and procedures passing strings and numbers works perfect in Delphi.
What is the correct syntax for passing...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.