VB Package & Deploy

[General_Jack_As]

I have a problem with this project that I am working on. When I package the program then install it on the system the program crashes when I try to access the database. I have allready covered all the bases. The database is on a networked drive and is accessable. This is the error message I get"
Provider cannot be found. It may not be installed properly.
Then that window goes a way then the next window comes:
Run Time Error '91':

Object variable or With Block variable not set.

The program works when compiled and installed on the computer that I installed vb 6.0 which leaves me to believe there is a certain file that I need when i do this. If anyone can help Me i would appreciate it. I use ADO and Data Enviroments as db connections.

[parse27]

what i think of your dillema,

"Provider cannot be found. It may not be installed properly." <-- if you use VB6, it uses Jet4.somethig engine to connect with an access database. maybethe comp you're installinng it on doesn't have the Jet4.something driver. Or maybe you have to set the database in the ODBC found in the Win Control Panel.

"Object variable or With Block variable not set. " <-- this has something to do with your code. usually happens when you do a record operation without defining the database "object"

this are just opinions and may be wrong. but i hope they help. :)

[General_Jack_As]

I am using jet3.51

[parse27]

hows about you try setting up the ODBC Data Sources in the win control panel for both the "server" and the "client"..maybe that would work..just a suggestion though..

[General_Jack_As]

Got it to work in case you cared. I had to **** with the dependancy files for a while but I got it.

[parse27]

yeah i do care..in fact i was starting to wonder how to do it myself..

you see i'm also doing a program..kinda like yours..i have to make connect around 4 computers to a central computer to give them access to a database in the central computer..

i don't know which way to go..some say i should use ASP in the terminals and let that access the database..but i'm kinda like to do it in VB..

thing is, i don't know if winsockets will to the trick or if i just have to expose the database to the other computers by configuring ODBC for both terminals and central computer..

wachathink? what would you suggest?

parse27

[General_Jack_As]

on the central computer host the database(I think your using access) When you write your program link all the connection strings for that database. I would recomend using Data Enviroments rather than ADO or anything else. They are easy to use and they are at a global level where a Data Enviroment can be accessed from any where in the project as to ADO where its form level. Code your program and when you are done using it go to the VB package and deploy. Create a dependancy file and place the dependancy file in the same location as the exe. Then when you go to package and deploy again and package the project include the dependancy file and have it install in App.path This way it is right next to the exe. You wouldn't need to configure ODBC VB 6.0makes it work without that by using its own connection code not windows.