Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Debian - Connect To Informix Database Post 302514062 by badmoon75 on Thursday 14th of April 2011 05:48:23 PM
Old 04-14-2011
Debian - Connect To Informix Database

Can anyone point me toward information on setting up a Debian server ODBC connection to an Informix server? I have a Windows server set up with the Informix drivers in ODBC and I'd like to do the same thing on Debian so that my Rails apps can query the database beneath our call-logging software. My Google searching only came up with really out-dated results. Any help is greatly appreciated. Thanks!
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

how to figure out the size in MB for an informix database

This is the info i have so far. please if you are dead positive can u let me know if i my math/process is correct. Chunks address chk/dbs offset size free bpages flags pathname 5003e1f8 1 1 0 250000 177177 PO- /database/link_cw_p01_rootdbs 5003e494 2 ... (5 Replies)
Discussion started by: Optimus_P
5 Replies

2. UNIX for Dummies Questions & Answers

accessing the informix database

How do I access Informix from unix? It's been about 2 years since I've last used unix and I've forgotten the command. (2 Replies)
Discussion started by: pbouknight
2 Replies

3. Programming

¿how can I connect C to a database?

hi, please, help me i need connect my program in C whit a SybaseIQ 12 database i´m programming in solaris 5 (unix) please, help me, because i don`t know what to do... thanks.. jonathan (0 Replies)
Discussion started by: DebianJ
0 Replies

4. Shell Programming and Scripting

Can i connect from a .sh or .sc to a database?

please, help me-.... i need connect to a database Sybase IQ 12 and I don't know if i can do it using a shell program. if it's posibble, please tell me how... please, help me, because I don't know what to do.... thanks... jonathan (1 Reply)
Discussion started by: DebianJ
1 Replies

5. Programming

How to connect database in TC

Anybody please help me how connect a database file in TC for windows. regards Senthil. K (5 Replies)
Discussion started by: Senthil
5 Replies

6. IP Networking

how you connect to a database

i am working on informix database can any body helps me with coding how to connect to it on solaris (3 Replies)
Discussion started by: ramneek
3 Replies

7. Shell Programming and Scripting

unix command to find the version of Informix database

Hi All Please let me know if there is command to check the version of the informix database installed..? Thanks in advance. Suresh (4 Replies)
Discussion started by: sureshg_sampat
4 Replies

8. Windows & DOS: Issues & Discussions

how to connect to sybase database?

hi, I'd like to connect to a Sybase ASE 12 through a a graphic user interface (GUI) that run on windows and solaris10, because i need to do some querys. The database is running on solaris 10. I'm not an expert using databases, but i know how to use some SQL commands through command line... (3 Replies)
Discussion started by: danin
3 Replies

9. Debian

Connect MySQL databse to debian

Hello, I wont to connect a MySQL database to debian: I have installed libmyodbc package and after i have configured /etc/odbcinst.ini: Description = MySQL driver Driver = /usr/lib/odbc/libmyodbc.so Setup = /usr/lib/odbc/libodbcmyS.so and /etc/odbc.ini : Description =... (0 Replies)
Discussion started by: linux31
0 Replies

10. IP Networking

Unable to connect to localhost in Debian 6?

Hello Everyone, I have unable to run the default server with localhost in my Debian machine. While trying to run Django I get: Error: That IP address can't be assigned-to. error While trying to run galaxy-dist I get this error: socket.error: Cannot assign requested address I can't telnet... (3 Replies)
Discussion started by: sachit adhikari
3 Replies
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)
All times are GMT -4. The time now is 10:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy