>Dear Expert,
>My VB6's app is still using ASA 7, it runs on IP 172.16.1.88
>now I want to access the database remotely from another PC
>172.16.1.99, could any body please help how to do this

Hi,

It's pretty easy to do with ASA (any version). I did it a lost in the past. I do not work anymore on databases but I remember the following:
- you should put an instruction such as HOST=172.16.1.88 somewhere on the ASA ODBC configuration panel,
- you do not need to put the calling PC address.

If the calling PC is near the serving machine (networkwise) you may not need to put the IP address anyway. The name of the DB may be enough. ASA may make the connection on its own. If the server and clients are remote, of course setting a command such as HOST=ip-adresss or HOST=dns-address will be necessary.

ASA offers a lot of tuning options. You may find it useful to fine-tune the connection. You can choose the size of the packet, the IP port, timeouts...

Look at the ASA 7 documentation. If you don't have one, download the document of the current version (9 or 10). It's pretty extensive, for free and still valid for what you have to do.

Francois