remote database accessing
-
I want to connect to a database and retrieve and insert data which is in another server.which means the database is not in our server. it may be in another server globally remote. this is about an asp web application. please reply me as soon as possible dayya
gayan
-
I want to connect to a database and retrieve and insert data which is in another server.which means the database is not in our server. it may be in another server globally remote. this is about an asp web application. please reply me as soon as possible dayya
gayan
One solution of this problem is create a web service and communicating with SOAP.
Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...
-
One solution of this problem is create a web service and communicating with SOAP.
Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...
-
Are yo trying to connect to it from the DB itself? As in from one DB to another that's on a different server? If so then you more appropriately it should be posted in the SQL forums. If you're doing this from C# then, unless its on a different vlan, then you need a web service (definition: Clickety[^]). If its on the same lan (read network) then you need to be more specific in specifying your connection string by specifying the server name or the IP address (more on that here: Clickety 2[^]) Web Services are not .Net specific, so don't blame your lack of understanding on .Net. There are many articles here that explain Web Services and give you examples. Here, I'll do your lazy work for you: (Clickety 3[^]) You also might want to try the ultimate answer tool. I mean this Clickety 4[^] rather than anything else.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook "There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib "Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"
-
Please search for creating web services in .net
Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...
-
I want to connect to a database and retrieve and insert data which is in another server.which means the database is not in our server. it may be in another server globally remote. this is about an asp web application. please reply me as soon as possible dayya
gayan
There are two options of doing that. 1. You can access it via our normal ADO.Net by creating the connection to that server and doing what you want on that server. 2. If your database server is MS SQL Server then you can create what is called a linked server... in this case you have to connect to you own server and fire select and insert queries on the remote server. Hope this helps.. Maharishi
Nothing is Impossible. Even impossible spells "i m possible"