Informix 9.4 und MSSQL2000
Sven needed to pull Informix 9.4 data into SQL Server 2000 for warehousing using DTS packages. The packages ran fine when launched manually, but failed when scheduled as jobs; he asked whether a special ODBC driver was needed. Respondents suggested checking the Informix ODBC DSN, services/hosts entries, and especially the account the job runs under: a scheduled DTS package run by SQL Agent needs sa/sysadmin rights or a proxy account. The poster said he would obtain the job history error message; no confirmed resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, For Datawarehouse anaylsis, we need to import data from our Informix Server to Our MSSQL 2000 Server. We are using DTS, this works as long as you start this packets maually. If we try to use to schedule these Jobs, it is not working. Are there special ODBC or whatever driver ? Thanks, Sven
Some ideas 1. Have you configured the Informix ODBC driver in SQL2000 server. 2. Have you added the services name to the services file in the windows server. 3. Are you using DNS, if not add the Informix server to the hosts file. 4. Does the user id in SQLServer have permissions to run the package. Thank you, Kannan Thirugnanam -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Schuran, Sven Sent: Monday, January 30, 2006 9:28 AM To: ids@iiug.org Subject: Informix 9.4 und MSSQL2000 [6289] Hi, For Datawarehouse anaylsis, we need to import data from our Informix Server to Our MSSQL 2000 Server. We are using DTS, this works as long as you start this packets maually. If we try to use to schedule these Jobs, it is not working. Are there special ODBC or whatever driver ? Thanks, Sven ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email.
Hi, 1. ODBC Connection works manually 2. Informix Connect works perfectly 3. DNS is used everythings works manually 4. admin user is used for test scenaryo Sven -----Ursprüngliche Nachricht----- Von: Thirugnanam.... [mailto:Kannan.Thirugnanam@JTax.com] Gesendet: Montag, 30. Januar 2006 15:49 An: ids@iiug.org Betreff: RE: Informix 9.4 und MSSQL2000 [6290] Some ideas 1. Have you configured the Informix ODBC driver in SQL2000 server. 2. Have you added the services name to the services file in the windows server. 3. Are you using DNS, if not add the Informix server to the hosts file. 4. Does the user id in SQLServer have permissions to run the package. Thank you, Kannan Thirugnanam -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Schuran, Sven Sent: Monday, January 30, 2006 9:28 AM To: ids@iiug.org Subject: Informix 9.4 und MSSQL2000 [6289] Hi, For Datawarehouse anaylsis, we need to import data from our Informix Server to Our MSSQL 2000 Server. We are using DTS, this works as long as you start this packets maually. If we try to use to schedule these Jobs, it is not working. Are there special ODBC or whatever driver ? Thanks, Sven ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
What error message is displayed in the job history. Thank you, Kannan Thirugnanam -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Schuran, Sven Sent: Monday, January 30, 2006 11:49 AM To: ids@iiug.org Subject: AW: Informix 9.4 und MSSQL2000 [6291] Hi, 1. ODBC Connection works manually 2. Informix Connect works perfectly 3. DNS is used everythings works manually 4. admin user is used for test scenaryo Sven -----Ursprüngliche Nachricht----- Von: Thirugnanam.... [mailto:Kannan.Thirugnanam@JTax.com] Gesendet: Montag, 30. Januar 2006 15:49 An: ids@iiug.org Betreff: RE: Informix 9.4 und MSSQL2000 [6290] Some ideas 1. Have you configured the Informix ODBC driver in SQL2000 server. 2. Have you added the services name to the services file in the windows server. 3. Are you using DNS, if not add the Informix server to the hosts file. 4. Does the user id in SQLServer have permissions to run the package. Thank you, Kannan Thirugnanam -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Schuran, Sven Sent: Monday, January 30, 2006 9:28 AM To: ids@iiug.org Subject: Informix 9.4 und MSSQL2000 [6289] Hi, For Datawarehouse anaylsis, we need to import data from our Informix Server to Our MSSQL 2000 Server. We are using DTS, this works as long as you start this packets maually. If we try to use to schedule these Jobs, it is not working. Are there special ODBC or whatever driver ? Thanks, Sven ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email.
Verify in the step tab of the job itself if there is another user mentioned. I had a similar problem, the job owner was sa and the user used to execute the job was a user Which did not have the sysadmin role. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Thirugnanam.... Sent: Monday, January 30, 2006 11:55 AM To: ids@iiug.org Subject: RE: Informix 9.4 und MSSQL2000 [6292] What error message is displayed in the job history. Thank you, Kannan Thirugnanam -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Schuran, Sven Sent: Monday, January 30, 2006 11:49 AM To: ids@iiug.org Subject: AW: Informix 9.4 und MSSQL2000 [6291] Hi, 1. ODBC Connection works manually 2. Informix Connect works perfectly 3. DNS is used everythings works manually 4. admin user is used for test scenaryo Sven -----Ursprüngliche Nachricht----- Von: Thirugnanam.... [mailto:Kannan.Thirugnanam@JTax.com] Gesendet: Montag, 30. Januar 2006 15:49 An: ids@iiug.org Betreff: RE: Informix 9.4 und MSSQL2000 [6290] Some ideas 1. Have you configured the Informix ODBC driver in SQL2000 server. 2. Have you added the services name to the services file in the windows server. 3. Are you using DNS, if not add the Informix server to the hosts file. 4. Does the user id in SQLServer have permissions to run the package. Thank you, Kannan Thirugnanam -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Schuran, Sven Sent: Monday, January 30, 2006 9:28 AM To: ids@iiug.org Subject: Informix 9.4 und MSSQL2000 [6289] Hi, For Datawarehouse anaylsis, we need to import data from our Informix Server to Our MSSQL 2000 Server. We are using DTS, this works as long as you start this packets maually. If we try to use to schedule these Jobs, it is not working. Are there special ODBC or whatever driver ? Thanks, Sven ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Hi, The User has privileg to add DTS for a special database. When he activate DTS package maually all data is stored perfectly in the MSSQL database. I try to get the error message, from our DTS user. Sven -----Ursprüngliche Nachricht----- Von: Lavoie, Diane [mailto:diane.lavoie@domtar.com] Gesendet: Montag, 30. Januar 2006 18:18 An: ids@iiug.org Betreff: RE: Informix 9.4 und MSSQL2000 [6293] Verify in the step tab of the job itself if there is another user mentioned. I had a similar problem, the job owner was sa and the user used to execute the job was a user Which did not have the sysadmin role. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Thirugnanam.... Sent: Monday, January 30, 2006 11:55 AM To: ids@iiug.org Subject: RE: Informix 9.4 und MSSQL2000 [6292] What error message is displayed in the job history. Thank you, Kannan Thirugnanam -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Schuran, Sven Sent: Monday, January 30, 2006 11:49 AM To: ids@iiug.org Subject: AW: Informix 9.4 und MSSQL2000 [6291] Hi, 1. ODBC Connection works manually 2. Informix Connect works perfectly 3. DNS is used everythings works manually 4. admin user is used for test scenaryo Sven -----Ursprüngliche Nachricht----- Von: Thirugnanam.... [mailto:Kannan.Thirugnanam@JTax.com] Gesendet: Montag, 30. Januar 2006 15:49 An: ids@iiug.org Betreff: RE: Informix 9.4 und MSSQL2000 [6290] Some ideas 1. Have you configured the Informix ODBC driver in SQL2000 server. 2. Have you added the services name to the services file in the windows server. 3. Are you using DNS, if not add the Informix server to the hosts file. 4. Does the user id in SQLServer have permissions to run the package. Thank you, Kannan Thirugnanam -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Schuran, Sven Sent: Monday, January 30, 2006 9:28 AM To: ids@iiug.org Subject: Informix 9.4 und MSSQL2000 [6289] Hi, For Datawarehouse anaylsis, we need to import data from our Informix Server to Our MSSQL 2000 Server. We are using DTS, this works as long as you start this packets maually. If we try to use to schedule these Jobs, it is not working. Are there special ODBC or whatever driver ? Thanks, Sven ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Does user admin have sa rights? DTS packages scheduled via sql agents needs sa level perms. If no sa rights you need to use a proxy account. Thanks = "Schuran, Sven" = <sschuran@maske.d = e> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect AW: Informix 9.4 und MSSQL2000 = 01/30/2006 11:48 [6291] = AM = = = Please respond to = ids@iiug.org = = = Hi, 1. ODBC Connection works manually 2. Informix Connect works perfectly 3. DNS is used everythings works manually 4. admin user is used for test scenaryo Sven -----Urspr=FCngliche Nachricht----- Von: Thirugnanam.... [mailto:Kannan.Thirugnanam@JTax.com] Gesendet: Montag, 30. Januar 2006 15:49 An: ids@iiug.org Betreff: RE: Informix 9.4 und MSSQL2000 [6290] Some ideas 1. Have you configured the Informix ODBC driver in SQL2000 server. 2. Have you added the services name to the services file in the windows= server. 3. Are you using DNS, if not add the Informix server to the hosts file.= 4. Does the user id in SQLServer have permissions to run the package. Thank you, Kannan Thirugnanam -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Schuran, Sven Sent: Monday, January 30, 2006 9:28 AM To: ids@iiug.org Subject: Informix 9.4 und MSSQL2000 [6289] Hi, For Datawarehouse anaylsis, we need to import data from our Informix Server to Our MSSQL 2000 Server. We are using DTS, this works as long as you start this packets maually.= If we try to use to schedule these Jobs, it is not working. Are there special ODBC or whatever driver ? Thanks, Sven ***********************************************************************= * ******* Forum Note: Use "Reply" to post a response in the discussion forum. ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of a= ny virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and open= ing any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is= not liable for any loss or damage arising in any way from this message or its attachments.= Privileged/Confidential Information may be contained in this message. I= f you are not the addressee indicated in this message (or responsible for delivery of the= message to such person), you may not copy or deliver this message to anyone. In such ca= se, you should destroy this message and kindly notify the sender by reply email. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =