Hello Experts,
I am new to ASP.NET, I already have hosted my Web site, which Open a SQL
Connection to my Static IP Address, But I can't make it happens.
My Connection Looks Like this.
Data Source = 120.xxx.xxx.xxx x,1444
And rest is the same, it work locallay but not when I launch it on web?
Can any body guide me please.......
Thanks ia Advance.
Rik 5 1463
Data Source = 120.xxx.xxx.xxx x,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=Database ServerName;Init ial Catalog=Databas eName;User
Id=;Password=;"
Hope it helps.
PAtrick
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Patrick,
I really appriciate you response.
strCmd = "user id=sa;password= testserver;init ial catalog=TestDat abase;data
source=210.xxx. xxx.146,1444;Co nnect 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 "Webmatrixhosti ng.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" <ig*@iprimus.co m.au> wrote in message
news:OG******** ******@TK2MSFTN GP12.phx.gbl... Data Source = 120.xxx.xxx.xxx x,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=Database ServerName;Init ial Catalog=Databas eName;User Id=;Password=;" Hope it helps. PAtrick
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
Rik,
offhand, why are you using port 1444 ?
The usual port is 1433.
Did you change SQL Server's port ?
Juan T. Llibre
ASP.NET MVP http://asp.net.do/foros/
Foros de ASP.NET en Español
=============== ======
"Rik" <ri********@yah oo.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. .. Patrick,
I really appriciate you response.
strCmd = "user id=sa;password= testserver;init ial catalog=TestDat abase;data source=210.xxx. xxx.146,1444;Co nnect 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 "Webmatrixhosti ng.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" <ig*@iprimus.co m.au> wrote in message news:OG******** ******@TK2MSFTN GP12.phx.gbl... Data Source = 120.xxx.xxx.xxx x,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=Database ServerName;Init ial Catalog=Databas eName;User Id=;Password=;" Hope it helps. PAtrick
Yes I did change the Port Setting of Sql server, as I came to know that mist
of the ISP are blocking the 1433 port. So I changed it from 1433 TO 1444.
Thanks for your Reply,
Any more clues?
"Juan T. Llibre" <no***********@ nowhere.com> wrote in message
news:Oq******** ******@tk2msftn gp13.phx.gbl... Rik,
offhand, why are you using port 1444 ? The usual port is 1433.
Did you change SQL Server's port ? Juan T. Llibre ASP.NET MVP http://asp.net.do/foros/ Foros de ASP.NET en Español =============== ======
"Rik" <ri********@yah oo.com> wrote in message news:%2******** ********@tk2msf tngp13.phx.gbl. .. Patrick,
I really appriciate you response.
strCmd = "user id=sa;password= testserver;init ial catalog=TestDat abase;data source=210.xxx. xxx.146,1444;Co nnect 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 "Webmatrixhosti ng.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" <ig*@iprimus.co m.au> wrote in message news:OG******** ******@TK2MSFTN GP12.phx.gbl... Data Source = 120.xxx.xxx.xxx x,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=Database ServerName;Init ial Catalog=Databas eName;User Id=;Password=;" Hope it helps. PAtrick
Rik so the problem is u are hosting ur site at webmatrixhostin g and u
can't connect to there Database?
If thats the case trying going to :- http://support.webmatrixhosting.net/..._TSSQL&lang=en
its the WebMatrixHostin g.net Support Center
Or is that u are trying to connect to SQLServer DB on your own PC?
Elaborate more
Hope it helps
PAtrick
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Kevin Sage |
last post by:
For anyone who is having this problem and want to know the
solution.
Add this line of code before your connect method call. It
loads up some config file that the code behind the scenes
needs that causes the delay when the config file is loaded
behind the scenes.
int temp = ServicePointManager.DefaultConnectionLimit;
|
by: Savas Ates |
last post by:
in asp page
im getting this error how can i solve it..
yesterday the codes work but i setup visual studio 6.0 now it doesnt
works..
|
by: Ryan Stewart |
last post by:
I'm running MySQL server on a WinXP box at home. I have a cable
modem/router. I've set up port forwarding on port 3306 to the machine
running MySQL. I can connect locally just fine, but when I try to
connect from a remote location using:
mysql -h xxx.xxx.xxx.xxx -P 3306 -u root -p mysql
I get:
ERROR 2003: Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061)
When I try:
|
by: lytung |
last post by:
Hi All,
I have been struggling with this problem for quite some time. Basically
i have an asp page (on the ISP server) that I want to connect to a sql
server on another machine (on my server) and I have been trying to
figure out how to do this. I tried to connect using an ip address in
the data source and it did not work. The asp.net code looks something
like this:
|
by: Marcus |
last post by:
Hello!
I'm trying to write a VB.NET program that connects to a AS/400 Server.
I've tried almost everything, but it will not connect.
I've tried to set up a DSN using the Client Access ODBC-driver
(v8.00.04.08) but with no result. I've also tried a DSN-less
connection.
From VB.NET i'm using oleDbConnection to create the connection. If I
don't supply a provider in the connection string, the program hangs
saying that a provider is...
| |
by: d3vkit |
last post by:
Okay so I am at a loss here. I have a website that I've previously had no trouble connecting to the mysql DB on. I have an include to a connect file with the relevant connection info, and it was working fine until today. I am trying to implement some ajax with the javascript framework mootools (although I don't see how this is causing the problem it started happening right around this time sooo...)
I am sending info from my login form to the...
|
by: Nathan Sokalski |
last post by:
I am attempting to send an email using ASP.NET 1.1's Mail.SmtpMail.Send()
method. My code contains all of the following:
Dim mailmsg As New Mail.MailMessage
Mail.SmtpMail.SmtpServer =
System.Configuration.ConfigurationSettings.AppSettings("smtpserver")
mailmsg.BodyFormat = Mail.MailFormat.Text
mailmsg.Subject = "My Subject"
|
by: xx75vulcan |
last post by:
Hi,
I have two seperate production machines that I'm trying to get to play
nicely together.
This setup has worked for years before - until recently bother
machines were reformatted, and reinstalled fresh. I know I'm missing a
simple setting here somewhere...
I have a Win 2003 IIS 6.0 box running as web server, and a Win 2003
IIS 6.0 box running as a web server with SQL 2000 Server installed.
|
by: RN1 |
last post by:
Is it possible to connect to my local SQL Server 2005 database from a
remote web server? If yes, what ConnectionString do I use?
Thanks,
Ron
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |