[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

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

How to access a MySQL database on an internet server?

I have a C# program (desktop) that I want to access a web service.  That web service (also written in C#) needs to access a MySQL database sitting on the hosting server (a Windows server).  I imagine that connection string would have the site name(?) and database name, but haven't a clue how to put it together.

Can someone please give me a pointer to a doc or something?  
0
rmmarsh
Asked:
rmmarsh
  • 5
  • 5
1 Solution
 
Jaime OlivaresCommented:
That's depend on the library you have choosen to access the MySql server. Have a look to:
http://www.connectionstrings.com/?carrier=mysql
0
 
rmmarshAuthor Commented:
If I'm using the Visual Web Developer 2005, what choices do I have for a library?  I see the connection string is almost a no brainer, but still don't know what to use for the connection: ODBC?
0
 
rmmarshAuthor Commented:
s/b Visual Web Developer 2005 *Express*
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Jaime OlivaresCommented:
I mean, the mysql connection type: ODBC, OleDB, which have you selected?
The link I have posted give you connection string for all possibilities.
0
 
rmmarshAuthor Commented:
Yes, it did... I guess I'll just pick one and see what happens... what do I put in the slot for "provider"?
0
 
Jaime OlivaresCommented:
in OleDB should be MySQLProv as shown.
0
 
rmmarshAuthor Commented:
OK... how does it know where the database is?  (ie the host name?)

R
0
 
Jaime OlivaresCommented:
if you are using OleDB (I have this not clear until now), you define a connection in the Windows Control Panel, specifying URL, servername, port, etc.
This connection has a name, this is the name you use in the DataSource field.
0
 
rmmarshAuthor Commented:
I'm using ODBC... give me a few days to figure this out (have to work the remainder of the week, so only work on this in my spare time)...

Thanks for your help so far...

R
0
 
vbturboCommented:
Hi

I you work alot with mysql then this would might be worth to consider

http://www.crlab.com/mysqlnet/

vbturbo
0
 
Jaime OlivaresCommented:
Still waiting for author response...
0

Featured Post

Industry Leaders: 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!

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