MSDTC on server '' is unavaliable

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

SQL Server 6.5 \ SQL Server 7.0

MSDTC on server '' is unavaliable

Author

Topic

CHAK_ALF
Starting Member

1 Post

Posted - 2007-11-27 : 13:47:41

Hello
first of all i'm sorry because this topic was in this forum but the other topic was closed.

I have the same error

quote:

if i put the statement in a trigger the
message MSDTC on server '' (NOTE there is no servername in the quotes) is unavailable.

but my error is when i try to insert into a table from acces


GRAR_Server.Execute "Insert Into OMI01 (DOCUMENTO,FECHA,NUMERO,OBSERVACIONES,REFERENCIA,SUCURSAL,BODEGA,SERIE,STATUS,TIPO_MOV) Select a.DOCUMENTO,a.FECHA,a.NUMERO,a.OBSERVACIONES,a.REFERENCIA,a.SUCURSAL,a.BODEGA,a.SERIE,a.STATUS,a.TIPO_MOV  From OPENROWSET('Microsoft.Jet.OLEDB.4.0','c:\CONFIGURACION\BDTRANSAC.mdb';'admin';'',womi01) a Where a.NUMERO = '" & CODIGOW & "' OR a.REFERENCIA = '" & CODIGOW & "'"

I hope you can help me

pd: sorry by my English but I'm not American

<center>

</center>

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-28 : 03:17:34

Run 'select @@servername' in query analyzer to see what you get.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources