Error in ODBC Connection HELP

I had in a customer a ODBC connection to the database sql
in which I modified the client configurations the
connection I took off the option to determine door
dynamicly and placed the 1433 but it gave error and after
this exactly placing again to determine door dynamicly it
gives always error and it does not function i remember
that before this it was to function perfectly. The error
is:
Error in Connection:
SQLState: ' 01000 '
Error in the SQL Server: 10061 [ Microsoft][ODBC SQL
Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
Error in Connection:
SQLState: ' 08001 ' Error in the SQL Sever: 17 [
Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL
Server does not exist or the access was refused the
computer in cause is with all the right definitions of
net, has access to the server... Please help Me! .Hi Nuno,
first of all be sure that you don't have network generic problems, using for
example the dos PING command or TRACERT.
Then I'd reinstall MDAC on client machine (if you've to connect to SQL
Server 7.00 install MDAC 2.5, for SQL 2000 MDAC 2.6SP2), reboot the client
and try again deleting the old DSN and recreating a newest one.
Very important is checking the TCP port is your server listening on (check
the server network utility on your server machine) and the TCP port is your
server transmetting (check the client network utility on your client
machine): they must be identical.
Finally check the authentication mode on your sql server: it must be the
same of the specified into your DSN configuration.
Hope it helps, regards
Riccardo Piccini
Supporto Software
EDP SERVICE SRL
"Nuno Pereira" <n.pereira@.desis.pt> ha scritto nel messaggio
news:17df301c42221$d6cab310$a001280a@.phx
.gbl...
> I had in a customer a ODBC connection to the database sql
> in which I modified the client configurations the
> connection I took off the option to determine door
> dynamicly and placed the 1433 but it gave error and after
> this exactly placing again to determine door dynamicly it
> gives always error and it does not function i remember
> that before this it was to function perfectly. The error
> is:
> Error in Connection:
> SQLState: ' 01000 '
> Error in the SQL Server: 10061 [ Microsoft][ODBC SQL
> Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
> Error in Connection:
> SQLState: ' 08001 ' Error in the SQL Sever: 17 [
> Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL
> Server does not exist or the access was refused the
> computer in cause is with all the right definitions of
> net, has access to the server... Please help Me! .