DB Engine :: Failed To Initialize Library With Error Number -2147467259
Apr 6, 2015
I have a procedure that works fine from SSMS but sometimes fails when running via SQL Agent. The SP sends emails..Here is the error message "Failed to initialize sqlcmd library with error number -2147467259"
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.
Any ideas as to how to troubleshoot or solve this?
When I boot my computer (Windows Home Premium 64bit) there is a pop up that says "Configuration System failed to initialize" and I don't know what might cause this..
I just added a post but I don't see it so here I go agian, sorry if it shows up later and there ends up being two of them. I started getting the error message - SQL Dumper Library failed ... Please reinstall... it doesn't say what to reinstal. Does anyone know if this is part of Office or XP? My problem started when I added Office 2007 and the additional Business contacts program from the web site. I did get SQL 2005 and installed it but it says it isn't working. When I click to repair it, it wants the disk, again I don't know what disk or program it wants, although it will not fix it from the XP disk. Any help would be appreciated!
have SQL Server 2005 std edition SP1 installed on Windows 2003 Std edition .Configured Transactional (single Publisher and no clustered environment.) Replication past two months working fine, Now 1.Distrib.exe application err is coming.
Due to which my job is failing (Distributor to Subscriber). Iam attaching thw file. Thanks Sandeep
When I attempt to run my DTS Pkg that contains ActiveX task, I get following error: "ActiveX Scripting was not able to initialize the script execution engine" When I run this from another computer, it runs fine. I have tried reregistrate DTS DLLs: Regsvr32.exe "C:Program FilesMicrosoft SQL Server80ToolsBinnaxscphst.dll" Regsvr32.exe "C:Program FilesMicrosoft SQL Server80ToolsBinndtspkg.dll" Regsvr32.exe "C:Program FilesMicrosoft SQL Server80ToolsBinndtspump.dll" But it does not help. I am worried the great site for DTS issues "http://www.sqldts.com " is down :-( Any ideas ?
My System: Windows Server 2003 + SP1 MS SQL Srrver 2000 + SP4
I have a SQl2k8 R2 up and running on a win2k8 R2, I have a domain controller as well with AD 2k8 R2. It works fine but from time to time I receive a dozen of successive alerts like th folowing
DATE/TIME: 11/22/2010 12:19:57 PM
DESCRIPTION: SSPI handshake failed with error code 0x80090311, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure.
COMMENT: (None) JOB RUN: (None)
I understand from some threads here that it is an issue related to contacting the AD. In event viewer it is not clear what is casuing this. I have WSS databases, Biztalk server databases.....and some other user databases. NO home made applications contact sql server.
What is the best route to follow to see who is not being able sometimes and why contacting the AD. I read the thread at URL.... but it is related to express 2005 and it does not apply to my case.
Hi everybody, I do custom log shipping over network like
step 1 backup log to C:.. step 2 zip log file c:... zip step 3 copy zip to \sm01 estorelogs... step 4 unzip file step 5 restore log with stand by
Few times a month it fails with
Error = -2147467259 (80004005) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server
1. Can someone help me? I am running an eCommerce website using SQL Server 2000, as of last week it was working just fine, today I try to access the sight and I get the following error below.
I haven't changed anything on the server, the SQL Server services is running so is the agent.
Operation: Creating Engine object Error number: -2147467259 Error source: Microsoft OLE DB Provider for SQL Server DatabaseUtils.OpenCommand DatabaseFile.IsDatabaseByteArrayUpdated SchemaFile.IsDatabaseSchemaUpdated Environment.InitEnvironment, Step: Loading database schema Engine.Init Engine.Refresh Error description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
In Management Studio i highlight my query and then click on 'Analyse query in Database Engine Advisor' but i get the following error message: "Failed to connect to an IPC Port: The system cannot find the file specified". Seems like if I reboot my computer it works one time then get the same error on the second time.I'm running developer edition with service pack 2.
I am importing an excel spreadsheet into SQL Server 2000. The dts package runs perfectly when you execute it under the Local Package pane.
My problem is when i schedule a job to execute the DTS package giving me the same error. I can only successfully execute the package under local Packages. Under Jobs i receive this error:
Executed as user: H-OBAdministrator. ...rt: Copy Data from 'Xagent - Report$' to [CIMPRO1].[dbo].[Xagent_Star_Coater_Points] Step DTSRun OnError: Copy Data from 'Xagent - Report$' to [CIMPRO1].[dbo].[Xagent_Star_Coater_Points] Step, Error = -2147467259 (80004005) Error string: 'R:sharedstar coaterMonthly Points RptCurrent_Month_Points.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Error source: Microsoft JET Database Engine Help file: Help context: 5003044 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -534774783 (E01FFC01) Error string: 'R:sharedstar coaterMonthly Points RptCurrent_Month_Points.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Error source: Microsoft JET Database Engine ... Process Exit Code 1. The step failed.
Any help on this error would be more than appreciated.
We have a SQL Server 2000 in a Windows 2003 Server, and we were working very well with the VB 6.0, but after an update in the Windows 2003, the Open method in ADO results in an error -2147467259 sometimes, but if we try the same code in a computer with another domain there are not any problem, some advice?
I'm not sure if I'm even starting at the right place. We have a web portal that we use to send email TSN Templates. When we press this link, it queries our SQL database but then times out. When we go to our logs to see waht has happened, this is what we get: Can anyone point me in the right direction? Timestamp: 15/08/2007 9:00:13 AM Message: HandlingInstanceID: 5228cfc1-fbc3-4c64-98ab-468d0a99ba85 An exception of type 'System.Web.HttpException' occurred and was caught. ------------------------------------------------------------------------ 08/15/2007 19:00:13 Type : System.Web.HttpException, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Message : Request timed out. Source : Help link : ErrorCode : -2147467259 Data : System.Collections.ListDictionaryInternal TargetSite : Stack Trace : The stack trace is unavailable. Additional Info: MachineName : TimeStamp : 15/08/2007 9:00:13 AM FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=3.0.2697.40343, Culture=neutral, PublicKeyToken=d6be776f5b1b3d1f AppDomainName : /LM/W3SVC/1/ROOT-1-128316415134243452 ThreadIdentity : WindowsIdentity : NT AUTHORITYNETWORK SERVICE Category: General Priority: 0 EventId: 100 Severity: Error Title:Enterprise Library Exception Handling Machine: Application Domain: /LM/W3SVC/1/ROOT-1-128316415134243452 Process Id: 36976 Process Name: C:WINDOWSSysWOW64inetsrvw3wp.exe Win32 Thread Id: 35804 Thread Name: Extended Properties: For more information, see Help and Support Center at
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.
exec distribution..sp_browsereplcmds SQL Server 2005 Standard SP1 says:
Msg 6513, Level 16, State 27, Procedure sp_browsereplcmds, Line 110Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure. Please restart SQL server in Address Windowing Extensions (AWE) mode to use CLR integration features.I have two (nearly) identically machines (test has 2, prod has 4 CPUs), both 3071MB RAM, Win 2k3 Server SP1, both have no AWE running.
On test-machine the procedure works fine, on production in doesn't. I checked performance. Test machine has about 180MB available memory, production about 160MB (nearly constant). Thread count for process sqlservr is constant and similar at about 65.
Any idea why it runs on test but not on production machine?
Hello, we've developed an application that runs on AXIM X51, if it is an important to know.
The data layer handles the connection using the singleton pattern, a bit of code of this is:
(....) Private Shared ceConnection As SqlCeConnection (....)
Public Shared Function GetConnection() As SqlCeConnection Try If (ceConnection Is Nothing) Then ceConnection = New SqlCeConnection(Me.connectionString) End If
If (ceConnection.State = ConnectionState.Closed) Then ceConnection.Open() End If
Return ceConnection Catch ex As Exception Throw ex End Try End Function
(....)
So far nothing strange. We started experiencing problems when the end-users get an "Unspecified error" which later debugging it we got the href value inside the exception object is -2147467259 and nothing else. And if that wasn't enough I couldn't replicate the error in my pocket.
The only way I got the same error was removing the SD Card where the db is located at the same time the application was still open.
Does anybody experienced the same problem??? I researched about this kind of errors "when the device is just restored from the suspend mode" but with out luck.
Please, I really appreciate any help with this issue. Any comment will be more than welcome.
Have 6 SQL Server 2012 failover clusters environments on Windows 2012 R2 standard edition.Have intermittent connectivity issues when using Windows Authentication, with the error "test connection failed because of an error in initializing provider. login timeout expired" . Am checking by using a UDL file and have tried the below.
1) Have made port changes to use static 1433 port. 2) Have enabled shared memory and using Named Pipes and TCP/IP by using cliconfig. 3) Have turned off firewall. 4) Loopback is disabled 5) SQL Browser is running, have changed 'Built in Account setting' from 'Local Service' to 'Network Service'. but with no effect.
Still I am getting intermittent connectivity issues.
Is there a trick to getting this installed correctly? Everything works great until it gets up to starting the service. Here is the complete section of my setup log file.
SQL 2005 Standard.
Machine : KINGSERVER550 Product : SQL Server Database Services Error : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." -------------------------------------------------------------------------------- Machine : KINGSERVER550 Product : Microsoft SQL Server 2005 Product Version : 9.00.1399.06 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_KINGSERVER550_SQL.log Last Action : InstallFinalize Error String : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. Error Number : 29503
I searched a previous thread dealing with this error, but seems like nobody has found a solution.
I've had a DTS Package scheduled to run every morning since June last year, however on Monday and again this morning, the DTS package has failed on two of its steps. This DTS package runs on SQL Server 2000 and the server is a Windows 2000 Server.
Basically, the DTS Package steps that fail are populating a "cache" table from a "live" table and then performing Inserts / Updates on the "live" table from a CSV file depending upon whether data exists in the "cache" table and whether the CSV file contains an "Insert" or "Update" flag. The live table has just over 800,000 rows of data and our nightly CSV extract, containing both inserts and updates, has about 6000 rows.
The error / failure has only happened in the last two days and I'm not too sure if there's any "timeout" feature in DTS and if there is, how I can modify it, or whether this may be something to do with long transactions or temp dbspace running out.
The time that the DTS package runs was modified last week to run two hours earlier (03:00 instead of 05:00) and has ran okay for a few days. I don't know whether this change is a red herring, as I have checked other DTS packages on the machine and none appear to run at the same time.
Here's the message from the third step in the DTS Package (second one that's failing).
Executed as user: SOEincaservice. ... Start: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_10 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_10, Error = -2147467259 (80004005) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Timeout expired Error source: Micros... Process Exit Code 2. The step failed.
Any help is greatly appreciated as I've searched these forums and the web and can't really find any answers.
Hello, I want to get data from datatable as below. I am getting error: BC30516: Overload resolution failed because no accessible 'New' accepts this number of arguments. I did not understand what is wrong. Because everything is same as msdn library. my codebehind is: Imports System.Data Imports System.Data.Sql Imports System.Data.SqlClientPartial Class Default2 Inherits System.Web.UI.Page
Private Shared Function GetConnectionString() As String ' To avoid storing the connection string in your code, ' you can retrieve it from a configuration file. Return "Data Source=Database;Initial Catalog=otel;Integrated Security=True;Pooling=False" End FunctionProtected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.LoadDim connectionString As String = _ GetConnectionString() ' Create a SqlConnection to the database.Using connection As SqlConnection = New SqlConnection(connectionString)
' Create a SqlDataAdapter for the Suppliers table.Dim mailsAdapter As SqlDataAdapter = _ New SqlDataAdapter() ' A table mapping names the DataTable.mailsAdapter.TableMappings.Add("Table", "Pages") connection.Open()Dim PagesCommand As SqlCommand = New SqlCommand( _"SELECT * FROM Pages", _ connection) PagesCommand.CommandType = CommandType.Text ' Set the SqlDataAdapter's SelectCommand. mailsAdapter.SelectCommand = PagesCommand ' Fill the DataSet. Dim dataSet1 As Dataset = New Dataset("Pages") 'ERROR MESSAGE HERE...........................................mailsAdapter.Fill(dataSet1) connection.Close()LblPageName.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(1)) TxtPageTitle.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(2))TxtPageSummary.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(3)) Rte1.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(4))TxtPageimgUrl.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(5)) End Using End Sub
DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.CREATE PROCEDURE [dbo].[spu_Import_Export_Image](@srvr varchar(50),@db varchar(50),@usr varchar(15),@pwd varchar(50),@tbl varchar(50),@col varchar(50),@mod varchar(1),@imgpath1 varchar(1000),@pk varchar(50))ASBEGINdeclare @path varchar(50)declare @whr varchar(200)declare @fil varchar(100)declare @cmd varchar(1000)declare @imgpath varchar(800)declare @ext varchar(5)--declare @pk varchar(50)declare @KeyValue varchar(8000)declare @image varchar(50)--declare @imgpath1 varchar(1000)declare @imgpath2 varchar(1000)declare @sellist varchar(2000)set @path = 'c: extCopy.exe'select @sellist = 'DECLARE curKey CURSOR FOR SELECT ' + @pk +' FROM '+ @tbl + ' ORDER BY ' + @pkexec (@sellist)OPEN curKeyFETCH NEXT FROM curKey INTO @KeyValueWHILE (@@fetch_status = 0)BEGINset @whr = '"where '+ @pk +' = "' + @KeyValueset @fil = @imgpath1 + '' + @KeyValue --+ @extset @cmd = @path + ' /S ' + @srvr + ' /D ' + @db + ' /U ' + @usr+ ' /P ' + @pwd+ ' /T ' + @tbl + ' /C ' + @col + ' /W ' + @whr + '/F ' + @fil+ ' /' + @modexec Master..xp_cmdShell @cmdFETCH NEXT FROM curKey INTO @KeyValueENDCLOSE curKeyDEALLOCATE curKeyENDGOAbove srcipt runs fine with image data type in one table but when irun for some other table it gives me Error MessageTEXTCOPY Version 1.0DB-Library version 8.00.194SQL Server 'WSQL01' Message 170: Line 1: Incorrect syntax near '99'.(Concerning line 1)DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.ERROR: Could not use database 'test1'NULL-----------Aslo it only runs on server console if i run it from workstation uingsame files and tables it gives me an error again. Can anybody help meand reply me at Join Bytes! asap.thnx,dharmesh
I recently joined a company that is having an issue connecting to SQL Server Integration Services on one of their production servers. When trying to connect via management studio, both locally and remotely, they receive the error below. The server is a 64 bit server and is using third party replication (Veritas).
It sort of sounds like the issue described in this knowledge base article: http://support.microsoft.com/kb/919224. However, we do not have a problem creating maintenance plans. I'd just give it a shot but its a production server and getting approval to do anything that modifies the registry with the registry replication setup is a pain, so I'd like to determine if there could be another cause first.
TITLE: Connect to Server ------------------------------
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
I have an application running on win 95/98 m/c which connects to SQl Server 6.5 Server on NT 4.0. From some of the client m/c i get an error message - 'DB-Library network Communications layer not loaded'. But from this client i am able to log on and use the enterprise manager. What could be the problem and how to resolve it ? Thanks.
