.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

DB-Library error msg (Number=10004, Severity=9, Function=dbopen)

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server


I am using Named Pipes to create Alias of the Sql Server 2008 using CliConfg utility. Now whenever i try to connect to the server I receive 

DB-Library error msg (Number=10004, Severity=9, Function=dbopen) Unable to connect: SQL Server is unavailable or does not exist.  Connection is busy , error.

please help.


View Complete Post

More Related Resource Links

Currency and number column error with office 2007 document formats in SharePoint 2010 library

Hi there,



The following error occurred within a SharePoint 2010 document library:

As I tried to test out the new SharePoint 2010 environment I changed the metadata from a few documents within a document library. I noticed that the data from the currency und number field was incorrect from a few documents. The numbers looked like that the decimal separator were ignored. For an example: 123.456,78 was saved as 12.345.678.

At first I thought it could be a language incompabilty but if that would be the case: Why would there be other documents which show the correct number?


I created another document library to recreate this error. And there I noticed the real reason: Every time I changed these fields from a document which was saved in the office 2007 format the error occurred. The metadata from the documents in the office 2003 format were correct.


Has anyone a similar problem or got an idea how to solve this problem?


System Specs:

Frontend: Windows Server 2008 SP2 ent

ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).


I Am Continiously Getting Error For Following Line Of Code, It Work  Fine In Other Database

Am I Doing Any Mistake

if (sh3itno != "" && dpsh3no != "")
                string queryy = "SELECT [CHEQNO] FROM [SH3MAST] WHERE (([CHEQDATE] = " + chqdate + ") AND ([FAVOUR] = " + favour + ") AND ([CHQTYPE] = " + ctype + ") AND ([TRSTN] = " + trstn + ") AND ([TRBANK] = " + trbank + ") AND ([SH3ITNO] = " + sh3itno + ") AND ([DPSH3NO] = " + dpsh3no + "))";
                OdbcCommand cmd3 = new OdbcCommand(queryy, connen1);
                string chqno =cmd3.ExecuteScalar().ToString(); (Here Iam Getting Error)
                tbl.Rows[i]["cheque no"] = chqno;
Stack Trace: 

[OdbcException (0x80131937): ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).]
   System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +39
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, Strin

'Meter number is not registered ' error FedEx ship web service move to production



I want to integrate FedEx ship web service in my website. It works fine for local but for production it gives error. I changed test credentials by production credentials. also changed test url "https://gatewaybeta.fedex.com:443/webservices" by production url "https://gateway.fedex.com:443/webservices" But I am getting error that meter number is not registered. Please advice.

Error adding a document library to a site



I am receiving the error "Cannot complete this action.  Please try again"  when trying to add a document library to one of the sites.  This is Sharepoint 2007 SP1.  I seem to be able to do it thru designer but not the web interface.

Does anyone know how to fix this?

Function to return number


I am trying to create a function that  return the number part within / / from a url if exist:

For exmple:

http://www.mydomain.com/Mobile_Exec/1234/Orange_revamps_business_website.aspx SHOULD RETURN "\1234\"

http://www.mydomain.com/News/Orange_revamps_business_website.aspx    SHOULD RETURN "\\"

http://www.mydomain.com/News/Features/627362/Orange_revamps_business_website.aspx SHOULD RETURN "\627362\"

I prefer if possible to use regular expression. Any help would be really appreciated.

HTTP 400 Bad Request Error when uploading to document library


I am running MOSS 3007 Standard on Windows 2003. When trying to upload files larger than about 29Mb, I am getting an HTTP 400 Bad request error. The error states "HTTP Error 400 - Request is badly formed." I am able to successfully upload a 28Mb file. Sharepoint is configured to accept files up to 75Mb.

I have done a fair amount of research on this, but none of the solutions seem to apply to our environment. The two most likely candidates do not apply, for example we are NOT running URLScan (there are a variety of solutions suggesting this could be an issue with uploads of 30Mb or more), and we are on 2003 with IIS6, so again the issue relating to 2008 and IIS7 do not apply.

