Re: need SQL protocol help

#1 (**permalink**) 04-19-2008, 09:00 PM

--0__=08BBE4E2DF9965A28f9e8a93df938690918c08BBE4E2DF 9965A2
Content-type: multipart/alternative;
Boundary="1__=08BBE4E2DF9965A28f9e8a93df938690918c 08BBE4E2DF9965A2"

--1__=08BBE4E2DF9965A28f9e8a93df938690918c08BBE4E2DF 9965A2
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable

Patricularly on SCO unix if your machine is on NIS then setlitcp protoc=
ol
won't work, try by taking out from NIS. If your client and server on t=
he
same machine then you can try seipcpip protocol. If you install Inform=
ix
connect alone , you can get ODBC libraries also.

Thanks & Regards
lakshman

=

Tom =

<tsmith@eastpoint =

city.org> =
To
Sent by: informix-list@iiug.org =

owner-informix-li =
cc
st@iiug.org =

Subj=
ect
need SQL protocol help =

04/08/2004 03:46 =

PM =

=

=

Please respond to =

tsmith@eastpointc =

ity.org =

=

=

My server is an SCO Open Server Release 5.0.5, with Informix SE 7.23.
I'm trying to access the data via ODBC, and I'm told that I need some
"extra" software, like Informix Connect. The trouble is that it
doesn't appear to support the protocol that I need (setlitcp). The
only version I can get from IBM's website is 2.8x. I was hoping that
perhaps an earlier version would support the version I need. Anyone
know where I can get/try an earlier version?

I've tried changing the protocol from "setlitcp" to "sesoctcp". THAT
didn't work either. (All I changed was the entries in the sqlhosts
file.) My sqlhosts file has:

pei setlitcp eptsco sqlexec
pei2 setlitcp eptsco sqlexe2

Could I "add" the protocol I need? Is there a way I can tell if it's
available?

Is there anything [else] I want/need on the server side so I can talk
to my db with ODBC drivers for Informix, on my client? It's been so
long, I don't know how to tell, and I have no docs whatsoever.

Any help is much appreciated.

Thanks,

Tom

=

--1__=08BBE4E2DF9965A28f9e8a93df938690918c08BBE4E2DF 9965A2
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

<html><body>
<p>Patricularly on SCO unix if your machine is on NIS then setlitcp pro=
tocol won't work, try by taking out from NIS. If your client and serve=
r on the<br>
same machine then you can try seipcpip protocol. If you install Inform=
ix connect alone , you can get ODBC libraries also.<br>
<br>
<br>
<br>
Thanks & Regards<br>
lakshman<br>
<br>
<br>
<br>
<img src=3D"cid:10__=3D08BBE4E2DF9965A28f9e8a93df938@us .ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for Tom <tsmith@east=
pointcity.org>">Tom <tsmith@eastpointcity.org><br>
<br>
<br>

<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=

<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE4E=
2DF9965A28f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">Tom <tsmith@eastpointcity.org></font></b>=
<font size=3D"2"> </font><br>
<font size=3D"2">Sent by: owner-informix-list@iiug.org</font>
<p><font size=3D"2">04/08/2004 03:46 PM</font>
<table border=3D"1">
<tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"=
center"><font size=3D"2">Please respond to<br>
tsmith@eastpointcity.org</font></div></td></tr>
</table>
</ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=

<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D08BBE4E2DF9965A28f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D08BBE4E2DF9965A28f9e8a93df938@us .ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">informix-list@iiug.org</font></td></tr>

<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D08BBE4E2DF9965A28f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D08BBE4E2DF9965A28f9e8a93df938@us .ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>

<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D08BBE4E2DF9965A28f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D08BBE4E2DF9965A28f9e8a93df938@us .ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">need SQL protocol help</font></td></tr>
</table>

