1. What databases can I use?
If you have an NT setup you may use Microsoft Access,
SQLserver 7.0 . And if you have a Linux Setup you may use
MySQL. IBN provides with the most suitable database as per
your requirements.
2. How do I set up an Access Data Source Name
(DSN)?
This service is given only to the resellers of
IBN who are given a control panel in which you have to properly
place your database in the directory.
3. Now that I have a DSN, how do I connect to it?
To connect using a System DSN, you will have to
place the coding given below in your ASP pages with the
details of your database.
Dim MyConn ' Connection Name
Dim RS ' Recordset Variable
Dim SQL ' Variable for SQL statement
Set MyConn = Server.CreateObject ("ADODB.Connection")
Set RS = Server.CreateObject ("ADODB.Recordset")
MyConn.Open "DSN=DSNName; UID=UserID; PWD=Password;"
SQL="Select fieldname1, fieldname2 From tablename"
' Execute the SQL statement and get Data in Recordset
Set RS = MyConn.Execute (SQL)
%>
4 . Can I use a DSN-less connection?
Yes, a DSN-less connection can also be used.
5. Do I replace or update my database?
It is better to update your database.
6. Can I use a SQL Server databases?
Yes, you can use a SQL Server database.
7. How do I connect to the SQL Server?
You can make a DSN for your SQL database and connect
through it.
