Communication link failure.

Jairo Gubler

unread,

Aug 16, 1999, 3:00:00 AM8/16/99

to

Can someone help me?

On SQLSERVER 6.5 the distribution task returns the following message (is was
working fine before this):
08S01[Microsoft][ODBC SQL Server Driver]Communication link failure

I tried odbcping and it returns login failed (why? I don't change passwords
or logins!).
COULD NOT CONNECT TO SQL SERVER

SQLState: 28000 Native Error: 4002
Info. Message: [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed

SQLState: 01S00 Native Error: 0
Info. Message: [Microsoft][ODBC Driver Manager] Invalid connection string
attrib
ute

Any suggestion? Shutdown ?

--
------------------------------------------------
Jairo Gubler
Analista de Sistemas - SFW
Dígitro Tecnologia LTDA
e-mail: jairo....@digitro.com.br

Jairo Gubler

unread,

Aug 16, 1999, 3:00:00 AM8/16/99

to

Now the odbcping works. The problem was that the password has an ";" and
odbdping don't accepts this. I tried with another user and now it works.
However the replication task continues to give the same message...
Can someone help me!

Jairo Gubler <jairo....@digitro.com.br> wrote in message
news:u$LZSe$5#GA.63@cppssbbsa05...

KNV

unread,

Aug 17, 1999, 3:00:00 AM8/17/99

to

Are you using SP5? Or have you installed MDAC 2.1 on your server?

--
KNV
Check out http://members.tripod.com/~vyaskn/SQLServerRes.html for SQL Server
resources on the net.
Always under construction!!!

Jairo Gubler

unread,

Aug 17, 1999, 3:00:00 AM8/17/99

to

The publication/distributor has SP5. The subscriber has an older version.
What's then purpose of MDAC 2.1 ?

The replication worked 3 months and nothing was modified
(installed/removed).

KNV <answ...@hotmail.com> wrote in message
news:uBG24XL6#GA.251@cppssbbsa04...

KNV

unread,

Aug 17, 1999, 3:00:00 AM8/17/99

to

There is a problem with MDAC 2.1. I am wondering, if you are seeing the same
problem:
See the following article for workaround:
Article ID: Q216848 BUG: MDAC: SQL Server Driver May Return Error "Login
Failed
http://support.microsoft.com/support/kb/articles/q216/8/48.asp

Jairo Gubler <jairo....@digitro.com.br> wrote in message

news:OnC2dEN6#GA....@cppssbbsa02.microsoft.com...

Jairo Gubler

unread,

Aug 17, 1999, 3:00:00 AM8/17/99

to

Before changing the DLLs can I do something to certify that's the problem.
Our servers are full time online (24 H) and they're at a remote site!!
Something like using isql, odbcping ?

I tested odbcping and isql and they are working with my user.
SERVER1 --> SERVER2
SERVER2 --> SERVER1

KNV <answ...@hotmail.com> wrote in message

news:uPDuuQN6#GA....@cppssbbsa02.microsoft.com...

Michael Hotek

unread,

Aug 17, 1999, 3:00:00 AM8/17/99

to

First off, I would sincerely hope you do not have SP5 on those servers.
This was pulled due to bugs. The appropriate SP is 5a. There is a
documented bug with replication and SP5a. Installing MDAC will take care of
the problem you are facing.

--
Mike
http://www.mssqlserver.com
MCSE, SQL Server DBA, Author
mailto:mho...@swynk.com
Please direct all replies to the newsgroup unless specifically stated
otherwise.

Jairo Gubler

unread,

Aug 18, 1999, 3:00:00 AM8/18/99

to

Unfortunately I have SP5 on those servers.

How can I confirm that SP5a solves my problem? Why does the replication stop
after 3 months, without any update on the servers?
I there some explication for this?

My greatest problem is that the servers are at a remote site, and our net
bandwidth only permits the use of rsh, telnet or Enterprise Manager.
So I must be certain that's the problem...

Michael Hotek <mho...@swynk.com> wrote in message
news:eN1Y4FT6#GA.242@cppssbbsa04...

Michael Hotek

unread,

Aug 18, 1999, 3:00:00 AM8/18/99

to

If you have SP5 on those servers, you have a BIG problem. There are bugs in
some rather unused portions of SQL Server, like backups. SP5 was pulled.
MS sent out an advisory. It is not supported and you should replace it
immediately with SP5a.

Mike

Jairo Gubler

unread,

Aug 19, 1999, 3:00:00 AM8/19/99

to

Here is an output of the Distribution Task (option -o).

Task: SEGUPNT1_SIAP_SEGUPNT2_SIAP

Server: SEGUPNT1
DBMS: Microsoft SQL Server
Version: 06.50.0255
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 30
max column name len: 30
need long data len: Y
max columns in table: 250
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072

execute sp_server_info 18
ANSI codepage: 0

select srvid, srvnetname from master..sysservers where srvname = 'SEGUPNT1'

select srvid, srvnetname from master..sysservers where srvname = 'SEGUPNT2'

Server: SEGUPNT2
DBMS: Microsoft SQL Server
Version: 06.50.0255
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 30
max column name len: 30
need long data len: Y
max columns in table: 250
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072

execute sp_server_info 18
ANSI codepage: 0
{?=call master..xp_regread ('HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\MSSQLServer\Replication', 'WorkingDirectory')}
{?=call master..xp_regread ('HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\MSSQLServer\Client\DB-Lib', 'AutoAnsiToOem')}
AutoAnsiToOem: on
select max (job_id) from MSsubscriber_status where publisher_id = 0 and
publisher_db = 'SIAP' and subscriber_id = 1 and subscriber_db= 'SIAP'
select * from sysobjects where name = 'sp_replsync' and type = 'P'select
"job_id" from "MSlast_job_info" where "publisher" = 'SEGUPNT1' and
"publisher_db" = 'SIAP' and "publication" is null
select type from MSjobs where publisher_id = 0 and publisher_db = 'SIAP' and
job_id = 3029342 {?=call sp_MSget_subscriber_jobs(0, 'SIAP', 1, 'SIAP',
3029342,
1)}
Job: 3029343
Partial: 0
Type: 0
Command: update "cnfg_gerachave" set "valor" = 19251 where "cod_cad" = 20
and
"cod_gerachave" = 'usrv_empenho'

Job: 3029343
Partial: 0
Type: 0
Command: insert into "usrv_empenho" values (20, 19251, 'AT03 ', 20,
200000000, {ts '1999-08-13 11:41:38.000'}, 98, NULL, NULL, {ts '1999-08-13
12:31:04.000'}, NULL, NULL, NULL, 'N', 'S', NULL, NULL, NULL, NULL)

Job: 3029343
Partial: 0
Type: 0
Command: insert into "usrv_empenhohora" values (20, 19251, 1, {ts
'1999-08-13
12:31:04.000'})

Job: 3029343
Partial: 0
Type: 0
Command: update "usrv_empenho" set "cod_usrvhorario" = 1, "dtInformada" =
{ts
'1999-08-13 12:31:04.000'} where "cod_cad_empenho" = 20 and "cod_empenho" =
19251

Job: 3029343
Partial: 0
Type: 0
Command: insert into "cnfg_locks" values ('usrv_uniservico', 'AT03', ' ', '
', '
', ' ', {ts '1999-08-13 12:31:04.097'}, '1776728 ', 1026)

Job: 3029343
Partial: 0
Type: 0
Command: update "usrv_uniservico" set "cod_usrvstatus" = 5 where
"cod_uniservico" = 'AT03 '

Job: 3029343
Partial: 0
Type: 0
Command: delete from "cnfg_locks" where "cod_lock_nome" = 'usrv_uniservico'
and
"chprimaria1" = 'AT03' and "chprimaria2" = ' ' and "chprimaria3" = ' ' and
"chprimaria4" = ' ' and "chprimaria5" = ' '

Job: 3029343
Partial: 0
Type: 0
Command: update "ocor_ocororgao" set "status" = 'A' where "cod_cad" = 20 and
"dtocorrencia" = {ts '1999-08-13 11:41:38.000'} and "cod_ocorrencia" = 98
and
"cod_orgao" = 200000000

Job: 3029343
Partial: 0
Type: 0
Command: update "cnfg_gerachave" set "valor" = 237862 where "cod_cad" = 20
and
"cod_gerachave" = 'cnfg_tabatualiz'

Job: 3029343
Partial: 0
Type: 0
Command: insert into "cnfg_tabatualiz" values (237862, 302, 20, '20',
'13/08/1999 11:41:38', '98', '200000000', ' ', {ts '1999-08-13
12:31:04.000'},
'1776728 ', '4')

Job: 3029343
Partial: 0
Type: 0
Command: delete from "cnfg_locks" where "cod_lock_nome" = 'ocor_ocororgao'
and
"chprimaria1" = '20' and "chprimaria2" = '1999-08-13 11:41:38' and
"chprimaria3"
= '98' and "chprimaria4" = '200000000' and "chprimaria5" = ' '

update "cnfg_gerachave" set "valor" = 19251 where "cod_cad" = 20 and
"cod_gerachave" = 'usrv_empenho';insert into "usrv_empenho" values (20,
19251,
'AT03 ', 20, 200000000, {ts '1999-08-13 11:41:38.000'}, 98, NULL, NULL,
{ts
'1999-08-13 12:31:04.000'}, NULL, NULL, NULL, 'N', 'S', NULL, NULL, NULL,
NULL);
insert into "usrv_empenhohora" values (20, 19251, 1, {ts '1999-08-13
12:31:04.000'});update "usrv_empenho" set "cod_usrvhorario" = 1,
"dtInformada" =
{ts '1999-08-13 12:31:04.000'} where "cod_cad_empenho" = 20 and
"cod_empenho" =
19251;insert into "cnfg_locks" values ('usrv_uniservico', 'AT03', ' ', ' ',
' ',
' ', {ts '1999-08-13 12:31:04.097'}, '1776728 ', 1026);update
"usrv_uniservico" set "cod_usrvstatus" = 5 where "cod_uniservico" = 'AT03
';delete from "cnfg_locks" where "cod_lock_nome" = 'usrv_uniservico' and
"chprimaria1" = 'AT03' and "chprimaria2" = ' ' and "chprimaria3" = ' ' and
"chprimaria4" = ' ' and "chprimaria5" = ' ';update "ocor_ocororgao" set
"status"
= 'A' where "cod_cad" = 20 and "dtocorrencia" = {ts '1999-08-13
11:41:38.000'}
and "cod_ocorrencia" = 98 and "cod_orgao" = 200000000;update
"cnfg_gerachave"
set "valor" = 237862 where "cod_cad" = 20 and "cod_gerachave" =
'cnfg_tabatualiz';insert into "cnfg_tabatualiz" values (237862, 302, 20,
'20',
'13/08/1999 11:41:38', '98', '200000000', ' ', {ts '1999-08-13
12:31:04.000'},
'1776728 ', '4');delete from "cnfg_locks" where "cod_lock_nome" =
'ocor_ocororgao' and "chprimaria1" = '20' and "chprimaria2" = '1999-08-13
11:41:38' and "chprimaria3" = '98' and "chprimaria4" = '200000000' and
"chprimaria5" = ' 'update "MSlast_job_info" set "job_id" = 3029343 where
"publisher" = 'SEGUPNT1' and "publisher_db" = 'SIAP' and "publication" is
null
Thread shutdown.
{?=call sp_MSget_subscriber_jobs(0, 'SIAP', 1, 'SIAP', 3029343, 1)}
Job: 3029344
Partial: 0
Type: 0
Command: insert into "cnfg_locks" values ('cham_chamada', '20', '368755', '
', '
', ' ', {ts '1999-08-13 12:31:06.690'}, '19540 ', 1027)

Waiting for thread to shutdown.
raiserror (14152, 18, 1, 'Distribution', 'SEGUPNT1_SIAP_SEGUPNT2_SIAP', 15,
'08S01[Microsoft][ODBC SQL Server Driver]Communication link failure')

08S01[Microsoft][ODBC SQL Server Driver]Communication link failure

Return Status: 2