Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Job fails after changing IP address Expand / Collapse
Author
Message
Posted Monday, October 22, 2012 3:43 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 5:22 AM
Points: 53, Visits: 904

There is a package imports data from MySQL server to SQL Server. The Package connects to the linux server through ODBC connection. But recently MySQL IP address been changed. After changing IP in ODBC connection, the package is still failing to run inside the job. Meanwhile it runs when I run it manually.
I can't figure it out what's going wrong. Tried to create new job, still the same. The error inside the job indicates that it's refering to the old IP address. But within package I didn't include IP address anywhere. It just uses connection through ODBC. Any help is appreciated.

Thanks.
Post #1375316
Posted Monday, October 22, 2012 4:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, Visits: 499
Are you changing the correct ODBC driver? Have you created a user DSN and are changing that? Do do you have 32 & 64 bit versions of the ODBC driver and are changing the wrong one?

Mack
Post #1375333
Posted Monday, October 22, 2012 8:16 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 5:22 AM
Points: 53, Visits: 904
You were right Mackers,

All the time I was changing wrong DSN . Forgot that the package works with system DNS only while running in job, and it uses User DSN while running in Visual Studio when you are using 64 bit Server.

Thank you very much.
Post #1375806
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse