SqlDbx Forum

SqlDbx

You are not logged in.

#1 2013-03-21 16:24:05

akrckng001
Member

can not connect MYSQL to SqlDbx

HI,

I have done all the required step mentioned to configure MySql with SqlDbx.
But still i am not able to find MySql server into SqlDbx login screen.
I have personal version of SqlDbx.
I have tried with both version of mySql connector-odbc

- mysql-connector-odbc-noinstall-5.2.4-win32
- mysql-connector-odbc-noinstall-5.2.4-winx64

as I am using 64b win machine so first i tried with winx64 but it does not work then i tried with winx32 as well
but nothing give much help... sad

please help me to get cofigure MySql with SqlDbx.

Thanks In Advance.

Offline

#2 2013-03-21 20:58:52

sqldbxhelp
Administrator

Re: can not connect MYSQL to SqlDbx

You need win32 odbc package for Personal edition.
From zip file extract myodbc5.dll and copy it  to directory where SqlDbx.exe located.
Start SqlDbx and on Login Screen select MySQL.
Specify Server as SERVER:PORT where SERVER is the name of the computer where MySQL is running. PORT number if different  from default (3306)
After that you should be able to connect.

Offline

#3 2016-12-14 05:09:30

level_max
Member

Re: can not connect MYSQL to SqlDbx

I have the same problem .

win10 X64   
mysql-connector-odbc-noinstall-5.3.7-win32
Sqldbx Personal edition

I already copy these files to the directory where SqlDbx.exe located

    myodbc5a.dll
    myodbc5a.lib
    myodbc5a.pdb
    myodbc5S.dll
    myodbc5S.lib
    myodbc5S.pdb
    myodbc5w.dll
    myodbc5w.lib
    myodbc5w.pdb

But it does not work.

Prompt message: Unable to find ODBC driver: myodbc5a.dll;myodbc5s.dll;myodbc5w.dll;myodbc5.dll

Last edited by level_max (2016-12-14 05:10:37)

Offline

#4 2020-11-18 01:26:43

RobertBolster
Member

Re: can not connect MYSQL to SqlDbx

sqldbx wrote:

You need win32 odbc package for Personal edition.
From zip file extract myodbc5.dll and copy it  to directory where to buy legal steroids gnc SqlDbx.exe located.
Start SqlDbx and on Login Screen select MySQL.
Specify Server as SERVER:PORT where SERVER is the name of the computer where MySQL is running. PORT number if different  from default (3306)
After that you should be able to connect.




I have sqldbx installed on my windows 10 64bit. When I choose "new connection" I have DBMS type "MySQL" to choose. At first I got errors for missing Dlls but I overcame it.

My sqldbx is installed on Ubuntu in AWS EC2 instance. It has a db and it's working well with my site and using phpmyadmin. I guess my MySql is not configured for remote connections. I tried to add a line in mysql configuration to bind to the external ip but not only it didn't work remotely, it also broke the internal connection and site didn't work well.

Anyone can help please? Thanks!

Last edited by RobertBolster (2020-11-23 04:09:49)

Offline

Board footer

Powered by FluxBB