johnlopez2000
Programmer
how do you use TCL ODBC?
I have a situation where I need to integrate to a foriegn Oracle database and am stuck with either very expensive options or less than desireable ones, and really don't want to create an integration using MSVBasic with the ActiveX Data Object.
Therefore, could anyone give me the 'cliff notes' on using TCL ODBC:
1. how to configure the ODBC data source
2. database connect string
3. how to submit the query
4. how to retrieve the results of the query (ie: like a MSVB recordset object)
5. how to iterate through the resultant recordset and parse the resultant field values
6. how to append or update records in a foriegn Oracle table on the target database
7. does one have to have the Oracle client configured on the computer where the ODBC datasource is located and the TCL interpreter is executing a program using TCL-ODBC
8. is there an alternative (ie: sockets) to creating a customer connection to the foriegn Oracle database
9. can TCL use Oracle SQL-NET to connect and query/update the foriegn Oracle database table(s)
10. does anyone have any sample programs/code frags they could share to accomplish this.
Thanks for your help. John Lopez
Enterprise PDM & Integration Consulting
Development for MatrixOne PDM Systems
johnlopez2000@hotmail.com
I have a situation where I need to integrate to a foriegn Oracle database and am stuck with either very expensive options or less than desireable ones, and really don't want to create an integration using MSVBasic with the ActiveX Data Object.
Therefore, could anyone give me the 'cliff notes' on using TCL ODBC:
1. how to configure the ODBC data source
2. database connect string
3. how to submit the query
4. how to retrieve the results of the query (ie: like a MSVB recordset object)
5. how to iterate through the resultant recordset and parse the resultant field values
6. how to append or update records in a foriegn Oracle table on the target database
7. does one have to have the Oracle client configured on the computer where the ODBC datasource is located and the TCL interpreter is executing a program using TCL-ODBC
8. is there an alternative (ie: sockets) to creating a customer connection to the foriegn Oracle database
9. can TCL use Oracle SQL-NET to connect and query/update the foriegn Oracle database table(s)
10. does anyone have any sample programs/code frags they could share to accomplish this.
Thanks for your help. John Lopez
Enterprise PDM & Integration Consulting
Development for MatrixOne PDM Systems
johnlopez2000@hotmail.com