Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

odbc_connect(3) [php man page]

ODBC_CONNECT(3) 							 1							   ODBC_CONNECT(3)

odbc_connect - Connect to a datasource

SYNOPSIS
resource odbc_connect (string $dsn, string $user, string $password, [int $cursor_type]) DESCRIPTION
The connection id returned by this functions is needed by other ODBC functions. You can have multiple connections open at once as long as they either use different db or different credentials. With some ODBC drivers, executing a complex stored procedure may fail with an error similar to: "Cannot open a cursor on a stored proce- dure that has anything other than a single select statement in it". Using SQL_CUR_USE_ODBC may avoid that error. Also, some drivers don't support the optional row_number parameter in odbc_fetch_row(3). SQL_CUR_USE_ODBC might help in that case, too. PARAMETERS
o $dsn - The database source name for the connection. Alternatively, a DSN-less connection string can be used. o $user - The username. o $password - The password. o $cursor_type - This sets the type of cursor to be used for this connection. This parameter is not normally needed, but can be useful for work- ing around problems with some ODBC drivers. The following constants are defined for cursortype: o SQL_CUR_USE_IF_NEEDED o SQL_CUR_USE_ODBC o SQL_CUR_USE_DRIVER RETURN VALUES
Returns an ODBC connection or ( FALSE) on error. EXAMPLES
Example #1 DSN-less connections <?php // Microsoft SQL Server using the SQL Native Client 10.0 ODBC Driver - allows connection to SQL 7, 2000, 2005 and 2008 $connection = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server;Database=$database;", $user, $password); // Microsoft Access $connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdbFilename", $user, $password); // Microsoft Excel $excelFile = realpath('C:/ExcelData.xls'); $excelDir = dirname($excelFile); $connection = odbc_connect("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=$excelFile;DefaultDir=$excelDir" , '', ''); ?> SEE ALSO
For persistent connections: odbc_pconnect(3). PHP Documentation Group ODBC_CONNECT(3)

Check Out this Related Man Page

iodbctest(1)						       iODBC Driver Manager						      iodbctest(1)

NAME
iodbctest, iodbctestw - iODBC Demonstration programs SYNOPSIS
iodbctest ["DSN=xxxx[;UID=xxxx][;PWD=xxxx][;OPT=value]"] iodbctestw ["DSN=xxxx[;UID=xxxx][;PWD=xxxx][;OPT=value]"] DESCRIPTION
The iodbctest program and iodbtestw programs are simple ODBC sample programs, showing the strength of the ODBC API to connect to any ODBC enabled database, issue SQL commands and retrieve the query results. The iodbctest program uses the standard ODBC API calls to connect using any DSN, but retrieves all results in ASCII mode. The iodbctestw program uses the ODBC Unicode API calls to connect using any DSN, and retrieves all results in Unicode mode. OPTIONS
The iodbctest program uses the SQLDriverConnect function to make a connection using any available ODBC compliant driver. This allows the user to override any ODBC connect attribute in the DSN string. Connect strings should start with either a DSN=xxx or a DRIVER=xxxx attribute optionally followed by other DSN attributes separated by a semicolon e.g: DSN=ora9;UID=scott;PWD=tiger;DATABASE=ora9u Any attributes required for a proper connection that are not entered in the DSN connect string, must be present in the odbc.ini file. If the connect string is passed as an argument to the iodbctest program, the string should be quoted as most shells use the semicolon as their command separator. If the connect string is entered on the interactive prompt, no quotes should be used. After a successfull connection has been established, the user is prompted for a SQL command to be send to the database. A SQL command can- not span multiple lines. If the SQL command returns one or more result sets, each result set is fetched using character buffers and displayed in a table. Additionally, the iodbctest program understands a few special commands: qualifiers Show a list of qualifiers using the SQLTables catalog call. owners Show a list of owners using the SQLTables catalog call. tables Show a list of tables using the SQLTables catalog call. types Show a list of tables types using the SQLTables catalog call. datatypes Show a list of data types using the SQLGetTypeInfo catalog call. reconnect Perform a disconnect/reconnect with the information saved during the first SQLDriverConnect. quit (or exit) Exit the program and return to the shell. EXAMPLES
Start the iodbctest program and get a list of DSNs before making a connection: $ iodbctest OpenLink ODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): ? DSN | Driver ----------------------------------------------------------------- ora9 | OpenLink Generic ODBC Driver mysql | OpenLink Generic ODBC Driver mysqllite | OpenLink Lite for MySQL myodbc | MyODBC Driver pgsql | OpenLink Generic ODBC Driver tds | OpenLink Generic ODBC Driver Enter ODBC connect string (? shows list): DSN=ora9;PWD=tiger Driver: 05.20.0316 OpenLink Generic ODBC Driver (oplodbc.so) SQL> Connect to an Oracle 9 instance which has been previously setup in the odbc.ini file: $ iodbctest "DSN=ora9;UID=scott;PWD=tiger" iODBC Demonstration program This program shows an interactive SQL processor Driver: 05.20.0316 OpenLink Generic ODBC Driver (oplodbc.so) SQL>select * from emp ID |NAME -----------------+------------------------------------------- 1 |Record 1 2 |Record 2 2 |Record 3 result set 1 returned 3 rows. SQL> quit COPYRIGHT
Copyright (C) 1996-2005 by OpenLink Software AUTHOR
iODBC Administrator <iodbc@openlinksw.com> 3.52.6 3 August 2005 iodbctest(1)
Man Page