From Roland.Skoldblom@ica.se Fri, 25 Jan 2002 00:06:50 -0800 From: Roland.Skoldblom@ica.se Date: Fri, 25 Jan 2002 00:06:50 -0800 Subject: Ang: RE: Access to Oracle Message-ID: MIME-Version: 1.0 Content-Type: text/plain Can you please guide me how to do all these steps? Roland "MacGregor, Ian A." @fatcity.com den 2002-01-24 08:15 PST Sänd svar till ORACLE-L@fatcity.com Sänt av: root@fatcity.com Till: Multiple recipients of list ORACLE-L 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@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@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@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@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@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@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@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@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).