NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Incorporating SQL Server 7.0/2000 Databases into your ASP Pages
2598
Incorporating SQL Server 7.0/2000 Databases into your ASP Pages
http://www.aspalliance.com/mtgal/sqlserver.asp
SQL Server 7.0 - installed on a server. This can be either a Windows NT 4 or Windows 2000 Server system. For help on seting up SQL Server, click HERE.
Configure SQL Server to use SQL Server and Windows NT authentication:
Open the SQL Server Enterprise Manager.
Right-click on the SQL Server which will be used with your ASP pages.
Click on Properties.
Click on the Security tab.
In the Authentication: section, click on SQL Server and Windows NT.
Click on the OK button to finish.
Internet Information Server 4.0 (IIS4) - installed on a Windows NT 4 Server.
ADO 2.0 (or later) - installed on the same server as the IIS4 computer. ADO comes as part of Microsoft's MDAC components ASP > Tips and Tutorials > Database-related Oct 10, 2006
Configure SQL Server to use SQL Server and Windows NT authentication:
Open the SQL Server Enterprise Manager.
Right-click on the SQL Server which will be used with your ASP pages.
Click on Properties.
Click on the Security tab.
In the Authentication: section, click on SQL Server and Windows NT.
Click on the OK button to finish.
Internet Information Server 4.0 (IIS4) - installed on a Windows NT 4 Server.
ADO 2.0 (or later) - installed on the same server as the IIS4 computer. ADO comes as part of Microsoft's MDAC components ASP > Tips and Tutorials > Database-related Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Incorporating SQL Server 7.0/2000 Databases into your ASP Pages: |
|||
Other links at ASP > Tips and Tutorials > Database-related
If you have an SQL database set up with your web host, a useful tip to know is how to connect to your SQL database via Enterprise Manager. The advantage of knowing
Category:
Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data.
Category:
Filter method is very useful working with large datasets. You might need to put only some records from your database but you should select all data from database. Fileter method is advantage working on recordsets after querying on SQL command.
Let's see what's going on a fresh example
Let's see what's going on a fresh example
Category:
When you're querying a Db typically you're looking for an exact match (=), less than (<), greater than (>), less than or equal to (<=), greater than or equal to (=>), or not equal to (< >). Which give you quite a number of ways that you can display your data, but with these operators a partial match is not allowed. In order to facilitate a partial match the like operator must be used and it's entirely up to you how that match is made. The example db contains most of the Titles, AirDates and What Bart Simpson writes in the blackboard at the beginning of The Simpson's (TM).
Category:
Database programming is like a confused little monkey. Puddlin? on the floor and screaming at the walls, it?s a tedious little thing that?s prone to memory leaks and lots of errors and mistakes. To the dismay of anyone hoping to avoid a headache, database programming is ridiculously redundant and incredibly boring. Because web development loves its little monkey sooooo much, it?s unfortunately here to stay.
Category:
Main Category
194
2041
824
286
175
1802
1238
913
1163
7489
70
909
59
2222
174
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19539
Categories: 1275
Registered Users: 750
Mailing List Subscribers: 2046
Unique Outgoing Hits: 228075
Pagerank Statistics
PHP News