Ed, was that all ? {g}
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..