ASP.NET Quickstart can't connect to database

myleslawrence

I hope this is the correct forum for this because I'm at wits end.
I have a Win 2003 server, SQL server 2000 and the .Net framework sdk
installed.

The ASP.NET VB Quickstart tutorials have web form examples some of which
connect to the database.
They do not work and I get 'server does not exist or access denied' when I
try to run any of the database examples.

If I revert back to asp and write a simple asp program that does an ADODB
connections and select, it works just fine. Anybody help me on this? Is
there an in which these are supposed to be installed?

Nov 19 '05 #1

Subscribe Reply

1222

Patrick.O.Ige

Are you changing the connection string s to suit your server!!!
Or you are using the same one..
If you are using the same one then you deserve the ERROR!
"myleslawre nce" <my***********@ msn.com> wrote in message
news:OQ******** ******@tk2msftn gp13.phx.gbl...

I hope this is the correct forum for this because I'm at wits end.
I have a Win 2003 server, SQL server 2000 and the .Net framework sdk
installed.

The ASP.NET VB Quickstart tutorials have web form examples some of which
connect to the database.
They do not work and I get 'server does not exist or access denied' when I
try to run any of the database examples.

If I revert back to asp and write a simple asp program that does an ADODB
connections and select, it works just fine. Anybody help me on this? Is
there an in which these are supposed to be installed?

Nov 19 '05 #2

myleslawrence

I changed the connect string to suit my server! I Don't deserve the error.
Thanks for the criticism.
"Patrick.O. Ige" <na********@hot mail.com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..

Are you changing the connection string s to suit your server!!!
Or you are using the same one..
If you are using the same one then you deserve the ERROR!
"myleslawre nce" <my***********@ msn.com> wrote in message
news:OQ******** ******@tk2msftn gp13.phx.gbl...
I hope this is the correct forum for this because I'm at wits end.
I have a Win 2003 server, SQL server 2000 and the .Net framework sdk
installed.

The ASP.NET VB Quickstart tutorials have web form examples some of which
connect to the database.
They do not work and I get 'server does not exist or access denied' when
I
try to run any of the database examples.

If I revert back to asp and write a simple asp program that does an ADODB
connections and select, it works just fine. Anybody help me on this? Is
there an in which these are supposed to be installed?

Nov 19 '05 #3

Juan T. Llibre

Hi, Myles.

Do you mean a QuickStart sample connection like this one ?

SqlConnection(" server=(local)\ NetSDK;database =pubs;Trusted_C onnection=yes")

That will work if SQL Server is installed in the same box as ASP.NET.
Is that your case ?

Also, could you post the exact connection string you're using ?

( Replace the username and password, if you're using them,
but leave the server name in )

The answers to these 2 questions would help, too :

1. Are you impersonating the ASP.NET user in web.config ?
2. Which type of authentication is your SQL Server setup for ?
( SQL Server; Integrated Windows; both ? )

We'll be able to help you a bit more if you'll provide that info.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======

"myleslawre nce" <my***********@ msn.com> wrote in message
news:OQ******** ******@tk2msftn gp13.phx.gbl...

I hope this is the correct forum for this because I'm at wits end.
I have a Win 2003 server, SQL server 2000 and the .Net framework sdk installed.

The ASP.NET VB Quickstart tutorials have web form examples some of which connect to the
database.
They do not work and I get 'server does not exist or access denied' when I try to run
any of the database examples.

If I revert back to asp and write a simple asp program that does an ADODB connections
and select, it works just fine. Anybody help me on this? Is there an in which these are
supposed to be installed?

Nov 19 '05 #4

Patrick.O.Ige

myleslawrence i wasn't critisizing you.
Did Juan advice did the trick.
Patrick
"myleslawre nce" <my***********@ msn.com> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..

I changed the connect string to suit my server! I Don't deserve the error.
Thanks for the criticism.
"Patrick.O. Ige" <na********@hot mail.com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..
Are you changing the connection string s to suit your server!!!
Or you are using the same one..
If you are using the same one then you deserve the ERROR!
"myleslawre nce" <my***********@ msn.com> wrote in message
news:OQ******** ******@tk2msftn gp13.phx.gbl...
I hope this is the correct forum for this because I'm at wits end.
I have a Win 2003 server, SQL server 2000 and the .Net framework sdk
installed.

