Re: Specify port no to connect to Informix Database through ODBC - Mailing list pgsql-odbc

From Jeff Eckermann
Subject Re: Specify port no to connect to Informix Database through ODBC
Date
Msg-id 20031129173849.54948.qmail@web20811.mail.yahoo.com
Whole thread Raw
In response to Specify port no to connect to Informix Database through ODBC  (lee_5398@yahoo.com (Lee))
List pgsql-odbc
Perhaps you might get some help if you post to an
Informix group/list.  This is a PostgreSQL list.

--- Lee <lee_5398@yahoo.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@postgresql.org)


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

pgsql-odbc by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: State S0002 (Base table not found)
Next
From: "Gunnar Groetschel"
Date:
Subject: PLEASE: I really need german characters