Mike sure the DSN driver is not trying to connect through Vines but with
TCPIP or whatever protocol... Even you your sure do it again... This is the
default. I spent a week and about a grand trying to fix the prob.
-Brian
----- Original Message -----
From: Bob Silverberg <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, October 12, 2000 9:00 AM
Subject: Problems setting up a remote DSN to SQL Server
> 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/[email protected]/
> 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.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
