There is very little information on using ASP to access INTERBASE database on the Internet. After several days of struggle, we finally successfully solved this problem. Now I would like to contribute part of the code and some information to everyone.
<%@ language="vbscript"%>
str1 = " Driver={XTG Systems Interbase6 ODBC driver};uid=sysdba;pwd=masterkey;Data Source=ly"
Set conn = Server.CreateObject("ADODB.Connection")
conn.open str1
Set rs = Server.CreateObject("ADODB.Recordset")
sqll="select * from GUNIT"
rs.open sqll,conn,1,3
rs.addnew
rs("id")=18
rs("name")="INTERBASE"
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
In the string connecting to the database in the above example, I used the INTERBASE ODBC driver developed by XTG Company. Most of the information on the Internet, including the technical documents introduced by Borland itself, uses the driver of Easysoft (now Easysoft Company A driver that supports IB7 has been launched). But I have not been successful in using Easysoft.
The following is the address of the solution proposed by BORLAND for using ASP to access the IB database: