Hi,
I have a list of databases that resides on remote computers. I have access to computername/servername, IP-address and database names for each database. And what I want to do is to connect to each of these databases and read a value from a specific table. However, I can't seem to figure out what connectionstring to use to tell the SQLbase driver which computer to connect to.
Does anybody have any Idea of how to do this? I'm quite frustrated at the moment of how hard it is to get (what seems to be) such an easy task to work.
I think I could get it to work by adding each database in the ODBC, but I don't like that sollution because there is more than 1k of databases to connect to, and since that list is being updated on a regular basis, I would have to update the ODBC each time the db-list is updated.
Another sollution I've been thinking about is to automatically create DSN files for each Database connection, and then use the dsn file in my connectionstring for each database... That sollution would work for me, IF I only knew what parameters to use. I would like to be able to set the serverpath property (or similar) in the DSN file, but I don't know If this is possible..?
Is there really no good way to pinpoint a servername at a specific IP along with a databasename in the Connectionstring for SQLBase?
The computers I should be connecting to all has the following setting in SQL.ini
...
[dbntsrv.dll]
comdll=sqlws32
...
And I interpret this as if they are using Sockets instead of pipes for client connections
I'm using Delphi 7 along with Gupta Centura SqlBase 7.6.1 and the TADOConnection component...
Start Free Trial
