hi ,

 I got the problem while executing the query..



  can any one gimme the solution

View Replies


Error While Executing Insert Statement On DB2 Using OLEDB Provider


          I am using simple data flow task to move data from SQL Server to DB2 using OLEDB provider on both ends. I am using OLE DB Command task to execute inserts on DB2. Following is my statement.

Insert into MMTSTLIB.INTIIF (IIFDTA) values (?)

In column mapping, correct column is assigned to parameter and column data type is unicode. Data viewers attached show correct data.

However when executed, it gives following error.

[OLE DB Command [138]] Error: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available.  Source: "Microsoft DB2 OLE DB Provider"  Hresult: 0x80040E14  Description: "Null values are not allowed in column or variable IIFDTA. SQLSTATE: 23502, SQLCODE: -407".


Please help.


View Replies View Related

Error 7399: OLE DB Provider 'Microsoft.Jet.OLEDB.4.0' Reported An Error.Authentication Failed.

I am trying to create an excel file using openrowset in ms sql 2000.but i get the following error when I try to create the file...My stored procedure code is below as well...Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.Authentication failed.What can I do?-- here is my codeCreate PROCEDURE MCA_SP_CREATE_EXCEL @File_Name as varchar(50) = ''ASBEGINSET NOCOUNT ONdeclare @File_Name as varchar(50)DECLARE @Cmd varchar(1000)DECLARE @fn varchar(500)DECLARE @provider varchar(100)DECLARE @ExcelString varchar(100)-- New File Name to be createdIF @File_Name = ''Select @fn = 'C:Test.xls'ELSESelect @fn = 'C:' + @File_Name + '.xls'-- FileCopy command string formationSELECT @Cmd = 'Copy C:Template.xls ' + @fn-- FielCopy command execution through Shell CommandEXEC MASTER..XP_CMDSHELL @cmd, NO_OUTPUT-- Mentioning the OLEDB Rpovider and excel destination filenameset @provider = 'Microsoft.Jet.OLEDB.4.0'set @ExcelString = 'Excel 8.0;Database=' + @fn-- Executing the OPENROWSET Command for copying the select contents to Excel sheet.exec('insert into OPENrowset(''' + @provider + ''',''' + @ExcelString + ''',''SELECT FirstName,LastName,Phone,Address,City,State,Zip FROM [Sheet1$]'') select au_fname as FirstName,au_lname as LastName,phone,address,city,State,Zip from authors')exec('insert into OPENrowset(''' + @provider + ''',''' + @ExcelString + ''',''SELECT StoreId, OrderNo, OrderDate, Quantity FROM [Sheet2$]'') select stor_id as StoreId,Ord_Num as OrderNo,Ord_Date as OrderDate,qty as Quantity from sales')SET NOCOUNT OFFEND

View Replies View Related

7399:OLE DB Provider 'SQL OLEDB' Reported An Error

After linking of remote server at 2nd end like under -

Open enterprise manager-
Linked server -
It is added and shown under link server , I just click on table under link server and go error -

Error - 7399:OLE DB Provider 'SQL OLEDB' reported an error

Thanking all of you in advance, I am looking for your valuable help


View Replies View Related

How Can I Avoid That The OLEDB Provider Intercepts The Error?

I have an stored procedure which is called by using ADO and OLEDB. I wish that when an error occurs (such as when a contraint is violated or trying to insert NULL in a not-null column) the error message is stored on an output parameter and returned to the client, without the error being raised by the OLEDB Provider.

How can I do that?

Thanks a lot in advance.

View Replies View Related

Microsoft OLEDB Provider Error (with SQL Server And ASP)

Dear all,

Still i am having problem with connecting sql server with ASP (Intranet).

Following is the code which i am using for the connection now,

Set conn=Server.CreateObject("ADODB.Connection")
conn.open "DSN=aspfirst;Uid=;PWD=;"

The error mesage , generated by this code is attached with this mail. Please check the attachment and hel me in the same


View Replies View Related

SQL Server OLEDB Provider Support Error

I have seen this question being asked couple of time in this forum. Now I'm in a different environment, so got to ask it again :-)

I installed XP embedded
release version with SP1, tools, MSDE (using the same machine for
database server) then started following through the tutorial provided
with the CDs. The installation is completed without errors.

As soon as I started adding component, or configuration I see this
error message, "SQL Server OLEDB provider support error" "Unable
to load SAL Server OLEDB povider resource DLL. The application cannot

What is the problem here? Your help is appreciated.


View Replies View Related

Parameterized Query For Microsoft OLEDB Provider For Oracle Using OLE DB Source In SSIS



Urgent Help required..........

Can anyone explain me steps how to parameterized query to send oracle.

If you know any other control which help to do this rather than OLEDB source.

Please let me know.



View Replies View Related

OLE DB Provider &&"Microsoft.Jet.OLEDB.4.0&&" For Linked Server Error

Hello all,
I want to create a table in MS-Access. So I have written the following query.

Code Snippet
select * from Openquery(KKACC, 'select * Into Temp from Table select 1 as col1')

But I am getting the following error.

Code Snippet
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "KKACC" returned message "Syntax error in FROM clause.".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "select * Into Temp from Table select 1 as col1" for execution against OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "KKACC".

How can I resolve this error. Does any one have any work arround for this..?
-- Krishna

View Replies View Related

OLEDB Provider


Does anyone know a good OLEDB provider for Oracle 7 other than the one of Microsoft and Oracle.



View Replies View Related

OLEDB Provider For SAS

Is there an OLEDB provider for SAS? Does anyone know where I could get one? Does it ship with the SAS installation? Thanks!

View Replies View Related

ERROR: Cannot Get The Column Information From OLE DB Provider &&"Microsoft.Jet.OLEDB.4.0&&" For Linked Server&&"(null)&&"


I have been trying to export data from a Microsoft Excel 2007,  Tester.xlsx to a SQL Server 2005 table  as :

'Data Source=C:Tester.xls;Extended Properties=Excel 8.0')...[Providers$]

I have an error:

Cannot get the column information from OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server"(null)"

View Replies View Related

OLEDB Provider Connectiontimeout

if you establish a connection to SQL-Server (2000) you can provide a value for connection timeout (default is 15). For several reasons I have to set this value on 240. The problem is:
After building the connection the adoconection shows a value of 180 for this property. No idea where the OLEDB-Provider gets this value !!???
What is the reason for regretting my given value ?
Thanks in advance for your help

Regards, Alex

View Replies View Related

Has Anyone Used The DTSFlatFile OLEDB Provider With ADO?

Has anyone used the DTSFlatFile OLEDB provider with ADO?
What properties do you need to set for a delimited file in order to use it?


View Replies View Related

SSRS With IBM's OLEDB Provider For DB2


I am using SSRS connecting to DB2 via IBM OLEDB provider for DB2. When I view the reports by clicking the link from report server, it does not show the latest data. But when I refresh the report, it shows the latest data. I feel this is a potential problem from SSRS as the same provider works fine with Crystal reports.

Can anyone throw lights on this?
S Suresh

View Replies View Related

Oracle OleDb Provider As Source


I am having a nightmarish time getting an Oracle Connection Manager working as a source in my SSIS package.

The CM is called "OLTP_SOURCE". When I inspect the configuration and test connection, it succeeds, however when I go to run the package (both in debug mode and via DTEXECUI) I get the following error:

The AcquireConnection method call to the connection manager "OLTP_SOURCE" failed with error code 0xC0202009

After this happens, if I go into an OLE DB Source within a DFT, I get the following:

No disconnected record set is available for the specified SQL statement.

Now, if I go back into the CM, enter the password and test, it succeeds. From this point, I will go to preview the data in the OLE DB Source, and it comes back fine. However, when I go to run the package, I get the same error time and time again:

The AcquireConnection method call to the connection manager "OLTP_SOURCE" failed with error code 0xC0202009

The quick reader will suggest that the password is not being persisted. To this end, I have tried each of the following techniques to no avail:

1. Double, Triple and Quadruple check that the "save" password option in the CM is checked.

2. Hardcode the connection string in the dtsx XML-behind.

3. Enable Package Configurations and hardcode the connection string in the dstsconfig file.

4. Run the dtsx file using DTEXECUI, providing it with the configuration (that includes the hard-coded password).

5. Run the dtsx file using DTEXECUI, providing it the connection string in the Connection Managager override UI.

Can anyone help shed some light on what might be going on? So far, it is obvious that there has to be something that I am doing wrong because (syntax dialect differences aside) I can't imagine that Oracle sources should be this much of a headache.




View Replies View Related

Microsoft OLEDB Provider Oracle


Previously i was using oracle8i with ssis.ssis was working fine.later i have upgraded 8i to oracle 9i.now when ever i try to establish a new connection using Microsoft OLEDB Provider for Oracle.i am getting the following error "Oracle error occurred, but error message could not be retrieved from Oracle" .but i am able to access the oracle 9i database thru pl/sql and toad. what could be the problem?



View Replies View Related

Cannot Connect Using ODBC Or OLEDB Provider

HI, I installed SQL Server 2005 as a named instance. While I can connect to my server using SQLCMD or SSMS, SSIS; I cannot create a DSN entry that can connect to it, use OLEDB or connect using OSQL. I get the following message when I try to connect to the server using these technologies:

"Cannot generate SSPI context"

I also have a SQL Server 2000 named instance on my PC and I do not have these kind of problems (connecting using ODBC, OLEDB or OSQL).

Is there a configuration setting that I am missing?

Thank you,


View Replies View Related

OleDb Provider Templates Problem


I have a question regarding oledb templates in Visual Studio 2005. For some time I was trying to get through but I can't. Can anyone tell me how can I read the properties of the DataSource class being inside Rowset or Command class?
I mean: DataSource class is creating Session class. Session is creating Rowset or Command and so on.. But how can I read the INIT_DATASOURCE property of the DataSource class while for example a Command is called?
Could you give me a sample of code which retrieves the INIT_DATASOURCE property in the Execute method of the

CRowsetImpl class?

class ColedbRowset :

public CRowsetImpl< ColedbRowset, ColedbWindowsFile, ColedbCommand>



HRESULT Execute(DBPARAMS * params/*pParams*/, LONG* pcRowsAffected)



View Replies View Related

RC1 Oledb Provider Missing Registry Key

The RC1 installer (and the previous beta too) doesn't write in the following registry key:

[HKEY_CLASSES_ROOTCLSID{32CE2952-2585-49a6-AEFF-1732076C2945}OLE DB Provider]
@="Microsoft SQL Server CE 3.0 OLE DB Provider for Windows"

so this provider doesn't appear on the oledb "Data Link Properties" panels. Manually entering the above key solves the problem. The last summer CTP version has been done this trick.

View Replies View Related

How Do I Compact SDF With SQL Mobile 3.0 OLEDB Provider With VC++


The interface ID IID_ISSCECompact has been removed from ssceoledb30.h thus causing a compile error on this statement:

 hr = m_pIUnknownProv->QueryInterface(IID_ISSCECompact, (void **) &pISSCECompact));

So how does one compact a database using the 3.0 OLEDB Provider and VC++?





View Replies View Related

A Transport-level Error Has Occurred When Receiving Results From The Server.(provider:TCP Provider,error:0-The Handle Is Invalid


I am using SQL Server 2005,

while trying to retrieve data from the database; I am getting the following

 A transport-level error has occurred when receiving results
from the server. (Provider: TCP Provider, error: 0 - The handle is invalid.)

 But I am getting this error randomly.

 Can some one help me out?
 Waiting for your response


View Replies View Related

A Transport-level Error Has Occurred When Receiving Results From The Server. (provider: TCP Provider, Error: 0 - The Handle Is I


Basically the error that I am getting is in our test automation when running as non-admin on the box (regular user). We use .Net C# SQLConnection class to connect to SQL express 2005 impersonating with admin credentials. After getting the connection we try to execute a select command and it some time fails with following error:
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The handle is invalid.) at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader()

This happen only in the non-admin scenario mentioned above. Any idea what is triggering this?

Thanks in advance for all replies.

View Replies View Related

Oledb Provider Having Problem In MS SQL Server 2005

I try to access the table "UserGroup" in my local sql server 2005 database. However I get this error message"Invalid object name 'UserGroup'. "I'm using MS Visual Studio 2005 and MS Sql Server 2005. I did install the latest Sql Native. In fact I just migrate from ASP.NET to ASP.NET 2.0 . It is working if my connection string is point to my "online host" without any error.'Online Connection String - Working<add key="OLEDB" value="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=abc;Initial Catalog=mydatabase_db;Data Source=xxx.xx.xx.xx,xxxx; Password=xxxx;Connect Timeout=3600"/>
 'Local Connection String - Not working  (SQL Authentication)<add key="OLEDB" value="Provider=SQLNCLI;Trusted_Connection=No;UID=calvin;Initial Catalog=mydatabase_db;Data Source=CALVINNB; Password=xxxxxx"/>OR(Windows Authentication)<add key="OLEDB" value="Provider=SQLNCLI;Server=CALVINNB;Database=mydatabase_db;Trusted_Connection=yes"/>Is the Oledb provider having problem in MS SQL Server 2005?
 Any help would be more appreciate.Calvin

View Replies View Related

Could Not Resolve Service Name - Oracle 8 And MS OLEDB Provider

Trying to used DTS from SQL Server 7 to import a table from Oracle 8 DB to SQL Server. SQL Server has Oracle 8 connectivity installed and a database instance setup. Connection using the instance works from Oracle Enterprise manager and all Oracle tools. The MS OLEDB provider for Oracle fails to connect : could not resolve service name. I have this working on a different server with the same setup (SQL Server 7 SP 2 + All Oracle 8.0.5 connectivity).


View Replies View Related

Missing Oracle OLEDB Provider In SSIS

Windows 2003(64bit) server, SQL 2005 Server(64bit), Oracle client 10G rel2 (64bit) is installed. But when I am going to create a datasource to the Oracle database the Oracle OLEDB Provider is missing, the only Providers avaliable is from Microsoft.

I have tried to install ODAC (64bit) with no result.

Anyone who have come across this problem and how do I do to resolve it?

BTW! Is there a way to try communication with the OLEDB provider from the commandprompt?

View Replies View Related

Ad Hoc Access To OLE DB Provider 'Microsoft.Jet.OLEDB.40' Has Been Denied.

Hi all,


I am currently working on a stored procedure in SQL 2000 where I use OPENROWSET function to read data from an Excel file into a temporary table.


It works fine when I logged in with username 'sa' and psswrd 'sa' but when I log in with another user name and password I get the following error:

"Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.40' has been denied.
You must access this provider through a linked server."


I am using VB 6.0 as front end. Is there anyway i can overcome this error?


Please help.



View Replies View Related

How Do I Get The CLSID For SQL Server 2005 OLEDB Provider?


How do I get the CLSID for SQL Server 2005 OLEDB Provider?  The following code yields the CLSID for 2000 Provider

        m_hr = CLSIDFromProgID(L"SQLOLEDB",&clsid); // SQL Server




View Replies View Related

Problems Executing Stored Procedure OLEDB

<sigh> been doing all kinds of stuff in SSIS and then I get to what I thought should be simple: Running a stored procedure, and I've had nothing but headache:

OLEDB connection, ResultSet None

SQL Statement: EXEC dbo.pStoredProcedure ?, ?, ?, ?, ?, ?, ? OUTPUT

Parameters Mapping page:

User::gvSourceName Input VARCHAR 0, User::gvDestinationName Input VARCHAR 1, System::UserName Input VARCHAR 2   etc.. etc..  UserlvDataImportID Output NUMERIC 6

I've emptied my stored procedure out... but that doesn't seem to matter it doesn't ever run the procedure.  If I try to parse the Query I get the error "The Query failed to parse.  Attempted to read or write protected memory.  This is often an indication that other memory is corrupt."

If I run the package I get the error: [Execute SQL Task] Error: Executing the query "EXEC dbo.pStoredProcedure ?, ?, ?, ?, ?, ?, ? OUTPUT" failed with the following error: "Unspecified error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

I've tried without the output variable and I still get the corrupt memory error and when I run the package I get: [Execute SQL Task] Error: Executing the query "EXEC dbo.pDataImportInfoInitINSERT ?, ?, ?, ?, ?, ?" failed with the following error: "Invalid character value for cast specification". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Even though I have made sure the datatypes match exactly between the parameters in the stored procedure and in the execute sql. I also know my connection is good as I use it in many steps before I get to the execute sql task...

Any ideas?  I've tried just about everything I can think of short of building a whole new package...

View Replies View Related

Convert Query From OLEDB To ODBC (Receiving Error)

I have the following query for my site which was functioning great using the OLEDB driver. Unfortunately, my client's web host forced us to use ODBC and it is no longer working   Any suggestions for what I should do?

Here is the query:
FROM (SELECT TOP 10 itemnum, itemnum FROM (
        SELECT TOP 100 itemnum, itemnum
          ORDER BY itemnum ASC) AS foo
     ORDER BY itemnum DESC)  AS bar INNER JOIN CatView AS t ON bar.itemnum = t.itemnum
ORDER BY bar.itemnum;

Here is the error i'm now receiving:

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The specified field 'itemnum' could refer to more than one table listed in the FROM clause of your SQL statement.
I know it was working great before, so i'm not sure what to do.


View Replies View Related

Oracle Oledb Provider Not Registered In Local Machine


I am trying to establish a connection to an Oracle database using the following code in a script task:

Dim oOleDbConnection As OleDbConnection
Dim sConnString As String = _
"Provider=OraOLEDB.Oracle;" & _
"Data Source=DBxxx;" & _
"User ID=Userxxx;" & _
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
When I execute the script task, I receive the following error:
The 'OraOLEDB.Oracle' provider is not registered on the local machine.
Am using the correct provider?
I do not know how to resolve the said error. 
Here are some facts:
Oracle 8i is installed.
Tnsnames.ora is updated.
I have successfully connected to Oracle SQL *Plus to test the above credentials.
Please help.

View Replies View Related

Aggregate Function Not Supported In SSAS OLEDB Provider?


I am writing a Reporting Services report pointed at an Analysis Services data cube, and in order to have more control over the MDX, I needed to switch my SSRS data source from the .NET Provider to the OLEDB provider (from ".NET Framework Service Provider for Analysis Services" to "OLEDB Provider for Analysis Services", that is).  I'm also entering my MDX in as an expression in the data source.
I noticed that when I summarize this data in the table footer on the report, the summary values that use the Aggregate function (=aggregate(fields!fieldname.value) for example) are blank.
I'm assuming that since the OLEDB provider is an "older" data provider for SSAS data and the Aggregate function was new in 2005 with the .NET provider, the OLEDB provider doesn't support the Aggregate function.  I was wondering if someone could confirm that this is the case?
Also, is there any other functionality that is not supported by OLEDB that would be supported by the newer .NET provider (aside from the ability to generate fields, parameters, and use the MDX query designer, of course)?

View Replies View Related

OLEDB Provider For DB2 - Record Locking &&amp; Open Sessions

We have a linked server configured on our SQL Server 2005 server that points to our iSeries.  A step in a scheduled job successfully updates data in tables on the iSeries using an update query and the 4-part naming convention (job reports success and updates can be verified), but it appears to leave locked records and open connections on the iSeries.  No open sessions showing in SQL Activity Monitor.
The linked server is configured using Microsoft's OLEDB Provider for DB2.  Are there additional settings that can be configured on the linked server to prevent this behavior or is this an issue that need needs to be addressed on the iSeries?  A timeout setting perhaps (not sure if this fixes the record locks though)?
Any help is greatly appreciated.

View Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved