How to open database files with the DB Extension: two ways to open a DB database

Two Types DB Database Opening Method

Currently, the databases used by various table-level management systems are common types, suchAccessDatabase (extension:MDB),XbaseClass database (extension:DBF), But the two extensions are the same.DBDatabases belong to two companies. One is an old-fashioned desktop database.Paradox, This isBorlandThe company's products are widely used in the eraDoSBut it is still usefulDelphi,C ++ BuilderProducts developed by tools such,MicrosoftDesktop Data EngineJetIts support is also complete; the other isSybaseOfASADatabaseAdaptive Server AnywhereThis database was previously calledSQL AnywhereThis database can be used not only at the desktop level, but also at the server level. Because it supports stored procedures, triggers, and so on, it is generally usedPowerBuilderIt is common to develop products because, after all, they are products of the same company. Both databases can pass throughADOIt is introduced in the popular link strings on the Internet, but it fails after repeated tests. After several explorations, the link string is finally found. The introduction is as follows:

The link string of paradox:

Conn. connectionstring = "provider = Microsoft. Jet. oledb.4.0 ;"_

& "Data Source =" & database file storage directory_

& "; Jet oledb: Engine type = 82 ;"

Used hereJetThe link string provided by the engine. There are two points to note: one isJet oledb: Engine type = 82, This isJetThe engine isParadoxThe driver type number provided by the database. The second isData SourceThe value is the path where the database file is stored, not the data file itself. It is also important to installBDE(Borland Data Engine.

Connection string of ASA:

Conn. connectionstring = "driver = {Adaptive Server Anywhere 8.0}; databasefile = full path name of database files; Uid = DBA; Pwd = SQL"

This is also required in the installationASAIn8.0Indicates the database version.ODBCManager to see if there is a version of that type. You can change it to the corresponding version.Uid = DBA; Pwd = SQLThis is the super user name and password for this type of database. This is the default password. If you have changed the password, you have to think about other methods.

There are also some extensionsDBMost of the database files are other types of databases that change the extension. For exampleDBFOrMDBExtensionDBWait. Let's determine which database it belongs.