connecting to online server

Question

Post reply

connecting to online server

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

try using

initial catalog

, instead of

database

:

Data Source=servername;Initial Catalog=dbname;

or try: http://www.connectionstrings.com

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Steve Jones - SSC Editor SSC Guru Points: 739541 More actions · Answer 2

Do you have an error?

I would suggest you grab a template from ConnectionStrings.com, as noted above, and use that.

blackdevil_heart SSC Enthusiast Points: 106 More actions · Answer 3

Thanx Guys. I was actually at connectionstrings.com before coming here. I wasn't just sure which one to use. Still confused.

Steve Jones - SSC Editor SSC Guru Points: 739541 More actions · Answer 4

Use this:

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

That's a basic, standard one for .NET connections with a user/pwd. If you can use trusted connection, that's great, but this should work. The DSN stuff can work, but it introduces a potential dependency on the particular machine and other setup.