need some help with packaging my programm

[sagi2313]

Hi all, am new to this forum.Name is alex and my question :
i wrote a small programm in VB6 which uses databases to show some data. I create the databases in SQL enterprize edition
and connect my app through SQL local server to the database.
everything works....ON MY PC!
what if i wana transfer the program to other PC's?
when i use the "package and deployment wizard" i am not prompted to include the database.i tryed using access instead
and ODBC as server but still get no results.
how could I tell the installation programm to copy the database in the app.folder and DECLARE THE DATABASE to the ODBC?
i tryed to include a registry key that will write in the sys registry about my database but didnt work!
maybe i did it wrong.
any ideas?
Thanks Alex

 

[zemp]

You will have to manually add the access database at the correct form in the wizard. Look for an add button. The PDW will then place it in a folder (I believe app is the default). You can change the location if you need to.

For the ODBC, you will have to create a DSN via code, either during installation or when your app runs for the first time ( check to see if it exists, if not create it, else use it). Search the form for Create DSN code.

If you are using SQL server then you will need to write code to create the database and to create the odbc DSN.

Thanks and Good Luck!

zemp

 

[zemp]

Sorry, typo, it should read 'Search the forum...' not the form. Also check out faq222-273.

Thanks and Good Luck!

zemp

 

[sagi2313]

Zemp,
thank you for answering my question.
now the problem changes a bit:
i used wise enterprise installer for the packaging.
there is an "ODBC" STEP where i declare data source and driver for the app.
it works to the point that it copies the .mdb file in the installation directory and declares the database to the local ODBC. the problem is that the ODBC declaration points to the database path of my PC and not the installation path . as a result i am obligated to copy the database to a specific folder on target PC. this is not convenient and totally unprofessional i think. I rather not used code to produse the DSN , as i havent got enough knowledge aroud that.
any ideas?
thatks again!
Alex

 

[zemp]

Sorry, I have never used Wise installer before. However, I have only heard good things about it so you should be able to set where the ODBC looks for the database. Take a closer look at the help files.

Thanks and Good Luck!

zemp