Connecting cursor to Oracle.

forum.advanced.programming (1998-2005)
Sergio Cerda

Connecting cursor to Oracle.

Post by Sergio Cerda » 30 Mar 2005, 19:18

 Posted by:  Sergio Cerda 

I am using TD 3.1, use Oracle 9i like DB, the problem is when connecting the
cursors, takes too much time. Because?

Sergio

Pedro Vazquez

Re: Connecting cursor to Oracle.

Post by Pedro Vazquez » 30 Mar 2005, 20:22

 Posted by:  Pedro Vazquez 

Sergio,
I´m connecting to Oracle 9i and 10g with TD 3.1 and 2005, and it takes
more or less 5 seconds at first time. But all the new connections are
established automaticaly.
I'm using OLEDB... it works fine...

In the "SqlCreateSession" help
" When connected to SQLBase, or when using an OLE DB connection,
a call to SqlCreateSession will create a new database connection. When
connected to other databases, Gupa first checks the combination of database
name, user ID, and password. For each new combination, a new database
connection is created. However, if the combination has already been used in
the application, only a new cursor is created, not a new database
connection."

In the "SqlConnect" help
"To make this easy, function SQLConnect has been altered in
SQLWindows version 3.1. SQLConnect now looks first at variable SqlUDL and,
if it finds a file name in that variable, reads connection information from
that file. If it finds a provider name in SqlUDL, it uses the provider name.
If the database name or user name or password was not specified, SQLConnect
will obtain the needed value from the values of variables SqlDatabase,
SqlUser or SqlPassword. It forms a connection string, then makes an OLE DB
connection with that string. If SqlUDL is null, SqlConnect uses the older
(API and routers) method of connecting with the values of SqlDatabase,
SqlUser, and SqlPassword. So, in many cases, existing apps simply need a few
lines to set the value of SqlUDP and the rest of the app will run smoothly
against OLE DB."

I dont know if this helps... but its good to refresh this info...

Regards...

Pedro E. Vazquez
Buenos Aires Software S.A. -- www.bas.com.ar
Argentina

Return to “advanced.programming”

Who is online

Users browsing this forum: [Ccbot] and 0 guests