Relocating Databases on SE for NT so network will see them
Posted in 1995
Topics: Networking & sqlhosts Configuration
We are using Informix SE for NT version 5.01.te1 running on Windows NT version 3.5. We would like to move our database to another drive. We've tried db-export and db-import, as suggested by informix customer support. The export and import processes work as far as relocating the database to another drive, however, when we try to connect to the server with a tcp/ip network type application, the only databases that are visible are those that reside in the informix\\bin directory. We have repeatedly tried to set the dbpath environment variable, however, this appears to have no effect except with db-access for NT which appears to be using only local drive mappings to connect to the database and not tcp/ip network connections. Does anyone out there have any clue as to how to get the sqlexec service, which runs on NT, to recognize a database in another location other than informix bin? Informix customer support has not, so far, been able to tell us how to do this, though they are giving us indications that it is supposed to be possible. Thanks in advance! Evan Martin elm@moscom.com