Opening a Table with a Connection String
SQL Drivers
It is possible to open a table with a connection string with or without using an intermediate file. The general way to do this for a SQL Driver is by using the following format:
Open {drivername}:[{schemaname}#]{table}@{connectstring} [|options| [intfile=.int]]
Parameters
- drivername: One of the drivers listed here.
- schemaname: Database schema name.
- table: Table name.
- connectstring: Connection string.
- intfile: Intermediate (INT) file.
Behavior
If used: - The INT file will be used to open the table in conjunction with the connection string. - The DRIVER_NAME, SERVER_NAME, DATABASE_NAME, and SCHEMA_NAME keywords from the INT file will be skipped; those values will be taken from the open string. - Cache (CCH) files will not be used. - Restructuring of the table is not possible.
If omitted: - The table will be opened without an INT file.
Example
This is an example of opening a table using a connection string and an INT file:
Open "MSSQLDRV:ordsys@SERVER=(local);Trusted_Connection=yes;DATABASE=MSSQLOrder180|options|intfile=Ordsys.int" as OrdSys