On our test server I use MS SQL Server Load stages to Bulk load data from DB2 to SQL Server in a number of jobs. I have exported these jobs and imported it on our Production server, and without changing anything other than the connection to the correct DB2 database, I now get the errors:
MS_SQL_Server_Load_7: Internal error: IDBInitialize->Initialize() failed.
MS_SQL_Server_Load_7: Failed to establish datasource connection
Does anybody have any idea how this can be solved?
Since there is no connection made to SQL Server, setting up a trace on SQL Server is of no use...
MS SQL Server Load stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Is your production server a separate machine than the machine from which you exported these jobs?
All work in DataStage takes place in the DataStage server. So moving to a new server will imply re-configuring these connections for DataStage to work.
As it raises 'initialize' error, you can start looking at dsenv file (available under the DSEngine directory).
Depending on how you do the load to SQL Server db, you may need to install and configure other libraries.
All work in DataStage takes place in the DataStage server. So moving to a new server will imply re-configuring these connections for DataStage to work.
As it raises 'initialize' error, you can start looking at dsenv file (available under the DSEngine directory).
Depending on how you do the load to SQL Server db, you may need to install and configure other libraries.
-
- Participant
- Posts: 2
- Joined: Tue Jan 25, 2005 5:39 am
- Location: Singapore
Re: MS SQL Server Load stage
I hope that you had resolved the problem. I am getting the same error now. can you pass me the solution.
Thanks for your time !
Thanks for your time !
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: MS SQL Server Load stage
I am at a different client now, but as I remember well, it had something to do with the ODBC connection from the production server to the SQL Server.
-
- Participant
- Posts: 2
- Joined: Tue Jan 25, 2005 5:39 am
- Location: Singapore
Re: MS SQL Server Load stage
Yes. You are correct. It works now after I changed the parameters! Thanks Guys for your valuable time !
Re: MS SQL Server Load stage
I just had the same error message and it turned out to be because the login in SQL server that I had created had a security policy with "expire password at first login" turned on.
In other words the error message seems to be a bit generic and can represent a variety of parameter/login problems.
In other words the error message seems to be a bit generic and can represent a variety of parameter/login problems.
First make it run, then make it right and then make it fast.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: