[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

Link to MySQL Database

Hi,

Really looking for guidence rather than a solution

Want to link into a MySQL database that we have with our host.

Can anybody guide me into where to start first.

I have VS.NET 2003. Is there a DataAdapter that allows this?
0
KBanner
Asked:
KBanner
  • 3
  • 2
2 Solutions
 
Carl TawnSystems and Integration DeveloperCommented:
You would need to use either the Odbc or OleDb database objects located in the System.Data.Odbc and System.Data.Oledb namespaces respectively. Conenction strings for MySQL can be found here:

    http://www.connectionstrings.com


If you need a code sample just say.
0
 
KBannerAuthor Commented:
Some code would be good thanks carl.

If you were to set it up via the dataAdapter wizard, is there anything I should know regarding host addresses etc.
0
 
Carl TawnSystems and Integration DeveloperCommented:
There are some samples here:  http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1288&lngWId=10

Only used MySQL a few times on Linux, but i'm not aware of any specific problems connecting to it. Haven't really used the DataAdapterWizard either so can't really comment, but I would guess it's fairly straight forward.

The usual things to look out for are firewalls and port numbers, but as long as you're using the defaults you should be ok.

If you run into any problems just post them here and we'll be happy to help you troubleshoot.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Bob LearnedCommented:
You can use the MySQL .NET data provider with .NET 2003:

    http://dev.mysql.com/downloads/connector/net/1.0.html

Bob
0
 
KBannerAuthor Commented:
Guys, thanks very much.

That'll give us a good foundation to get our feet wet.
0
 
KBannerAuthor Commented:
I will issue points straight after, however, if I have further 'quick' questions, may I post at a later time?

Thanks again
Kerrin
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now