"SangHunJung" <SangHunJung@discussions.microsoft.com> wrote in message
news:6C155DA0-52B3-4B82-A5F2-0B949BF64C21@microsoft.com...
> Okay, I posted it there.
> However this seems like Win 2003 server 64bit issue. The reason is I
> don't
> see any other ODBC drivers except SQL Native Client and SQL Server.
> Normally, when creat a new data source, I would have a list of drivers to
> select such as, microsoft excel, access, Fox Pro, etc. I don't see any of
> them except two SQL driver. I think this is some thing to do with MDac
> but
> there is no way I can uninstall MDAC and reinstall. Is there any way to
> do
> that?
>
> Thanks,
> Sunny
>
> "Brian Lawton" wrote:
>
>> Since SQL 2005 is still in beta, you'll want to post this in the
>> Community
>> Newsgroups:
>>
>> http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us
>>
>>
>> --
>> --Brian
>> (Please reply to the newsgroups only.)
>>
>>
>> "SangHunJung" <SangHunJung@discussions.microsoft.com> wrote in message
>> news:0270474D-18E6-400F-A5AF-1C3C457A0400@microsoft.com...
>> > Hello folks,
>> > I have an issue with ODBCJT32.DLL on a Itenium server that Yukon i64
>> > (April
>> > CTP)running on 64 bit Windows 2003 SP1 server. When we try to run a
>> > distributed query that needs this driver SQL gives the following error:
>> >
>> > Msg 7403, Level 16, State 1, Line 1
>> > The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
>> >
>> > I ran component checker and it found ODBCJT32.DLL as registered to
>> > system.
>> > However, I realized that MSJET40.DLL is not registered, didn't see it
>> > from
>> > comp checker either. So I tried to install MDAC 2.8 SP8
>> > (KB829558-ia64)
>> > but
>> > it returns "There is no need to install this SP because setup has
>> > detected
>> > that the system is newer than the update you are applying"
>> >
>> > Now, my last card is manually register MSJET40.DLL to system. What do
>> > you
>> > think? Any insight would be helpful.
>> >
>> > Thanks in advance.
>> > Sunny Jung
>> >
>>
>>
>>

"Mike Epprecht (SQL MVP)" wrote:

> Hi
>
> Most of those drivers have not been ported to 64bit, so you won't see them.
> All what I've seen is UDB/DB2, Oracle, Sybase and SQL Server 64 bit drivers
> for 64 bit Windows.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "SangHunJung" <SangHunJung@discussions.microsoft.com> wrote in message
> news:6C155DA0-52B3-4B82-A5F2-0B949BF64C21@microsoft.com...
> > Okay, I posted it there.
> > However this seems like Win 2003 server 64bit issue. The reason is I
> > don't
> > see any other ODBC drivers except SQL Native Client and SQL Server.
> > Normally, when creat a new data source, I would have a list of drivers to
> > select such as, microsoft excel, access, Fox Pro, etc. I don't see any of
> > them except two SQL driver. I think this is some thing to do with MDac
> > but
> > there is no way I can uninstall MDAC and reinstall. Is there any way to
> > do
> > that?
> >
> > Thanks,
> > Sunny
> >
> > "Brian Lawton" wrote:
> >
> >> Since SQL 2005 is still in beta, you'll want to post this in the
> >> Community
> >> Newsgroups:
> >>
> >> http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us
> >>
> >>
> >> --
> >> --Brian
> >> (Please reply to the newsgroups only.)
> >>
> >>
> >> "SangHunJung" <SangHunJung@discussions.microsoft.com> wrote in message
> >> news:0270474D-18E6-400F-A5AF-1C3C457A0400@microsoft.com...
> >> > Hello folks,
> >> > I have an issue with ODBCJT32.DLL on a Itenium server that Yukon i64
> >> > (April
> >> > CTP)running on 64 bit Windows 2003 SP1 server. When we try to run a
> >> > distributed query that needs this driver SQL gives the following error:
> >> >
> >> > Msg 7403, Level 16, State 1, Line 1
> >> > The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
> >> >
> >> > I ran component checker and it found ODBCJT32.DLL as registered to
> >> > system.
> >> > However, I realized that MSJET40.DLL is not registered, didn't see it
> >> > from
> >> > comp checker either. So I tried to install MDAC 2.8 SP8
> >> > (KB829558-ia64)
> >> > but
> >> > it returns "There is no need to install this SP because setup has
> >> > detected
> >> > that the system is newer than the update you are applying"
> >> >
> >> > Now, my last card is manually register MSJET40.DLL to system. What do
> >> > you
> >> > think? Any insight would be helpful.
> >> >
> >> > Thanks in advance.
> >> > Sunny Jung
> >> >
> >>
> >>
> >>
>
>