Connection to another Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Day to All,

Recently our company has updated one of our servers from SQL 2003 to SQL
2005. I had a number of queries referencing the newly updated server from the
server which was not updated. Before the update I had no problem with the
queries.

Currently when I run the queries I get an error indicating that a connection
cannot be made. I have checked everything and cannot resolve my problem.

Please look at my query and see if changes need to be made or give me a clue
to where I can resolve the problem.

query:

SELECT TOP Internal_ID_Number, Original_FileNo, DocumentType, PolicyNo,
Original_EscrowFileNo, CountyCode, FileNo, LocationCode,
EscrowFileNo, EntryDate, UserId
FROM GREAT1.ImageTrak.dbo.Closings g1Closings
ORDER BY EntryDate DESC
 
Your Access front-end uses an ODBC connection (?DSN) to connect to
SQL-Server, right? And even if the same server machine is now hosting the
new version, the connection probably needs to be refreshed.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Thanks much Jeff, I do believe I have tried refreshing the connection, but I
will check it in case I have done it incorrectly.
--
CapnOdie


Jeff Boyce said:
Your Access front-end uses an ODBC connection (?DSN) to connect to
SQL-Server, right? And even if the same server machine is now hosting the
new version, the connection probably needs to be refreshed.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
Click to expand...
 
To Jeff and all,

I have refreshed the obdc connection and tried to re-run the query and am
now receiving the error "Cannot logon to server". The logon information in
the connection dialog box is for the host database on the 2003 server. I
have gone to the enterprise manager and made sure that sp_addlinkedserver
was run and I can run the query there successfully. The problem seems to be
something in Access, but can't come up with the problem. All the tables and
queries (views or stored procedures) run properly on the host, it is the ones
that are linked to the second server.

Got me hanging from a tree! gonna be a long day.
--
CapnOdie


CapnOdie said:
Thanks much Jeff, I do believe I have tried refreshing the connection, but I
will check it in case I have done it incorrectly.
Click to expand...
 
Back
Top