[egenix-users] RE: [egenix-support] SQL Server connection to Oracle Bug (Distributed Database)

Remy Pinsonnault remy_pinsonnault at roche.ca
Wed Mar 30 11:28:05 CEST 2005


Ok thanks for your help.

I will continue my investigation and I will have to buy a support ticket if
I don't fint the problem.

Rémy

-----Original Message-----
From: eGenix Support Team: M.-A. Lemburg [mailto:support at egenix.com] 
Sent: Miércoles, 30 de Marzo de 2005 10:15 a.m.
To: remy_pinsonnault at roche.ca
Cc: 'egenix-users at lists.egenix.com'
Subject: Re: [egenix-users] RE: [egenix-support] SQL Server connection to
Oracle Bug (Distributed Database)


Rémy,

the whole subject of distributed transactions is very
complex, so we can only guess at what's causing the
problem without having direct access to your machine.

The fact that the old ODBC DA works for you indicates that
your setup has a problem with connections that are pooled to execute more
than one request simultaneously. Another possible cause is that the other
tools you are using are not trying to initiate a distributed transaction at
all and thus don't see the problem.

There's also a bug in SQL Server 2000 that may be related
to the problem you are seeing:

* ODBC Driver for SQL Server 2000 Incorrectly Returns SQL_SUCCESS on
SQLDescribeParam()
   http://support.microsoft.com/default.aspx?scid=kb;en-us;321255

   (mxODBC uses SQLDescribeParam() whereas the old ODBC DA does not)

Some more problem cases are described in the MS knowledge base:

http://support.microsoft.com/search/default.aspx?query=7391+OLE+DB&catalog=L
CID%3D1033&pwt=false&title=false&kt=ALL&mdt=0&comm=1&ast=1&ast=2&ast=3&mode=
a&x=0&y=0

This one sounds like a good candidate to check:

* You may receive a 7391 error message in SQL Server 2000 when you run a
distributed transaction 
against a linked server after you install Microsoft Windows XP Service Pack
2

   http://support.microsoft.com/default.aspx?scid=kb;en-us;839279

When debugging problems like these, please always start
Zope from a command window - not as service. If that works,
try finding out which permissions are needed to access
the various components involved in the distributed
transaction and update the policy of the Zope service
account accordingly.


Please note that our support is not free of charge. If you want us to help
you beyond the links and hints we've already given you so far, please
purchase a support ticket from our web-site. We can also provide remote
login support if needed to help you resolve the problem.

Thanks,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Mar 30 2005)
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::



More information about the egenix-users mailing list