Results 1 to 6 of 6

Thread: MYSQL connection error

Threaded View

  1. Jan 8th, 2007, 07:32 AM #1
    slaphead109
    slaphead109 is offline

    Thread Starter
    Member
    Join Date
    Oct 2002
    Posts
    54

    MYSQL connection error

    I am trying to remotely connect to a MySQL database version 4.1.14 via VB6.

    The connection string I am using is :-

    CONN_STR = "Driver=SQL Server;Server=" & SERVER_IP & "," & ";Database=" & DataBase & ";Uid=" & UID & ";Pwd=" & PWD & ";"

    However, I believe I am not declaring the driver correctly. I have used "SQL Server" which was used in the example from www.connectionstrings.com.

    I have downloaded the ODBC 3.51 driver and it has auto installed somewhere (no idea where).

    How do I use it in my code?
    Do I need to add a reference to it in my project (It doesn't seem to be in the list)?

    Has anyone any experience of connecting to a remote MySQL database please?
    Last edited by slaphead109; Jan 8th, 2007 at 11:26 AM. Reason: I don't believe the driver is the problem
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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