Description
You can MS Access 2000 database to store your data in the server. The database has to be uploaded in httpdocs folder. This alone will not suffice as rights has to be given for " writing" data to the database.The following procedure will provide you with the connection strings.
Required Information
Your website's hosting control panel user name and password.
Procedure
Connection Strings:
MS Access 2000:
<%
Dim Conn
Set Conn = Server.CreateObject ("ADODB.Connection")
strProvider = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb")
Conn.Open strProvider
%>
MS SQL 2000:
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={SQL Server};Server=ServerIP;Database=databasename;UID=username;PWD=password;"
%>
Database Coding Samples:
We offer the following codes on free basis. We do not offer any support and are not liable for any issues that may arise due to the use of such codes.
[1] You can download coding from https://wpshub.com/downloads/persits.txt
[ ! Notes ]
Database name should be tough to guess for security reasons.
Avoid using lengthy database names.
Make sure you upload database in "httpdocs" folder.
You might not be able to access your database if your connectivity is slower.
If your account is suspended due to excess bandwidth usage or server usage, your access will be suspended.
