Issues Getting ASP.NET And SQL To Talk

Aug 8, 2005

Hi! This is my first time messing with SQL and ASP.NET. I'm having issues getting the SQL to work with ASP.NET. I am using win XP Pro running IIS. I have all patches and upgrades installed on the computer. All files are served off localhost.When I try to visit the ASP.NET page I get the following error message.
 
Server Error in '/PortalVBSDK' Application.
SQL Server does not exist or access denied. 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.SqlClient.SqlException: SQL Server does not exist or access denied.Source Error:



Line 28: Dim links As New ASPNET.StarterKit.Portal.LinkDB()
Line 29:
Line 30: myDataList.DataSource = links.GetLinks(ModuleId)
Line 31: myDataList.DataBind()
Line 32: Source File: C:Program FilesASP.NET Starter KitsASP.NET Portal (VBSDK)PortalVBSDKDesktopModulesQuickLinks.ascx    Line: 30 with the stack trace of



[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASPNET.StarterKit.Portal.LinkDB.GetLinks(Int32 moduleId)
ASP.QuickLinks_ascx.Page_Load(Object sender, EventArgs e) in C:Program FilesASP.NET Starter KitsASP.NET Portal (VBSDK)PortalVBSDKDesktopModulesQuickLinks.ascx:30
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +750


Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 Any help would be greatly appriciated!Joshua

View 2 Replies


ADVERTISEMENT

How To Get Two Different SQL Servers To Talk To One Another

Jan 17, 2006

Hi all I need to create a view for another sql server on the network.

I can create a view for two to databases on the same sql server to talk but how do you do it for a differend sql server??


CREATE VIEW dbo.Revocations_View
AS
SELECT TM#, LastName, FirstName, MI, SSN, [I/R #], Date, ReasonofRevocation, Notes, Termination, Conditional, WasEmployeeFined, LicenseSuspension,
Status
FROM LicensingActions.dbo.Revocations_Tbl

View 3 Replies View Related

Cannot Talk On 1433 Port

Apr 30, 2001

I have sql server that get the following error on error log.

SuperSocket Info: Bind failed on TCP port 1433.

This error forces client to use Named Pipe to connect to SQL Server.

Does anyone how to fix this error.

Thank You,
John

View 4 Replies View Related

MSDE 2000 Release A Won't Talk

Jul 20, 2005

MSDE 2000 Release A installed under windows 2000 pro will notcommunicate with SQL Server Manager nor MS Access on peer computer.Can someone help?Have set DISABLENETWORKPROTOCOLS=0 at install time.Install log shows installation successful..Control Panel> Admin Tools> Services section shows SQL server instancerunning.Disabling firewall has no effect.SQL Server Manager (icon at bottom right in task tray - thisstarts/stops Server instances), on same computer as SQL Serverinstance, shows only instance "H" which is the same as the computername. (This instance was uninstalled before new instance wasinstalled.) Typing new instance name ("HABC" and variations) intotop combo box produces error messages such as "wrong format for name","Network path not found" "RPC service not running". What is thecorrect computer/name format?? Key problem is clearly that ServiceManager can't communicate with this local MSDE instance.All Windows 2000 updates from MS web site have been installed.Objective is to operate MS Access on computer X (also running Win 2000Pro) with computer H as a peer that hosts MSDE.Has anyone else run MSDE 2000 Release A on a Windows 2000 Pro system??---Mark Ferguson

View 10 Replies View Related

Can Service Broker Talk To Informix

Jan 16, 2007

Hi,

I am very new to Service Broker.

Can I have a Service Broker which will Exchange Message from Informix and service broker sitting on SQL Server Box.

If this is possible, How can we achieve it. Any Pointers will be very helpfull.

Thanks

View 8 Replies View Related

Is Anyone Talk About The Core Differences Between SQL-Express And The Whole Edition?

Jul 14, 2007

should be detail ,I think it will be helpful to the newbirds such as me and the others.

View 3 Replies View Related

How Can I Get My Desktop App To Talk To My Windows CE Device In Vb.net Compact Framework?

May 9, 2008

HI all,

Que 1.

M doing PDA Project in Vb.net Compact framework [ CF ]. In tht I need to do synchronization My PDA's database with Desktop Computer's database manually.
So Plz Suggest me some options .....
One of them I know & Its RAPI..
--> "RAPI allows desktop based applications to talk with CE devices while they're connected to the desktop via ActiveSync".

but M confused regarding ActiveSync Bcoz i want to do it Manually.

Thnx & Regards

Amit B. Master

View 3 Replies View Related

Can A SQL Server Express Talk With Other SQL Server Express In The Same Network?

Dec 5, 2006

Hi

There is a service from SQL Server 2005 that "listens" to the network, if the network is down, all data gets saved within the local instance of the SQL server 2005. And when the network becomes available, the local instance of the sql server will automatically "feed" the local records to the central SQL server 2005.

What is that feature called?





View 3 Replies View Related







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