RE: ODBC connection parameters

you must be having php manual installed, there is a topic called Unified ODBC Functions. you can refer the same for connecting to odbc databases. you need odbc_connect() to connecto to database, the syntax is: int odbc_connect (string dsn, string user, string password [, int cursor_type]) following functions are available for odbc: odbc_autocommit -- Toggle autocommit behaviour odbc_binmode -- Handling of binary column data odbc_close -- Close an ODBC connection odbc_close_all -- Close all ODBC connections odbc_commit -- Commit an ODBC transaction odbc_connect -- Connect to a datasource odbc_cursor -- Get cursorname odbc_do -- Synonym for odbc_exec() odbc_error -- Get the last error code odbc_errormsg -- Get the last error message odbc_exec -- Prepare and execute a SQL statement odbc_execute -- Execute a prepared statement odbc_fetch_into -- Fetch one result row into array odbc_fetch_row -- Fetch a row odbc_fetch_array -- Fetch a result row as an associative array odbc_next_result -- Checks if multiple results are avaiable odbc_fetch_object -- Fetch a result row as an object odbc_field_name -- Get the columnname odbc_field_num -- Return column number odbc_field_type -- Datatype of a field odbc_field_len -- Get the length (precision) of a field odbc_field_precision -- Synonym for odbc_field_len() odbc_field_scale -- Get the scale of a field odbc_free_result -- Free resources associated with a result odbc_longreadlen -- Handling of LONG columns odbc_num_fields -- Number of columns in a result odbc_pconnect -- Open a persistent database connection odbc_prepare -- Prepares a statement for execution odbc_num_rows -- Number of rows in a result odbc_result -- Get result data odbc_result_all -- Print result as HTML table odbc_rollback -- Rollback a transaction odbc_setoption -- Adjust ODBC settings. Returns FALSE if an error occurs, otherwise TRUE. odbc_tables -- Get the list of table names stored in a specific data source. Returns a result identifier containing the information. odbc_tableprivileges -- Lists tables and the privileges associated with each table odbc_columns -- Lists the column names in specified tables. Returns a result identifier containing the information. odbc_columnprivileges -- Returns a result identifier that can be used to fetch a list of columns and associated privileges odbc_gettypeinfo -- Returns a result identifier containing information about data types supported by the data source. odbc_primarykeys -- Returns a result identifier that can be used to fetch the column names that comprise the primary key for a table odbc_foreignkeys -- Returns a list of foreign keys in the specified table or a list of foreign keys in other tables that refer to the primary key in the specified table odbc_procedures -- Get the list of procedures stored in a specific data source. Returns a result identifier containing the information. odbc_procedurecolumns -- Retrieve information about parameters to procedures odbc_specialcolumns -- Returns either the optimal set of columns that uniquely identifies a row in the table or columns that are automatically updated when any value in the row is updated by a transaction odbc_statistics -- Retrieve statistics about a table regds, -----Original Message----- From: Douglas F. Keim [mailto:keimdf@softek-net.com] Sent: Tuesday, October 08, 2002 21:06 To: php-windows@lists.php.net Subject: ODBC connection parameters I am trying to connect to an ODBC database that is not Access nor MSSQL. I have the ODBC entry done and have tested the connections within the ODBC manager. I noticed that a connection within PHP begins with $Link, but I can't seem to find the values for the rest of the statement. for Mysql it goes something like this -- $Link = mysql_connect. I need to figure out what mysql_connect should be replaced with. The only reference that I found was mssql_odbc. I also know that Mysql and ODBC support is built into PHP, so maybe this is easier that I think. Anyone help me?