473,672 Members | 2,682 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Connection with SQL DB on internet Web hosting using ASP.NET

Dear Microsoft Developers Support ASP.NET Tea

I have SQL DB has been created in web hosting support SQL server & ASP.NET and I develop on localhost web Application using ASP.NET

After created SQL DB on web hosting I get this information

* IP Address for the Server for example: 66.102.135.15
* DB name for example: Dynam
* DB username for example: user
* DB password for example: passwor

I Registered the Server 66.102.135.150 in SQL Enterprise Manager after that I used wizard in ASP.NET to create SqlConnection with Sql DB that hosted on server 66.102.135.150

But when starting Run ASP.NET Page I get error message on the browser

Please help me how to fix this problem

I think the problem in the SqlConnection please give how to write connection string manually.
Someone tolled me might be the problem it the web.config. If that true please give how to change web.config probably
Nov 18 '05 #1
1 1220
CT
You can change the value of the mode attribute of the customErrors node to
"Off" in the Web.config file, so that you can see the actual error message
in a remote browser as well as locally.

--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Mazyad" <Ma********@hot mail.com> wrote in message
news:2A******** *************** ***********@mic rosoft.com...
Dear Microsoft Developers Support ASP.NET Team

I have SQL DB has been created in web hosting support SQL server & ASP.NET and I develop on localhost web Application using ASP.NET.
After created SQL DB on web hosting I get this information:

* IP Address for the Server for example: 66.102.135.150
* DB name for example: Dynamo
* DB username for example: user1
* DB password for example: password

I Registered the Server 66.102.135.150 in SQL Enterprise Manager after that I used wizard in ASP.NET to create SqlConnection with Sql DB that
hosted on server 66.102.135.150.
But when starting Run ASP.NET Page I get error message on the browser.

Please help me how to fix this problem.

I think the problem in the SqlConnection please give how to write connection string manually. Someone tolled me might be the problem it the web.config. If that true please give how to change web.config probably.

Nov 18 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1679
by: Jo Davis | last post by:
I'd like to do this: Have a SQL Server database hosted on a public facing web server. I want it to be held at an ISP/Web hosting company. Though I have ADSL here I don't want to manage a server. I want some ASP pages accessing the database. I would also like for a very small number (probably 2) of users to access
4
5616
by: GAVO-UK | last post by:
Hello everyone. Using Access 2003 and MSDE I just started experimenting using Access as the front end for SQL using *.adp, and would like to connect the front end to the back end remotely, purely through the internet to a remote computer, hosting the SQL Server (MSDE), but the problem is that I don't know where to start, the only thing I do know is that I have to create a connection string using ADO - OLE DB, something like this
12
3461
by: Charlie | last post by:
Hi: My host will not allow me use a trusted connection or make registry setting, so I'm stuck trying find a way to hide connection string which will be stored in web.config file. If I encrypt string externally, can it be used in it's encrypted form to connect to SQL Server? If I decrypt back to string for use in connection string during runtime, I have to supply a key. If I do that, hacker could use key to break encryption. How do I...
18
2634
by: WStoreyII | last post by:
I am making a asp page that will run on my computer by iis. But the problem is the database in on a web server. I can not seem to get the connection to work for it though here his the connection and the error. Any help please. Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://n.1asphost.com/WStoreyII/PIMP.mdb" Error: Microsoft JET Database Engine (0x80004005) Not a valid file name. /Default.asp, line 40
4
4144
by: Nathaniel Sherman | last post by:
Alright, folks, here's the deal... I'm working on migrating a classic ASP website to an ASP.NET codebase. At the heart of the site is a MySQL database. To make sure an "in-process" program doesn't screw up the live site, I run a local IIS webserver on my XP Pro (AMD XP 2500+, 512MB DDR RAM) machine, which resides behind an XP ICS gateway on my LAN. I also have a MySQL server set up locally for development purposes.
6
1500
by: Mike L. | last post by:
Hi, Pls, beware that I'm new to this :) I've developed several web appl, either with ASP or ASP.NET. All using SQL server as the back end. In my development environment, I have a single server running Win2K, which serves as Web Server and SQL server as well. And, since my hosting (production server) using the same config; ie: using a single server to serve both web server and SQL server; it's always been easy
13
2838
by: Jennifer.Berube | last post by:
well I'm not sure how to go about making my SQL connection string... The code below is what I need to replace with my SQL connection...I just don't know if that code is for DSN or access... I don't want to use DSN just a connection string...help? function GetConnection() const DSN = "membershipdb" const UID = "webuser"
3
4044
by: danielmcinerney | last post by:
i am trying to set up internet connection sharing between a vista machine (host) and an XP machine (client). i have followed guidelines from various pages on the internet but i still cannot get it working. here is what ive done i gave up on using dhcp addressing between the host and client as this wasnt working so i tried using static ip's instead. the host and the server are connected by a wired connection (through a switch). the host is...
1
2259
by: =?Utf-8?B?QiBTaW5naA==?= | last post by:
Hi Scenario 1) Host - XP Laptop with internet connection using Sky Broadband Wireless Router Netgear DG834GT 2) MS Virtual Server 2005 - I have deployed an XP MS Virtual Server 2005 to act as a virtual machine
0
8423
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,...
0
8948
Oralloy
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...
0
8701
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7481
agi2029
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...
1
6261
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4246
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...
0
4446
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2097
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1842
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.