Hi All,
I have been banging my head against a wall on this one for a while and I am stumped. I have an application that uses Sybase Adaptive Server Anywhere as the database. This application runs in multiple locations with multiple databases that synchronizes the data periodically based on a set of business rules. Sometimes a user needs to get data from database a to database b immediately so I created a program that allows the user to connect to a remote database and tell it to synchronize. The program is working well from my computer. Here is the problem. On another users computer VFP can’t make a connection to the remote database and the error says the user does not exist. The connection string is stored in the database and I am connecting to the same databases from my computer and all works fine. I can connect using other applications to the remote database. I setup a DSN and tested the connection and that worked fine. I tried to connect to the remote database using with VFP using the DSN and it failed. I added the user and password in the DSN so VFP did not have to send that info and it did not make a difference.
It gets even better. On a whim, I changed the main connection string that I use to connect to the main (consolidated) database to point to the remote database and VFP connected just fine. For example.
SQLSTRINGCONNECT("Consolidate database",.f.)
SQLSTRINGCONNECT("Remote database",.f.)
SQLSTRINGCONNECT("Remote database",.f.)
The main difference between my computer and the other user is I don’t have XPsp2 installed. The remote database computer does have XPsp2 installed. The personal firewall is opened up to let communication through for the database application.
Any help would be very appreciated.
Thanks.