Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC Over the internet
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00602630
Message ID:
00603214
Views:
26
>Ed, was that all ? {g}

Yes; that's plenty for a shop with less than 30 workstations.

>Thanks !
>
>
>>>>>Is there a way to make a odbc or oledb connection to a table or dbc in another computer through the internet via tcp/ip?
>>>>
>>>>Yes - under NT/Win2K/XP, you can specify a share using an IP address for the servername in a UNC; you essentially have a (relatively slow) file server connection referencing the table by UNC; eg:
>>>>
>>>>I have a server whose IP Address is 64.252.xx.yy, with a sharename called 'MyData'. If I want to open the table MyTable.DBF on that system, I can specify the filename as \\64.252.xx.yy\MyData\MyTable.DBF under these operating systems. Win9x does not permit the direct use of an IP address as a machine name in a UNC; you must resolve that name to a NetBIOS name using the LMHOSTS file to map a machine name to an IP address, and use the machine name rather than the IP address in the UNC. Both ODBC and OLEDB support UNC-based file names
>>>
>>>Ed, just for kicks, what is your experience on the connection response with an Intranet connection ? I tend to like this ...
>>
>>We routinely run under NBT (NetBIOS over TCP/IP) in-house with our Win2K server farm and peer-to-peer communication, using DNS for name resolution, and run RRAS and Win2K TS over SDSL to our remote warehouses. Performance on the remotes is absolutely acceptable given the traffic level (768Kbps SDSL at our end, with 384Kbps outbound/1.5Mbps inbound supporting one RRAS and 4-5 TS sessions on a Dell 1400 with dual 933MHz PIIIs and 768MB) doing transactional apps remotely, and 100BaseTX full duplex in the main shop. Win2K Pro and XP Pro are wonderful; using DNS name resolution for NetBIOS handles the Win98 and WinME boxes nicely. The base server configuration is three identical Dell 1400s, one as primary AD server, DNS and base file sharing, one running SQL Server 2K, and the Win2K TS box, all running RAID 10 (mirrored RAID-0 arrays) on Quantum Atlas IVs. We use two separate ISPs for connectivity, DSL.net is our SDSL provider, and Snet.Net provides low-cost ADSL, with dynamic routing
>>managed by SonicWall SOHO-50 Router/VPN appliances, with remotes using either SOHO 10s or the SonicWall VPN software..
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform