What is PhpDig?
PhpDig is a PHP MySQL based
Web Spider & Search Engine.

odbc_connect
Prev	LXIII. ODBC Functions	Next

odbc_connect

Name

odbc_connect — Connects to an ODBC data source.

Synopsis

resource odbc_connect(DSN, user, pass[, cursor]); string DSN: DSN (Data Source Name) string user: User name string pass: Password int cursor (optional): Cursor type

Returns

Connection ID or FALSE on error

Description

Creates a connection to the specified database using an optional username and password. If a username and password are unnecessary, use empty quotes rather than omitting the parameters. The cursor type is optional but useful for dealing with some ODBC where a cursor type is needed - for example, to return the number of rows from a query.

The cursor types are SQL_CUR_USE_IF_NEEDED, SQL_CUR_USE_ODBC, SQL_CUR_USE_DRIVER, and SQL_CUR_DEFAULT.

Version

Existing since version 3.0.6

Example

Example 1329. Connect to database

<?php
$database = "DSN"; 
if (!$db = @odbc_connect($database,"user","pass")) {
   echo "Could not connect to $database!\n"; 
   exit;
}
?>

Prev	Home	Next
odbc_commit	Up	odbc_cursor

PHP Functions Essential Reference. Copyright © 2002 by New Riders Publishing (Authors: Zak Greant, Graeme Merrall, Torben Wilson, Brett Michlitsch). This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later (the latest version is presently available at http://www.opencontent.org/openpub/). The authors of this book have elected not to choose any options under the OPL. This online book was obtained from http://www.fooassociates.com/phpfer/ and is designed to provide information about the PHP programming language, focusing on PHP version 4.0.4 for the most part. The information is provided on an as-is basis, and no warranty or fitness is implied. All persons and entities shall have neither liability nor responsibility to any person or entity with respect to any loss or damage arising from the information contained in this book.