[dba-SQLServer] linking back...

hmm, I hadn't thought of doing that, I certainly have access to the jet
database drivers via ssis.

I'll re-work my solution to run off a ssis package instead... Thanks Dave!

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


On Mon, Sep 12, 2011 at 2:56 PM, David McAfee <davidmcafee at gmail.com> wrote:

> 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...
> > >
>