Module Ocamlodbc

module Ocamlodbc: sig .. end

Interface to databases.

exception SQL_Error of string

To report errors.

type sql_column_type =

`\|`	`SQL_unknown`
`\|`	`SQL_char`
`\|`	`SQL_numeric`
`\|`	`SQL_decimal`
`\|`	`SQL_integer`
`\|`	`SQL_smallint`
`\|`	`SQL_float`
`\|`	`SQL_real`
`\|`	`SQL_double`
`\|`	`SQL_varchar`
`\|`	`SQL_date`
`\|`	`SQL_time`
`\|`	`SQL_timestamp`
`\|`	`SQL_longvarchar`
`\|`	`SQL_binary`
`\|`	`SQL_varbinary`
`\|`	`SQL_longvarbinary`
`\|`	`SQL_bigint`
`\|`	`SQL_tinyint`
`\|`	`SQL_bit`

The various SQL types for columns.

module SQL_column: sig .. end

Classic interface

type connection

The type of connections to databases.

val connect : string -> string -> string -> connection

create base user passwd creates a connection to data source base, as user user, with password passwd.
Raises SQL_Error if we could not connect to the database.

val disconnect : connection -> unit

Disconnect from a database. The given connection should not be used after this function was called.
Raises SQL_Error if an error occured while disconnecting.

val execute : connection -> string -> int * string list list

execute c q executes query q through connection c and returns the result as a pair (error_code, recordlist), where a record is a string list. The error_code is 0 if no error occured.

val execute_with_info : connection ->
       string -> int * (string * sql_column_type) list * string list list

Object-oriented interface

class data_base : string -> string -> string -> object .. end