Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1_PAblo_Angel
Starting Member
9 Posts |
 Posted - 2010-11-08 : 11:32:31
|
| Hi all,first post and a bit of an amateur with this stuff so any and all help much appreciated...basically I've been told to investigate the possibility of querying the data stored on a server on our local network from our remote website (asp.net 3.5), via the local network's external IP. I am aware that support for Server 2000 has been withdrawn from VS 2010 and so I would need to use ODBC commands... I was just wondering if this is at all possible to begin with, and whether the limitations of ODBC data sources make it impractical regardless.If that's the case, could I do it if we upgraded our database to 2005/2008?Thanks in advance! |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-11-09 : 14:59:37
|
| Assuming your ODBC drivers are up to date, and the relevant ports are open and server references are resolvable , then setting up and ODBC data source is straightforward. Ensure you have relevant security on the target server \ database .Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2010-11-21 : 17:42:06
|
| yes it is very possible and simple. see tutorials herehttp://www.asp.net/get-started |
|
|
|
|
|
|
Accessing SQL Server 2000 from remote site