OraFAQ Forum: Windows » ODBC Oracle programming

Home » Infrastructure » Windows » ODBC Oracle programming

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ODBC Oracle programming [message #99997]

Wed, 12 June 2002 06:59

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...

Report message to a moderator

Re: ODBC Oracle programming [message #100255 is a reply to message #99997]

Mon, 23 September 2002 12:54

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.

Report message to a moderator