Introduction
This article gives complete steps on how to connect to InterBase using an ASP, of which the most popular is Microsoft Internet Information Server (IIS). However, if you are familiar with the basics of connecting to an ODBC data source using an ASP, you probably only need to know a couple things and can probably ignore the rest of this article. So, if you are familiar with the basics of connecting to an ODBC data source using an ASP read on. Otherwise, skip to the Detailed Instructions section..
The Basics
Detailed Instructions
Install ADO. If you have Windows 2000, it comes pre installed. If you don't have it installed, it is included with various Microsoft products and is also included with the Microsoft MDAC which can be downloaded from http://www.microsoft.com/data/
Select Data Sources (ODBC) from Control Panel.
Create a new System DSN. If you have InterBase 6 select the Easysoft IB6 ODBC driver. If you have InterBase 5, select the INTERSOLV InterBase ODBC Driver.
Give the DSN any name of your choosing. Make the database name point to your database using a remote connection string. If the database is on the same CPU as your server, you can use localhost, or the server name. If you are using the Easysoft driver, click Test to make sure what you have entered works.
Next, you'll create a Microsoft Data Link file that uses this ODBC driver. If you have Windows 95/98/NT, you can create a new Microsoft Data Link file from Windows Explorer by select it in the New Menu. Windows 2000 users should read http://community.borland.com/article/0,1410,27138,00.html for how to create a Microsoft Data Link File with Windows 2000. Once you have your Microsoft Data link file created, double click on it. Select the Provider Tab, and select an OLE DB Provider of Microsoft OLE DB Provider for ODBC Drivers.
Click Next. Make the data source name be the one you just created. Enter your user name and Password and check Allow saving password. Finally click Test Connection to make sure what you have done works.
Finally, open your Data Link file in Notepad. It should look as follows:
[oledb]
; Everything after this line is an OLE DB initstring
Provider=MSDASQL.1;Password=masterkey;Persist Security Info=True;User
ID=sysdba;Data Source=ibdsn1
The last line should work as your connect string for your ASP connection.
Examples
Below are various examples of connecting to an InterBase database using an ASP. For a discussion of what each parameter in the connect string means see http://support.microsoft.com/support/kb/articles/q193/3/32.asp
Example 1:
var oConn;
var oRs;
// Create ADO Connection Component to connect with sample database
oConn = Server.CreateObject("ADODB.Connection");
oConn.Open("Provider=MSDASQL.1;Password=masterkey;Persist Security
Info=True;User ID=sysdba;Data Source=ibdsn1");
oRs = oConn.Execute("select * from employee");
All further examples just show the Open line. All the remaining lines are the same:
Example 2:
oConn.Open("Provider=MSDASQL.1;Password=masterkey;User ID=sysdba;Data Source=ibdsn1");
Example 3:
oConn.Open("Provider=MSDASQL;Password=masterkey;User ID=sysdba;Data Source=ibdsn1");
Example 4:
oConn.Open("Provider=MSDASQL;Password=masterkey;User ID=sysdba;Data Source=ibdsn1;db=localhost:c:ibdbsclarify.gdb");
Example 5:
oConn.Open("Provider=MSDASQL;Password=masterkey;User ID=sysdba;Data Source=ibdsn1;initial catalog=localhost:c:ibdbsclarify.gdb");
Example 6:
oConn.Open("Provider=MSDASQL;Password=masterkey;User ID=sysdba;Dsn=ibdsn1");
Example 7:
oConn.Open("Provider=MSDASQL;Password=masterkey;UID=sysdba;Dsn=ibdsn1");
Example 8:
oConn.Open("Provider=MSDASQL;Pwd=masterkey;UID=sysdba;Dsn=ibdsn1");
Example 9:
oConn.Open("Driver={Easysoft IB6 ODBC};Pwd=masterkey;Uid=sysdba;server=localhost:;db=localhost:c:ibdbsclarify.gdb");
Example 10:
oConn.Open("Provider=MSDASQL;Pwd=masterkey;Uid=sysdba;Dsn=ibdsn1;database=localhost:c:ibdbsclarify.gdb");
Example 11:
oConn.Open("Provider=MSDASQL;Pwd=masterkey;Uid=sysdba;Dsn=ibdsn1;dbq=localhost:c:ibdbsclarify.gdb");
Example 11:
//If the username and Password are specified in the DSN, you can specify
only the user name
oConn.Open("Provider=MSDASQL;UID=sysdba;Dsn=ibdsn1");
Example 12:
oConn.Open("Driver={Easysoft IB6 ODBC};Pwd=masterkey;Uid=sysdba;database=localhost:c:ibdbsclarify.gdb");
Example 13:
oConn.Open("Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Pwd=masterkey;Uid=sysdba;db=localhost:c:ibdbsclarify.gdb");
Example 14:
oConn.Open("Driver=Easysoft IB6 ODBC;Pwd=masterkey;Uid=sysdba;db=localhost:c:ibdbsclarify.gdb");
Last Modified: 14-MAR-03