MySQL Forums
Forum List  »  Microsoft SQL Server

DTS error message
Posted by: Chu Soon Tan
Date: August 30, 2010 07:33PM

Dear:

I have schedule a script using DTS package which transfer the data in mssql to mysql server through port 3306 with LAN network connections.

but i encounter some error message as follow:
Executed as user: SG\svc-clustersvc. ...art: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error string: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '10.8.1.254' (10060) Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 2003 (7D3) Error string: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '10.8.1.254' (10060) Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '10.8.1.254' (10060) Error source: Microsoft OLE DB Provider for ODBC Dri... Process Exit Code 5. The step failed.

it was not occur offer but few time already, does anyone understand the error message?

I check my mysql server, the service is up and accessible. and also for mssql server as well.

many thanks.
chusoon

Options: ReplyQuote


Subject
Written By
Posted
DTS error message
August 30, 2010 07:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.