The "Request is badly formed" part of the request is particularly confusing as most issues I have come across where this error is the symptom point to errors in custom code that is trying to talk to SharePoint. We have done none of our own custom coding and this error is occurring when attempting a simple upload to a document library.

Trying to drag and drop the file across when the document library is open in windows explorer also fails.

I did come across someone saying they had a similar problem which was caused by a damaged content database, however in this case, it is occuring regardless of which content database I use, so either they are all corrupt

Calculated Columns in a Form Library receive error: Value does not fall within the expected range.


I have a forms library that posts the date the form was created. We would like to create a calculated column that allows us to look at these forms based on the month and year they were created. I had created a calculated column that extracts the month and replaces the number with a text string by using an if statement; "IF(MONTH([Proposal Date])=1,"January","") It goes on to evaluate each month and replace the number with the text string. This formula worked for quite some time, though now when I try to add any calculated columns or edit any existing calculated columns on this form library I receive the following error: Value does not fall within the expected range. Now my existing calculated columns (like the one above) do not work and I can not create new calcualted columns. Any insight would be awesome as this has been plaguing me for a couple of months now.

Error "The process cannot access the file ....." occurs while using function "ExportToStream"


Dear all,

   I sometimes get the following error while printing crystal report to pdf:

   System.Runtime.InteropServices.COMException (0x80004005): The process cannot access the file because
it is being used by another process. at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export
(ExportOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream
(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
 at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options) at
 CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType) at
 CommonWA.CommonFunc.GetPDFMemoryStream(DCMSReportDoc _dcmsreportdoc, Boolean& _DataExist) in E:\wwwroot\ASPWA\CommonWA\CommonCom.vb:line 382

  The error not occurs frequently but sometimes it will happen, can someone tell me why the error occurs and how can I solve the problem?

Thank you very much.


Error: 18456, Severity: 14, State: 16 Login failed for user 'NT AUTHORITY\SYSTEM'

Hi,   can someone help me with this error. Error: 18456, Severity: 14, State: 16 Login failed for user 'NT AUTHORITY\SYSTEM' [CLIENT:<local machine>] I've found several Threads but not with the NT AUTHORITY\SYSTEM.   Thanks for help.   Jens

SQL Server 2005 x64: Intermittent "Error: 18456, Severity: 14, State: 10."

Hi, We are experiencing intermittent authentication errors "Error: 18456, Severity: 14, State: 10" on a customer's production server. This is a new server that has just been rolled out in the past several months. Rebooting the server appears to make the problem go away. We are using SQL authentication from a separate server that is running IIS. The application always uses the same username and password to connect. Server info: select @@versionMicrosoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53 Copyright (c) 1988-2005 Microsoft CorporationStandard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1) select @@versionSP1 Sample error from SQL Server errorlog: Date  7/7/2006 10:53:24 AMLog  SQL Server (Archive #2 - 7/7/2006 12:20:00 PM)Source  LogonMessageError: 18456, Severity: 14, State: 10. MSDN (http://msdn2.microsoft.com/en-us/library/ms366351.aspx) lists various states for this error message but 10 is not included, and it says "Other error states exist and signify an unexpected internal processing error." Note: This was not a case of a transient error that occurs only when SQL Server is starting up - these errors occurred at a variety of times, two months after the server was last rebooted / SQL Server last restarted. Thanks for any help you can provide. Regards,-Frank.

"This document could not be checked out" error in IE with SP2010 doc library

We created a document library in Sharepoint 2010 and configured it to require checkout. Via Internet Explorer, users click on a document in the library and choose "Check Out and Edit". They get the error message "This document could not be checked out. You may not have permission to check out the document or it is already checked out or locked for editing by another user". We confirm that the document is not checked out to anyone else. The user is able to open the document Read Only from IE and then check it out in the application (for example, they can click the Check Out button in Word 2007 successfully), so the problem seems to be IE related. We have tried adding the Sharepoint site in the Trusted Sites and Local Intranet zones in IE, but it doesn't make a difference.Any suggestions?Thanks.

Infopath form and forms library error

