Waspman
Posts: 948
|
| Posted: 10/07/2005, 7:39 AM |
|
Is it possible for to connect to a SQL database on another server?
Or provide someone the address and login details so they can access it?
Thanks in advance, T
_________________
http://www.waspmedia.co.uk |
 |
 |
Benjamin Krajmalnik
|
| Posted: 10/07/2005, 8:50 AM |
|
Yes and no.
It depends on the database on the backend.
If you are running an access database the answer is no.
If you are running SQL, the answer is yes.
Depending on the network architecture, you may need to open up firewall
ports, and you will need to make sure the account you are using in the
application's database connectio has access rights to the database.
The question is too generic to be able to give you further guidance.
However, my applications are deployed in an architecture where the db server
is on a different server as the web server, and in a different security zone
on the firewall. I have clients running the application on a webserver
which is at another physical locaion, with all db access over the internet.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 10/07/2005, 12:19 PM |
|
The quickest way to test this may be to create an ODBC Data Source in Windows Control Panel that connects to your remote database. Once you set it up then you'll know that you can connect to your database on another server. Plus you can access thousands of Internet articles that describe the process of setting up DSN and generally connecting to databases remotely.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
