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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run time error -2147217887 (80040e21) 2
Run time error:"2147467259 (80004005)"Anyone ever get this error? 1
ADODB.Connection run-time error -2147467259 (80004005) 3
Adding Records to a Linked BE Table on a MS SQL Server 5
using sql server function 2
Link to SQL Server via code 6
Error handler not catching SQL Server Connection failure 2
Run time error '-2147467259 (80004005) adding icon 3

Top