MYSql ODBC Connection Help Please

General discussion forum about all databases other than SqlBase.

MYSql ODBC Connection Help Please

Post by » 19 Mar 2014, 16:07

Having a problem with MYSql ODBC connection from SQLTalk. The system DSN test connection is OK.
Connect to local SQLBase server - OK.
When tryging to connect to MYSql ODBC I get 401.

ODBC does not appear in Gupta Connectivy Admistrator
Relevant sql.ini

Code: Select all

; On 11.7 and above, if the CLIENTNAME is not specified, the computername
; will be displayed on the server. Also, the CLIENTNAME is not limited to 12 characters.

; The transports option overrides the [win32client.dll]
; Possible values for transports are
; npipe,tcpv4,tcpv6,apipe
;clientruntimedir=C:\Program Files\Gupta\SQLBase117

; The [win32client.dll] used to have a list of communication .dll's
; to use for communication. Communication .dll's have been removed.
; This section is read and interpreted to be backwards compatibible.
; The transports parameter now supersedes it.



Mike Vandine

Re: MYSql ODBC Connection Help Please

Post by Mike Vandine » 20 Mar 2014, 02:39

Hi Phil,

Are you trying to connect to the MySQL database using SQLTalk? That's not going to work. SQLTalk doesn't connect to other DB types anymore.

Best regards,

Posts: 2212
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: MYSql ODBC Connection Help Please

Post by FRBhote » 20 Mar 2014, 06:23

That is sad. Because when we want to connect with SqlWin, we first check connection with Sqltalk. If that works then SqlWin will work too.

Mike Vandine

Re: MYSql ODBC Connection Help Please

Post by Mike Vandine » 20 Mar 2014, 06:32

The SQLTalk that is in the TD Development directory still connects, I think. Just not the one from the SQLBase directory.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests