Specified SQL Server Not Found: (ASP.NET(1.1) - SQL2000)
Oct 12, 2006
Hi,
I was hoping someone may be able to shed some light on a SQL2000 connection problem.
I have an ASP.NET(1.1) application that connects to a SQL2000 instance on the localmachine, the connection details are as follows:
Connection Code :try
{//connect to the provided datasource
using(SqlConnection connection = new SqlConnection(strConnectionInfo))
{
strStatus = "Pulling Data";
SqlDataAdapter sqlA = new SqlDataAdapter("SELECT * FROM NavBlocks",connection);
sqlA.Fill(dsNav.NavBlocks);
SqlDataAdapter sqlB = new SqlDataAdapter("SELECT * FROM NavItems",connection);
sqlB.Fill(dsNav.NavItems);
bNavLoaded = true;//prevent further calls
}
}The connection string is as follows: "Data Source=BOBBITSQL2000;Initial Catalog=pinnacleCMS;User Id=myUser;Password=myPass;"
Now this conection has never been a problem, the intial catalog exists, the user exists and has permissions, further to this this users connection details can be used to succesfully access the database from a dsn on this machine. The server explorer finds the database fine, Visio finds the databse fine.
The problem only existed after I reverse engineered the database into visio (the database was originally developed using Visio), then dropped all of the tables using Enterprise Manager, and re generated the database from within Visio (ddl script) following a few minor changes.
Since the re generation I get the server not found error message from the ASP.Net application.
I have tried using different network libraries, logging in using the sa account etc, it makes no difference the ASP.Net application cannot see the SQL server instance.
Any ideas would be greatly appreciated.
p.s. I have tried dropping the firewall with no success, no updates have been installed.Thanks
i have sql2000 & sql2005 on the same machine. I am unable to register my localhost in sql2000, get an access denied error. How can I make my localhost use sql2000 database?
I've got a package which reads a text file into a table and updates another. I set up configurations so that I could import it into the SSIS store on both my dev and live servers. Now, I'm getting this error. I tried removing the configs and am still getting it.
I've been through each step and everything looks okay. Does anyone have any idea (a) what's wrong, (b) how to localise the error or (c) get any additional information? Or do I just have to recreate the package from scratch?
Error at PartnerLinkFlatFileImporter: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found.
Error at PartnerLinkFlatFileImporter [Log provider "SSIS log provider for SQL Server"]: The connection manager "" is not found. A component failed to find the connection manager in the Connections collection.
I have inhereted this application and I am a newbee at asp.net. Fisrt my apologies for posting such a large amount, I just wanted to give you all the information that I possibly can.
I have the follwoing error "Specified SQL server not found".
Server Error in '/ppasa' Application. --------------------------------------------------------------------------------
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found. 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.Runtime.InteropServices.COMException: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found.
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:
[COMException (0x80004005): [Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found.] ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options) +0 PPASA.PPASA.OpenCloseDB(Boolean Connect) in c:inetpubwwwrootPPASAPPASA.vb:9 PPASA.Login.btnSubmit_Click(Object sender, EventArgs e) in c:inetpubwwwrootPPASALogin.aspx.vb:38 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
-------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
The process of my application works as follows. 1)Login.aspx submits the username and password. It is linked to Login.aspx.vb with the following statement <%@ Page Language="vb" AutoEventWireup="false" Codebehind="Login.aspx.vb" Inherits="PPASA.Login"%> 2)In Login.aspx.vb (below) has a call to PPASA.vb with the following statement Call OpenCloseDB(True).
Public Class Login Inherits System.Web.UI.Page
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer. <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub Protected WithEvents Label1 As System.Web.UI.WebControls.Label Protected WithEvents Image1 As System.Web.UI.WebControls.Image Protected WithEvents Label2 As System.Web.UI.WebControls.Label Protected WithEvents txtUsername As System.Web.UI.WebControls.TextBox Protected WithEvents Label3 As System.Web.UI.WebControls.Label Protected WithEvents txtPassword As System.Web.UI.WebControls.TextBox Protected WithEvents btnSubmit As System.Web.UI.WebControls.Button Protected WithEvents btnClear As System.Web.UI.WebControls.Button
'NOTE: The following placeholder declaration is required by the Web Form Designer. 'Do not delete or move it. Private designerPlaceholderDeclaration As System.Object
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init 'CODEGEN: This method call is required by the Web Form Designer 'Do not modify it using the code editor. InitializeComponent() End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here End Sub
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click Dim rs As ADODB.Recordset
Call OpenCloseDB(True) rs = cnn.Execute("SELECT ID FROM PPASA_User WHERE Name='" & UCase(txtUsername.Text) & "' AND Password='" & txtPassword.Text & "'") If Not rs.BOF And Not rs.EOF Then Call PopulateUserInfo(rs.Fields(0).Value) Server.Transfer("PPASAMain.aspx") Else Call ClearLoginBoxes() End If Call OpenCloseDB(False)
End Sub
Public Sub PopulateUserInfo(ByVal MyID As Integer)
Dim rs As ADODB.Recordset
Call OpenCloseDB(True) rs = cnn.Execute("SELECT ID,Name,Security FROM PPASA_User WHERE ID=" & MyID) If Not rs.BOF And Not rs.EOF Then rs.MoveFirst() 'CurrentUser.ID = rs.Fields(0).Value 'CurrentUser.Name = rs.Fields(1).Value 'CurrentUser.Security = rs.Fields(2).Value Session.Add("ID", rs.Fields(0).Value) Session.Add("Name", rs.Fields(1).Value) Session.Add("Security", rs.Fields(2).Value) Session.Add("DonorID", 0) End If Call OpenCloseDB(False) End Sub
Private Sub ClearLoginBoxes() txtUsername.Text = "" txtPassword.Text = "" End Sub
Private Sub btnClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClear.Click Call ClearLoginBoxes() End Sub End Class
3)PPASA.vb then creates the connection to the Database. PPASA.vb looks like this.
Module PPASA
Public cnn As New ADODB.Connection
Public Sub OpenCloseDB(ByVal Connect As Boolean)
If Connect = True Then If cnn.State = 0 Then cnn.Open("Description=PPASA;DRIVER=SQL Server;SERVER=THE-ONESERVERA;UID=sa;PWD=123;APP=Microsoft Data Access Components;DATABASE=PPASA") End If Else If Connect = False Then If cnn.State = 1 Then cnn.Close() End If End If End Sub
Public Function CheckSecurity(ByVal Actual As Integer, ByVal Required As Integer) As Boolean If Actual >= Required Then CheckSecurity = True Else CheckSecurity = False End If End Function End Module
4)After I submit Login.aspx the application boms and gives me the "Specified SQL server not found".
Extra Info:
The Sql server is up and running. I have tested it by connecting with 2 test connection files index.asp and index2 .aspx. Here are the files. The files also return results from the pubs db.
index.asp
<% Set conn = Server.CreateObject("ADODB.Connection") strConn="DRIVER={SQL Server};SERVER=THE-ONESERVERA;UID=sa;PWD=123;DATABASE=pubs"
conn.open strConn
sql = "SELECT * from authors" set rs = conn.Execute(sql) if not rs.EOF then while not rs.EOF lastname = rs("au_lname") firstname = rs("au_fname") response.write "LASTNAME :: " & lastname & " \// FIRSTNAME :: " & firstname & "<br>" rs.movenext wend end if conn.Close() Set conn = Nothing %>
and index2.aspx
<%@ Page aspcompat=true %> <% Dim objConn Dim strConn Dim objRs Dim objCmd Dim objField
If Not objRs.EOF then Do While Not objRs.EOF response.write ("VALUES :: ") For Each objField In objRs.Fields Response.Write (" " & objField.value & " \// ") Next response.write ("<br>") objRs.movenext Loop End if
objConn.Close() %>
There are also the following files in the bin directory. Interop.ADOR.dll Interop.MSChart20Lib.dll Interop.Scripting.dll PPASA.dll utCharting.dll
So my question is this, why do I get the error "Specified SQL server not found", when I dont get the error with the test connection files.? Do I have to do anything with the .dll file in the bin directory, like register them or something? How does the Login.aspx.vb file call the PPASA.vb file when I see no reference to PPASA.vb in the Login.aspx.vb file? I would appreciate any help or suggestions. Thanks
I have 2 server 2003 boxes one has sql 2000 and the other has IIS. I can pull up my pages on the iis server but as soon as my app tries to access the sql server I get cannot find server. All my settings are correct in the web.config file. I do not have this problem with the same setup on server 2000 boxes. Also active dir is not set up on the 2000 or 2003 boxes. Can someone please help. thanx weisenbr
I am trying to connect to my SQL Server through my ASP.NET webpages. My problem is that, no matter what I do, it always says that the server is not found. I know the IP address of my server, and this IP address works from other computers within my network, just not mine.
I have no idea what it could be. If anyone knows, any help would be greatly appriciated.
Hi, i have just started working with asp.net and purchased a book which has MSDE with it for database access. Ihave followed all the instructions on how to install MSDE, however when i try to set up a database using Miscrosoft ASP.NET Web Matrix, i get the error message:Unable to connect to the database server.SQL server does not exist or access denied.ConnectionOpen(Connect()).This message occurs when i am creating a new database.does anyone have any ideas why this may be happening?I have MySQL installed on my computer, could this be interfering with the MSDE ?Thanks....
Sometimes when I try to connect to an existing server (sql 7.0) , I get the error message "specified sql server not found-check registration properties" and it refuses to connect to it. Has anyone encountered this before? Do help.
and i get "[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found."
From my older host I have no problems connecting to my server... so I assumed it must be something at my new host, but I'm able to connect to other remote sql servers from my new isp (for example I can connect from my new ISP to the old ISP's SQL server w/o a problem), but for some reason I can't from the new host connect to mine.. is there a setting on mine that needs to change?
newhostwebsvr to oldhostsql works... oldhostwebsvr to mylocalsql works.. newhostwebsvr to mylocalsql doesn't work??
Hi there, I access to server SQL by an application on web,I configured the ODBC box for using TCP/IP and the server use also the TCP/IP. I have this message :
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found. /medecin/IdentificationAcces/membre_enregistrer.asp, line 108
Yesterday I created a table in Sql Server 2000,using this script: CREATE TABLE [dbo].[User]( [Id] [int] NOT NULL, [UserName] [nvarchar](20) NOT NULL, [TrueName] [nvarchar](20) NOT NULL, [Password] [nvarchar](60) NOT NULL, [Department] [int] NOT NULL, [Mobile] [nvarchar](20) NULL, [Telephone] [nvarchar](20) NULL, [Remark] [nvarchar](200) NULL, [Enabled] [bit] NOT NULL, [Available] [bit] NOT NULL, CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ( [Id] ASC ) ON [PRIMARY] ) ON [PRIMARY] There was only one record in it: INSERT INTO [User] VALUES(1,N'SUP',N'Jim',N'213123',1,NULL,NULL,NULL,1,1) After I executed this script:UPDATE [User] SET UserName=N'f',TrueName=N'gg',[Password]=N'dfsdfsdf',Mobile=NULL,Telephone=NULL,Remark=NULL, Enabled=1 WHERE [Id]=1 AND Available=1 The value of 'Available' field changed to Zero.That was not supposed to happen. I'm pretty sure it is a bug, because when I did the same thing in Sql Server 2005, everything was correct. Anybody can tell me if this is a known bug? I searched google,but couldn't find any answer. Thanks!
I recently was moved into an applications developers position here at the lawfirm I work at. Thusfar, its been alot of straight ASP, SQL2000, and Access. I know the need for me to know .Net is coming, and Ive decided to start playing with ASP.net so I can look a bit proactive.. Ive looked over what I need to get started, in liu of Visual Studio I know of the VS Express options. However, I currently have SQL Server 2000 installed locally on my machine along with IIS 5.1. All the VS Express information Ive found keeps referencing SQL2005 express. Can I get away with using what I already have with 2000? Or if not, can SQL2005 express be run alongside with SQL2000? Any assistance would be greatly appreciated. Brian
I'am running Sql2000 Enterprise edition on Windows 2000
When I re-name the Server for example from TST_SVR To TST_SVR1, Sqlserver comes backup fine with the new name (TST_SVR1) , BUT I'am still able to connect to the SqlServer even with the old Server name (TSR_SVR). I do not want to connect using the old server name.
I have dropped and added server using Sp_addserver and Sp_Dropserver, My @@servername command returns the new server name
Brand new to linked servers and trying some stuff. I've successfully linked a server using EM (both are sql2000). I can successfully run a select statement through QA. I'm trying to test a locally-stored procedure and am having a bit of trouble. Please, no arguements about best method - I have no choice. Cannot create stored procs on remote machine.
If I run this through QA, I get an immediate return set: select * from linkedName.dbName.dbo.tblName
If I try to create a test stored proc like the following, I get: Error 7405: Heterogeneous queries require the ANSI_Nulls and ANSI_WARNINGS options to be set for the connection. This ensure consistent query semantics. Enable these options and thenreissue your query. When I looked it up in BOL, I thought I was setting these items?
CREATE PROCEDURE zp_countyListing AS SET ANSI_WARNINGS ON SET ANSI_NULLS ON
I have Windows server 2003 installed, and Visual Studio .NET 2003 ent.arch also. I downloaded the msde sp3 from microsoft's site. installed it. The problem occured when i rebooted my machine. The system tray icon of SQL Server Service Manager says "Not connected". When i open the manager, there are no Services nither Servers listed in the dropdown lists. Can you help with this. Thx in advance!
I’ve got a linked server created in SQL2000 to DB2.
I’m using Client Access ODBC Drivers, and Microsoft OLE DB provider for ODBC Drivers.
I have views created against the linked server as
ALTER VIEW BLBATDT AS SELECT * FROM LURCH_PARADB.S102D4LM.PARADB.BLBATDT
All seem(ED) to be working fine until I ran into this issue.
Using the view If I select count(*) from BLBATDT returned value 786 If I select * from BLBATDT I get 76 rows returned
If I select from BLBATDT where field = value I get nothing, when in fact there is a value I specified.
I modified the view creation to
Create view as select * from openquery(LURCH_PARADB, 'select * from S102D4LM.PARADB.BLHDR')
Performed the above simple selects, (same results)
I modified the view creation to Create view as select * from openquery(LURCH_PARADB, 'select field_list_of_all_fields_in_the_table from S102D4LM.PARADB.BLHDR')
Same results
However if I modified the view creation to Create view as select * from openquery(LURCH_PARADB, 'select field1, field2 from S102D4LM.PARADB.BLHDR')
And limit the fields selected to a small subset, everything works fine.
I think the issue may be that the parent tables are very wide in total byte count and the number of fields is also large. This particular tables has 120 fields with a total record length of over a 1000 bytes.
hello,I'm trying to create a linked server from an SQL2000 to a Unify ELS(very old, odbc is version 1) database on SCO unix.The odbc driver is old but it works fine when used by applications forcreating reports.What I want to do is make a linked server from the SCO box to the win2kbox. So, I'm using enterprise manager to create the linked server.The DSN of the unify database is CORE_OFFICE1I'm getting 'Error 7399: OLE DB provider 'MSDASQL' reported an error.Datasource name not found and no default driver specified.When I create the linked server I chose the OLE DB for ODBC drivers.I put 'CORE_OFFICE1' for the Data Source name. I also setup thesecurity with the name of a unix account for login/password.What else should I have?I'm new at this linked server stuff!Product Name:Data Source:Provider String:Location:Catalog:Thanks,Oskar
Our SQL Developer asked for a new server with a separate small hard disk for the Transaction Log alone to reside on, to increase performance. This will be hard to do, since the servers we have been looking at are low-profile rackmount, and only hold 2 SATA disks. I hate to waste our only expansion bay on a small HD. Is this really something important, or will a Quad-core processor and plenty of RAM make the performance difference negligible? We have 32-bit SQL2000 licensed per processor, and our database is only about 26GB. I was hoping to get 1 large disk and partition it into a 20GB OS partition, and the rest would be for SQL. Am I totally on the wrong track?
My 2nd question is about RAM - if we get 4GB of RAM, will it decrease the performance if we get 64-bit O/S pre-installed instead of 32-bit? I know 64-bit O/S *can use* more RAM than 4GB, but does it *need* more RAM for the same level of performance that we have now? (We are planning to expand that to at least 8-12GB whenever we upgrade to 64-bit SQL2005, but the budget does not allow it just yet.)
I want to install SQL 2000 Server on Win-2003 STD Server and transfer the database that has been running on SQL-2000/Win 2K server.
Win-2003 Server has Apache services and TrendMicro AV Server running. After installation the SQL service starts automatically. But I am not able to see the database from Enterprise manager. It gives error 'A connection could not be established to <local>. Reason: Login failed for DOMAIN/USER. I am logged into Win2003 server as 'Administrator' for installation. SQL Server authentication in Mixed Mode and connect using Domain user account.
While applying update(SP3) also the same error comes after trying to validate password and the Sql service automatically stops. I tried using both Win pwd and SQL sa pwd. Both are giving same error.
When making a call to MyList.DataSource = products.GetProductCategories(); I get the "SQL Server not found or Access denied" error. Where should I start looking?
Hi, Can any one suggest me how to find a error log when SQL Server Agent is down. I did not find it in NT error log when my SQL Server Agent was shut down. Is it known problem and pls also suggest me for the remedy to this problem. thanks in advance. regards, Narayanan.
Hi,I have a Scheduled Job on my PC that runs against a Linked Server. Ihave scheduled the Job to run when SQL Server Agent starts and I haveconfigured my SQL Server and SQL Server Agent to start when the OSstarts. The connection to the Linked Server is via my Broadbandinternet connection.I have some suspicions as to the cause and hence a possible solutionbut I want to run my ideas past anyone else who may have experiencedthe same.1. Should I have my DSL modem turned on before I start the PC so thatthe Network connection is available when the OS starts?2. Are the Network connections only made available after you havelogged in and hence not established quickly enough before SQL Serverand SQL Server Agent are started?Yesterday, when I rebooted the PC with the modem still on theScheduled Job ran without failure but this morning again it failed. Myusual routine is to turn on the modem just before I login.If No. 2 is the case then maybe I just need to set the "Retryattempts" parameter.Thanks,Michael HolbertonHospedaje Los Jardines & Sacred Valley Mountain Bike ToursCusco Database Development and Cycling Serviceshttp://www.machawasi.com/http://machawasi.blogspot.com/http://databaseservices.blogspot.comhttp://serviciosdeciclismodelperu.googlepages.com
Hi All!Has anyone has seen this error before?Event Type:InformationEvent Source:Application PopupEvent Category:NoneEvent ID:26Date:5/14/2004Time:10:06:45 AMUser:N/ADescription:Application popup: sqlmangr.exe - Entry Point Not Found : Theprocedure entry point TraceMessage could not be located in the dynamiclink library ADVAPI32.dll.This computer is running MS SQL Server STD Edition 2000 W/ ServicePack 1.Thanks!
Can someone help to fix this query so that it returns a 0 (zero), as opposed to a blank or null value, when case_id # 1049 record is not found. And if the record is indeed found it should return the case ID (numeric value).
SELECT CASE WHEN count(*) = 0 THEN 0 ELSE a.CASE_ID END FROM (SELECT CASE_ID FROM CASE_DETAIL WHERE CASE_ID = 1049) a GROUP BY CASE_ID GO
Linked server from SQL2005 to SQL2000 Hi I use the following SQL statements to create a link server. RemoteServerName is an SQL2000 and I am executing this in another machine which is SQL2005.
Though the link server is created successfully, I am not able to se the tables under it so could not query anything.
I have setup SQL2000 Personal edition on my notebook.
I cannot connect to an existing SQL7 server on the network anymore. I used to run SQL7 Desktop edition which ran just fine. I also noticed that when I start my machine it take about 2 minutes until the SQL service is started.