asked on

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?

ASKER CERTIFIED SOLUTION

Carl Tawn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

KBanner

ASKER

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.

Carl Tawn

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.

SOLUTION

Bob Learned

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

KBanner

ASKER

Guys, thanks very much.

That'll give us a good foundation to get our feet wet.

KBanner

ASKER

I will issue points straight after, however, if I have further 'quick' questions, may I post at a later time?

Thanks again
Kerrin