[dba-SQLServer] linking back...

Why not SSIS/DTS once per night/hour from the MDB into the SQL DB?


On Mon, Sep 12, 2011 at 2:23 PM, Francisco Tapia <fhtapia at gmail.com> wrote:

> 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...
> >
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>