Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Connections to data sources

  
   Database Forums (Home) -> ODBC RSS
Next:  sp_preprexec error  
Author Message
Simon

External


Since: Mar 08, 2006
Posts: 25



(Msg. 1) Posted: Thu Jun 12, 2008 8:27 am
Post subject: Connections to data sources
Archived from groups: microsoft>public>sqlserver>odbc (more info?)
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 ?

 >> Stay informed about: Connections to data sources 
Back to top
Login to vote
Mary Chipman [MSFT]

External


Since: Feb 04, 2005
Posts: 51



(Msg. 2) Posted: Thu Jun 12, 2008 12:30 pm
Post subject: Re: Connections to data sources [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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 ?

 >> Stay informed about: Connections to data sources 
Back to top
Login to vote
Simon

External


Since: Mar 08, 2006
Posts: 25



(Msg. 3) Posted: Thu Jun 12, 2008 12:30 pm
Post subject: Re: Connections to data sources [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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 ?
>
 >> Stay informed about: Connections to data sources 
Back to top
Login to vote
Mary Chipman [MSFT]

External


Since: Feb 04, 2005
Posts: 51



(Msg. 4) Posted: Mon Jun 16, 2008 11:59 am
Post subject: Re: Connections to data sources [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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 ?
>>
 >> Stay informed about: Connections to data sources 
Back to top
Login to vote
Eric Russell

External


Since: Jun 19, 2008
Posts: 37



(Msg. 5) Posted: Thu Jun 19, 2008 1:50 pm
Post subject: Re: Connections to data sources [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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 ?
> >
 >> Stay informed about: Connections to data sources 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SSIS ODBC Data Flow Sources - I need to use SSIS to pull data from RBASE into SS2005. I was able to create a source connection easily enough as the DSN's were available in the dropdown list. My problem is I'm not seeing a Data Flow Source to use with an ODBC connection. Any..

Move Data Sources (ODBC) to another machine - Hello sorry if this is a novice question but is there a way to move all of the 'Data Sources (ODBC)' in WinXP's Control Panel -> Administrative Tools settings to another machine? There are numerous System DSN data sources set up in there and was..

install ODBC connections with login scripts or GPO - Is there any way to add our standard System DSN or equiv, ODBC connections on XP clients via scipt or GPO? THis cannot be the first time this question has been asked but I cannot find a satisfactory answer. Thanks in advance!

Editing Data - I am new to SQL so please be patient. I have a database in SQL 2000. When I expand the Database, Tables window, I right click on a table and select return all rows. When I try to edit data in some of the fields it tells me, "Transaction cannot...

Err Msg: String data, right truncation - Fieldname: Description - varchar(100) I tried to insert a record together with the above field - Description - in Chinese characters. Once I enter the Chinese characters more than 50 characters, the err msg promt out : "[ODBC SQL Server Driver]Str...
   Database Forums (Home) -> ODBC All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]