 |
BorlandTalk.com Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Brian Paine Guest
|
Posted: Fri Apr 23, 2004 3:04 pm Post subject: Remote Access to SQL Server |
|
|
How would I go about accessing SQL Server 2000, runing on a web server,
remotely from another machine? Is is just a change to the connection string?
Thanks,
Brian
|
|
| Back to top |
|
 |
G. Allen Casteran Guest
|
Posted: Fri Apr 23, 2004 3:34 pm Post subject: Re: Remote Access to SQL Server |
|
|
In article <408930cc$1 (AT) newsgroups (DOT) borland.com>, [email]bpaine (AT) snowhill (DOT) com[/email]
says...
| Quote: | How would I go about accessing SQL Server 2000, runing on a web server,
remotely from another machine? Is is just a change to the connection string?
Thanks,
Brian
|
If you can avoid allowing a direct connection to the DB over the
internet you will be much safer. The security risks are great when you
expose your DB.
The one exception to this rule is if your internet links are kept to
sites within your organization or close partners where you can set up
VPN links between the sites.
I would look into using a web services (SOAP) interface or a 3 tier
model, depending upon the application requirements.
Allen.
|
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|