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

Accessing Pervasive.SQL V8 with VB.NET 2005

Accessing Pervasive.SQL V8 with VB.NET 2005

(OP)
Hi,

I am having problems connecting a simple application written in VB.NET (2005) with our Pervasive.SQL V8 database.  I have attempted three methods:

1.  using OdbcConnection - the application works fine but remains in memory when closed.  This happens only when I populate a DataSet object using a DataAdapter object.
2.  using ADODB.Connection - the connection works ok and the application closes down ok, but I cannot use the Recordset.MoveLast method to move to the end of the recordset.
3.  using OleDb.OleDbConnection I get an "Invalid user authorization specification." error message from Pervasive ODBC Engine

Can anyone tell me help?

Thanks in advance

Jeremy

RE: Accessing Pervasive.SQL V8 with VB.NET 2005

I would recommend using the PSQL Managed Provider and the PsqlConnection from Pervasive (http://www.pervasive.com/developerzone/platforms/net.asp).  
The code is very similar to the OdbcConnection:
Here's a simple console application (save the file as "simpleadonetvb.vb"):

CODE

Imports Pervasive.Data.SqlClient

Module Module1

    Sub Main()
        Dim conn As New PsqlConnection("ServerDSN=DEMODATA")
        Dim cmd As New PsqlCommand("select id,name from class", conn)
        conn.Open()
        Dim dr As PsqlDataReader
        dr = cmd.ExecuteReader
        While (dr.Read)
            Console.WriteLine("ID: " & dr("id").ToString() & " -- " & "Name: " & dr("name").ToString())
        End While
        dr.Close()
        conn.Close()

    End Sub

End Module

and the command line to compile it:

CODE

vbc /target:exe /r:c:\pvsw\pervasive.data.sqlclient.dll simpleadonetvb.vb

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

RE: Accessing Pervasive.SQL V8 with VB.NET 2005

(OP)
Thank you for your assistance.  I will give your suggestion a go today and see if it helps

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