Follow this article: [^] Make sure that the service run at 32 bit runtime if you use JET or ACE OLEDB connections. As they do not work on 64 bit run time.

Check the link http://forums.asp.net/t/946809.aspx[^] Regards Aman Bhullar www.arlivesupport.com[^]

You can keep the connection strings in app.config file under the onnectionstrings section and read it using ConfigurationManager.ConnectionStrings

Rajesh Koriya wrote: But I get Error "Login failed for user(sa)". Obviously the credentials you are attempting to use are incorrect. Verify the username and password. Also, DO NOT use the sa login. only two letters away from being an asset