Re: need SQL protocol help
--0__=08BBE4E2DF9965A28f9e8a93df938690918c08BBE4E2DF9965A2 Content-type: multipart/alternative; Boundary="1__=08BBE4E2DF9965A28f9e8a93df938690918c08BBE4E2DF9965A2" --1__=08BBE4E2DF9965A28f9e8a93df938690918c08BBE4E2DF9965A2 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__=08BBE4E2DF9965A28f9e8a93df938690918c08BBE4E2DF9965A2 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