[dba-SQLServer] linking back...

yeah,
  I meant that i'm trying to create a linked database to an Access 2000 jet
database.  I wasn't able to do it from our new windows 2008 r2 cluster, so I
had to use our 2005 system instead which does have the jet drivers on it,
but then that's a windows 2003 server as well :|,   There is not really much
I can do but to use it this way and figure out how to get the jet drivers to
show up in windows 2008r2, but maybe later as this project was due on Friday
:-/, linking the data was just the beginning...




-Francisco
http://bit.ly/sqlthis   | Tsql and More...
<http://db.tt/JeXURAx>




On Mon, Sep 12, 2011 at 1:03 AM, Mark Breen <marklbreen at gmail.com> wrote:

> Hello Francisco,
>
> Do you mean that SQL Server can link to a Jet db?  If so, I did not know
> that.
>
> Or are you attempting something else?  I presume that you do not want to
> install Office ?
>
> Mark
>
>
>
>
> On 6 September 2011 22:27, Francisco Tapia <fhtapia at gmail.com> wrote:
>
> > I thought I had a grasp of this but there is something wrong with my
> > machine
> > and the new sql server 2008 r2 cluster :-|.  I have a vendor specific
> > Access
> > Database which I must link down to vs Upsizing, the vendor doesn't
> support
> > the upsize, but being that I'm on a new OS and the culster is on 2008, I
> > don't see the drivers for the jet engine... :-| anyone been through this
> > hoop?
> >
> >
> > arg!
> >
> >
> > -Francisco
> > http://bit.ly/sqlthis   | Tsql and More...
>
>