Ultradev example tutorial: 2.4 UltraDev and the join code of all sorts of databases

The 2nd chapter: Install a database

The 4th: UltraDev and the join code of all sorts of databases

When we use Ultradev, can choose to use a variety of databases, our for instance commonly used Access database, Sql database, mysql is waited a moment. Ultradev is in with all sorts of database connective moment, needs database joins code is different. In him computer, can use DSN, decide join character oneself; On database server, can use DSN, decide join character oneself or be Server.Mappath; Friends are in begin to learn when, easy and promiscuous. In this series teaching material, I am listed here a few come out, as reference.

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

ODBC DSNLess Connection

(do not need DSN to join)


Join of MS Access ODBC DSNless


Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\Somepath\dbname.mdb;Uid=Admin;Pwd=pass;

Join of DBase ODBC DSNless


Driver={Microsoft DBASE Driver (*.dbf)};DriverID=277;Dbq=c:\Somepath\dbname.dbf;

　


Join of Oracle ODBC DSNless


Driver={Microsoft ODBC For Oracle};Server=OracleServer.world;Uid=admin;Pwd=pass;

　


Join of MS SQL Server DSNless


Driver={SQL Server};Server=servername;Database=dbname;Uid=sa;Pwd=pass;

　


Join of MS Text Driver DSNless


Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\Somepath\;Extensions=asc, csv, tab, txt;Persist Security Info=False;

　


Join of Visual Foxpro DSNless


Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\Somepath\dbname.dbc;Exclusive=No;

　


MySQL DSNless join

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

　


Above just was listed a few when using Asp, with the commonly used ADO connective code of the database that arrive. Want to noti ce nevertheless, in deciding join code dialog box oneself, every join code can be group only, cannot have group additionally, admit not to come out otherwise. If appear the circumstance of line feed, you get oneself to start work, them join rises.