SQL Server Run-time error "-2147467259 (80004005):

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I am connecting from an Access front end to a SQL Server 2005 Express
database on a remote PC. I have enabled TCP/IP on the server and
turned off firewalls on both boxes.

The first recrodset opens and reads the data fine. The subsequent
one
(which runs after it gives the following error on update.


Run-time error "-2147467259 (80004005):
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server
'EMPDB\SQLEXPRESS' in sys,servers. Verify that the correct server
name
was specified. If neccessary, execute the stored procedure
sp_addlinkedserver to add the server to sys.servers.


The code is


strCon = "ODBC;Database=EmDataSQL6;DSN=EmpDBDataSource3;Server=EmpDB
\SQLEXPRESS;UID=123;PWD=123"


rs.Open "SELECT JobFlag FROM tblJob WHERE JobID =" & JobID, strCon,
adOpenForwardOnly, adLockReadOnly
mblnJob = rs4!JobFlag
rs.Close
Set rs = Nothing


rs.Open "SELECT EmpJobStatus FROM tblEmpJob WHERE (EmpJobID =" &
glngEmpJobID & ")", strCon, adOpenKeyset, adLockPessimistic
With rs4
!EmpJobStatus = gstrEmpJobStatus
.Update
End With
rs4.Close
Set rs4 = Nothing
 
Back
Top