DAO VB6 TO ADO.NET?

databases United States
  • 16 years ago

    PREVIOUSLY I USED M-ACCESS TO CREATE .MDB DATABASE, AND USE DAO METHOD TO RETRIVE DATA IN VB6 WITHOUT ANY PROBLEM.


    IN VB.NET, I HAVE PROBLEMS CONNECTING TO .MDB DATA WITH THE CODE. ALL EXAMPLES OF VB.NET BOOKS THAT I READ ARE USING SQL-NORTHWIND AS EXAMPLE. I SUSPECT I MAY NEED TO USE DIFFERENT SETTINGS???

  • 16 years ago

    Do you have problems connecting to the database in ado.net


    have you set the connection string in the connection object?

  • 16 years ago

    PROBLEM SOLVED...
    BECAUSE I GOT THE CONNECTION STRING WRONG.
    MY BOOKS EXAMPLE WERE ON SQL E.G. ONLY
    BY PUTTING
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\XXX.MDB",
    I MANAGE TO CONNECT THE DATABASE!!

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“In order to understand recursion, one must first understand recursion.”