exist database connection

• • Reply

  14 years ago

  by jebat

  boedax's malay

  , Indonesia

  Joined 14 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

  Report abuse
• • Reply

  14 years ago

  by DoctorMahdi

  DoctorMahdi

  , Somalia

  Joined 15 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

  Report abuse
• • Reply

  14 years ago

  by jebat

  boedax's malay

  , Indonesia

  Joined 14 years ago

  thanks for your answer.....

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

  thanks....

  Report abuse