Re: vb5 app needs informix data

First check that you can Ping the unix box from the client and make sure SetNet is configured properly. What error messages or other symptoms are you getting? Mark Capaldi markcapaldi at csi dot com Remove anti-spam measures if replying On Mon, 1 Mar 1999 22:15:49 -0500, "Stafford" <jrstafford@accs.net> wrote: >I'm trying to load Informix 7.0 data into my VB5 application using ODBC. >The informix is running on a unix box, while my app is a win95. I'm >guessing at most everything, and looking at one other app that is similar. >It appears to be using tcp/ip as the protocol. I think I'm getting close, >but I'm still getting a very vague ODBC connection error. First of all, >what should the VB code look like? The current code is: > > Dim db As Database > Dim rs As Recordset > Dim SQL As String > > SQL = "Select * From STRINVCE" ' Where INV_NO = " & SableNum > Set db = OpenDatabase("Export1", dbDriverNoPrompt, >False,"ODBC;DSN=Export1") > Set rs = db.OpenRecordset(SQL, dbOpenDynaset) > >Is there any reason why this would not work? > >Besides the code, what other setup issues need to be addressed in order to >retrieve informix data from a unix box? I've been using vb for a while, but >never had to access informix data on a unix box. Any help would be very >much appreciated. > >Thanks, >Jeff >stafforj@bestaccess.com > >