Ultradev Instance Tutorial: 2.4 Ultradev Connection code with various databases

Tutorials | data | database Chapter II: Setting Up a database

Section Fourth: Ultradev connection code with various databases

When we use Ultradev, we can choose to use a variety of databases, such as our Common Access database, SQL database, MySQL and so on. Ultradev when connecting to various databases, the required database connection code is different. On your computer, you can use DSN, custom connection characters, and on the database server, you can use DSN, custom connection characters, or Server.MapPath; friends are easy to confuse when they are beginners. In this series of textbooks, I am here to enumerate some of them for reference.

---------------------------------------------------------------

ODBC dsnless Connection

(no DSN connection required)


MS Access ODBC dsnless Connection


Driver={microsoft Access Driver (*.mdb)};D Bq=c:\somepath\dbname.mdb; Uid=admin; Pwd=pass;


DBase ODBC dsnless Connection


Driver={microsoft DBASE Driver (*.dbf)};D riverid=277;dbq=c:\somepath\dbname.dbf;

　


Oracle ODBC dsnless Connection


Driver={microsoft ODBC for Oracle}; Server=oracleserver.world; Uid=admin; Pwd=pass;

　


MS SQL Server dsnless Connection


Driver={sql Server}; Server=servername;database=dbname; Uid=sa; Pwd=pass;

　


MS Text Driver dsnless Connection


Driver={microsoft Text Driver (*.txt; *.csv)};D bq=c:\somepath\; Extensions=asc,csv,tab,txt; Persist Security Info=false;

　


Visual Foxpro dsnless Connection


Driver={microsoft Visual FoxPro Driver}; SOURCETYPE=DBC; SOURCEDB=C:\SOMEPATH\DBNAME.DBC; Exclusive=no;

　


MySQL dsnless Connection


Driver={mysql}; database=yourdatabase;uid=username;pwd=password;option=16386;

　


The above is just a list of some common ADO connections to the database used when using ASP. Note, however, that in the Custom Connection Code dialog box, each connection code can only be one row, not another line, or you will not recognize it. If there is a line break, you have to do it yourself and connect them.