Class DBI::DBD::SQLAnywhere::Driver
In: lib/dbd/sqlanywhere/driver.rb
Parent: DBI::BaseDriver

Methods

connect   default_user   disconnect_all   new  

Included Modules

Utility

Public Class methods

Public Instance methods

connect( dbname, user, auth, attr )

The DBNAME string can be specified in the following forms:

"DBI:SQLAnywhere:" "DBI:SQLAnywhere:{ENG}" "DBI:SQLAnywhere:{ENG}:{DBN}" "DBI:SQLAnywhere:{CONNECTION_STRING}" # where CONNECTION_STRING ~= "key1=val1;key2=val2;…"

For the first form, nothing will be added to the connection string. With the second and third forms the driver will add ENG and DBN to the connection string accordingly. The fourth form will pass the supplied connection string through unmolested.

The user and auth can be passed into the function and they will be automatically appended to the connection string. Since Ruby DBI will automatically fill in the username and password with defaults if they are ommited, you should NEVER include a "UID=" or "PWD=" in your connection string or an exception will be thrown.

Examples: 

  Function Call                                              ==> Generated Connection String
  ==============================================================================================
  DBI.connect("DBI:SQLAnywhere:")                            ==>  "uid=dba;pwd=sql"
  DBI.connect("DBI:SQLAnywhere:Demo")                        ==>  "eng=Demo;uid=dba;pwd=sql"
  DBI.connect("DBI:SQLAnywhere:Demo:Test")                   ==>  "eng=Demo;dbn=Test;uid=dba;pwd=sql"
  DBI.connect("DBI:SQLAnywhere:Demo:Test", 'john', 'doe')    ==>  "eng=Demo;dbn=Test;uid=john;pwd=doe"
  DBI.connect("DBI:SQLAnywhere:eng=Demo;dbn=Test")           ==>  "eng=Demo;dbn=Test;uid=dba;pwd=sql"
  DBI.connect("DBI:SQLAnywhere:eng=Demo;dbn=Test;uid=john")  ==>  EXCEPTION! UID cannot be specified in the connection string
  DBI.connect("DBI:SQLAnywhere:CommLinks=tcpip(port=2638)")  ==>  "CommLinks=tcpip(port=2638);uid=dba;pwd=sql"

The attr parameter is ignored.

[Validate]