Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







IDBInitialize::Initialize Returned 0x80004005


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 Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
'Invalid Authorization Specification' From IDBInitialize::Initialize (c++)
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 Replies !   View Related
Provider 'MSOLAP.2' ICommandPrepare::Prepare Returned 0x80004005
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 Replies !   View Related
Linked Server Issue: OLE DB Error Trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterface Returned 0x80004005
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 Replies !   View Related
Failed To Initialize Distributed COM (CoInitializeEx Returned 80010119).
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 Replies !   View Related
Data Returned From .WriteXML Is Different Than What Is Returned In Query Analyzer.
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 Replies !   View Related
Getting Error 0x80004005
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 Replies !   View Related
Error Code: 0x80004005
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 Replies !   View Related
Error 0x80004005 Request Is Not Available. Please Help!!
 

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 Replies !   View Related
Xp_readmail=&>error Courrier 0x80004005
hello I ve this error courrier 0x80004005 by runing the xp_readmail
any advice?

thanks in advance

View Replies !   View Related
Error 0x80004005 - Copying Database
I have an interesting phenomen: When I want to copy a DB local with Task - Copy DB:

I got following error:

Fehler beim Suchen nach einem Ordner in SQL. OLE DB-Fehlercode: 0x80004005 (Der Client kann die Verbindung nicht aufbauen). (Assistent zum Kopieren von Datenbanken)
 
means Client can not connect.

I use Windows authentification an use the my local SQL server, and simply click through the wizard. Yesterday it worked fine, but now I got this error, where I found no solution yet.

It is no real important problem, because I worked around and made a copy of the DB.

But it is interesting to know why this error is now coming.

View Replies !   View Related
Xp_sendmail Failed With Mail Error 0x80004005
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 Replies !   View Related
Error 0x80004005 When Copying Tables Between Servers
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 Replies !   View Related
Xp_sendmail: Failed With Mail Error 0x80004005
 

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 Replies !   View Related
Xp_sendmail: Failed With Mail Error 0x80004005
 

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 Replies !   View Related
Error: 0x80004005 On Microsoft SQL Native Client
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 Replies !   View Related
The ExistsOnSQLServer Method Has Encountered OLE DB Error Code 0x80004005
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 Replies !   View Related
OLEDB Command Transform Error Code: 0x80004005
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 Replies !   View Related
Web Form OleDbException (0x80004005): Disk Or Network Error.]
 
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 Replies !   View Related
Please - OLE DB Provider For SQL Server (0x80004005) Cannot Generate SSPI Context
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 Replies !   View Related
(Project Real Implementation) Error Code: 0x80004005 OLEDB Connection To SQL Server
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 Replies !   View Related
Snap-in Failed To Initialize
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 Replies !   View Related
How Initialize A Connection String In .Net
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 Replies !   View Related
MMC Snap-in Failed To Initialize
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 Replies !   View Related
Snap In Failed To Initialize
I get this error after upgrading to SQL Server Enterprise edition version 7 from Server 7.0.

Thanks

View Replies !   View Related
Snap-im Failed Initialize
I have problem with sql server configuration tool. it can not be opened

View Replies !   View Related
How To Initialize Package Variables?
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 Replies !   View Related
Not Able To Initialize Scripting Engine
 

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 Replies !   View Related
How Can I Skip An Initialize Snapshot?
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 Replies !   View Related
RS 2005 Initialize Greyed Out ???
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 Replies !   View Related
Snap-in Failed To Initialize.
When you try to start Enterprise  Manager of SQL server 2000, you get the following error message:

Snap-in failed to initialize.
Name: Not available
CLSID: {A841B6C2-7577-11D0-BB1F-00A0C922E79C}.

Earlier it was running <b>perfectly alright</b>. but for installing report service feature i<b> upgrade sql2000 with service pack 3</b>. <b>after running setupsql.exe . it was shwing message like you should now backup your master and msdb database since this installation has update their content.</b>

please help

View Replies !   View Related
Reporting Services Won't Initialize
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 Replies !   View Related
Report Server Does Not Initialize
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 Replies !   View Related
Initialize All Fields When Table Is Created
Is there a way to give fields or rows default data when the table is created?

