IDBInitialize::Initialize Returned 0x80004005

Jun 5, 2008

When executing the following SQL statement we get the error as message below:

INSERT INTO [dbo].[ProductImport] ([CustomerName], [AccountCode], [ProductCode], [Description1],
[Description2], [MaterialType], [Brand], [PGroup], [Type], [GSM], [Colour], [Size1], [Size2], [Microns],
[PriceQuantity], [PriceUnit], [Packed], [Price], [MinQuantity], [TonnePrice], [LeadTime], [WebURL])

SELECT [CustomerName], [AccountCode], [ProductCode], [Description1], [Description2], [MaterialType], [Brand],
[PGroup], [Type], [GSM], [Colour], [Size1], [Size2], [Microns], [PriceQuantity], [PriceUnit], [Packed], [Price],
[MinQuantity], [TonnePrice], [LeadTime], [WebURL]
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'
Text;Database=D:ApplicationsxxxxxxxxxAppRootxxxxxxxxxSQLCatalogues;HDR=YES', 'SELECT * FROM [product_test.csv]')
AS ImportFile WHERE [ImportFile].[MaterialType] IN (1, 2, 3, 4)


Error message
Server: Msg 7399, Level 16, State 1, Line 5
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].



This is being run on
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
Windows 2003, build 3790.srv03_gdr.070301-2306


Have checked a number of knowledge base articles
C:Windowssystem32msjet40.dll version 4.0.8618.0

REGEDT32: HKEY_LOCAL_MACHINESOFTWAREODBC, Administrator/everyone full access

D:ApplicationsxxxxxxxxxAppRootxxxxxxxxxSQLCatalogues has full permissions for Administrator/everyone groups

Can anyone suggest the next step to identifying a possible cause to this issue.

View 3 Replies


ADVERTISEMENT

'Invalid Authorization Specification' From IDBInitialize::Initialize (c++)

Nov 13, 2006

Hi

I've been trying to connect to my local SQL Server instance (SQL Server 2005) using the SQLNCLI interface from c++ without success. I consistently receive an 'Invalid authorization specification' error (SQL state 28000 and SQL error number 0) when I call IDBInitialize::Initialize to connect to the database. I was hoping someone here could shed some light on this and help me out.

The strange thing is that I get no error if I leave the user blank (L"" in vValue.bstrVal) and try to connect. Also, IDBProperties::SetProperties returns 0 when the user is blank but 40eda when the user is set. This seems to be a message from the pipeline facility but I haven't found the description of the code (0xeda).

The user in the database is configured with no password and I can successfully connect to the server and open the database using that user through Management Studio.

I've also tried using the SQLOLEDB provider with the same results.

Suspecting that I'm setting the properties wrong I include a code snippet below showing how I'm setting the properties:

for (int i = 0; i < sizeof(dbprop) / sizeof(dbprop[0]); i++)
VariantInit(&dbprop[ i ].vValue);

// Server name
dbprop[0].dwPropertyID = DBPROP_INIT_DATASOURCE;
dbprop[0].vValue.vt = VT_BSTR;
dbprop[0].vValue.bstrVal = SysAllocString(L"localhost");
dbprop[0].dwOptions = DBPROPOPTIONS_REQUIRED;
dbprop[0].colid = DB_NULLID;

// Database
dbprop[1].dwPropertyID = DBPROP_INIT_CATALOG;
dbprop[1].vValue.vt = VT_BSTR;
dbprop[1].vValue.bstrVal = SysAllocString(L"test");
dbprop[1].dwOptions = DBPROPOPTIONS_REQUIRED;
dbprop[1].colid = DB_NULLID;

// Username
dbprop[2].dwPropertyID = DBPROP_AUTH_INTEGRATED;
dbprop[2].vValue.vt = VT_BSTR;
dbprop[2].vValue.bstrVal = SysAllocString(L"jph");
dbprop[2].dwOptions = DBPROPOPTIONS_REQUIRED;
dbprop[2].colid = DB_NULLID;

