My Web Service will not connect to my SQL database. Why?

Question

I'd appreciate any suggestions

I have an app which uses a web service to connect to a SQL database. The application reports back an Access Violation message.

This works at some sites, but not at others. I’ve compared every permission, property and setting I can think of between the working sites and the non working ones and all appears to be the same.



My ConnStr is:



data source=SERVERNAME/DATABASE; initial catalog=USER; user=USERNAME; password=PASSWORD



Any help would be appreciated.



Thanks

Answer 1

Well, do you log any exceptions that are being thrown? That usually helps in order to find out what the problem is.

I'll assume you are using Microsoft SQL Server and give you a somewhat generic answering. I'll also assume all your connection parameters are correct.

I recently had a connectivity problem that turned out to be caused by the fact SQL server doesnt have TCP/IP enabled by default. You have to configure your server to allow TCP/IP connections if that is the case.

You could also be using an erroneous connection string.

A firewall could be blocking you (if it's a remote location).

Try logging exceptions so I can give you a more accurate answer.

Answer 2

wager it relies upon on your application. If the utilizing is in elementary words run on the cellular gadget (no information superhighway element) then an entire database is overkill for storing the rankings. you does not opt for an entire database operating on the cellular customer. Now if you're making a web-depending application, then your server ought to really use a database (sq. Server once you've the right license for a web deployment). For the textual content record to hint the rankings, relies upon back on how your recreation style is setup. when you're preserving say the properly 10 rankings, your record ought to easily be a comma delimited record with 10 lines that you replace. date,call,score date,call,score ... ... date,call,score you should study the values once you intend to show the extreme rankings and/or after a recreation completes to ensure if the present recreation beats a extreme score. If the present score beats one, insert on the right area interior the array conserving the study in values and function a bite of code that only outputs the hot extreme score record. although to a textual content record, evaluate an elementary XML record (not confident if the phone SDKs have a tendency to include a parser or not). ** Edit ** @Semper VI - i does not be taken aback if MySQL ran on Android. probably not an suited setup, yet i'm confident someone with slightly loose time and some interest has ported it. ** Edit 2 ** I agree that a database thus isn't mandatory. human beings have performed some quite staggering issues although, only to tutor it will be performed. I did ignore about HSQLDB, which probably must be more advantageous suited if a database replaced into actual needed. i'm wondering what technique Android/iPhone/WinPhone use for storing contact techniques. i comprehend Android syncs up with gmail contacts, yet i'm guessing they cache it interior sight to the phone besides.

Answer 3

You're going to have to be a bit more specific. If the reason you are as vague as you have been is that you don't know, then throw the offending connection code in a try/catch block, throw the inner exception, and then post your error in the details of your question.

If you don't provide detail, nobody can help you.