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 |
|
Ger
Starting Member
11 Posts |
 Posted - 2002-08-09 : 11:04:28
|
| I need to use an application that uses SQL Server through ODBC from a remote computer. I could install the application locally (an EXE). I suppose I would have to use RAS to connect to our network and so be able to reach the database server. How would I set up the ODBC entry? Should I first connect with RAS in order to "see" the server when setting it up? Is there anything special I should know to do this?Thank you!! |
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-08-09 : 12:24:17
|
| I am not sure about this, but believe before you can use ODBC that you need to setup something called DSN (Data Source Name). Refer to BOL. In windows, click START, click SETTINGS, click CONTROL PANEL, click DATASOURCES ODBC. This puts you in the ODBC Data Source Administrator. I think you want to select the DRIVERS tab, scroll to bottom and select SQL Server.HTHs solart |
 |
|
|
Ger
Starting Member
11 Posts |
Posted - 2002-08-09 : 15:59:24
|
| Thank you Solart; I already use it through ODBC. The big question is, how do I connect to the database with dialup? I suppose the ODBC interface will allow me to use the application just as it is now, but from a remote computer, off the local network, I need to set up the link somehow. I believe RAS allows you to become part of the network you're connecting to - is this the right way to reach the database? Does it work anyway? Thanks... |
|
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-08-09 : 16:28:43
|
| Sorry, I miss understood about Remote Access Services (RAS). I am afraid you are way out of my area of knowledge.However, for what it's worth Windows help says the following:Additional Network Services for Windows NT ServerThe following services add networking capabilities beyond basic networking to Windows NT Server. The service must be installed for help to be available. For more information, see Installing Network Services. TCP/IP Gateway Service for NetWare Remote Access Service Services for Macintosh Remoteboot Service Network Client AdministratorInstalling Network Services says:Installing Network ServicesThese services let you access the Internet, NetWare networks, UNIX networks, and remote computers or networks. Windows NT Server can also provide file and print support to Macintosh clients, allow network clients to load MS-DOS or Windows for Workgroups software over the network, and administer the installation of the client software provided with Windows NT Server for non-Windows NT computers.After you install Windows NT, you can install these services using the Network option in Control Panel. To do this, on the Services tab, click Add. Then, in the Network Services box, click a service, click OK, and then supply the path to the distribution files. You can also install these services during Custom Setup TCP/IP. Services for NetWare can also be installed during Express Setup.Remote Access Service says:Remote Access Service (RAS)Users in remote sites can use the network as if their computers were directly connected to the network. After installing RAS, you can use RAS phone book to maintain the telephone numbers of remote networks, and to connect to and disconnect from these remote networks. You administer Windows NT Remote Access servers using Remote Access Admin.The way I interpret the above is that the Server needs to have steps taken to support RAS, then the administration of the remote phone numbers cause the network to recognize you as part of the network when you dial in.You may be very close to getting this problem solved.HTHs and Best Wishes solart |
|
|
|
Ger
Starting Member
11 Posts |
Posted - 2002-08-12 : 17:05:43
|
| Thank you! |
|
|
|
|
|
|
|
|
Remote database access