Link to home
Start Free TrialLog in
Avatar of DB-IT
DB-IT

asked on

Error while creating ODBC for MySQL

I'm trying to create a link between MS-SQL 2005 and MySQL in DTS. So, I've installed MySQLConnector/ODBC 3.51 for MySQL ODBC creation. However, I've encountered the following error (refer to file for the settings) :

Connection Failed: [08S01][MySQL][ODBC 5.1 Driver]Lost connection to MySQL server at 'reading initial communication packet', system error:0

Please help. Thanks in advance.
mySQL.bmp
SOLUTION
Avatar of Umar Topia
Umar Topia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of DB-IT
DB-IT

ASKER

Thank you all for the solutions/suggestions