<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D08BBE4E2DF99=
65A28f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE4E2DF9965A28f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>My server is an SCO Open Server Release 5.0.5, with Informix SE 7.2=
3.<br>
I'm trying to access the data via ODBC, and I'm told that I need some<b=
r>
"extra" software, like Informix Connect.  The trouble is=
that it<br>
doesn't appear to support the protocol that I need (setlitcp).  Th=
e<br>
only version I can get from IBM's website is 2.8x.  I was hoping t=
hat<br>
perhaps an earlier version would support the version I need.  Anyo=
ne<br>
know where I can get/try an earlier version?<br>
<br>
I've tried changing the protocol from "setlitcp" to "ses=
octcp".  THAT<br>
didn't work either.  (All I changed was the entries in the sqlhost=
s<br>
file.)  My sqlhosts file has:<br>
<br>
pei     setlitcp eptsco     sqlexec<br>
pei2   setlitcp eptsco     sqlexe2<br>
<br>
Could I "add" the protocol I need?  Is there a way I can=
tell if it's<br>
available?<br>
<br>
Is there anything [else] I want/need on the server side so I can talk<b=
r>
to my db with ODBC drivers for Informix, on my client?  It's been =
so<br>
long, I don't know how to tell, and I have no docs whatsoever.<br>
<br>
Any help is much appreciated.<br>
<br>
Thanks,<br>
<br>
Tom<br>
<br>
<br>
</tt><br>
</body></html>=

--1__=08BBE4E2DF9965A28f9e8a93df938690918c08BBE4E2DF 9965A2--

--0__=08BBE4E2DF9965A28f9e8a93df938690918c08BBE4E2DF 9965A2
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=08BBE4E2DF9965A28f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYX J0U2F2ZXIhAAA7

--0__=08BBE4E2DF9965A28f9e8a93df938690918c08BBE4E2DF 9965A2
Content-type: image/gif;
name="pic26568.gif"
Content-Disposition: inline; filename="pic26568.gif"
Content-ID: <20__=08BBE4E2DF9965A28f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA
AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZe ZgLVA9YVCpnGagVjV171aRVrYR
RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFil KQdI8GA5IcpApeJQt8L09lmgkH
LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d 5VyKtCKW3jfz4uMKmq3xu4N0nK
BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI
TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZl qWmyFy5/6yBBuji0AxFR
M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNU tJOUAVLoUr1+wqDGTE4zk+T6FG
uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO 3mpOaKnL0Z2EKvNMSILEThKhCg
zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXp uFKhSYZALd0O5RKa2z9EYKBbpb
qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NE NQj2jXjmfNgOZDaXb5glRmXQ33
YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4 rwxxINMvpFFAz1KOODHiu+4aEw
NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoC WOOUwgltIwAKRxJgbIkJAQZEq0
2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ 6ChjCAH3QlhJcT6VWE6FCkfCco
CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3 QxhgohNKXJCWv8JQr/PDdaqd6w
2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iIm THEQyqJ4eIxJJoUBc+3CbBuwZE
V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4senwEhYG nKEFJeGrxUZy8dB8gmAXI/sPvH
ESfCwVt5hTgYiqQqtdRNHQIU1PJ33ZqmzgE90OwLaoJcnMop1W iMmgkPHQRIrwgFuNV90A3doNKT
mrKIN07AnGcI9BQjhCBN4RfA1qIZnMqorJCogKfGQnxSCDilTV IA0yl5ciTovgLuBDKFUDE9aQcw
9SA+rjSNf9/M1gxrj6VwDTS0IUSElMzBfsj0NFXR2kwsV1A5IF1grLgLL/r1R40BZEnuBWgmQEyb
jqRwSAt6bqMCOFkvKFN2GPPkUzIm/SCF8z8pVzpbjVnMsy0vOr1hw3SaSRUhpY09v0z0J1FnwzPl
fmh+xl4WtR0zGu24I4KbMQm3lnVu2oNWxI9W/lcyzA+mCKF4DBikxb/+UWtOGRiFP8qEwAayIgIA
Ow==

--0__=08BBE4E2DF9965A28f9e8a93df938690918c08BBE4E2DF 9965A2
Content-type: image/gif;
name="ecblank.gif"
Content-Disposition: inline; filename="ecblank.gif"
Content-ID: <30__=08BBE4E2DF9965A28f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7

--0__=08BBE4E2DF9965A28f9e8a93df938690918c08BBE4E2DF 9965A2--

sending to informix-list

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode