Ang: RE: Access to Oracle

From: <Roland.Skoldblom_at_ica.se>
Date: Fri, 25 Jan 2002 00:06:50 -0800
Message-ID: <F001.003FAE21.20020124235022@fatcity.com>

Can you please guide me how to do all these steps?

Roland

"MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU>@fatcity.com den 2002-01-24 08:15 PST

Sänd svar till ORACLE-L_at_fatcity.com

Sänt av: root_at_fatcity.com

Till: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Kopia:

Whose ODBC DRIVER are you using? If it is Microsoft's ,go to the "workaround options" for the DSN; once there, turn of muti-threaded server support.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----

Sent: Thursday, January 24, 2002 4:55 AM To: Multiple recipients of list ORACLE-L

Anyone who can help me with this:

I have a Microsoft routin, whic calls oracle procedure in database "servername", which have a databaselink to other databases(located on computers with Linux system).That procedure is supposed to pick up data from tables which exist in the other
databases. It works fine when I run the oracle procedure from oracle, but when I make the call from oracle I get the following error message:

Why doesnt this work. If I make an ordinary call to rhe database "servername" and just picks data from the same database then it is no problem at all.

SQLCODE = -2041
SQLERRM = ORA-02041 client database did not begin a transaction

the query that is executed is: SELECT TABLE_NAME FROM ALL_TABLES_at_C.Hakon5 WHERE TABLE_NAME='ICA_ARTIKEL' AND OWNER='A111640' and that doesnt seem so strange to me.

I can run this query separately from oracle too but when i run it from Access application(by the call) then I get the errormessage according above.

Really appreciate if anyone could help me with this.

Thanks in advance

Roland

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Roland.Skoldblom_at_ica.se

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Roland.Skoldblom_at_ica.se

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jan 25 2002 - 02:06:50 CST