Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating a connection to Oracle
Message
From
25/07/2001 14:12:56
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Creating a connection to Oracle
Miscellaneous
Thread ID:
00535231
Message ID:
00535231
Views:
40
Using VFP6 SP4.

In my application I connect to an Oracle data source. I use the following command to connect to the data source:

gnconn = SQLCONNECT('mydatasource', 'userid', 'password')

When testing my app, I start, stop and restart the APP in my command window serveral times. Our DBA says that my Oracle connections are adding up.

I always CLEAR MEMORY before starting my APP. What else do I have to do to clear any open Oracle connections? Will restarting VFP clear these connections? Does CLEAR MEMORY clear these connections?

Thanks,

Jerryt
Next
Reply
Map
View

Click here to load this message in the networking platform