connecting to web database from desktop application.

I am thinking of using my web database as the database to use for my program, though not sure how feasible due to connection speeds and having to transfer that info.

what I am using as the connection string is

con.ConnectionString = "Data Source=databse ipadress inserted here; Initial Catalog=databasename here;Integrated Security=True"; with real data obviously inserted into the ip and tables, but when i try and send values there it just hangs and then crashes. I am thinking its not finding the database. Is there something else im to do?

I am using the exact same code as when i use my own machine as the server, and it works great that way, only thing different is the trying to send to the web server.

Verify with your host IF the SQL Server is available outside the firewall -my guess is NOT.

You probably would need to also add the IP port: "Data Source=nnn.nnn.nnn.nnn:1433;..."

Security would be different since I doubt that you are in the same domain -therefore "...;Intetrated Security=True" probably isn't true. You would most likely need a SQL Server login (User/Password).

But first, check with the host to see if it is even worth any more time.

|||

I contacted them and it seems like it should be np. They told me where I need to add in the white space the ipaddress its coming from and did all that.

From looking at another site I got a little code from there, but still is wrong. is this any closer?

con.ConnectionString = "Data Source=69.89.20.44:3306; user=buenavi1_test&password=testing; Initial Catalog=buenavi1_Lottery";

This was simply a test table set up and a test user and password and im sending the data from a program i have used before to this database and not the other database I used, so I know the data is good.

Just always times out on the connection string.

|||

Rick,

First, a reminder to be cautious when posting security information. You should immediately change your username and password -many hackers will be hitting the connection you posted.

I see this error: "user=buenavi1_test&password=testing" should be "user=buenavi1_test;password=testing" (Semi-colon instead of amperstand.)

But more importantly, since you aren't getting any error messages, I suspect that you may not be making a connection.

Have you verified that your firewall is open and allowing outbound traffic?

|||

Thanks for the help, I will review this agin later. Still not going through so I will check firewalls.

Im not needing this as an option was just investigating the feasibility more or less of using it like that.

As far as security, in this point I wasn't too concerned as that database, table, user name and password were all created for no other reason then to test this, they aren't used elsewhere for anything, but I have now deleted all.

Again thanks for the help.