Question Deploy Applications

[Grafix]

Hi dudes,

am newbie in VB.NET applications. I finished my school project successfully. I created a setup project to deploy my system but its not doing what i want after installations, i meant i don't know how to include the database i created using mysql server into the .exe/.msi package.

What i used;

Microsoft Visual Studio 2008
Microsoft SQL Server 2005
MySQL Connect/NET

I Google my problem but could get a dime.

Plz where can i get good resource to solve my problem?

Tnx n cheers >>>

 

[jmcilhinney]

Hang on a second. You say that you're using Microsoft SQL Server 2005 and MySQL Connector/Net. That doesn't make sense. Connector/Net is for connecting to a MySQL database, not SQL Server. You're going to have to clarify. Also, how EXACTLY did you create the database in the first place?

 

[Grafix]

Oh sorry its a mistake.

I created it wit MySQL Server 5.0 using:

mysql> CREATE DATABASE ''databasename''; 
 
mysql> GRANT ALL PRIVILEGES ON ''databasename''.* TO "''username''"@"''hostname''" IDENTIFIED BY "''password''";
 
mysql> FLUSH PRIVILEGES;
 
mysql> EXIT

The database is located @ C:\Program Files (x86)\MySQL\MySQL Server 5.0\data\sisdb

I use Windows Vista Home Premium.

Thank you very much Jm

 

[jmcilhinney]

Where is the MySQL server in relation to your app? Will they be on the same machine?

 

[Grafix]

YES i want the application to work on the target machine with the database i created in MySQL server only ...