exist database connection

  • 11 years ago

    hiiiiiiiiiiiii,

    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....

     

    thanks

  • 11 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")

    Regards

    DoctorMahdi

  • 11 years ago

    thanks for your answer.....

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

    thanks....

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.

“Debugging is anticipated with distaste, performed with reluctance, and bragged about forever.” - Dan Kaminsky