Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250

    Question Unanswered: mysql connection

    hi

    i could nt connect to mysql from my client app using the connection str

    DRIVER={MySQL ODBC 3.51 Driver};SERVER=192.168.1.212;DATABASE=DB1;UID=MyUs er1;PWD=MyPasswd1;OPTION=18475

    but when i give 'localhost' instead of IP it gets connected to the database

    the ADO error message is

    error no -2147467259

    [MySQL][ODBC 3.51 Driver]Access denied for user: 'MyUser1@MySystem' (Using password: YES

    pl explain this
    Cheers....

    baburajv

  2. #2
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137

    Re: mysql connection

    How have you specified the hostnames in the user, host and db tables in the mysql database?

  3. #3
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250

    Re: mysql connection

    Originally posted by aus
    How have you specified the hostnames in the user, host and db tables in the mysql database?

    could u pl explain , or suggest some links

    am new to mysql
    Cheers....

    baburajv

  4. #4
    Join Date
    Feb 2004
    Posts
    3

    Re: mysql connection

    try this..

    note:
    xserver,xdatabase,xuser,xpass is a variable

    example:
    xserver="192.168.215.3"
    xdatabase="customer"
    xuser="reuben"
    xpass="none"

    also check the character case either lower/upper case of your mysql database,user,password design

    connStr = "DRIVER={MySQL ODBC 3.51 Driver};" _
    & "SERVER=" & xserver & ";" _
    & "DATABASE=" & xdatabase & ";" _
    & "UID=" & xuser & ";" _
    & "PWD=" & xpass & ";" _
    & "OPTION=18475"


    Originally posted by baburajv
    hi

    i could nt connect to mysql from my client app using the connection str

    DRIVER={MySQL ODBC 3.51 Driver};SERVER=192.168.1.212;DATABASE=DB1;UID=MyUs er1;PWD=MyPasswd1;OPTION=18475

    but when i give 'localhost' instead of IP it gets connected to the database

    the ADO error message is

    error no -2147467259

    [MySQL][ODBC 3.51 Driver]Access denied for user: 'MyUser1@MySystem' (Using password: YES

    pl explain this

  5. #5
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    THANKS,,

    IT WORKED,

    BUT WATS THE OPTION, 18475 ?
    Cheers....

    baburajv

  6. #6
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137
    Option 18475 is the sum of a few different options that MyODBC accepts, like changing LONGLONG columns to INT, for one. It also uses a compressed communication protocol, simulates an ODBC 1.0 driver, doesn't set a packet limit, returns found rows instead of affected rows and tells the driver that the client can't handle the real width of the column. More detail is available below.
    http://www.mysql.com/doc/en/MyODBC_c...arameters.html

  7. #7
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    thanks
    Cheers....

    baburajv

Posting Permissions

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