MYSql ODBC Connection Help Please

[phil@informasys.com]

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

[win32client]
; 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.
clientname=Win32User

; The transports option overrides the [win32client.dll]
;ection.
; Possible values for transports are
;
; npipe,tcpv4,tcpv6,apipe
;transports=npipe,tcp,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.
;
[win32client.dll]
comdll=sqlodb32
comdll=sqlws32
;comdll=sqlapipe

[win32client.ws32]
serverpath=MSIAPP,127.0.0.1,2155/*

[odbcrtr]
remotedbname=MMSP,DSN=MMSP
odbctrace=off
odbctracefile=
longbuffer=32000
enablemultipleconnections=off
fetchrow=1

[Mike Vandine]

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,

[FRBhote]

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]

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