Error Source Oraoledb
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings cannot initialize the data source object of ole db provider oraoledb.oracle for linked server 7303 and policies of this site About Us Learn more about Stack Overflow
Cannot Get The Column Information From Ole Db Provider "oraoledb.oracle" For Linked Server
the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation ole db provider oraoledb.oracle for linked server returned message ora-12154 Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it
Allow Inprocess
only takes a minute: Sign up “Cannot create an instance of OLE DB provider” error as Windows Authentication user up vote 12 down vote favorite 7 I am trying to run openrowset from MS SQL Server on an Oracle server. When i execute the following command: select * from OPENROWSET('OraOLEDB.Oracle','srv';'user';'pass', 'select * from table') the following error occurs Msg 7302, microsoft sql server error 7303 linked server oracle Level 16, State 1, Line 1 Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "(null)". Can anyone tell me how I can use openrowset with OraOLEDB.Oracle? I am using 64 bit version of MS SQL Server and Oracle OLEDB driver. Edit I have tried this on two machines running Windows 7 x64 & Windows Server 2008 x64 with MS SQL Server 2008 x64. Both showed the same error message. sql-server oracle oledb windows-authentication linked-server share|improve this question edited Nov 21 '13 at 14:10 patrickmdnet 2,3381627 asked Jan 24 '13 at 11:14 th1rdey3 2,03941544 I am trying to run OpenQuery against my linked server and getting same error. My linked server is using OraOLEDB.Oracle provider and I have already enabled the allow In Process option. The funny part is I have been using this linked server without any issue since last week, I did sql server reboot and it suddenly started to give error. –Amit Patel Jan 24 '13 at 17:22 add a comment| 4 Answers 4 active oldest votes up vote 28 do
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a
Cannot Create An Instance Of Ole Db Provider Oraoledb.oracle For Linked Server
blank message. Please type your message and try again. More discussions in Oracle Provider
Cannot Initialize The Datasource Object Of Ole Db Provider For Linked Server
for OLE DB All PlacesDatabaseDatabase Application DevelopmentWindows and .NETOracle Provider for OLE DB This discussion is archived 1 2 Previous tns could not resolve the connect identifier specified sql server linked server Next 16 Replies Latest reply on Dec 2, 2008 7:32 PM by 561796 OraOLEDB error '80040e4b' : Accessor is not a parameter accessor 503027 Mar 30, 2006 11:35 PM Hi! I'm seeing the following http://stackoverflow.com/questions/14499977/cannot-create-an-instance-of-ole-db-provider-error-as-windows-authentication-u error, inconsistently, in my ASP application: OraOLEDB error '80040e4b' Accessor is not a parameter accessor The database is an Oracle 9i database - the web server has an Oracle 9i client installation on it. Not sure as to the MDAC version as my company firewall prevents me downloading the Component Checker. Is there another way to determine the version? If I refresh the page, the error will disappear https://community.oracle.com/thread/377592 and the page will load correctly. I've notice that, although it occurs on and off, it always occurs on the following line of code: start_date = rstProb("start_date") In context: Set cnnDB = Server.CreateObject("ADODB.Connection") strConn = "Provider=OraOLEDB.Oracle;User ID=USER_SCHEMA;Password=password; Data Source=SOURCE" cnnDB.Open(strConn) Set rstProb = SQLQuery(cnnDB, "SELECT * FROM PROBLEMS WHERE ID = 10) start_date = rstProb("start_date") You get the picture. The column PROBLEMS.START_DATE is of type DATE Any thoughts? I can't understand why this doesn't fail consistently, even though the data does not change... Thanks in advance for your thoughts. Regards, mroshaw 40806Views Tags: none (add) This content has been marked as final. Show 16 replies 1. Re: OraOLEDB error '80040e4b' : Accessor is not a parameter accessor 504652 Apr 6, 2006 5:50 PM (in response to 503027) Hi, Could you please tell me how you solve the problem? Thanks a lot, Hugo. Like Show 0 Likes(0) Actions 2. Re: OraOLEDB error '80040e4b' : Accessor is not a parameter accessor 503027 Apr 25, 2006 4:16 PM (in response to 504652) I applied Oracle Provider for OLE DB 9.2.0.7.0 patch - I no longer see any occurrences of this error. WOO HOO! mroshaw Like Show 0 Likes(0) Actions 3. Re: OraOLEDB error '80040e4b' : Acc
chapter describes components of Oracle Provider for OLE DB (OraOLEDB) and how to use the components to develop OLE DB consumer applications. This https://docs.oracle.com/cd/E48297_01/doc/win.121/e18594/using.htm chapter contains these topics: OraOLEDB Provider Specific Features Using OraOLEDB with Visual Basic OraOLEDB Provider Specific Features The following sections describe provider-specific features of OraOLEDB: Data Source OraOLEDB Sessions http://www.sqlservercentral.com/Forums/Topic862065-146-1.aspx Commands Rowsets Data Types LOB Support Unicode Support Errors OLEDB.NET Data Provider Compatibility Additional provider-specific information is provided in Appendix A, "Provider-Specific Information". Data Source A data source object in linked server OraOLEDB is responsible for establishing the first connection to the Oracle Database. To establish the initial connection, the consumer must use the CoCreateInstance function to create an instance of the data source object. This function requires important information about the provider: class ID of the provider and executable context. The class ID of OraOLEDB is CLSID_OraOLEDB. OraOLEDB is an in-process ole db provider server. When calling CoCreateInstance, use the CLSCTX_INPROC_SERVER macro. For example: // create an instance of OraOLEDB data source object and // obtain the IDBInitialize interface hr = CoCreateInstance(CLSID_OraOLEDB, NULL, CLSCTX_INPROC_SERVER, IID_IDBInitialize, (void**)&pIDBInitialize); The code snippet above does not enable OLEDB Services when instantiating the Data Source object. To enable OLEDB services, see "Compatibility with OLE DB Services" below. Note: OraOLEDB does not support persistent data source objects. After the successful creation of an instance of a data source object, the consumer application can initialize the data source and create sessions. OraOLEDB supports connections to Oracle Databases releases. To connect to a specific database, the consumer is required to set the following properties of the DBPROPSET_DBINIT property set: DBPROP_AUTH_USERNAME with the user ID, such as scott DBPROP_AUTH_PASSWORD with the password, such as tiger DBPROP_INIT_DATASOURCE with the net service name, such as myOraDb The consumer could also populate DBPROP_INIT_PROMPT with DBPROMPT_PROMPT which causes the provider to display a logon box for the user to enter the connect information. Usin
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » Administering » Linked Server connecting to Oracle problem Linked Server connecting to Oracle problem Rate Topic Display Mode Topic Options Author Message LOOKUP_BI-756009LOOKUP_BI-756009 Posted Monday, February 8, 2010 2:13 PM SSC-Addicted Group: General Forum Members Last Login: 2 days ago @ 12:52 PM Points: 415, Visits: 1,477 I have SQL 2005 on my system and would like to connect to Oracle 10g as a linked server.This is the error mssg Im gettingOLE DB provider "OraOLEDB.Oracle" for linked server "TestOraLink" returned message "ORA-12154: TNS:could not resolve the connect identifier specified".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "TestOraLink".This is what has been done so far 1) Installed Oracle Client for 10g on my machine2) The C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN has 2 files [tnsnames] and [sqlnet]3) Contents on tnsnames is as belowgp = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = cs.org)(PORT = 1526)) ) (CONNECT_DATA = (SERVICE_NAME = gp2) ))4) Executing tnsping gp returns TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 08-FEB-2010 16:02:10Copyright (c) 1997, 2005, Oracle. All rights reserved.Used parameter files:C:\oracle\product\10.2.0\client_1etwork\admin\sqlnet.oraUsed TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = cs.org)(PORT = 1526))) (CONNECT_DATA = (SERVICE_NAME = gp201)))OK (20 msec)5) Execute sqlplus login/123@gp returnsSQL*Plus: Release 10.2.0.1.0 - Production on Mon Feb 8 16:04:35 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining options6) In mngt studio, used following script to create linked serverEXEC sp_addlinkedserver @server = 'TestOraLink', @srvproduct = 'Oracle', @provider = 'OraOLEDB.Oracle', @datasr