We are using C# as front End and Sqlserver 2005 as backend.We are using visual studio 2008.
System.data.sqlclient is the provider for sqlserver in our localhost and our functionality is running correctly.

But we are using bigrock -windows hosting server, where we uploaded our files and we get to know that they are providing OLEDB as provider for sqlserver so we changed the code according to oledb connections.
Inspite of that connection is not working. It is giving Method 500 ERROR.

please help me by giving your solutions

thanks

Icon Web team

When you changed your connection according to oledb, did you try it locally?
Did you double check the username and passwords for the database on the server?
Also, try sending bigrock a ticket and asking them. Sometimes there's something in the settings area that you could change.
Last thing, sometimes people forget to change the connection in the web.config, so double check on that.