hi all, we are having database server in different place and application is in running in different place. i want to use same database remotely. can anyone give me an idea how to connect???? what is the procedure to connect.... thanks its very urgent, prompt respose would be highly appreciated. Regards TRA

Depends on what DB platform are you using?

SQL Server 2000

 windows 2003 server.

Still waiting for good suggestion.. thanks

 How about creating a VPN and connecting to your database server through that?

how to do this. can you explain me or send the some coding here.pls. thanks

This is something you would do at an infrastructure level so I would start off by having a read of this:

http://technet.microsoft.com/en-us/library/bb727041.aspx

 

its showing error as below 

We’re sorry! The page you were expecting to see has been removed or is unavailable.

 

please can u give me the correct link. thanks

Sorry about that - I made a mistake when creating the hyperlink. See if this works:

http://technet.microsoft.com/en-us/library/bb727041.aspx

Hi Tim,

Thanks for your prompt response.

I think you misunderstand... what's my requirement is as follows.

1)  I developed .NET desktop application backend as SQL Server 2000

2) SQL database server is located in "xxx" and all the users in "xxx" are using the database through the network. its working nice

3) the same application is installed in 'YYY' location as well, but i want to use same database of 'XXX' for this application in 'YYY'.

How to connect from YYY to XXX through the application to retrieve and push back the datas.

Hope you understand my requirement now.

Kindly help me out. thanks

still waiting for the reply....

still waiting for the reply. pls. can anybody help me

Hm, what does it mean XXX and YYY in concrete? LAN?

 xxx and yyy as a location

eg.

database server is in INDIA and i want to use the same database server from outside the india somewhere like UAE, USA or UK. etc.,

 how to do this..????

i hope now you understand my requirement

Thx, now it is much more readable. Ok. I suppose you use VB.NET OleDbConnection. So, It was not able (server, driver or oledb no matters) to handle connection string with http URI instead of LAN / file path? Also, did you try IP instead web address? If I am misserably out, please navigate me the right way, because I have no idea what you tried.