Re: Problem setting up Oracle -> SQL dts task

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello Philip,

I think Oracle client is also necessary and MDAC shall be updated for this
situation.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
From: "Philip Colmer" <pcolmer@xxxxxxxxxxxxxxxx>
References: <OI$3SPTQGHA.5520@xxxxxxxxxxxxxxxxxxxx>
<mbPw7rYQGHA.4620@xxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Problem setting up Oracle -> SQL dts task
Date: Tue, 7 Mar 2006 07:12:40 -0000
Lines: 100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
Message-ID: <OZHyJabQGHA.5808@xxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.sqlserver.dts
NNTP-Posting-Host: 84.12.25.254
Path: TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.dts:64252
X-Tomcat-NG: microsoft.public.sqlserver.dts

Peter

Just to clarify - I'm running the enterprise manager on an XP PC. My
intention is to pull the data from Oracle and push it to MS SQL. Do I
still
need to make changes on the SQL Server as your posting suggests?

Thanks.

--Philip

"Peter Yang [MSFT]" <petery@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:mbPw7rYQGHA.4620@xxxxxxxxxxxxxxxxxxxxxxxx
Hello Philip,

Please check if you create a odbc DSN to oracle on the server, can you
access Oracle server properly via ODBC connection using MS odbc driver
for
Oracle?

You may want to install the latest Oracle client to test the situation:

220915.KB.EN-US PRB: SQL Distributed Query with Oracle Needs Oracle
Client
and
http://support.microsoft.com/default.aspx?scid=KB;EN-US;220915

In addition, you may want to reinstall MDAC on the server by right
clicking
%windir%\mdac.inf->Install. You will be prompted to insert Win2003 SP1
setup CD.

Since it is a hang issue, to find out the root cause of this issue we may
need to analyze memory dumps, this work has to be done by contacting
Microsoft Product Support Services. Therefore, we probably will not be
able
to resolve the issue through the newsgroups. I recommend that you open a
Support incident with Microsoft Product Support Services so that a
dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.

For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no
rights.


--------------------
From: "Philip Colmer" <pcolmer@xxxxxxxxxxxxxxxx>
Subject: Problem setting up Oracle -> SQL dts task
Date: Mon, 6 Mar 2006 15:37:02 -0000
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
Message-ID: <OI$3SPTQGHA.5520@xxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.sqlserver.dts
NNTP-Posting-Host: host.chadwyck.co.uk 195.22.151.242
Path: TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.dts:64222
X-Tomcat-NG: microsoft.public.sqlserver.dts

I've set up a PC that is to act as a DTS engine to pull data out of an
Oracle server & pump it into a database under SQL 2000. I've done it this
way, rather than using the SQL Server itself because I don't want to
install
the Oracle client software onto the server.

I've created the DTS package with the Oracle connection, the SQL
connection
and a Transform Data Task between the two. My problem is that if I
right-click on the transform data task, the user interface just hangs.
I've
tried using both the ODBC and OLE DB Oracle connectoids, but to no avail.

I've checked that the Oracle client software is able to communicate with
the
Oracle server, and it is.

Any suggestions?

--Philip








.

Relevant Pages

  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... "Oracle may provide additional releases or versions of its programs ... in the form of an Update as part of our technical support services. ... cucumber vendor that insisted I could only buy cucumbers from them, ... If I have the source code, I know I can relly on a product for ever, ...
    (comp.lang.php)
  • Re: Oracle licence question
    ... What you mean - they use portable SQL as definied by the ANSI SQL standard, ... and every support call costing an arm and a leg. ... One thing you need to watch is staffing, costs for Oracle staff here in the ... no added cost in the database - and that duplication has cost, ...
    (comp.databases.oracle.server)
  • Re: Problem when WIndows 2000 Server is rebooted
    ... who were not forced, as a contract condition, to support versions of the ... a currently supported version of the Oracle database. ... support a version of the Oracle database that is under active Oracle ...
    (comp.databases.oracle.server)
  • Re: Thoughts on MF COBOL, Unix, and RDBMS
    ... COBOL compiler available but it doesn't support SQL, ... It does support SQL, either through the MF-supported OpenESQL precompiler or the Oracle ... You can talk through ODBC or OCI (Oracle Call ...
    (comp.lang.cobol)