The ASP.NET VB Quickstart tutorials have web form examples some of which connect to the database.
They do not work and I get 'server does not exist or access denied' when I
try to run any of the database examples.

If I revert back to asp and write a simple asp program that does an ADODB connections and select, it works just fine. Anybody help me on this? Is
there an in which these are supposed to be installed?

Nov 19 '05 #5

Similar topics

3506

Can't get ODBC to work with PHP

by: webhead74 | last post by:

Hi, I've worked on this for a couple of days & can't figure out what I'm doing wrong. I'm trying to connect to a remote AS400 database using odbc & php. Here's my environment: Server: RedHat ES 2.1 IBM HTTP Server (was pre-built by IBM): Server version: IBM_HTTP_Server/2.0.47.1 Apache/2.0.47

PHP

4141

cannot connect to mySQL database using an applet

by: Jeff Sandler | last post by:

I have a database I created in mySQL. I've been entering data every day into the database using a Java application that I wrote. The database and the Java program are on the same Win 98 SE machine. I've been working on another program (an applet) to send and receive data over the internet. I got the applet to connect with the database and receive data. All the while I was developing the applet, I would tell it to find the database at...

MySQL Database

2187

help: how to config to use dotnet's quickstart?

by: Damon | last post by:

I installed a .NET on my windowsXP pro. And, I ran "C:\Program Files\Microsoft Visual Studio ..NET\FrameworkSDK\Samples\Setup\ConfigSamples.exe" and got same virtual directories. when I use this URL-http://localhost/quickstart to use Quickstart, the webpage could not display.IE always asks me to download "default.aspx". So, how to config IIS or something else to use Quickstart correctly?

.NET Framework

923

Quickstart connection problem

by: myleslawrence | last post by:

I hope this is the correct forum for this because I'm at wits end. I have a Win 2003 server, SQL server 2000 and the .Net framework sdk installed. The ASP.NET VB Quickstart tutorials have web form examples some of which connect to the database. They do not work and I get 'server does not exist or access denied' when I try to run any of the database examples. If I revert back to asp and write a simple asp program that does an ADODB

.NET Framework

1337

IIS configuration problems with quickstart samples

by: Abhishek Srivastava | last post by:

Hello All, I have installed the quick start samples that come along with .net sdk. I am facing some strange behavior on my machine. I would be gratefull if someone could explain what is going on. If I type http://15.76.221.178/quickstart in my browser I get an error message you are not authorized to view this page. If I type http://localhost/quickstart. by browser automatically goes to

ASP.NET

1542

Quickstart Problem

by: Eustice Scrubb | last post by:

I'm trying to use the Insert.aspx Quickstart and I'm getting a NULL pointer exception. Any help? <code> <script language="VB" runat="server"> Dim myConnection As SqlConnection Sub Page_Load(Src As Object, e As EventArgs) ' Create a connection to the SQL Server myConnection = New SqlConnection("Data Source=SERVER;" _

ASP.NET

1166

Ent Lib DAAB 2.0 Quickstart

by: moondaddy | last post by:

I'm checking out the Ent Lib for the first time and tried to run the Quickstart for data access. upon clicking the first button in the sample app I get an error saying there may be an error trying to connect to sql server 2005.... Is this really expecting sql server 2005? or is this just the way the msg was keyed in? I'm running sql server 2000 which is where the entlib quickstart db is installed. Also, is there a more appropriate...

.NET Framework

3769

php script can't connect to local mysql, what the heck?

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...

MySQL Database

9796

how to use db2 connect server as a gateway to connect to mainframe db2 database

by: jeffhan | last post by:

we have os/400 db2 database at the backend. i installed db2 v9 connect server on one windows server which is locating the same network with database server. now how to i configure the connect server and client, so client could access the database through the connect server? like that: db2client <--db2 connect server <--db2 mainframe database

DB2 Database

9645

What is ONU?

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...

General

9480

Changing the language in Windows 10

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,...

Windows Server

10091

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9950

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

8972

AI Job Threat for Devs

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...

Career Advice

5511

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4050

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3645

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2879

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General