Stack Overflow
Stack Overflow

Questions tagged [oraoledb]

Open standard data access methodology which utilizes Component Object Model (COM) interfaces for accessing and manipulating different types of data.

27 questions
4
votes
4 answers

The system cannot find message text for message number 0x80040e4b in the message file for OraOLEDB

What could mean the following message? The system cannot find message text for message number 0x80040e4b in the message file for OraOLEDB.
Miroslav Kovarik
  • 59
  • 1
  • 3
3
votes
1 answer

Oracle Temporary Tables has "data block corrupted"?

Within a packaged SP I am populating a Temporary Table. At the end of the procedure processing I read the Temporary Table into a ref cursor. When I try to execute the procedure in SQL Developer everything works as it should. When I try to execute…
glaucon
  • 8,112
  • 9
  • 41
  • 63
2
votes
1 answer

ORA-01036: illegal variable name/number with Oracle 18 and Oracle 19 Windows client

After upgrading from Oracle 11/12 to 18/19 I get this error: ORA-01036: illegal variable name/number. The error occurred in a query like this: SELECT * FROM (SELECT * FROM TABLE) MY_TABLE WHERE ROWNUM <= :P_ROWNUM (Subquery + binding parameters) The…
Massimiliano Fabris
  • 21
  • 3
2
votes
0 answers

OraOLEDB ORA-01840: input value not long enough for date format

I have the following SQL in Oracle: SELECT CE.ENCNTR_ID AS CernerEncounterID ,TO_DATE(S.ACTIVE_STATUS_DT_TM,'YYYY-MM-DD HH24:MI:SS') AS NoteStartDateUTC ,S.AUTHOR_ID …
user1052513
2
votes
1 answer

Oracle connections broken in SSIS after uninstalling 32bit version of oracle client

I get the following error message when I try to test my connections: Test connection failed because of an error in initializing provider. The 'OraOLEDB.Oracle.1' provider is not registered on the local machine I originally had 32 bit and 64 bit…
Lozik
  • 135
  • 8
2
votes
0 answers

OraOledb.Oracle Provider through ASP.NET

Question: Why can my local code execute a ORAOleDB.Oracle connection but I get no provider found when I run Anonymous execution though the same computers IIS Website. So I am publishing a website on my local machine to connect to different…
Arabidnun
  • 21
  • 2
2
votes
0 answers

Classic ASP/OraOLEDB - how to define OUT param containing TABLE?

A classic ASP script migrated from msdaora to OraOLEDB will no long execute an Oracle SP it used to. The SP looks like this : TYPE tbl_CONSOLIDATED_ID IS TABLE OF VARCHAR2(32) INDEX BY BINARY_INTEGER; TYPE tblSAM_DD_TEXT IS TABLE OF…
glaucon
  • 8,112
  • 9
  • 41
  • 63
1
vote
0 answers

OPENROWSET From SQL to Oracle

i'm trying to connect from sql server to oracle server with OPENROWSET for fetch data. this is my query: SELECT a.* FROM OPENROWSET(N'OraOLEDB.Oracle', N'Data Source=Myip:Port/dbname';'User Id=user';'Password=pass;', 'select * FROM view WHERE…
AhmadR3zA
  • 31
  • 5
1
vote
2 answers

error 3706 provider cannot be found. it may not be properly installed

All. I have used a DLL approach explained on How to securely store Connection String details in VBA This code is running very well on windows 10 64 bit and MS Office 64 bit. But same copy of the files i am not able to use on Wndows 8.1 Pro and MS…
Shekhar Nalawade
  • 127
  • 1
  • 1
  • 15
1
vote
0 answers

How to improve performance when accessing the Oracle data through SQL Server views

We have a database A on OraOLEDB. Oracle server, and database B on SQL Server. Our department uses SQL Server to manipulate both A and B, so we created some views for database A in SQL Server so that we can read and write query for those data. But…
Ning
  • 21
  • 4
1
vote
0 answers

ADODB.Connection.Execute return value / execute validation

When using the ADODB.Connection.Execute command, if the query returns a recordset, the ADODB.Recordset object can be checked for validity to confirm if the query/command was executed successfully. Example: SELECT * FROM users If a command that…
Dodzi Dzakuma
  • 1,406
  • 2
  • 21
  • 39
1
vote
0 answers

Sql Query Error "ORA-01403: no data found"

I have query to get value from an Oracle database to SQL Server table, and here's my code : SET @TDATE = GETDATE() SET @DDATE = CASE @DDATE WHEN '' THEN CONVERT(VARCHAR(10),GETDATE(),121) ELSE @DDATE END SET @sQuery = 'SELECT * INTO ##TMPWIP FROM…
Sabilv
  • 602
  • 1
  • 15
  • 44
1
vote
1 answer

OraOLEDB.Oracle provider returning the wrong results

Here's a bizarre one for you. I'm running a simple query against a table that looks like this: select expiration_date from Tbl where expiration_date > sysdate - 1 In SQL Developer, this is returning 35 rows. A VB.NET application, calling the exact…
roufamatic
  • 18,187
  • 7
  • 57
  • 86
0
votes
0 answers

oracle oledb driver memory leak, vc++

Platform: Windows Server 2000, Visual studio 2022, Oracle OraOleDB driver version 19.1.0.0.20190510 I am using OraOleDB driver to access database. During 24x7 test I observed a memory leak. I used DebugDiag to detect memory leak which suggesting…
user2354396
  • 41
  • 4
0
votes
1 answer

'Application.Transpose(rs.GetRows)' type mismatch error Nº 13 in SQL/VBA code

I'm trying to export data from an Oracle Database through VBA, and I'm getting an error Nº 13 Type Mismatch at line: mtxData = Application.Transpose(rs.GetRows) below is my entire code Sub start() Dim cn As ADODB.Connection Dim rs …
Savio
  • 3
  • 2
1
2