Re: ODBC-> different databases
Posted in 1998
Topics: Connectivity: ODBC / JDBC / .NET, Internationalization & Character Sets
Have a look at ISG Navigator at www.ISGsoft.com ISG Navigator is a multi database and platform environment that provides ADO, OLEDB, ODBC and JDBC to multiple databases as if they were a single virtual data base. I this instance you would use ISG Navigator to point at each of these databases they would than appear to ODBC as if they were a single database allowing SQL statements to access either of both databases in a single session and SQL statement. I believe this would simplify your environment. Regards David A R'diger Papke wrote in message <6vf9hs$mt8$4@news01.btx.dtag.de>... >Hi, >I 've a Problem connecting to different Databases via ODBC (not the same >GLS-Environment) >from one NT-Client. >Because of the different GLS-Environment ( Databases on NT-Servers and >UNIX-Servers) >before accessing to a database(DSN) the UserEnvironment has to be >changed >via SetNet32-Tool or by changing the User-Profile. >1. It's very complicated. >2. It require that the user has permission to change his profile or to >run setnet32. > >Is there any other, shorter, not so complicated way??? > >Can someone give me help, or confirm that there is no other way. > >-Ruediger