INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

OLEDB Recursive code eventually drops relational service

OLEDB Recursive code eventually drops relational service

(OP)

OLEDB Recursive code eventually drops relational service

I think this is what is happening.

I use vb.net

If I use oledb continuously opening, closing, connecting and destroying the Connection object my app eventually stops working. It seems the relational service stops working.  After the app hangs even a simple singleton select from my vb.net application won't work.

The VB.Net Code and connection string I use is below. My code calls this function dozens of times in a loop.

ConnectString > "Provider=PervasiveOLEDB;Data Source=jj7;Location=bserver"

Public Function oledbGetDataSet(ByVal ConnectName As String, ByVal SQL As String) As DataSet
        Dim ds As New DataSet
        Dim conn As New OleDbConnection(Me.GetConnectionString(ConnectName))
        conn.Open()
        Dim adp As New OleDbDataAdapter(SQL, conn)
        adp.Fill(ds)
        conn.Close()
        conn = Nothing
        adp = Nothing
        Return ds
    End Function

RE: OLEDB Recursive code eventually drops relational service

(OP)

I forgot to mention I am using 9.6 client and engine.

RE: OLEDB Recursive code eventually drops relational service

I'm running 10 and VB.NET 2005 and I've gotten your code to run through over 1000 iterations (and still going).  
ARe you seeing anything else other than the hang in your app?  Does the PCC work when the app is hung?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close