Connecting to MySQL...

Results 1 to 2 of 2

Thread: Connecting to MySQL...

  1. #1
    Join Date
    Dec 1969

    Default Connecting to MySQL...

    Hi everyone!<BR><BR>I&#039;ve been working with ASP in a very basic capacity for the last couple of months using an Access database, but now I&#039;d like to try using MySQL instead. The only problem is I don&#039;t understand how to get a connection to a MySQL database.<BR><BR>I&#039;ve been using a DSNless connection to Access, but this was all very simple as I just specified the location of the Access file on the server and it all worked. But what do I do with a MySQL database? Can I connect to it in the same way, by specifying it&#039;s location in the root folder on the server? As I use MySQL via the command line, I don&#039;t know what MySQL database files look like or where are they kept?<BR><BR>I apologise if the answers to this simple problem are stored somewhere on but I couldn&#039;t find anything that helped!<BR><BR>Thanks in advance for any help,<BR><BR>Chris.

  2. #2
    Join Date
    Dec 1969

    Default Google is a wonderfull place.

    "Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts