VB Project Installation [with database]

[hYph3n]

hi guys!

i have a project, which is to be deploye with in next 4 days, i have just to learn to make a setup, by reading the inno scrpit help from this forum.

What i want to know is, how can i make a setup file, so that it copies the source database in the client system, and make the DNS, so that my applicaton that is oging to be install can access it.

please, help me as soon as possible.

[DaGeeza]

May not be a solution you are wanting - but I use InstallShield it has a built in VB project scanner function which scans your VB project and does all the donkey work for you.

[randem]

hYph3n,

What database are you using and why are you still useing DSN's. Unless required. Are you using ********** or Inno Setup they are not interchangable?

[hYph3n]

hYph3n,

What database are you using and why are you still useing DSN's. Unless required. Are you using ********** or Inno Setup they are not interchangable?

I am using MS.SQL.

why i am using DNS? because i dont know the other method




and right now i have yet to decide what should i use, inno setup or inno script, its all up to the suggestions that you and other experts will give me.

[dglienna]

You use Inno Script to write the script that Inno Setup uses to create the installation file. Inno Script lets you add files, and install them. Do you have a blank DB to include or are you including a populated DB? It can't be open at the time.

[randem]

hYph3n,

MS SQL can iuse OLEDB. You will not need a DSN if you connect that way. Take a look in my signature for Multi Database Connection and Database Problems. These should help you.

[hYph3n]

@ randem

i have read the links in your signature, database multi connection and problems, but none of these tell me the detail about OLEDB, can you give me the link to read it.

however, right now my application is complete using the DNS, can you tell me somehow to make the setup file for my application.

[randem]

hyph3n,

Look in my signature for ********** and Inno Setup to create your setup package. Also look in my signature for Connection Strings to help you with OLEDB connection.

[hYph3n]

hyph3n,

Look in my signature for ********** and Inno Setup to create your setup package. Also look in my signature for Connection Strings to help you with OLEDB connection.

right now i am downloading the inno setup file, thanks man!

and i have read the connection string as well

Standard Security:
"Provider=sqloledb;Data Source=<it will be the path? should it be absolute path or relative?>;Initial Catalog=<our database>;User Id=sa;Password=asdasd;"

one more thing. you wrote there OLEDBConnection (.NET), will this work for my VB6 as well?

[randem]

hyph3n,

OLE DB, OleDbConnection (.NET)

You want to use OLE DB. Only OleDbConnection is for .NET.

it will be the path? should it be absolute path or relative?

That depends on where your database is. I would not hard code it though. Use a variable that can be changed inside your app.

[hYph3n]

hyph3n,


You want to use OLE DB. Only OleDbConnection is for .NET.


That depends on where your database is. I would not hard code it though. Use a variable that can be changed inside your app.

i am very much thank ful to you, i dont know how can i pay you for my appreciations, however, i have added to your reputations

Thanks again man! ..

and i think, i must ask for the database during the setup wizard. thanks again


i have posted one more question regardin the license, if you can help me in it then please check out the post in the very forum.