Solved

odbc error connecting mysql

Posted on 2004-09-08
2
787 Views
Last Modified: 2012-06-21
running windows xp pro sp1, running mysql server & client 4.0.20a and access 2000 on same pc. would like to use access 2000 as frontend for mysql.

downloaded mysql ODBC 3.51.09 Driver and installed it successfully.

mysql startup using "mysqld"

created system dsn
dsn name : test
descrip: MySQL ODBC 3.51 Driver DSN
server name /ip: localhost
db name: test
user : root
password: (blank)

port (if not 3306)-  blank
sql cmd to connect - blank

msaccess 2000:
when i click "test data source" diagonal box pop up "[MySQL][odbc3.51 driver] Can't create tci/ip socket (10050)"


mysql server log :
error: aborted connection 1 to db: unconnected user 'odbc' host localhost 'got an error reading communication packet'

Need to create odbc connection to mysql .Can someone please help me resolve this ?
0
Comment
Question by:nikarim
2 Comments
 
LVL 10

Accepted Solution

by:
jayca earned 500 total points
ID: 12011900
Check your port setting.
Can't create tci/ip socket (10050

I would rather use MSDE :)

Check this tutorial
http://www.aspfree.com/showblog/433/An-Access-FrontEnd-to-MySQL

0
 

Author Comment

by:nikarim
ID: 12012243
o.k figure it out. Sorry not from the link to your tutorial but from your comment... sorta  "Check your port setting."

went back to networking 101
1) did everything right ? yes
2) what is the problem ? "can't connect"
3) port, sockets ? "nah"
4) did i mention everything ? "nah"
5) what did i forget to mention ? ***McAfee !
6) Shutdown McAFee Virus & Firewall and ...   Viola! It work !



0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now