Hi,
I am trying to connect to different databases (but only one at the same time..) when I run tests from a CA Gen GUI application.
But after I have select and connect to a server and database initially, I am not provided with the opportunity to change the server or source.
The only thing that may help, is to delete the file iefgdic.ini and start an application - then I am (almost always...) provided the opportunity to
select a new ODBC-source . Sometimes a new iefgdic.ini file is created, and sometimes the connection to the correct database is established.
Sometimes when I start an application and there is none existing iefgdic.ini, an incomplete dito is left...
Only containg the following rows:
[MaxDatabases]
Max=100
If that happens, I have to handcraft the iefgdic.ini and restart the application. Sometimes it works.
[MaxDatabases]
Max=100
[ODBC]
DatabaseCount=1
Database1=GENDB
Trancode1=
LoadModule1=
Server1=GENDB
SQLid1=ABC
SQLPassword1=ABC
I also have some problem yo connect to the database if I don't point it out as the default database when I configure the ODBC-source.
That is possible to solve by defining one ODBC-source for each database, but local admin permission is required for that operation.
So any one that knows how to use one ODBC-source from which one could connect to different databases without edit iefgdic.ini each time ?
Or is there any other solutiuons ?
/Tomas Norström