Never mind. It was my bug!!!!

>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.
>
>

>*First connection
>SQLSTRINGCONNECT("Consolidate database",.f.) && works
>*second connection
>SQLSTRINGCONNECT("Remote database",.f.) && Fails with invalid user error
>
>*First connection
>SQLSTRINGCONNECT("Remote database",.f.) && works
>

>
>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.