Re: How to connect SQL Server from ASP.NET Page

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rik (rikleo2001_at_yahoo.com)
Date: 02/24/05 

Date: Fri, 25 Feb 2005 12:44:13 +1300

Patrick,

I really appriciate you response.

strCmd = "user id=sa;password=testserver;initial catalog=TestDatabase;data
source=210.xxx.xxx.146,1444;Connect Timeout=30"

The IP Address is our Static IP Address, which is linked with my system, and
My System have SQL Server running on it.

I generated a ASP.NET page, and Launched it on the free trial Web Hosting
web site "Webmatrixhosting.net"

Now when I want to connect to the my Static IP Address, It raised an Error,
SQL Server Does not exit.

Waiting for further help please....

rik

"Patrick Olurotimi Ige" <ige@iprimus.com.au> wrote in message
news:OG5QmTsGFHA.1172@TK2MSFTNGP12.phx.gbl...
> Data Source = 120.xxx.xxx.xxxx,1444
> Rik is that only ur connection?
> how can that connect ..
> And pls ask the Admin where u are hosting ur website whats the database
> server name u are connecting to and ur password and username.
> And tthen use the string below to connect:-
> "Data Source=DatabaseServerName;Initial Catalog=DatabaseName;User
> Id=;Password=;"
> Hope it helps.
> PAtrick
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Exception trying to import data from Excel .
    ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
    (microsoft.public.sqlserver.tools)