>Hello all,
>
>I have been searching the thread trying to find some comments on generating Oracle connections and the amount of time it takes to create each one. I would like to have several connections at once doing different things within my app. Does anyone know of a way to speed up the connection generation to Oracle using SPT?
>
>Matt

Download my ODBC DSN class from UT Downloads. Search on Member ID 12473.

lnHandle = sqlstringconnect('Driver=Microsoft ODBC for Oracle;UID=my_id;PWD=my_pwd;Server=sid;')

or

lnHandle = sqlstringconnect('Driver=Oracle ODBC Driver;UID=my_id;PWD=my_pwd;DBQ=sid;')

There is no way to lessen the amount of time to create a connection, and the times to create are rarely consistent. You are at the mercy of currently available bandwidth.