Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
filf
Yak Posting Veteran
67 Posts |
 Posted - 2006-01-10 : 08:21:49
|
| I have a client who is looking to provide agents with versions of a parent website. The parent website is managed by a sql server based CMS and the data is regularly updated and edited. What would I have to do to connect remotely to this database so that the agent websites could query and be returned data from the parent website sql server over http.Is this something that can be configured or is it not possible?I imagine it is possible but I also imagine it is not something that the current host is going to be willing to provide on a shared sql server.Any advice on this would be greatly appreciated, I have run some unsuccessful tests:[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.and I have spent a lot of time searching for info on this but so far to no avail? |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-01-10 : 20:44:43
|
| Have you contacted the host to see if they will provide you remote access to the SQL Server? Have you considered a web service to deliver the data to the agent websites?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
|
|
filf
Yak Posting Veteran
67 Posts |
Posted - 2006-01-11 : 05:15:20
|
| HI Thanks for the replies.Enterprise access is already available and I have used it widely over different network connections.Essentially my problem is the running multiple agent websites that feed off a subset of data from a main parent website - this data subset is continually changing and the agent websites are distributed all over the world.I have been in touch with the host.I like the idea of a web service delivering data to the agents as well - I think this is going to be most feasible as my initial tests to connect via an asp page from one host to a sql server on another domain basically just bug out.The more I look at the problem the more I am seeing the issues that could arise - including data security at the end of the parent website. |
|
|
|
filf
Yak Posting Veteran
67 Posts |
Posted - 2006-01-11 : 10:24:34
|
| I have been back to the client to discuss this further and he has re-iterated what he is after - however data security of the parent site is an important issue and the client can only have access to it on a per query basis. We are going to be unable to provide them a published subset of the data.The client actually raised as an example cheap flight websites and travel agents whereby many sites are running from the same backend database.Am I making this harder for myself than it actually is? I am going to investigate web services but it is an area I have not worked in previously so it is a bit of a black hole. |
|
|
|
filf
Yak Posting Veteran
67 Posts |
Posted - 2006-01-11 : 11:41:15
|
| Okay I have disocvered the solution to make this work for agents sites, www.w3schools.com is where I have been since my last post.My site is already on a dot net server but it looks like SOAP and WEB SERVICES are going to poovide the solution to the problem.Kind of scary to quote for technologies I have never used but that is how the cookie crumbles I guess.This answered my question exactly:If the industry published an UDDI standard for flight rate checking and reservation, airlines could register their services into an UDDI directory. Travel agencies could then search the UDDI directory to find the airline's reservation interface. When the interface is found, the travel agency can communicate with the service immediately because it uses a well-defined reservation interface.This is not what I am going to do for our application but it specifies clearly the technologies involved.Thanks for all your help. |
|
|
|
|
|
|
Are cross domain queries to sql server possible?