• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 578
  • Last Modified:

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."
===================================================
0
Jey_P
Asked:
Jey_P
  • 3
  • 2
5 Solutions
 
Kyle AbrahamsSenior .Net DeveloperCommented:
They are trying to create a linked server.

The error they're getting says that for some reason they can't initialize that data source.  Either they're creating the linked server wrong or additional permissions are needed.

http://technet.microsoft.com/en-us/library/aa226395(v=sql.80).aspx
0
 
Anthony PerkinsCommented:
I am going to go out on a limb and suggest the linked server is from a 64-bit SQL Server using JET to connect to MS Access.  Is that correct?  If so, you should know there is no 64-bit JET driver.
0
 
ValentinoVBI ConsultantCommented:
Anthony: actually, since Office 2010 there is one, see Microsoft Access Database Engine 2010 Redistributable

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.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Anthony PerkinsCommented:
since Office 2010 there is one
I suspect you will find that is not a JET driver, but rather an ACE driver.  My point was they cannot use a JET connection from a SQL Server 64 bit O/S.

But feel free to let me know if I am wrong.
0
 
ValentinoVBI ConsultantCommented:
I suspect you will find that is not a JET driver, but rather an ACE driver.  My point was they cannot use a JET connection from a SQL Server 64 bit O/S.

Well, ACE actually is the new JET.  It's backward-compatible and can thus be used to create the linked server from a 64-bit SQL.

With version 2007 onwards, Access includes an Office-specific version of Jet, initially called the Office Access Connectivity Engine (ACE), but which is now called the Access Database Engine. This engine was fully backward-compatible with previous versions of the Jet engine, so it read and wrote (.mdb) files from earlier Access versions.

The engine in Microsoft Access 2010 discontinued support for Access 1.0, Access 2.0, Lotus 1-2-3 and Paradox files. A 64-bit version of the ACE Driver/Provider was introduced, which in essence provides a 64-bit version of Jet.

The engine in Microsoft Access 2013 discontinued support for Access 95, Access 97 and xBase files.

From a data access technology standpoint, Jet is considered a deprecated technology by Microsoft, but Microsoft continues to support ACE as part of Microsoft Access.
Ref Microsoft Jet Database Engine [Wikipedia]

The above means that care should be taken on which ACE driver to install: if it's an oldes Access version (95/97) then it's not a good idea to install the latest (2013) ACE driver, but ACE 2010 should work.
0
 
Anthony PerkinsCommented:
Certainly ACE can be used where JET used to be used previously, but they are not the same connection string, that is the point I was making.  In other words yes, they may be able to use ACE instead of JET however, they will have to change their linked server.

I trust this is clear now.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now