Home » Infrastructure » Windows » ODBC Oracle programming
ODBC Oracle programming [message #99997] Wed, 12 June 2002 06:59 Go to next message
Marie
Messages: 8
Registered: March 2002
Junior Member
I want to know how to set options programmatically for the ODBC Oracle driver in Visual Basic. I found the API SQLConfigureDataSource. With it, we can set options for the ODBC Access driver but not all the options for the ODBC Oracle driver (for example the options Workaround options / Disable MTS support).

If you have any idea, it will be welcome...
Re: ODBC Oracle programming [message #100255 is a reply to message #99997] Mon, 23 September 2002 12:54 Go to previous messageGo to next message
Sud
Messages: 63
Registered: September 2002
Member
You can add all of the parameters in the connect string delimited with a semicolon (";").

For example, to Disable MTS Support you would write the connect string by adding the parameter "MTS" with a value "T"

Driver={Oracle ODBC Driver};UID=USERNAME;PWD=PASSWORD;DBQ=SERVICENAME;MTS=T;

To get all the configurable parameters follow the link http://otn.oracle.com/docs/tech/windows/odbc/htdocs/817help/sqoraFormat_of_the_Connection_String_.htm

To use the above link, I think you have to be Oracle Technet member which is free.

Hope this helps.
Re: ODBC Oracle programming [message #100483 is a reply to message #99997] Fri, 17 January 2003 10:17 Go to previous messageGo to next message
agustin lozano
Messages: 1
Registered: January 2003
Junior Member
i need help for use ODBC oracle.
Re: ODBC Oracle programming [message #100486 is a reply to message #100483] Sat, 18 January 2003 11:25 Go to previous message
arnshch
Messages: 4
Registered: August 2002
Junior Member
What specifically do you need and in what context
in Oracle programming(I presume you are talking about
PL/SQL)?
Previous Topic: Unable to login Oracle 8i - SQL Plus in Win 2000 Pro
Next Topic: opening Ms Word with OLE2 method
Goto Forum:
  


Current Time: Fri Mar 29 10:42:17 CDT 2024