My dev machine has SQL Server 2005 on it and that is how I make my DBML file and define the tables in there and then make a WCF Service. When i go to host the WCF service, the server has SQL Server 2000, it finds the connection string fine but not the table im pointing it to. Is there a way to tell through the web.config file which SQL Server i am using at run time?
Thanks
sure, that's what the connection string is for, are you sure you have the right permissions on the server?
The name of the server and database should be in the connection string (in the config file); what does it currently look like? And what is the exact error message.
The exact connection string depends on your setup (for example, is the server a "named instance"?).
The other thing I can think of... are the objects in the right schema? i.e. are they "daniel.sometable" on your machine, but "dbo.sometable" on the server? This matters, since the dbml includes the schema. Fortunately, you can edit the dbml (it is just xml) and use "replace all" (i.e. ctrl+h) to fix this...
