OdbcConnection Class

The OdbcConnection class establishes a database connection using ODBC (Open Database Connectivity).

Syntax

class OdbcConnection extends Connection

Run On

Client

Methods

  Method Description
Gg922613.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg922613.pubmethod(en-us,AX.60).gif createStatement Creates a Statement object that is used to execute an SQL statement. (Inherited from Connection.)
Gg922613.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from Object.)
Gg922613.pubmethod(en-us,AX.60).gif finalize (Inherited from Connection.)
Gg922613.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
Gg922613.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
Gg922613.pubmethod(en-us,AX.60).gif new Establishes a connection to a data source based on the login properties (username, password, and so on.) (Overrides the new Method.)
Gg922613.pubmethod(en-us,AX.60).gif notify Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
Gg922613.pubmethod(en-us,AX.60).gif notifyAll Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
Gg922613.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
Gg922613.pubmethod(en-us,AX.60).gif odbcGetInfoInt Provides an interface to the SQLGetInfo Open Database Connectivity (ODBC) function to retrieve information about the ODBC driver and data source that are associated with a connection. (Inherited from Connection.)
Gg922613.pubmethod(en-us,AX.60).gif odbcGetInfoLong Provides an interface to the SQLGetInfo ODBC function to retrieve information about the ODBC driver and data source that are associated with a connection. (Inherited from Connection.)
Gg922613.pubmethod(en-us,AX.60).gif odbcGetInfoStr Provides an interface to the SQLGetInfo ODBC function to retrieve information, in string format, about the ODBC driver and data source that are associated with a connection. (Inherited from Connection.)
Gg922613.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
Gg922613.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
Gg922613.pubmethod(en-us,AX.60).gif toString Converts the Connection object to a string. (Inherited from Connection.)
Gg922613.pubmethod(en-us,AX.60).gif ttsabort Discards changes that are associated with a transaction and rolls the database back to the original state. (Inherited from Connection.)
Gg922613.pubmethod(en-us,AX.60).gif ttsbegin Begins a transaction. (Inherited from Connection.)
Gg922613.pubmethod(en-us,AX.60).gif ttscommit Commits the changes that are associated with a transaction to the database. (Inherited from Connection.)
Gg922613.pubmethod(en-us,AX.60).gif ttsLevel Returns the number for the last call to the ttsbegin method that is used to begin a transaction. (Inherited from Connection.)
Gg922613.pubmethod(en-us,AX.60).gif ttsNotifyAbort Is called when an exception is thrown. (Inherited from Connection.)
Gg922613.pubmethod(en-us,AX.60).gif ttsNotifyBegin (Inherited from Connection.)
Gg922613.pubmethod(en-us,AX.60).gif ttsNotifyCommit Is called when the ttscommit method is called. (Inherited from Connection.)
Gg922613.pubmethod(en-us,AX.60).gif usageCount Returns the current number of references, that is, the value of the reference counter, that the object has. (Inherited from Object.)
Gg922613.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
Gg922613.pubmethod(en-us,AX.60).gif xml Returns an XML string that represents the current object. (Inherited from Object.)

Top

Remarks

Within the context of an OdbcConnection, SQL statements are executed and results are returned. If a connection to the ODBC data source cannot be established, an exception is thrown and the reason posted in the InfoLog.

In order to work, the proper ODBC drivers must have been installed and configured in the ODBC Manager in the Control Panel.

Inheritance Hierarchy

Object Class
  Connection Class
    OdbcConnection Class

See Also

LoginProperty Class

Connection Class

UserConnection Class