Connect to Remote Server Database from Local Machine
-
I am trying to create an application that can connect to a database on a remote server. If anyone knows how to achieve this or has any good reading material please could you let me know? Any help is much appreciated.
McGann
-
I am trying to create an application that can connect to a database on a remote server. If anyone knows how to achieve this or has any good reading material please could you let me know? Any help is much appreciated.
McGann
Mc--Gann wrote:
remote server
By this I assume you mean 'Not on the same Local Area Network' Also, what type of database are you trying to connect to?
Steve Jowett ------------------------- Real programmers don't use PL/1. PL/1 is for insecure momma's boys who can't choose between COBOL and Fortran.
-
Mc--Gann wrote:
remote server
By this I assume you mean 'Not on the same Local Area Network' Also, what type of database are you trying to connect to?
Steve Jowett ------------------------- Real programmers don't use PL/1. PL/1 is for insecure momma's boys who can't choose between COBOL and Fortran.
Correct its over the web. It's a MSSQL database
ASP all the way
-
Correct its over the web. It's a MSSQL database
ASP all the way
You can connect to SQL over internet. Check out ConnectionStrings.com for connection string.
-
Correct its over the web. It's a MSSQL database
ASP all the way
You should be aware of firewall inparticular the UDP ports. MS SQL Server uses port 1440 as standard but is othen changed. Assuming the port is 1440 then in your connection string you will need to specify the port along with the server ip address, for example :
Data Source=123.123.123.123:1440;Initial Catalog=MyDatabase;User ID=MyUserId;Password=MyPassword
Steve Jowett ------------------------- Real programmers don't use PL/1. PL/1 is for insecure momma's boys who can't choose between COBOL and Fortran.
-
You can connect to SQL over internet. Check out ConnectionStrings.com for connection string.
thanks for the help
ASP all the way
-
Correct its over the web. It's a MSSQL database
ASP all the way
Who in their right mind exposes a SQL Server directly to the Internet?? That's insane!
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009... -
Who in their right mind exposes a SQL Server directly to the Internet?? That's insane!
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...Fasthosts do and that seems quite secure to be honest, I can access it using management studio from my PC easily which makes for simple maintenance. Phil Software Developer http://www.yorkshirehumberit.co.uk