How do u distribute a vb app, which works on another pc?

[99mel]

I have made a vb app and i'm TRYING to make it work on another pc!

the app works apart from one part of it, this part uses the crystal report viewer control.
I'm also using Microsoft Access to write and read data for the crystal report.

I get the error 'Unable to load database' when trying to view the report!!

Can anyone help me with this problem?

i used Interdev, Deployment wizard just crashed out when i tried using it.

 

[sunaj]

Hi,

Making a vb project like that, you use a lot of dlls that you have to include when distributing your project to other pcs.
The normal way to do that is to use a Deployment wizard like you mention. I use the 'Package and deployment wizard' that comes with visual studio. The wizard finds all the dlls and creates a setup program that makes sure that all the dll is present on the pc that you are installing on (if not the setup program will install them).
You can also install all the dlls yourself, but with your project there's a lot of them and is not very practical. You should try and get your deployment wizard working or find another one that works.

Sunaj

 

[99mel]

I used Interdev as i need the setup to make several directorys under the app path, and a few other things too.

As i compiled the installation file, all the dll's should of been automatically added. There error i'm getting though may not be to do with a dll missing.

the error is 'Unable to Load Database' i'm opening a crystal report which is bound to a .mdb. I can delete all the data and write data to this database! but can't seem to get the crystal report to show the data!

any help pleaseeee?

 

[reidfl]

You must manually add the crystal report distribution or runtime files that the Package and deployment wizard missed.

View the help topic in crystal reports that refers to distributing crystal reports.

Question, are you using a ODBC connection to connect to your .mdb.



Direct Access - Access 7



FILENAME LOCATION DESCRIPTION
P2BDAO.DLL WINDOWS\SYSTEM or WINDOWS\SYSTEM32 (NT only) SCR Physical Database DLL
P2CTDAO.DLL WINDOWS\SYSTEM or WINDOWS\SYSTEM32 (NT only) SCR Physical Dictionary DLL
P2IRDAO.DLL WINDOWS\SYSTEM or WINDOWS\SYSTEM32 (NT only) SCR Physical Directory DLL
 

ODBC - Access 7.0



After installing the Microsoft Data Access (MDAC) files and copying P2SODBC.DLL, no addition files are needed for this data source. For more information, see ODBC - Required Runtime Files.

 

[99mel]

i'm simply defining myrs as a Recordset, and mydb as database
and connecting to the mdb through 'OpenDatabase' and 'OpenRecordset'

I found the error with the report, the location of the db was incorrect and i think i've fixed that. I don't need Access installed on another machine do i?

 

[99mel]

For me to use the above method of connecting to my mdb do i need any differenet dlls or anything?

i'm getting this stupid error now 'ActiveX component can't create object' when trying to do the following line:

Set mydb = OpenDatabase(App.Path & "\adb.mdb&quot

Any suggestions?

 

[ronze]

similar question on the exe for an app.

can I distribute just the shortcut to the end user(s). my app will have multiple end users.

I'm thinking that if I send out the shortcut then all impending changes to the final product can be done and linked to the executible on my computer?

is this possible, or will the multiple copies only be one program?

does this question make sense?

thanks
Christina