i want to connect to a sql server running on another xp computer. i have made the sql connection, sql data adapter (using Data controls, not connecting manually from code). i can fill the data adapter from the design view by right clicking on the adapter, Fill dataset and i see all the data in tables.

however when i need to fill the dataset at runtime i get a sql error. it seems i must connect from the same domain but i am running xp and i have failed to create domains (this is probably not possible without a 2000/2003 server)

Please help, i need to maintain sql database on a remote pc running XP and all applications access the sql server on the remote pc

please help

i am using a sql login