[dba-SQLServer] linking back...

ok,
  there is a project property to set the ssis project to 32bit mode... that
seems to take care of this issue.. thanks guys :)

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




On Tue, Sep 13, 2011 at 9:44 AM, Francisco Tapia <fhtapia at gmail.com> wrote:

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