Hi everyone,
I'm trying to setup a datasource to point to a SQL Server database on
another physical server, but the verification always fails. I have been
able to get it to work between my workstation (running W2K Server/CF 4.5.1)
and the remote server (running NT4/SQL Server 7). I can setup both an ODBC
and an OLE DB connection between my workstation and the remote server.
The problem comes when I try to set the datasource up on the Production web
server (running W2K Server/ CF 4.5.0). Both with ODBC and OLE DB it always
fails. I noticed that if I increase the Login Timeout, it takes longer
before it fails, so it sounds like it may be timing out.
Both my workstation and the Web server are accessing the SQL Server database
via TCP/IP over the internet. Both my workstation and the Web server are in
the same city, while the SQL Server machine is in another city.
Has anyone encountered anything like this? Any suggestions would be greatly
appreciated.
Thanks,
Bob
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
