 Forum main
page
Most
active member
Login page
Register
Log out
Search page
Information Online
View our event calendar
Add general event such as an upcoming
software release or conference
View all birthdays
Public image gallery
Upload your images in your profile
Profile editing page
Subscription list page
Address book page
Member list page
View the
most active member
User groups listing
Private message page
|
|
Users viewing this topic: none
|
|
Login  | |
|
Oracle Adapter Problems - 23 November 2007
|
|
|
lfbarbieri
Posts: 11
Score: 0
Joined: 24 March 2006
Status: offline
|
Hi there
We use the TopXml Oracle Adapter for a few of our projects. I am trying to use it on my development box and having problems creating a schema using the Database Schema Wizard.
I select "Oracle Data Provider for .NET Version 10.2.0.200" for Data Provider and input my connection information. When I click on "Test Connection" button I am getting the following error:
The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.
I look in the Event Log and I cannot find any more information.
I have no troubles doing queries against this database using SQL Plus and Golden32. I have the latest version of the Oracle Client installed and version 4.0.7 of BizTalk Utilities Adapter for Databases installed.
I have created custom .net code and have no problems connecting either.
Any ideas, thanks
Luciano Barbieri
|
|
|
|
|
RE: Oracle Adapter Problems - 24 November 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
What version of the ODP.NET Client do you have installed?
Is this 64-Bit?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Oracle Adapter Problems - 26 November 2007
|
|
|
lfbarbieri
Posts: 11
Score: 0
Joined: 24 March 2006
Status: offline
|
This is 32bit, I downloaded the latest version from Oracle last week.
|
|
|
|
|
RE: Oracle Adapter Problems - 27 November 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
What is the version of the ODP.NET Provider tat you downloaded? This needs to match with the version of the Provider.
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Oracle Adapter Problems - 2 December 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
The Provider we have specified as Oracle Data Provider for .NET Version 10.2.0.200 should match with the following ODP.NET Assembly in the GAC Oracle.DataAccess.Client.OracleParameter, Oracle.DataAccess, Version=1.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342.
Is this version of the Oracle Assembly in the GAC?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Oracle Adapter Problems - 3 December 2007
|
|
|
lfbarbieri
Posts: 11
Score: 0
Joined: 24 March 2006
Status: offline
|
It appears like I have that one, here is what is in my GAC:
Assembly Name:
Oracle.DataAccess
I have 3 versions:
10.1.0.400
1.102.2.20
2.102.2.20
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version
Email TopXML