We have an old access database which someone is trying to connect to from a linked server in SQL2005. In SQL2000 this worked with no issue however I cannot now find a ole db provider which will allow me to connect to this db. Is this possible anymore or does the fact that it is access 97 mean the connection is now not possible ?
Access 97 is no longer in support, so I'd recommend upgrading. Generally speaking, the Access-to-SQL Server relationship works more smoothly when the link is initiated from Access. --Mary On Thu, 12 Jun 2008 08:27:00 -0700, Simon wrote: >We have an old access database which someone is trying to connect to from a >linked server in SQL2005. In SQL2000 this worked with no issue however I >cannot now find a ole db provider which will allow me to connect to this db. > >Is this possible anymore or does the fact that it is access 97 mean the >connection is now not possible ?
Sadly we have a .net app which queries the access db via the linked server. Now we have moved to SQL2005 we can`t get that process to work. Think this might be a little tricky ! "Mary Chipman [MSFT]" wrote: > Access 97 is no longer in support, so I'd recommend upgrading. > Generally speaking, the Access-to-SQL Server relationship works more > smoothly when the link is initiated from Access. > > --Mary > > On Thu, 12 Jun 2008 08:27:00 -0700, Simon > wrote: > > >We have an old access database which someone is trying to connect to from a > >linked server in SQL2005. In SQL2000 this worked with no issue however I > >cannot now find a ole db provider which will allow me to connect to this db. > > > >Is this possible anymore or does the fact that it is access 97 mean the > >connection is now not possible ? >
It might be an MDAC/SNAC issue. Try googling it in that context. I'm sure other people must have had the same problem. --Mary On Thu, 12 Jun 2008 09:42:00 -0700, Simon wrote: >Sadly we have a .net app which queries the access db via the linked server. >Now we have moved to SQL2005 we can`t get that process to work. Think this >might be a little tricky ! > >"Mary Chipman [MSFT]" wrote: > >> Access 97 is no longer in support, so I'd recommend upgrading. >> Generally speaking, the Access-to-SQL Server relationship works more >> smoothly when the link is initiated from Access. >> >> --Mary >> >> On Thu, 12 Jun 2008 08:27:00 -0700, Simon >> wrote: >> >> >We have an old access database which someone is trying to connect to from a >> >linked server in SQL2005. In SQL2000 this worked with no issue however I >> >cannot now find a ole db provider which will allow me to connect to this db. >> > >> >Is this possible anymore or does the fact that it is access 97 mean the >> >connection is now not possible ? >>
Rather than using a linked server connection to the MS Access file, try using openrowset and experiment with various provider configurations. http://msdn.microsoft.com/en-us/library/ms190312.aspx http://www.connectionstrings.com/?carrier=access http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForAccess http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMicrosoftJet "Simon" wrote: > We have an old access database which someone is trying to connect to from a > linked server in SQL2005. In SQL2000 this worked with no issue however I > cannot now find a ole db provider which will allow me to connect to this db. > > Is this possible anymore or does the fact that it is access 97 mean the > connection is now not possible ?
Can the application connect to the MS Access database directly rather than via a linked server setup in SQL Server? "Simon" wrote: > Sadly we have a .net app which queries the access db via the linked server. > Now we have moved to SQL2005 we can`t get that process to work. Think this > might be a little tricky ! > > "Mary Chipman [MSFT]" wrote: > > > Access 97 is no longer in support, so I'd recommend upgrading. > > Generally speaking, the Access-to-SQL Server relationship works more > > smoothly when the link is initiated from Access. > > > > --Mary > > > > On Thu, 12 Jun 2008 08:27:00 -0700, Simon > > wrote: > > > > >We have an old access database which someone is trying to connect to from a > > >linked server in SQL2005. In SQL2000 this worked with no issue however I > > >cannot now find a ole db provider which will allow me to connect to this db. > > > > > >Is this possible anymore or does the fact that it is access 97 mean the > > >connection is now not possible ? > >