Cheers,
JP

View 1 Replies View Related

Provider 'MSOLAP.2' ICommandPrepare::Prepare Returned 0x80004005

Jun 9, 2008

Hi,I have a stored procedure that makes an MDX query for me, on SQL 2000, service pack 3 it works fine, but on service pack 4 it stops working with the error:Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'MSOLAP.2' reported an error. The provider did not give any information about the error.OLE DB error trace [OLE/DB Provider 'MSOLAP.2' ICommandPrepare::Prepare returned 0x80004005:  The provider did not give any information about the error.].and i'f i call @@Error I get the error number 7399.Any ideas as to what might be going on? The stored procedure which worked prior to service pack 4 is as follows:CREATE PROCEDURE MDXTester
(
@CustId Varchar(4)
)
AS
IF NOT EXISTS(SELECT * FROM master..sysservers where srvname = 'CZVCube')
BEGIN
EXEC sp_addlinkedserver 'CZVCube',
'',
'MSOLAP.2',
'10.0.41.128',
'CZV'
END

DECLARE @OPENQUERY nvarchar(4000), @MDX nvarchar(4000), @LinkedServer nvarchar(4000)
SET @LinkedServer = 'CZVCube'
SET @OPENQUERY = 'SELECT * FROM OPENQUERY('+ @LinkedServer + ','''
SET @MDX = 'WITH
MEMBER [Measures].[YTD NV] AS ''''Sum(YTD(),[Net Value])''''
MEMBER [Measures].[YTD Prev] AS ''''Sum(YTD(),([Measures].[Net value], ParallelPeriod([Fiscal year], 1, [FiscalYear].CurrentMember)))''''
MEMBER [Measures].[YTD Change] AS ''''[Measures].[YTD NV] - [Measures].[YTD Prev]'''', FORMAT_STRING = ''''###,###.00''''
MEMBER [Measures].[YTD Change Perc] AS ''''[Measures].[YTD Change] / [Measures].[YTD Prev]'''', FORMAT_STRING = ''''###,##0.0%''''
MEMBER [Measures].[Monthly Change] AS ''''[Net Value] - ([Net Value],FiscalYear.PrevMember)'''', FORMAT_STRING = ''''###,###.00''''
MEMBER [Measures].[Monthly Change Perc] AS ''''([Monthly Change] / ([Net Value],FiscalYear.PrevMember))'''', FORMAT_STRING = ''''###,##0.0%''''
MEMBER [Measures].[Annual Change] AS ''''[Net Value] - ([Measures].[Net value], ParallelPeriod([Fiscal year], 1, [FiscalYear].CurrentMember))'''', FORMAT_STRING = ''''###,###.00''''
MEMBER [Measures].[Annual Change Perc] AS ''''([Annual Change] / ([Measures].[Net value], ParallelPeriod([Fiscal year], 1, [FiscalYear].CurrentMember)))'''', FORMAT_STRING = ''''###,##0.0%''''
MEMBER [Measures].[12 mth mov av] AS ''''Avg([FiscalYear].CurrentMember.Lag(11):[FiscalYear].CurrentMember, [Measures].[Net Value])''''
SELECT {[Measures].[Net Value] , [Measures].[YTD NV], [Measures].[YTD Prev],[Measures].[Monthly Change], [Measures].[Monthly Change Perc], [Measures].[Annual Change], [Measures].[Annual Change Perc], [Measures].[YTD Change], [Measures].[YTD Change Per
c], [Measures].[12 mth mov av]} ON COLUMNS,
LastPeriods(12, [FiscalYear].[Apr 08]) ON ROWS
FROM CZV
where [C_CRMID].[' + @CustId + ']'
EXEC(@OPENQUERY + @MDX + ''')')

  

View 1 Replies View Related

Linked Server Issue: OLE DB Error Trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterface Returned 0x80004005

Aug 13, 2007

Window Server 2003 R2 Standard Edition (x64) SP1
Sql Server 2000 8.00.2039 SP4 Enterprise Edition (32 bit version)

A linked server is configured to a sql 2000 server and when I execute sql statement SELECT * FROM [LinkedServer].[Database].[dbo].[TableName] it gives following error message: -

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterface returned 0x80004005: The provider did not give any information about the error.].

In case if anyone has a solution to it, please let me know.

View 3 Replies View Related

Failed To Initialize Distributed COM (CoInitializeEx Returned 80010119).

Dec 10, 2007

I'm receiving this error message when trying to install SQL Server 2005 Express Edition on Windows Vista Home Premium:

Product: Microsoft SQL Server 2005 Express Edition -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]The server could not load DCOM.. Refer to the server error logs and Setup logs for detailed error information.

In the ERRORLOG file, the error is:

Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.

There is no Component Services in the Control Panel. Do they just mean Services? If so, how do you configure DCOM in the Services?

Thanks in advance for your help!

Below is the complete ERRORLOG:

2007-12-06 11:16:09.69 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 6.0 (Build 6000: )
2007-12-06 11:16:09.72 Server (c) 2005 Microsoft Corporation.
2007-12-06 11:16:09.72 Server All rights reserved.
2007-12-06 11:16:09.72 Server Server process ID is 5672.
2007-12-06 11:16:09.72 Server Authentication mode is MIXED.
2007-12-06 11:16:09.72 Server Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2007-12-06 11:16:10.31 Server Registry startup parameters:
2007-12-06 11:16:10.31 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2007-12-06 11:16:10.31 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2007-12-06 11:16:10.31 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2007-12-06 11:16:10.31 Server Command Line Startup Parameters:
2007-12-06 11:16:10.31 Server -m SqlSetup
2007-12-06 11:16:10.31 Server SqlSetup
2007-12-06 11:16:10.31 Server -Q
2007-12-06 11:16:10.31 Server -q SQL_Latin1_General_CP1_CI_AS
2007-12-06 11:16:10.31 Server -T 4022
2007-12-06 11:16:10.31 Server -T 3659
2007-12-06 11:16:10.31 Server -T 3610
2007-12-06 11:16:10.31 Server -T 4010
2007-12-06 11:16:10.38 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-12-06 11:16:10.38 Server Detected 2 CPUs. This is an informational message; no user action is required.
2007-12-06 11:16:10.53 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-12-06 11:16:10.67 Server The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.
2007-12-06 11:16:10.71 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-12-06 11:16:10.73 spid4s Warning ******************
2007-12-06 11:16:10.73 spid4s SQL Server started in single-user mode. This an informational message only. No user action is required.
2007-12-06 11:16:10.73 spid4s Starting up database 'master'.
2007-12-06 11:16:10.91 spid4s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2007-12-06 11:16:11.02 spid4s SQL Trace ID 1 was started by login "sa".
2007-12-06 11:16:11.07 spid4s Starting up database 'mssqlsystemresource'.
2007-12-06 11:16:11.09 spid4s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-12-06 11:16:11.69 spid4s Password policy update was successful.
2007-12-06 11:16:11.71 spid7s Starting up database 'model'.
2007-12-06 11:16:11.71 spid4s Server name is 'FRANK-LAPTOP-PCSQLEXPRESS'. This is an informational message only. No user action is required.
2007-12-06 11:16:11.71 spid4s Starting up database 'msdb'.
2007-12-06 11:16:12.48 spid7s Clearing tempdb database.
2007-12-06 11:16:12.59 Server A self-generated certificate was successfully loaded for encryption.
2007-12-06 11:16:12.60 Server Server local connection provider is ready to accept connection on [ \.pipeSQLLocalSQLEXPRESS ].
2007-12-06 11:16:12.60 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2007-12-06 11:16:12.62 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2007-12-06 11:16:13.15 spid7s Starting up database 'tempdb'.
2007-12-06 11:16:13.31 spid4s Recovery is complete. This is an informational message only. No user action is required.
2007-12-06 11:16:17.13 spid51 Setting database option RECOVERY to SIMPLE for database model.
2007-12-06 11:16:17.46 spid51 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2007-12-06 11:16:17.53 spid51 Configuration option 'default language' changed from 0 to 0. Run the RECONFIGURE statement to install.
2007-12-06 11:16:17.53 spid51 Configuration option 'default full-text language' changed from 1033 to 1033. Run the RECONFIGURE statement to install.
2007-12-06 11:16:17.55 spid51 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2007-12-06 11:16:18.28 spid51 Setting database option NEW_BROKER to ON for database tempdb.
2007-12-06 11:16:18.37 spid51 Setting database option NEW_BROKER to ON for database msdb.
2007-12-06 11:16:18.65 spid51 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2007-12-06 11:16:18.66 spid51 Configuration option 'user instances enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
2007-12-06 11:16:18.68 spid51 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2007-12-06 11:16:21.64 Server Error: 17102, Severity: 16, State: 1.
2007-12-06 11:16:21.64 Server Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.
2007-12-06 11:20:10.69 Server CPU time stamp frequency has changed from 52964 to 1017280 ticks per millisecond. The new frequency will be used.
2007-12-06 11:24:10.70 Server CPU time stamp frequency has changed from 1017280 to 1144761 ticks per millisecond. The new frequency will be used.
2007-12-06 11:32:10.70 Server CPU time stamp frequency has changed from 1144761 to 1030017 ticks per millisecond. The new frequency will be used.
2007-12-06 12:05:17.64 spid4s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
2007-12-06 12:05:17.64 spid4s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.





View 1 Replies View Related

Data Returned From .WriteXML Is Different Than What Is Returned In Query Analyzer.

Jun 20, 2006

I have a strange problem. I have some code that executes a sql query. If I run the query in SQL server query analyzer, I get a set of data returned for me as expected. This is the query listed on lines 3 and 4. I just manually type it into query analyzer.
Yet when I run the same query in my code, the result set is slightly different because it is missing some data. I am confused as to what is going on here. Basically to examine the sql result set returned, I write it out to an XML file. (See line 16).
Why the data returned is different, I have no idea. Also writing it out to an XML file is the only way I can look at the data. Otherwise looking at it in the debugger is impossible, with the hundreds of tree nodes returned.
If someone is able to help me figure this out, I would appreciate it.
1. public DataSet GetMarketList(string region, string marketRegion)2. {3.   string sql = @"SELECT a.RealEstMarket FROM MarketMap a, RegionMap b " + 4."WHERE  a.RegionCode = b.RegionCode"; 5.   DataSet dsMarketList = new DataSet();6.   SqlConnection sqlConn = new SqlConnection(intranetConnStr);   7.   SqlCommand cmd = new SqlCommand(sql,sqlConn);8.  sqlConn.Open();9.   SqlDataAdapter adapter = new SqlDataAdapter(cmd); 10.   try11.   {12.   adapter.Fill(dsMarketList);
 13.  String bling = adapter.SelectCommand.CommandText;//BRG 14.   dsMarketList.DataSetName="RegionMarket"; 15.  dsMarketList.Tables[0].TableName = "MarketList"; 16.    dsMarketList.WriteXml(Server.MapPath ("myXMLFile.xml" )); // The data written to  17. myXMLFile.xml is not the same data that is returned when I run the query on line 3&4 18.           // from the SQL query 19.  } 20.  catch(Exception e) 21. {  22. // Handle the exception (Code not shown)

View 2 Replies View Related

Getting Error 0x80004005

Jan 2, 2007

Hi Everybody,

Iam a sql server developer,iam on a migration project,iam encountering an error when iam editing the control flow task.it says the sql server doesnot exist or access denied,pls can anyone help me on this.



Thanks and Regards,

sg

View 5 Replies View Related

Error 0x80004005 Request Is Not Available. Please Help!!

Apr 21, 2008



Hi,

I tried to confiure sql reporting service on vista box but I got the following page.


Server Error in '/Reports' Application.


Request is not available in this context
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Request is not available in this context

Source Error:





An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:





[HttpException (0x80004005): Request is not available in this context]
System.Web.HttpContext.get_Request() +3465893
Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +47
Microsoft.ReportingServices.UI.GlobalApp.Application_Start(Object sender, EventArgs e) +32

[HttpException (0x80004005): Request is not available in this context]
System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +3385130
System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +125
System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +182
System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +259
System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +245

[HttpException (0x80004005): Request is not available in this context]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3465475
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69
System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +675





I tried a lot of searches online but could not find any solutions. I am running Vista Ultimate, SQL Server 2005 and IIS 7. I am sure I configure everything right under "Default Web Site". The same config is running perfectly under XP. Can anyone help please?

View 19 Replies View Related

Error Code: 0x80004005

Dec 5, 2006

I created a package that refreshes tables on one SQL Server to another SQL Server. First, I use an ExecuteSQL task to truncate the tables. Then I use a Data Flow task to copy the tables from one server to the other. Finally I update a log table. It was working fine with four tables. I added another table to the refresh and now I get these error messages:

[Source - RbcAcctSegment [1096]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unspecified error". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure".

[Source - RbcAcctSegment [1096]] Error: Opening a rowset for "[dbo].[RbcAcctSegment]" failed. Check that the object exists in the database.

[DTS.Pipeline] Error: component "Source - RbcAcctSegment" (1096) failed the pre-execute phase and returned error code 0xC02020E8.

RbcAcctSegment is the new table that I added. The errors occur in the Data Flow task. We have tried running this on a different workstation with the same results.

What would cause this?

Fred

View 5 Replies View Related

Xp_sendmail Failed With Mail Error 0x80004005

Jul 20, 2005

Hello!My environment is: Win 2000 Server, MS SQL-Server 2000 (SP2)and MS ExchangeServer 5.5the two following TransactSQL-codepieces show differentresults:1. with attachmentmaster..xp_sendmail@recipients = 'j.hetzel@rac.de',@subject = 'test',@message = 'test',-- ******************************@attachments = 'c: est.txt',-- ******************************@no_output = 'False'-->18025 level 16 state 1 line 0xp_sendmail failed with mail error 0x800040052. without attachmentmaster..xp_sendmail@recipients = 'j.hetzel@rac.de',@subject = 'test',@message = 'test',-- ******************************-- @attachments = 'c: est.txt',-- ******************************@no_output = 'False'-->Mail sent.why am I not able to send emails with attachments?Who can help me???Thanks in advanceJürgen

View 2 Replies View Related

Xp_sendmail: Failed With Mail Error 0x80004005

Feb 28, 2008



I'm a user of SQL 2000//2005, and I'm trying to send files using SQL Mail.



I'm am successful when I send a file of approx 13MB in size but, when I try to send a 24MB file, I receive the above subject error.



Is anyone aware of a file size limitation on attachments?

View 13 Replies View Related

Xp_sendmail: Failed With Mail Error 0x80004005

Mar 6, 2008



After consulting with the Exchange Administrator, I was advise that there is a limit on file attachments. This explains why I get this message with large (>20MB) attachments.

With this additional information I need to compress my file using a compression tool like winzip or pkzip. My company uses the windows version of pkzip. However, I have downloaded an evaluation version of the PKzip command line version.

Can someone provide guidance how I can execute this utility within my sql procedure?

View 4 Replies View Related

Error: 0x80004005 On Microsoft SQL Native Client

Nov 20, 2006

The below error happens when trying to use the SSIS Transfer SQL Server Objects Task to transfer objects. Related to (Bug?? Transfer SQL Server Objects Task - error when copying Views )?

--------------------

Error: 0xC002F325 at Transfer Data (NEW) Pre, Transfer SQL Server Objects Task: Execution failed with the following error: "ERROR : errorCode=-1071636471 description=An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unspecified error".

helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".

Task failed: Transfer Data (NEW) Pre

View 2 Replies View Related

Hresult: 0x80004005 Description: Unspecified Error

Mar 25, 2008



hello all

i m getting the following error while exporting an excel file in SSIS

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".

is this a bug?
pls suggest a workaround.

View 2 Replies View Related

Error 0x80004005 When Copying Tables Between Servers

Feb 23, 2007

hi
I've got a job which copy tables between different servers .
I am feeding the tables one by one and the process of copying is in a loop so I have cotrol over the copying process.
it works fine but sometimes randomly I am getting
Execution failed with the following error: "ERROR : errorCode=-1071636471 description=SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification".An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".

and the process fails and this might happen for in any point and on any table and sometimes it runs all the way successfully!!
any idea what the problem might be!
Thanks

View 5 Replies View Related

The ExistsOnSQLServer Method Has Encountered OLE DB Error Code 0x80004005

Oct 2, 2006

I export data from a dozen tables of one database to another database on another server regularly and it works well. However, if i choose the option of "save SSIS package", I get the following error:

TITLE: SQL Server Import and Export Wizard
------------------------------

The operation could not be completed.

------------------------------
ADDITIONAL INFORMATION:

The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement issued has failed.


------------------------------
BUTTONS:

OK
------------------------------




I use management studio to do this, but the servers are 2000.

Does anyone have any clue about this?

View 3 Replies View Related

Web Form OleDbException (0x80004005): Disk Or Network Error.]

Sep 25, 2006


Hi Everyone,

Hope you don€™t mind helping.

I am actually following exactly the example given in Karl Moore€™s €˜The Ultimate VB.net and ASP.net Code Book€™, ISBN 1-59059-106-2, Chapter 4, pp 141€¦

I am using VB.Net 2002 and create a Web Form, placing on it a Data Adapter, Connector and Dataset and link this to a Data Grid. The database is a quite large (150 Mb) Access 97 db that is shared over a network and the Provider is a Microsoft.Jet.OLEDB.4.0 connection. While in designer mode I can create the Dataset and even preview the data itself from the menu. When I run the project, the Web Form displays, connects to the Site (via IIS 5.1) but then the following error text is thrown all over the form:

Server Error in '/WebApplication3' Application.



Disk or network error.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Disk or network error.

Source Error:




An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:



[OleDbException (0x80004005): Disk or network error.] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) System.Data.OleDb.OleDbConnection.InitializeProvider() System.Data.OleDb.OleDbConnection.Open() System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) WebApplication3.WebForm1.Page_Load(Object sender, EventArgs e) System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain()




Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032

I have read and implemented the articles in the KB about setting up System TEMP variables and changing their rights and also setting up the ODBC key in the registry but these make no difference however I change them. I have also tried copying the database to the local machine, again to no avail.

The versions of the system I am using are:

Microsoft Visual Basic .NET 55524-640-5065381-18871
Microsoft Visual Studio .NET 2002 Service Pack 1 (KB837234)
Microsoft Developer Environment 2002 7.0.9955

I have no idea why what should be a very simple thing just fails so catastrophically. I am tempted to move to VB 2005 but if anyone can shed light on the problem I should be most grateful.

Many thanks for your time and Energy.
Jim McGoldrick

View 1 Replies View Related

OLEDB Command Transform Error Code: 0x80004005

Dec 20, 2007

I'm receiving an Error Code: 0x80004005 ... a "non-specific error" when trying to use a fairly simple insert in the oleDB command transform. SQL command works fine if I specify the parameters in the values clause of the INSERT statement. If however, I try to use the parameters in setting a variable, I get the 0x80004005 error. Is this a known issue/limitation, or am I just reallly doing something wrong?

View 4 Replies View Related

Please - OLE DB Provider For SQL Server (0x80004005) Cannot Generate SSPI Context

Dec 7, 2005

Please can anybody help me in fixing this error I am getting on ASP page while accessing ASP database page using an SQL server database.

View 4 Replies View Related

Microsoft JET Database Engine Hresult: 0x80004005 Description: Unspecified Error.

May 12, 2006

I have ran into the same problem ... Importing from Access into SQL 2005 using SSIS and get the error:

[Connection manager "SourceConnectionOLEDB"] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".

View 3 Replies View Related

Microsoft SQL Native Client Hresult: 0x80004005 Description: Violation Of PRIMARY KEY Constraint

Apr 14, 2008

We scheduled lot of SSIS packages on 64 bit server and most of the time they are running fine. Some times we are getting below error message on any random package. When we re-run its working fine to success. This is repeating once in a week on different packages.



Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK_TblObject'. Cannot insert duplicate key in object 'dbo.tblObject'."



Please let me know if you have any solutions?

View 3 Replies View Related

(Project Real Implementation) Error Code: 0x80004005 OLEDB Connection To SQL Server

Mar 25, 2008

Hi List
Im trying to set up an implementation of Project Real --it works like this-
Create two system environment variables called REAL_Root_Dir and
REAL_Configuration with the values given below. Click on
Start -> Control Panel -> System. Go to the Advanced Panel, click Environment Variables button, then New in the System variables box.

If the Project REAL files were installed at C:Microsoft Project REAL, then the variable values will be:

Variable Name: REAL_Root_Dir
Variable Value: C:Microsoft Project REALETL

Variable Name: REAL_Configuration
Variable Value: %REAL_Root_Dir%REAL_Config.dtsconfig



The package OLEDB connections work like this
First read enviroment variable to get location of config file
Next read Config File to get connection string for Config Database
<?xml version="1.0"?>
<DTSConfiguration>
<Configuration ConfiguredType="Property" Path="Package.Connections[SQL - Configuration].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>Data Source=(local);Initial Catalog=DataWarehouseABC;Provider=SQLNCLI.1;Integrated Security=SSPI;</ConfiguredValue>
</Configuration>
</DTSConfiguration>
Next read Config database to get connection strings for Source and Destination databases



Destination database is called "DataWarehouseABC"
Source database is called "SnapshotABC"


the Source database OLEDB connection works 100%
however the destination OLDB connection we get this error below
PS--Both source and destination databases are on the same development machine , however both databases are restored bak files from another production machine







Error 1 Error loading LoadGroup_Daily.dtsx: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Login failed for user 'xxxxxx'.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot open database "DataWarehouseABC" requested by the login. The login failed.".


Any ideas on how one OLEDB Connection in this package can get this corruption


thanks in advance
Dave

View 5 Replies View Related

Snap-in Failed To Initialize

Feb 19, 2008

When i try to open Sql Server Enterpris Manager the following error msg appers
Snap-in Failed to initialize
Name- unknown
CLSID{--}
 
how to solve this pbm help me very urgent

View 3 Replies View Related

How Initialize A Connection String In .Net

Feb 3, 2004

i am using a control that i downloaded from the control gallery It has a line for a connection string.

which i put on in there: data source=server;initial catalog=database;user id=blahblah;password=557896 and i get an error:

Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[InvalidOperationException: The ConnectionString property has not been initialized.]
System.Data.SqlClient.SqlConnection.Open() +433
Microsoft.Vote.VoteButtonClick(Object sender, EventArgs e) +289
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277


How would i initialize the connection string.


any help would be appreciated


alucke

View 1 Replies View Related

MMC Snap-in Failed To Initialize

Sep 16, 2004

I am getting this problem when I try to open a DTS package.

MMC: Snap-in Failed to Initialize: Name: Meta Data Services:
CLSID(xxxxxxxxxxx)

Have anyone encountered this problem?

Lystra

View 4 Replies View Related

Snap-im Failed Initialize

Jun 9, 2008

I have problem with sql server configuration tool. it can not be opened

View 3 Replies View Related

RS 2005 Initialize Greyed Out ???

Sep 13, 2006

HI There

I have installed Reportin Services 2005 , X64. I selected install but do not configure.

Afterwards i applied Service Pack 1 and ran all the hotfixes for sql components as per KB 918222.

The i launch the RS configuration manager i succesffuly setup Report Server/Manager Virtual DIrectory and servcie identity.

I then setup the database, i create a new database to the local 2005 instance i just installed with RS, the databse is created successfully.

Basically i have green ticks all the way, however Initialize is greyed out i cannot take the option to initialize the server ???

When i try to restart the RS service it says that the service failed to repond in a timely fashion, when i check the even log the servcie only started 10 minutes later, and there are no errors ?

WHen i go back to RS config manager , initialize is till greyed out , this is the last step i ahve to do but i cannot take the option ???

PLEASE HELP, Thanx

View 6 Replies View Related

How Can I Skip An Initialize Snapshot?

Jun 2, 2006

Hence you have a database which huge tables and a transactional replication (push subscriptions).

Now my question:

1. if I have to initialize a snapshot but I would like to do it without the snapshot agent, what methods are available?



2. Usually the distribution agent will request an initialize snapshot. How can I tell him, that I would like to use an alternative method and that the distribution agent should NOT request a snapshot?



3. Any suggestions about a good practive for materializing huge and big tables wihtout using the disitrbution agent (e.g. "switch off" replication, bcp table out of the primary site and bcp it into the target site, "start" distribution agent so that it doesn't request a snapshot).



Regards

Nobsay

View 6 Replies View Related

Not Able To Initialize Scripting Engine

Nov 27, 2006

 

I have a DTS package that is running under SQL 2005 (64-bit Itanium).  It has a data driven query in it and I receive the following error:

ActiveX Scripting Transform 'DTSTransformation__1' was not able to initialize the script execution engine

I don't want to have to re-register any DLLs if I don't have to.  Shouldn't this work out of the box?

Any ideas?

View 2 Replies View Related

Reporting Services Won't Initialize

Feb 18, 2008

I have just completed a fresh install of SSRS 2005. Now, when I try to initialize it, it fails. I then try to delete any encrypted content and get the following error:




Code Snippet
ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value for the "LogonCred" configuration setting cannot be decrypted. (rsFailedToDecryptConfigInformation)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()




From what I know, Reporting Services has never been installed on the machine in question. And if so, then haow can I get around this encrypted key issue?

Thanks!

View 6 Replies View Related

How To Initialize Package Variables?

May 2, 2007

I have a For Loop container where each iteration a Master record is inserted. I also have a number of package variables capturing rowcounts from the dataflow task. I later update the master record with the rowcounts. How do I initialize the package variables containing the rowcounts because currently, some of the rowcounts are being populated with rowcounts from another file.



thanks

View 3 Replies View Related

Report Server Does Not Initialize

Jun 25, 2006

I am using ms sql 2005 standard edition on windows Nt

Everything is working fine except the report server..

when i run the configuration tool and try to start the report server, it fails to start.. i am using sql on the local machine .

i have set p lmy database on the windows credentials..

i am using my machine name/user name as the account name for the database setup.

i have also used rsconfig utility to configure the report server but nothing happens after that..



pls help

View 5 Replies View Related

Initialize All Fields When Table Is Created

Sep 24, 2006

Is there a way to give fields or rows default data when the table is created?

View 1 Replies View Related







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