remotely getting the users database connection string

Question

hi iam using asp.net 2.0 with c# with sql server2000. when user logins to my website i want to acess the users local database all user having the same database name same tables every thing but but they are not connected in network .so i want to know how to get the data source value in the connection string for that user so that i can acess his local database. can you give example which helps me

Sam Hobbs · Answer

See How to enable remote connections in SQL Server 2005 ; I think that will help. Look for other articles about remote connections. I am not sure that will work but I hope it does.

charan sekhar · Answer

yes every computer is having the data base that are the shops so every shops has their own database with same data base name and same tables

Sam Hobbs · Answer

I think I understand. If I do then you probably need to make remote connections using SQL Server and every user's system must have SQL Server; can your web site require that the user's system has SQL Server? Also remote connections can be a security risk so many systems do not allow remote connections; do you understand that?

Abhimanyu K Vatsa · Answer

hello.... your question is not so clear? please use some codes.