1,105,594 Community Members

ADODC1 remote

Member Avatar
jemartalaban_1
Light Poster
49 posts since Feb 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

hi, i create a program with adodc and data, i created an exe file and installer of if, then i install it to other pc, but an error msg appear, there is a problem on my path of adodc to the database, but i was installed it to exact location in my pc. How can i make that the database and adodc1 are still connected even their directory change.? THANKS !

Member Avatar
QVeen72
Veteran Poster
1,016 posts since Nov 2006
Reputation Points: 104 [?]
Q&As Helped to Solve: 164 [?]
Skill Endorsements: 7 [?]
 
0
 

Hi,

Place the Database in the same folder as the project/application... and wrire this code in form_load..:

Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path _
    & "\MyDB.mdb ;Persist Security Info=False"
Adodc1.Refresh

change database name accordingly..
bind all the controls, in runtime.. not design time...

Regards
Veena

Member Avatar
jovstudios
Junior Poster in Training
55 posts since Mar 2013
Reputation Points: -3 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hello You Can use Package and Deployment Wizard to make an Setup.exe for your Project in Vb 6.0 then Make it Sure Your Database Added to Installation.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article