-
2 tnsnames.ora to choose from
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
Last edited by davey23uk; 04-06-2005 at 06:25 AM.
-
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!
waaa...
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
-
Originally posted by kris123
makauwi na nga, gabi na eh
??
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|