How do I open a table in Microsoft SQL Server or MySQL?
The Microsoft SQL Full-ISAM driver (included in dL4 for Windows) and the MySQL Full-ISAM driver use a special filename format, server:database.owner.table. The server and owner fields are optional. The driver also supports "user=" and "pswd=" options to specify the server login and password values. The following are examples of opening tables.
Open #3,"bigsystem:accounting.payroll" As "Microsoft SQL Server Full-ISAM"
Open #3, "(user=fred, pswd=secret)xyz:sales.customer" As "Microsoft SQL Server Full-ISAM"
Open #3,"server:accounting.payroll" As "MySQL Full-ISAM"
- FAQ:
