Firebird Database Connection

I. Reason

Firebird database is used in v6.0.188.

A student's data may need to be directed from the "super trademanager enhanced edition" to crossing the river. As the USB forwarding cable is supported to open the cash box separately, hyperwang uses the transfer wiring to make a small ticket to open the cash box.

2. The Firebird Database has a bright future and may be used by myself next time.

Iii. Conditions (not all conditions need to be met, but I use the following method to connect)

1. firebirdv2.0.

2. I installed firebird_odbc_2.0.0-win32.exe and set it.

3. The fdclient. dll file in the bin folder of the Firebird Database is renamed to "gds32.dll" in system32 ".

4. source code in VB 6.0

Private sub command1_click () connstr = "driver = Firebird/Interbase (r) driver; uid = sysdba; Pwd = masterkey; dbname = C: \ Documents and Settings \ Administrator \ Desktop \ demo. ydb; "set objcon = new ADODB. connection objcon. connectiontimeout = 60 objcon. commandtimeout = 60 objcon. cursorlocation = 3 objcon. open connstr set rs = objcon. openschema (20) while not Rs. EOF if RS ("table_type") = "table" then debug. print RS ("table_name") rs. movenext wendend sub

Iv. Results

Test passed.

Jiaguoxinzhi for future reference. On November 11, the father-in-law went to addon to buy burn powder.

Reference: Step 2:

ODBC settings in Firebird

Step 1: Install firebird2.0. : Http://www.delphifans.com/SoftView/SoftView_1649.html

Step 2: Install the Firebird ODBC driver.

: Http://www.praktik.km.ua/downloads/Firebird_ODBC_2.0.0-Win32.exe

Step 3: Set Firebird ODBC setup.

First open the control panel in Windows-> management tools. Double-click the data source (ODBC) and select System DNS, as shown in:

Click Add. The following dialog box is displayed:

Select Firebird/Interbase (r) driver and click "finish". The following dialog box is displayed:

 

Set it

◆ DSN is the name of the data source you want (any)

◆ Driver is the default option.

◆ The description field can be left blank

◆ The database is the path in any database you create using Firebird, for example:

C: \ Program Files \ Firebird \ firebird_00005 \ Security. FDB

◆ The customer field is the client. dll file in the bin folder of the Firebird Database that you installed, including IT.

◆ Database accounts and passwords: sysdba and masterkey

◆ The role can be left blank

◆ Use default settings for other fields

Click OK.