does the webhost have the right version of .NET to run linq...? also on a webhost account the database is properly not on the same machine as the webserver... so the localhost/127.0.0.1 properly will not work...
have you looked in your documentation for the account, they should tell you there what the IP or whatever you need to make a connection string to the DB... what is the webhost you are using...? and you can run the webservice in your browser... to make sure it is running ok...? i am not actually clear on your question really... On 8/27/08, Stephen Price <[EMAIL PROTECTED]> wrote: > > Hey all, > > I was having a problem with my WCF web service talking to the database. I'm > using Linq to SQL, and discovered that it stores the connection strings in > settings in the project. If the string in the web.config is not found then > it falls back to the connection string in the dll. (from settings). That's > where I discovered my string seems to be an old string. Anyway I have gotten > it talking to my webhost's database again (they moved the SQL server and it > stopped working!). > > The problem i'm having now is that on the server i'm trying to deploy my > app to it's got a similar problem, it can't connect to the database. I wrote > a command line app to make calls to the same assembly the webservice uses to > call the database, and it has no problems connecting. > The connection string in the command's config and the string in the > web.config is the same. I've tried changing it from (local) to 127.0.0.1to > the subnet ip address and all seem to fail. I see no hits on the database > using SQL profiler. It has to be a connection string issue but I can't see > it for looking. Any ideas anyone? oh, I've set up my local machine in a > similar manner and it works (using (local)) so putting that up on the server > you'd think it would work. Could be a cross domain thing but the webservice > is working its just the database calls by the webservice are failing. > > thanks! > Stephen > p.s. this was the problem I was trying to solve when I hit the other > problem I posted earlier today. tough day! > > ------------------------------------------------------------------- > OzSilverlight.com - to unsubscribe from this list, send a message back to > the list with 'unsubscribe' as the subject. > Powered by mailenable.com - List managed by www.readify.net -- .net noobieâ„¢ This Framework is not Big Enough for the both of us... ------------------------------------------------------------------- OzSilverlight.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net