exist database connection

  • 12 years ago


    i have problem in my program.... i make database connection like that

    "Dim conect As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ABC.mdb;Jet OLEDB:Database Password=xxx;")"

    and then if i export my data using Crystal report VS.net 2003 to

    " “C:\Document and Setting\jun\My Documents\Report.xls” ", so if i want to connect againt to my database (like view data from database, insert data etc). then view message like that.

    "Could not find file “C:\Document and Setting\jun\My Documents\ABC.mdb”"


    how i can make exist database connection....


    please help me....



  • 12 years ago

    Hi jebat

    Use this connection string and see the result

    Dim conn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Document and Setting\jun\My Documents\ABC.mdb;Persist Security Info=False")



  • 12 years ago

    thanks for your answer.....

    i want make static connection but process anything can't disturb my connection....(convert data, etc)


Post a reply

Enter your message below

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


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.

“There's no test like production” - Anon