MYSql ODBC Connection Help Please

General discussion forum about all databases other than SqlBase.
phil@informasys.com

MYSql ODBC Connection Help Please

Post by phil@informasys.com » 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

[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

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,

FRBhote
India
Posts: 2182
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: [Ahrefs], [Ccbot] and 0 guests