:- use_module(library(odbc)).(can be autoloaded)
aliasoption is used. In addition to the options below, options applicable to odbc_set_connection/2 may be provided.
- Define the user-name for the connection. This option must be present if the database uses authorization.
- Provide a password for the connection. Normally used in combination with
- Use AliasName as Connection identifier, making the connection available as a global resource. A good choice is to use the DSN as alias.
- If OpenMode is
once(default if an
aliasis provided), a second call to open the same DSN simply returns the existing connection. If
multiple(default if there is no alias name), a second connection to the same data-source is opened.
true, use Microsoft SQL server 2005 mars mode. This is support for multiple concurrent statements on a connection without requiring the dynamic cursor (which incurs an astounding 20-50x slowdown of query execution!!). MARS is a new feature in SQL2k5 apparently, and only works if you use the native driver. For the non-native driver, specifying that it is enabled will have absolutely no effect.
- Select the version of the ODBC connection. Default is
'3.0'. The other supported value is
The following example connects to the WordNet1An
SQL version of WordNet is available from http://wordnet2sql.infocity.cjb.net/
 database, using
the connection alias
wordnet and opening the connection
open_wordnet :- odbc_connect('WordNet', _, [ user(jan), password(xxx), alias(wordnet), open(once) ]).