Icon ODBC Interface - Function Reference

open()

Description: establishes an ODBC connection using the specified DSN, user and password.
Returns the associated ODBC file.

Syntax: open(dsn,"o", user, password)

Parameters:

dsn: data source name (in ODBC Manager)
mode: ODBC mode ("o")
user: database user
password: user password

Code Example

procedure main()
  # open DSN "mydb" defined in ODBC Data Sources (see Windows 9x Control Panel folder)
  # using username "federico" and password "mypassword"

  db:=open("mydb","o","federico","mypassword")
  
  # 
  # program body
  #

  close(db) # close table and disconnect
end