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
Connections And Server Database Permissions
2592
Connections And Server Database Permissions
http://www.powerasp.com/content/hintstips/permissions.asp
This article is an overview of SYSTEM DSN's, DSN-LESS Connections, and any permissions that may need to be set on the server.
This article only applies to using Access Database's.
I have written this article because these issues appear to be a very confusing for people just learning ASP ASP > Tips and Tutorials > Database-related Oct 10, 2006
This article only applies to using Access Database's.
I have written this article because these issues appear to be a very confusing for people just learning ASP ASP > Tips and Tutorials > Database-related Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Connections And Server Database Permissions: |
|||
Other links at ASP > Tips and Tutorials > Database-related
You can use the "Compact and Repair" function in Access from ASP code. The following code is an example of how this can be done. Note that when you decide to "Compact and Repair" your Access database, some autonumbers can be changed. Access makes all autonumbers consecutive.
This code uses one database, but I'm sure the code can easily be changed so that the listbox displays, for example, all the databases in one folder
This code uses one database, but I'm sure the code can easily be changed so that the listbox displays, for example, all the databases in one folder
Category:
Servlets, the Java equivalent of CGI applications, can deliver on many of Java's promises while dodging some of its worst limitations
Category:
The answer is shown below. All I had to do was create an object, and use "expando properties" to fill it with recordsets. The function DBGetNamedRecords takes the name of the recordset and the SQL to fill it.
Category:
In the previous chapter, we looked at the basics of ADO, concerning ourselves mainly with the Recordset object and the manipulation of data. In most of the examples, we obtained data by simply specifying the name of a database table, but as you've seen from the object model, ADO has other objects that allow data to be accessed.
Category:
We have already discussed how to create DSN and show database contents in the ASP page in our tutorial Accessing Database from ASP. Then we moved on to learn how to add records to the database in the tutorial Adding Records to the Database. We will now see how to update the records in the database
Category:
Main Category
191
2035
816
286
175
1802
1218
911
1163
7457
70
902
59
2217
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: 19455
Categories: 1275
Registered Users: 748
Mailing List Subscribers: 2046
Unique Outgoing Hits: 227458
Pagerank Statistics
PHP News