Re: Anybody have luck with Delphi 2.0 C/S to Informix 7.1?
Posted in 1996
Topics: Error Codes & Troubleshooting, Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing
No, you do not need any BDE stuff running it will all get loaded. The name of the test/demo program that Informix ships is ILOGIN.EXE. Try to run this. Try different variations on the information you provide and run setnet prior to this and try to get all of the information including password setup there. The ILOGIN demo is a little flaky. This demo tries to connect to a database called STORES7 which does not always exist. Enter the name of another database on this line. Also make sure that the dll's that Delphi needs to access are present. I think it will prompt you if they are not. If this is still a problem, send me screen captures of your setnet host and server information and your services file. Also the ILOGIN demo will return better error codes. Use the finderr utility that also comes with setnet to try and debug it. This is difficult the first time because everything needs to be just right, but after the first it gets easier. FRDI OUT Andy Seitz wrote: > > Thanks Frank: > > Which test application are you referring to? I have I-Net, but no test app > I know of. > I made the entries in the etc /services on my NT machine, but no luck > still. > What else needs to be running for this whole thing to work? Do I need to > be running some other > background process on the PC? Interbase server? Some type of BDE daemon? > I am missing something here. Any unique or weird entries in the BDE config > that are not obvious? > > I appreciate your comments. > > Andy Seitz > > Frank Dickinson <frdi@gate.net> wrote in article > <32B6272E.296C@gate.net>... > > We use Delphi client server with the native drivers and > > Intersolv's ODBC alot without many problems. It sounds like you > > need to establish basic connectivity first to the server before > > you try to get Delphi or an ODBC driver to work. > > > > In order to get this to work you must setup the NT workstation > > properly: > > 1) Add the service name to the services file located in > > system32/drivers/etc. This tells the workstation what port the > > database server will be listening to on the host machine. > > 2) Setup the Informix connect or I-Net product. > > 3) Run setnet32 to set the host name, service name, and protocol > > for a connection. (Make sure the database is running and > > listening on the right port) I have had problems if I do not set > > the password using the setnet utility, so set a password for the > > connection to use. > > 4) Run the test application that comes with I-Net or Connect, > > that will tell you if you are making a good connection.