[dba-SQLServer] linking back...

This is part of my error when I was trying to get a link back to jet, as it
turns out my server is windows 2008 R2 (64 bit) along with Sql Server 64bit
and the error I get is: when I try to use SSIS to push out a simple update
table package :-|

The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered --
perhaps no 64-bit provider is available.  Error code: 0x00000000.


any ideas?

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




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

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