ASP access to InterBase database

The information of using ASP to visit InterBase database is very few, after a few days of struggle finally successfully solved this problem. Now we have some code and some information to contribute to you.

<%@ 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 of connected databases in the example above, I am using the InterBase ODBC driver developed by XTG Company. Most of the information on the web, including Borland itself, is driven by Easysoft ( Now Easysoft Company has launched to support the IB7 drive. But I did not succeed in adopting Easysoft.

The following is the address of the Borland solution for accessing the IB database using asp:

Http://community.borland.com/article/0,1410,27152,00.html