Using ADOConnection by assigning the ODBC handle?

Zlatibor Boro Urosevic

Delphi Developer

Using ADOConnection by assigning the ODBC handle?

2004-04-28 12:55:20 AM
delphi28
Hello,
Is it possible somehow to assign an ODBC handle to ADO Connection for use with standard DB components (TADO Table, Query,...).
My problem is that I must obtain an ODBC session handle from the calls to API of my legacy system.
I would like then to assign this handle somehow to ADOConnection component for use with standard Delphi components...
...is it possible?
Thanks,
Boro

Viatcheslav V. Vassiliev

Delphi Developer

2004-04-28 01:36:15 AM

Re:Using ADOConnection by assigning the ODBC handle?

No, ADO uses OLEDB interfaces and does not use ODBC (except OLEDB provider
for ODBC). But even for OLEDB provider for ODBC it is impossible open
connection specifying ODBC handle.
You may want to look for TDataSet descendants that works with ODBC.
//------------------------------------------
Regards,
Vassiliev V. V.
www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Zlatibor Boro Urosevic" <XXXX@XXXXX.COM>ÓÏÏÂÝÉ?ÓÏÏÂÝÉÌÁ
?ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅ? news:408e9078$XXXX@XXXXX.COM...

Quote

Hello,

Is it possible somehow to assign an ODBC handle to ADO Connection for use
with standard DB components (TADO Table, Query,...).

My problem is that I must obtain an ODBC session handle from the calls to
API of my legacy system.
I would like then to assign this handle somehow to ADOConnection component
for use with standard Delphi components...

...is it possible?

Thanks,
Boro