ODBC connector not working (1 Viewer)

H

hafco

Registered User.

Local time

Yesterday, 20:11

Joined

Aug 2, 2015

Messages

12

• Aug 4, 2015

• #1

does anyone have some suggestions for me?

keep getting error :

Connection Failed [HY000][MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on ''my ip adress' (10061)

also titlebar of the ODBC connector form display's (application not responding).

i've tried to reinstall several times but no results.


installed ODBC driver :MySQL ODBC 5.1 Driver Versie 5.01.13.00


server software
Apache/2.2.16 (Debian)
MySQL-client versie: 5.1.73


MySQL Karakterset: UTF-8 Unicode (utf8)

can anyone help me?

 

Rx_

Nothing In Moderation

Local time

Yesterday, 21:11

Joined

Oct 22, 2009

Messages

2,803

• Aug 5, 2015

• #2

http://www.easysoft.com/applications/openoffice_org/odbc.html
Right hand column - see Connecting Access to - pick source.

It has been about too many years (maybe 9 years). The EPA drinking tried a failed attempt to use this before switching to MS SQL Server.
I remember having to set up a Java server inbetween the MS Access and the database. You are going to have to do some homework. My guess is that it is not direct.

 

Rx_

Nothing In Moderation

Local time

Yesterday, 21:11

Joined

Oct 22, 2009

Messages

2,803

• Aug 5, 2015

• #3

Got a quick break.
Here are the step by step for MySQL ODBC
http://www.geeksengine.com/article/mysql-odbc.html
The Port Number has a default, but a MySQL installation can change that too.
Please be sure and provide feedback for others who may search and find your post.
I don't have a MySQL DB installed so I can't test it.

 

H

hafco

Registered User.

Local time

Yesterday, 20:11

Joined

Aug 2, 2015

Messages

12

• Aug 5, 2015

• #4

Hello there ,
thanks for your response to my question.
I just received an email from my webhosting company.
They informed me that SQL databases on the servers are not available for remote applications.....

But never the less i have learned quite a lot while searching and trying to find the answer for my question, so my efforts where not entirely useless.

 

Rx_

Nothing In Moderation

Local time

Yesterday, 21:11

Joined

Oct 22, 2009

Messages

2,803

• Aug 6, 2015

• #5

"SQL databases"
Just wanted to be clear that "your SQL Databases" are not available...

If you need a free Microsoft SQL Server Database available from a cloud site, look for the key word AZURE. MS Access can use the free ODBC driver SQL Server Native Cleint 11.0 to connect to it.
Thanks for marking you post Solved!