Database Discussion - ASP and SQL Server 2000

Print Page | Close Window

ASP and SQL Server 2000

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=5901
Printed Date: 30 March 2026 at 3:35pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ASP and SQL Server 2000

Posted By: pmormr
Subject: ASP and SQL Server 2000
Date Posted: 22 September 2003 at 7:51pm

Does anyone know of any "getting started with SQL Server and ASP" articles? I recently installed SQL Server and i am clueless as how to get started using it with ASP.

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Replies:

Posted By: michael
Date Posted: 23 September 2003 at 9:55am

There are tons of articles, basically it's the same (in the beginning) then with access, just the connection string is different. do a search on aspin.com, there are tons of tutorials.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: pmormr
Date Posted: 23 September 2003 at 2:28pm

just a small problem, i found a tutorial, but when i try to connect it gives me an error. I'm using the following connection string:

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'CONFUCIUS\Compujerk'.

/spanish/go.asp, line 11

and i used this to connect:

   Dim conn
   Set conn = Server.CreateObject("ADODB.Connection")
   strCon = "DRIVER={SQL Server}; SERVER=CONFUCIUS; DATABASE=spanish;"
   conn.open strCon

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Posted By: michael
Date Posted: 23 September 2003 at 2:57pm

You would have to have the user Compujerk as a Trusted Logon in SQL. Otherwise try:
strCon = "DRIVER={SQL Server}; SERVER=CONFUCIUS; user=sa password=whateveryourpasswordis DATABASE=spanish;"

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: go4ranking
Date Posted: 12 November 2003 at 9:21am

Hello,

I am also looking for articles /tutorials for "getting started with SQL Server and ASP" .

Baiscally an articles covering basic database operation (addtion , deletion, modification, updation) using ASP +SQL 2000 will defiantely help for building the concept

Regards,

Ajay

Posted By: michael
Date Posted: 12 November 2003 at 3:30pm

Please don't dig out old posts, you should start a new topic for something like that.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker