Skip site navigation (1) Skip section navigation (2)

Re: Specify port no to connect to Informix Database through ODBC

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Lee <lee_5398(at)yahoo(dot)com>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Specify port no to connect to Informix Database through ODBC
Date: 2003-11-29 17:38:49
Message-ID: 20031129173849.54948.qmail@web20811.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Perhaps you might get some help if you post to an
Informix group/list.  This is a PostgreSQL list.

--- Lee <lee_5398(at)yahoo(dot)com> wrote:
> Hi,
> I'm developing a socket program to connect to
> Informix database
> through the ODBC. In here i called my socket program
> as "tap" . My tap
> will listen for data from unix through port 1070.
> After checking of
> the data, tap will then insert the data to the
> informix database. I
> know we can point the tap to one specified port in
> Informix database
> through the services file. My question is how should
> i know to which
> port my tap program send out to the informix
> database or should i ask
> how should i specify one port to connect to the
> informix and lock that
> port from other process to use it?For current
> moment, my tap will
> randomly pick one port to connect to informix
> database.
> 
> My coding for connect to Informix looks like below;
> // Initialize ODBC variables
> // NOTE : Make sure these variables is intialized
> before used.
> henv = SQL_NULL_HENV;
> hdbc = SQL_NULL_HDBC;
> hstmt = hOrderStmt = hTradeStmt = SQL_NULL_HSTMT;
> 
> SQLAllocEnv(&henv);
> SQLAllocConnect(henv, &hdbc);
> 
> char szRetMsg[500];
> memset(szRetMsg, '\0', sizeof(szRetMsg));
>  
> if
>
(SQLSetConnectOption(hdbc,SQL_TXN_ISOLATION,SQL_TXN_READ_UNCOMMITTED)
> != SQL_SUCCESS) {
>       
>
SQLErrorMessageBox(henv,hdbc,hstmt,"Connect",(LPSTR)&szRetMsg);
>       
>
::MessageBox(NULL,szRetMsg,"Tap32",MB_ICONSTOP|MB_TASKMODAL);
>        PostQuitMessage(0);
>        return FALSE;
> }
> 
> 
> if (SQLConnect(hdbc, szDSN, SQL_NTS, szUserID,
> SQL_NTS, szPassword,
> SQL_NTS) != SQL_SUCCESS)
> {
> 
>
SQLErrorMessageBox(henv,hdbc,hstmt,"Connect",(LPSTR)&szRetMsg);
> 
>
::MessageBox(NULL,szRetMsg,"Tap32",MB_ICONSTOP|MB_TASKMODAL);
>  PostQuitMessage(0);
>  return FALSE;
> }
> 
> I really appreciate if someone can help me out.
> Thank you very much.
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo(at)postgresql(dot)org)


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

In response to

pgsql-odbc by date

Next:From: markDate: 2003-12-02 05:30:49
Subject: odbc and crypt authentication
Previous:From: Jeff EckermannDate: 2003-11-29 17:35:34
Subject: Re: State S0002 (Base table not found)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group