|
-
Nov 15th, 2012, 10:11 PM
#22
Re: Home Server
You want to test the connection, db operations(SELECT, INSERT, etc.) that you have written in your VB.Net application with a mysql db. Isn't it ?
Then download the MySQL connector for ADO.Net: http://dev.mysql.com/downloads/connector/net/1.0.html
Install WAMP or XAMP or something like that in your machine. Turn it ON. Now, your db would be available under the host: "localhost", db name would be the name of the db that you have created (you could use phpMyAdmin for this), and use a db username and password that you have created for it or you could use the default ones when you install WAMP.
Then import the MySQL connector in your program and use it. An example is available here: http://stackoverflow.com/questions/6...answer-6190631
For the connection string, you could use this syntax: http://www.connectionstrings.com/mys...ysqlconnection
Like others said, I didn't get the idea of using a separate server/PC for testing. You could use the local server within that PC like I said above, or you could setup a Virtual Machine like others suggested.
Or, are you trying to figure out something specific ?
If my post was helpful to you, then express your gratitude using Rate this Post. 
And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video)
My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler Master 450W Thunder PSU, 1.4 TB HDD, 18.5" TFT(Wide), Antec V1 Cabinet
Social Group: VBForums - Developers from India
Skills: PHP, MySQL, jQuery, VB.Net, Photoshop, CodeIgniter, Bootstrap,...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|