Client Connection Problems
Hello All I have being upgrading the hardware for my development system and have run into problems accessing the database from a client machine. The setup is as follows: 9.21.TC6R1-1, Merant OLE DB 2.1, Windows 2000 Professional. VB6 + SP4, Access 2000 on the "workstation" 2 DELL PowerEdge 600SC servers being run as peer-to-peer (one acting as the "server" and the other as the "workstation"). I have successfully imported my client's schema into my new "server". On the "workstation" I can successfully test the connection via DB Ping, ODBC and Merant's OLE DB. I can also view the data via Access which is using the ODBC connection. However (!), I cannot connect via DBACCESS or the VB program (which uses the Merant OLE DB connection via ADO). The error I get is -25596 "The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry". I have checked the registry and have an entry in SQLHOSTS in both machines for my database server. Also the c:\\winnt\\system32\\drivers\\etc\\services file which has an entry for the service (online). This has been rather frustrating as my original system works fine and I can see no difference except that I have changed the server name. BTW the original system is NT4 Server and Workstation. The new setup does not have W2K server but I do not think that is an issue here. I have been going round in circles now and would value some input. Kind Regards Ian Logan
I've don't know if it is really required but have you run regcopy as the administrator? This seems to clear up problems Ian Logan wrote: > > Hello All > > I have being upgrading the hardware for my development system and have run > into problems accessing the database from a client machine. The setup is as > follows: > 9.21.TC6R1-1, Merant OLE DB 2.1, Windows 2000 Professional. > VB6 + SP4, Access 2000 on the "workstation" > 2 DELL PowerEdge 600SC servers being run as peer-to-peer (one acting as the > "server" and the other as the "workstation"). > > I have successfully imported my client's schema into my new "server". > On the "workstation" I can successfully test the connection via DB Ping, > ODBC and Merant's OLE DB. I can also view the data via Access which is using > the ODBC connection. > > However (!), I cannot connect via DBACCESS or the VB program (which uses the > Merant OLE DB connection via ADO). The error I get is -25596 "The > INFORMIXSERVER value is not listed in the sqlhosts file or the Registry". > I have checked the registry and have an entry in SQLHOSTS in both machines > for my database server. Also the c:\\winnt\\system32\\drivers\\etc\\services file > which has an entry for the service (online). > > This has been rather frustrating as my original system works fine and I can > see no difference except that I have changed the server name. BTW the > original system is NT4 Server and Workstation. The new setup does not have > W2K server but I do not think that is an issue here. I have been going round > in circles now and would value some input. > > Kind Regards > Ian Logan -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #
Paul I've run regcopy on both machines but it did not help. regcopy was not on the "server" so I copied over and then ran it. Ian L > I've don't know if it is really required but have you run regcopy > as the administrator? This seems to clear up problems > > Ian Logan wrote: > > > > Hello All > > > > I have being upgrading the hardware for my development system and have run > > into problems accessing the database from a client machine. The setup is as > > follows: > > 9.21.TC6R1-1, Merant OLE DB 2.1, Windows 2000 Professional. > > VB6 + SP4, Access 2000 on the "workstation" > > 2 DELL PowerEdge 600SC servers being run as peer-to-peer (one acting as the > > "server" and the other as the "workstation"). > > > > I have successfully imported my client's schema into my new "server". > > On the "workstation" I can successfully test the connection via DB Ping, > > ODBC and Merant's OLE DB. I can also view the data via Access which is using > > the ODBC connection. > > > > However (!), I cannot connect via DBACCESS or the VB program (which uses the > > Merant OLE DB connection via ADO). The error I get is -25596 "The > > INFORMIXSERVER value is not listed in the sqlhosts file or the Registry". > > I have checked the registry and have an entry in SQLHOSTS in both machines > > for my database server. Also the c:\\winnt\\system32\\drivers\\etc\\services file > > which has an entry for the service (online). > > > > This has been rather frustrating as my original system works fine and I can > > see no difference except that I have changed the server name. BTW the > > original system is NT4 Server and Workstation. The new setup does not have > > W2K server but I do not think that is an issue here. I have been going round > > in circles now and would value some input. > > > > Kind Regards > > Ian Logan > > -- > Paul Watson # > Oninit Ltd # Growing old is mandatory > Tel: +44 1436 672201 # Growing up is optional > Fax: +44 1436 678693 # > Mob: +44 7818 003457 # > www.oninit.com #