View Replies !   View Related
The Process Could Not Initialize &#39;Replication Counters&#39;?
SQL server 6.5 SP5a Publisher, SQL Server 7 SP3 Distributor, SQL Server 7
SP2 Subscriber. The Publisher was rebooted. LogReader complained saying,
The process could not connect to server 'xxxxxx'. Restarted SQLAgent on
Distributor and now get, The process could not initialize 'Replication
counters'. I have seen the previous thread regarding this, but sp_repldone
will blow away transactions in the log that I want to be distributed.

Thanks,

Darren Fuller

View Replies !   View Related
Merge Repl - Could Not Initialize Subscription
Attepting to run merge replication - get the error "The merge process could not initialize the subscription".

Snapshot replication runs OK.

Have restored remote DB, removed and reinstalled replication on distribution server. Running out of ideas...

Any suggestions please ?

View Replies !   View Related
Not Able To Initialize The Script Execution Engine
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:

'Task_01' was not able to initialize the script execution engine

Any ideas?

Thx

 

View Replies !   View Related
Initialize Pull Transaction From Backup
I'm trying to initialize a subscriber from a backup for a pull subscription. The publisher was started before the full backup was made. I followed the instructions @ Books Online topic "Initializing a Transactional Subscription Without a Snapshot" http://msdn2.microsoft.com/en-us/library/ms151705.aspx and How to: Initialize a Transactional Subscriber from a Backup (Replication Transact-SQL Programming) http://msdn2.microsoft.com/it-it/library/ms147834.aspx . I initialized the subscriber by restoring the db before I run the create subscriber scripts. All agents run successfully except for the following:

The network setup is that the publisher and the subscriber are in 2 different domains with the distribution database at the publisher. The subscriber agent is able to connect and run however the error on the subscriber side is:

"Agent message code 14080. The remote server "subscriber" does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers."

The warning on the publisher side is in the Replication Monitor where in the status it says Uninitialized Subscription.

Any ideas on why it says it isn't initialized? Is there a StoredProc that I have to execute to initialize from backup?

View Replies !   View Related
The Merge Process Could Not Initialize The Subscription.
I met some problems in merge replication with sql server 2005 (sp2).

one user who is using the PDA (SQL Mobile 2005) try to sync with server, the error info is coming.

the error in replication monitor is shown as following:
Error messages:
The merge process could not initialize the subscription. Ensure that the subscription registration exists at the publisher, and reregister the subscription if necessary. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201011)
Get help: http://help/MSSQL_REPL-2147201011
The subscription could not be found. (Source: MSSQLServer, Error number: 20021)
Get help: http://help/20021
The subscription has expired. Mark the subscription for reinitialization and restart the Merge Agent to reinitialize the subscription. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200980)
Get help: http://help/MSSQL_REPL-2147200980

is there anybody who has any idea about it?

View Replies !   View Related
Merge Process Could Not Initialize The Subscription
I am experiencing some replication problems. I have a test server with a test database which has been working just fine with some simple Merge Replication. That old server is now been targeted for decommissioning. I have moved the test database to another test server and have set everything conceivable up the same as it was on the prior server but I am experiencing errors that I have not been able to resolve. I am using the same Domain User account with the same privileges on both systems...

 

The first error I receive in my SQL Server error logs is:

 

Message
Error: 14151, Severity: 18, State: 1.

 

Rapidly followed by the following error message:

 

Message
Replication-Replication Merge Subsystem: agent SOURCE-DATABASE-MERGE-DESTINATION-16 failed. The merge process could not initialize the subscription. Ensure that the subscription registration exists at the publisher, and reregister the subscription if necessary.

 

From within the Replication Monitor I look into the subscription and I can see the following error message:

 

Command attempted:

{call sys.sp_MSmergesubscribedb ('true', 0) }

 

Error messages:

The merge process could not initialize the subscription. Ensure that the subscription registration exists at the publisher, and reregister the subscription if necessary. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201011)
Get help: http://help/MSSQL_REPL-2147201011

 

INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. (Source: MSSQLServer, Error number: 1934)
Get help: http://help/1934



