SQL Server error
Hi EE,
Could you please help on below error that we are getting in our end and cannot access DB Server. I am not very familiar with this error. Please post me how to troubleshoot this issue how we prevent from this in future( Can we setup any monitoring ?) . Thanks and much appreciates.
Regards
J
==========================
"In a nutshell, we are trying to use Linked Server to combine data from the SQL server and an Access file (no password on the Access file) but can't get the Linked Server to work. We tried to create the Linked using both Server Management Studio and T-SQL with the same result.
At the creation stage (sp_addlinkedserver) no errors are returned. However, all statements trying to use the linked server return some kind of error. The procedure sp_testlinkedserver is generating the error code 7303 but we are unable to resolve the issue."
==========================
Could you please help on below error that we are getting in our end and cannot access DB Server. I am not very familiar with this error. Please post me how to troubleshoot this issue how we prevent from this in future( Can we setup any monitoring ?) . Thanks and much appreciates.
Regards
J
==========================
"In a nutshell, we are trying to use Linked Server to combine data from the SQL server and an Access file (no password on the Access file) but can't get the Linked Server to work. We tried to create the Linked using both Server Management Studio and T-SQL with the same result.
At the creation stage (sp_addlinkedserver) no errors are returned. However, all statements trying to use the linked server return some kind of error. The procedure sp_testlinkedserver is generating the error code 7303 but we are unable to resolve the issue."
==========================
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
But you might indeed be on to something! For a 64-bit SQL they'd indeed need to install the 64-bit driver and not 32-bit.