Gene6 FTP Server Forum: MySQL DB setup help - Gene6 FTP Server Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

MySQL DB setup help I am unable to use a MySQL DB Rate Topic: -----

#1 User is offline   letkemanp 

  • Member
  • PipPip
  • Group: Members
  • Posts: 10
  • Joined: 12-July 04

Posted 12 July 2004 - 05:19 PM

I am unable to connect to Gene6 using MySQL server 4.x with MyODBC for authentication.

This is my connection string:

Driver={mySQL};Server=localhost;Port=3306;Option=131072;Stmt=;Database=ftpdb;Uid
=pete;Pwd=dbadmin;

This is my query:
select password, account FROM ftp_auth WHERE uid=%s

This is my database setup:
Table Name = ftp_auth
Field Name, Field Type
uid, varchar(30)
password, varchar(30)
autoid, int(3) unsigned,YES
account, varchar(30)

This is what appears in the log:
04/07/12 12:04:32, [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
04/07/12 12:04:32, Authentication error: Could not invoke authentication
0

#2 User is offline   Matthieu 

  • Addicted Member
  • Group: Staff
  • Posts: 1964
  • Joined: 22-October 03
  • Gender:Male
  • Location:France : Mouy
  • Interests:Science-fiction, World news

Posted 12 July 2004 - 07:31 PM

QUOTE
Driver={mySQL};


You need to define the driver to use "{mySQL}" is not enough (make sure you also installer myODBC for mysql).
Gene6, SARL
Do not use PM to ask for support, use the forum or support email.

Special offer : 10% discount with coupon code : DISCOUNT
0

#3 User is offline   letkemanp 

  • Member
  • PipPip
  • Group: Members
  • Posts: 10
  • Joined: 12-July 04

Posted 12 July 2004 - 07:41 PM

Yep that was it thanks for you help M.Roger
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users