I have looked into  the help links from above, researched codes and also browsed this forum and others to no avail so far. Any help or suggestions would be greatly appreciated! THANKS!

 

 

View Replies !   View Related
Replication Without Initialize Subscriptor With The Snapshot
Hello all,


I am developing a system using SQL Server replication between SQL Server EXPRESS 2005 clients and SQL Server 2005 servers. I initialize the replica databases with a script, then I do not want to initilize the subscriber with the snapshot; I configure each subscriber to "not initilize", but when I run the first synchronization the snapshot copy process is always is executed.

Maybe am I forgetting something? Can I use this SQL Server EXPRESS - SQL Server replication scheme without initialize the subscribers with the snapshot?
Thaks for reading!

View Replies !   View Related
Unable To Get Snapshot Agent To Initialize
I am unable to get my snapshot agent to initialize.  When I start the "View Snapshot Agent Status" and press the Start button, it appears that the snapshot agent attempts to starts and then it doesn't.   

I have configured the a distribution server and need to push a replication to another database, both can connect, etc.

I used the wizard to configure the distributon server and subscription server.  I am using AdventureWorks, and am attempting to replicate a single small table.

View Replies !   View Related
Initialize A Backup Device - Without Backing Anything Up To It
Is there a way to initialize a backup device without actually backing anything up to it?
 
This would make my backup code much simpler.
 
 

View Replies !   View Related
The Merge Process Could Not Initialize The Subscription.
 
When I want to sync from the emulator, this error will appear
 
A call to SQL server reconciler failed. Try to resynchronize the subscription. The merge process could not initialize the subscription. Ensure that the subscription registration exist on the publisher, and reregister the subscription if necessary. The subscription could not be found, the subscription has expired. Mark the subscription for reinitialization and restart the merge agent to reinitialization the subscription.
 
 
I return to the publisher, r-click then and make reinitializes to all subscription.
 
The same thing I did it to the subscription.
 
But the error still appears.
 

View Replies !   View Related
Initialize Error Connecting To SQL Server Database
    Newbie strikes again..   I'm attempting to connect to a SQL Server database (using VS 2005).  My code generated no errors in the build but when I tried to access the database, I got the following message:"The ConnectionString property has not been initialized."My connection string is stored in my web.config file.  My code goes as follows:Dim strSQL As String = "SQL string stored here"Dim objConnection as SqlConnection = New SQLConnection(ConfigurationManager.AppSettings("name of connection string is here"))Dim objCommand as SQLCommand = New SqlCommand(strSQL, objConnection)objConnection.Open()Then I go on to open my reader and such.  Where should I be initializing the ConnectionString property?TIA,Lesley

View Replies !   View Related
DTS Error- Can Not Initialize Script Execution Engine
SQL 2k, simple DTS package that formerly worked, reads data from an Excel SS, moves it into SQL 2K with a Data Driven Query.

I started receiving this error:

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

The MSDN KB reports that this corresponds to
DTSPackage error 1017 DTSPackage_E_AxScript_CantInitializeEngine

OR
DTSDataPump error 8262 DTSDataPump_E_AxScript_CantInitializeEngine

Great. Can anyone tell me what this means and how it can be fixed.

Thanks in advance.

View Replies !   View Related
Disk Space Required To Initialize Subscriber
Quick question- how much disk space is required on the subscriber to initialize a subscription (transactional replication) – does it have to copy the snapshot files (e.g. the bcp files etc) from the distributor, and then initialize the subscriber from this, or does it do this over the network?

Does it differ depending on whether it is push or pull?

Say I have a 10 GB snapshot on the distributor with a push subscription to the subscriber. Do I need 20 GB free on the subscriber? E.g. 10 GB to receive the snapshot files + 10 GB for the subscriber DB? Or just 10 GB for the subscriber DB which is initialized from the snapshot files over the network?

Thanks in advance for any help with this.

View Replies !   View Related
ActiveX Scripting Transform 'AxScriptXform' Was Not Able To Initialize
I was using the DTS Import/Export wizard and I went to edit the
vbscript that does the transformation. When I run the package I get an
error message --

ActiveX Scripting Transform 'AxScriptXform' was not able to initialize
the script execution engine.
Help appreciated.

Ian O'Neil.

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved