Database Discussion - accessing SQL help

Print Page | Close Window

accessing SQL help

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=8313
Printed Date: 30 March 2026 at 7:27am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: accessing SQL help

Posted By: llbarnes
Subject: accessing SQL help
Date Posted: 24 December 2003 at 10:47am

Hi guys and gals. I know this is cheating, but I am straight hardware and management so this coding is kinda crazy stuff for me. Can anyone give me a real quick asp script that will connect to a SQL server and show me two variables?

Server name - star01
database name - star
tablename - tPer_Person
login - sa
pass - "nothign"
Field#1 - FirstName
Field#2 - SocialSecurityNum

Thanks in advance

Replies:

Posted By: Bunce
Date Posted: 28 December 2003 at 11:11pm

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer - http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Pro viders.htm#OLEDBProviderForSQLServer

http://www.w3schools.com/sql/sql_select.asp - http://www.w3schools.com/sql/sql_select.asp

-------------
There have been many, many posts made throughout the world...
This was one of them.