Including database in the installation
-
Hello, How do I include the database that I am using to my VB .NET application? My application and the DB is connected via the ODBC. And i dont want to set up the database in another PC and creating the database and tables, etc... I would like to have the DB, tables, etc setup once my application is installed.. Possible? The database that I am using is mySQL Server 5.0; Driver is: MySQL ODBC 3.51 Driver Visual Studio 2005. And I am planning to publish the application via the publish tab in the properties. Thanks!
-
Hello, How do I include the database that I am using to my VB .NET application? My application and the DB is connected via the ODBC. And i dont want to set up the database in another PC and creating the database and tables, etc... I would like to have the DB, tables, etc setup once my application is installed.. Possible? The database that I am using is mySQL Server 5.0; Driver is: MySQL ODBC 3.51 Driver Visual Studio 2005. And I am planning to publish the application via the publish tab in the properties. Thanks!
I have used MySQL in Linux Environment a long time ago. propably in redhat 6 :). i have never used it in Windows. but to my knowledge Mysql is not like MS Access , you cannot ship it with your Application. even SQL you cannot do that. We usually have a Server and our Applications will point to that Server for Data, but now if you want to Copy your App on the CD and expect a DB , i think you should go for MSAccess. Hope this Helps
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
I have used MySQL in Linux Environment a long time ago. propably in redhat 6 :). i have never used it in Windows. but to my knowledge Mysql is not like MS Access , you cannot ship it with your Application. even SQL you cannot do that. We usually have a Server and our Applications will point to that Server for Data, but now if you want to Copy your App on the CD and expect a DB , i think you should go for MSAccess. Hope this Helps
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
Really?? Bummer. So, the only way around this is to just put all the tables in a text file and just copy-paste it then, huh? X| Thank you :)
No. I don't use MySQL so I can't really comment on it specifically. But, you normally include a blank copy of your database files or the SQL scripts to create the database in your installer. You can execute anything you need to setup the database from there.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
No. I don't use MySQL so I can't really comment on it specifically. But, you normally include a blank copy of your database files or the SQL scripts to create the database in your installer. You can execute anything you need to setup the database from there.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008