Printable View
Hi Friends,
Our (Visual Basic) appds developer is using OLEDB/ODBC to connect
to our Oracle 8i database which resides on RS6000 AIX . He uses the
Win2K server as the middle tier for his MTS. On the middle tier server
we have also a 10g DB and 10g client installed on different home.
Thay have their respective net manager and tnsnames.ora.
My question is how can i direct hist VB programs ODBC to use the
connect id of the tnsnames.ora of the 10gDB and not the tnsnames.ora
10g client.
Thanks a lot
1. Set the oracle_home to that of the DB
2. make both files the same
3. uninstall the client as you dont need it
4. set TNS_ADMIN
Thanks dear, but this VB programmer is troubling me about his
program error using a OLE DB. He said his program works fine in
8i client, but when we used 9i client he got error related to
distributed trasaction coordinator. The work around he got on 9i
client is to install the MSVCRTD.DLL as what oracle forum suggested:
Heres the qoute for one forum related to the problem:
quote********************************************************quote
Hi,
Can anyone help me to solve this problem?
When we set the TRANSACTION attribute to REQUIRED
TRANSACTION for our components. We hit the
following error.
Error: -2147168246
Error Description: "New transaction cannot enlist in the
specified transaction coordinator. "
Our scenario:
Our components are set to "REQUIRES TRANSACTION".
Here is our current configuration :
Machine 1: (Hosts our COM+ components)
(a)Oracle Net Client 9.2.0.1.0
(b)Oracle Services per Microsoft Transaction Server
(c)Oracle OLEDB Providers 9.2.0.2.0
(OraOLEDB.Oracle)
(d)Windows 2000 COM+ Services
(e)COM Components deployed under MTS that use ADO to talk
to the Oracle
(f)OS: Windows 2000 Professional
Machine 2: (Hosts Oracle 9i Server 9.2.0.1.0)
(a) Oracle 9i Server 9.2.0.1.0
(b) Windows 2000 Advanced Server
The Oracle MTS Recovery Service is started successfully.
Whenever we choose our components to enlist in a
transaction by choosing
the MTS 'Requires a transaction' attribute, we get back
the following
error
from the provider :
Error: -2147168246
Error Description: "New transaction cannot enlist in the
specified
transaction coordinator. "
With the Microsoft OleDB Provider MSDAORA we get back no error.
The test program msdtcora.Exe works with success.
Any help will be appreciated.
thanks,
Domenico
Anser for Oracle ======================================
The ORAMTS component that originally shipped with Oracle 9i Release 2 was a debug version of the actual ORAMTS.DLL component.
The incorrect component has a dependency on msvcrtd.dll (a debugging component included in Microsoft Visual C++) and will not
function correctly on any machine that does not have msvcrtd.dll installed.
The problem can be resolved via one of the following solutions:
· Obtain and install Oracle 9i Patch 2428356
(HIGHLY Recommended Solution)
Oracle is aware of this problem and is providing a patch that contains the correct version of ORAMTS.DLL. Customers with a valid
Oracle support contract may obtain this patch directly from Oracle.
· Install msvcrtd.dll on the Oracle server
(Alternative Solution)
In the event that the Oracle patch cannot be obtained, the server may be patched with msvcrtd.dll. This solution has not been
extensively tested and may cause instability or loss of performance.
Note: The Microsoft development EULA forbids the redistribution of the msvcrtd.dll component! Production servers MUST be patched
with the official Oracle patch!
=====================================
Quote
"· Obtain and install Oracle 9i Patch 2428356"
Iive searched for this patch# in the metalink but to no avail.
Is this a patch fot the database of for the client?
What should i do in the 10g connections?
Thanks a lot
Did u encounter anything similar to this?
I just found that patch quite easily - didnt look hard enough I guess - or in the right place
Hi dear,
I login to metalink,
then click patch & updates,
then click simple seach,
-(search by) patch no,
-entered the patch no 2428356
-(platform or language) MS Wimdows (32-bit) Client
then go,
no patches found
Where did i go wrong?
Thanks a lot
:)
Log onto metalink
Click Patches and Updates
Click Simple Search
Enter 2428356 into the wee little text box
Select Micrsoft Windows (32 Bit) from the platform bit.
Click on the little go button
gee whizz I have a match!
Ooh dear...But thats what i exactly did?
Maybe the site likes u better than me?
Or does it concern our maintenance. It will
lapsed this coming May.
try reading a bit harder - you chose client. It isn't a client patch
waaa...Quote:
Originally posted by davey23uk
Log onto metalink
Click Patches and Updates
Click Simple Search
Enter 2428356 into the wee little text box
Select Micrsoft Windows (32 Bit) from the platform bit.
Click on the little go button
gee whizz I have a match!
u r confusing me again, theres no option to choose from there about
database only platform or language, and thats what u said also
makauwi na nga, gabi na eh
??Quote:
Originally posted by kris123
makauwi na nga, gabi na eh
Ohh sorry dear, it means "I have to go coz its getting late"
Hi Kris,
If I read your post before correctly, you have a colleague programmer who tried this (quote)
"The test program msdtcora.Exe works with success."
I am having problems with this with regards to Oracle 9i. The msdtcora.exe that I've found is only specified for Oracle 7/8. I keep getting errors, but don't know if this is because the test program is not compatible with Oracle 9i, or if there really is a problem with the Oracle config.
Would it be possible to get into contact with him/her?
Regards
Jakob Boivie
that person is banned from this forum - what is the trouble you are having?
LOL....blast from the past.
kris123 was as mad as a box of frogs
I think there might be a problem with our Oracle config, which is producing DB connection errors. We are running an application on Windows 2000 advanced server, using Oracle 9i as DB.
In order to verify this I was using the Oracle Test program for COM+ on Windows 2000, msdtcora.Exe from http://support.microsoft.com/kb/q193893/. This one supposedly uses standard Oracle interfaces, not Microsoft DTC.
However, since the readme says:
"This Oracle test program determines whether you can connect to your
Oracle7.3 or Oracle8 database using Oracle's XA facility.", I don't know whether the error I am getting is because the test program is not applicable to Oracle 9i, or if the problem is in the Oracle config itself?
In detail, the original error is "Microsoft][ODBC Driver Manager] Failed to enlist on calling object's transaction, SQLSTATE=25000", which happens when the ODBC Driver Manager’s call to the ODBC driver fails. I have tried using Microsofts ODBC driver instead of Oracles, but to no success. Also tried changing transaction timeout on the MTS.
/Jakob
This is the error from msdtcora.exe:
Calling LoadLibrary on xa73.dll.
LoadLibrary on xa73.dll failed.
/Jakob
ok, 7.3 programs / libraries cannot connect to a 9i database.
That tool is worthless for your tests here. Whats wrong with trying with sqlplus or the odbc test tool?
Sqlplus works fine.