I've created an InfoPath 2010 form and associated it with a forms library on a SharePoint site. When I go to the library and choose "Add document" the form opens up to be filled out by the user. When the form is filled out, and the user tries to submit, they get an error saying that I need to configure SharePoint to allow cross-domain data access for user form templates that use connection settings in a data connection file and store a UDC file in the same site collection as the form. So I've enabled cross-domain data access and I've already created a Data Collection Library for Forms in the Site that is approved. What am I missing?  Why am I still getting the error?  

Error number: MSSQL_REPL-2147201016 and other animals (I jmade a boo bioo)

Hi guys,   Just experimenting with replication at the moment, and after trying to set a table as read only using the following: ALTER TABLE mytable WITH NOCHECK ADD CONSTRAINT chk_read_only CHECK ( 1 = 0 )   (yes - I know now, that won't work) - I removed the constraint within managment studio, and subsequently mucked up the syncing. (clever eh???)   The whole thing is running on sql server 2005, publicher and subscribers all on the same box for the moment)   2 of the 4 subscriptions give the 2147201016 error, - complaining about a missing stored procedure - if I look in the stored procedures for the subscribed tables - it seems that all the dbo.msmerge procedures have gone bye bye!   also - the other 2 tables give another error: -------------- The schema script 'if object_id(N'[dbo].[ALBANKHOL]') is not null exec('ALTER TABLE [dbo].[ALBANKHOL] WITH NOCHECK ADD CONSTRAINT chk_read_only CHECK( 1 = 0 ) ')' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001) ---------------- (yes - table "albankhol" is the one I created the read only constraint on.   as mentioned, all subscribers and publisher are on the one database - so I don't think it;s a timeout issue     any ideas?

COM Interop Error loading type library/DLL TYPE_E_CANTLOADLIBRARY error in Vista but not XP

I have created a .NET executable that is using a COM assembly that is located on a servers shared drive but am  having problems getting it to work on a number of machines. I have made sure to register the COM assembly using regsvr32 and doing that it works on the computer that I developed it on. From there I brought it over to a Windows XP computer where it didn't work. I received an error message saying "Error loading type library/DLL ... (TYPE_E_CANTLOADLIBRARY)", which was in reference to the COM assembly. After some trouble shooting I found that if I granted the executable FullTrust in the .NET security model the .NET executable was able to load the assembly and everything worked properly. From there I brought the executable to a Windows Vista computer, registered the COM assembly using regsvr32 and granted the .NET executable FullTrust in .NET but it doesn't work. I get the same error saying "Error loading type library/DLL ... (TYPE_E_CANTLOADLIBRARY)". Any idea why the same steps would work in XP but not in Vista? Am I missing something obvious? Any suggestions would be greatly appreciated.

Uploading a file to a document library produces access denied error, but only on first try.

Hi I have a task which uses a custom form which is part of a custom workflow.  The form incorporates an asp fileUpload control to allow a user to browse for a local file which they can then select and it will be upload a file to a folder in a document library.  The first time this action is performed the folder in the document library will not exist so the code creates a folder and then uploads the file to it. The problem I have is, the first time users try and upload a file the directory is created in the document library as expected, but then the user gets redirected to the standard SharePoint Access Denied page.  If the user goes back to the task list, then loads the task web page again, selects the same file and hits upload, then the file is uploaded fine. All subsequent file uploads work fine after that for all users. Users have Contribute permissions on the document library. The code to do the upload is as follows.  The task has a "CR Number" associated with it, which the directory in the doc library should be called.  It uploads the file to a stream.  Then gets the url of the web and works out the file url and uploads it.  The creation and checking of the folder in the doc library happens in the getDirUrl method. /// <summary> /// Processes an uploaded file. /// </summary> /// <param name="

getting error when i clicked on doucment library

Exception occurred. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION)) plz help

Error: 18056, Severity: 20, State: 28.

Error: 18056, Severity: 20, State: 28. 9.00.4035.00, Enterprise Edition (64-bit) Looking for troubleshooting steps specific to state 28.    As it is occurring on a server supporting automated testing whose configuration is not trivial to describe, I’m hoping that state 28 deals with (something) that will help me narrow my focus a bit.  Should that not pan out, I'll edit with more info.   edit: also getting one more cycle worth of data
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend