Re: No SQL OLE DB connectivity

• Previous message: Marc: "Using Excell in C# OleDbException on connection.Open"
• In reply to: farqua: "Re: No SQL OLE DB connectivity"
• Next in thread: farqua: "Re: No SQL OLE DB connectivity"
• Reply: farqua: "Re: No SQL OLE DB connectivity"
• Messages sorted by: [ date ] [ thread ]

Date: Thu, 8 Apr 2004 15:10:12 -0400

Did you try everything I suggested? Renaming the dlls (they're in System32,
and they're not ActiveX DLLs so using regsvr32.exe is pointless) will work,
but Windows file protection will keep overwriting...you can install MDAC 2.8
in safe mode, too.

-- 
Regards,
John Boatner
MCSD, MCDBA, MCSE, MCSA, MCDST
J2 Technologies, Inc.
http://www.j2tech.com
"farqua" <farqua@news.com> wrote in message
news:pan.2004.04.07.19.24.21.166885@news.com...
> On Tue, 06 Apr 2004 22:49:17 -0400, John Boatner, MCSD, MCDBA, MCSE, MCSA,
> MCDST wrote:
>
> > The behavior you are experiencing is probably caused by DLLs not being
> > registered (specifically SQLSRV32.DLL and ODBCBCP.DLL). You can try
> > installing the MDAC (http://www.microsoft.com/data) 2.7 SP1 Refresh, or
2.8
> > (I recommend 2.8).  If running the MDAC setup doesn't cure this, try
> > renaming SQLSRV32.DLL and ODBCBCP.DLL in the %winroot%\system32 folder,
and
> > sqloledb.dll and oledb32.dll in %ProgramFiles%\Common Files\System\Ole
DB -
> > then try the installer again.
> >
> > As a last resort, extract MDAC_TYP.EXE to a temp folder (e.g.,
mdac_typ.exe
> > /t:c:\mdac_tmp) - open the temp folder where you extract mdac in
Explorer,
> > then right click on SQLNET.INF and select Install - this will "force
feed"
> > the SQL Net libraries into Windows.
> >
> > Regards,
> > John Boatner
> > MCSD, MCDBA, MCSE, MCSA, MCDST
> > J2 Technologies, Inc.
> > http://www.j2tech.com
> >
> >
> > "farqua" <farqua@news.com> wrote in message
> > news:pan.2004.04.04.07.31.02.941196@news.com...
> >> I've loaded MSDE from the Office Pro 2003 CD onto my XP box. I haven't
> >> been able to get MS Access to connect with the MS SQL Server at all. In
> >> researching through Microsoft's site I find a test of the SQL OLE DB
> >> provider where I create an empty desktop text document called Test.udl
and
> >> double click it. When I double click it, I get an error about not
having a
> >> provider. I would like to know how I can add or start the provider so
that
> >> I can use MSDE.
> >>
> >> Thanks
>
> I've tried multiple times to reload MDAC 2.8 to no avail. I even tried
> MDAC 2.7. When I tried to register the dll's I get a dialog box message
> that the dll was loaded but, "DllRegisterServer entry point was not found.
> This file cannot be registered." I tried renaming and reloading the MDAC.
> I tried extracting MDAC to a directory and forcing the SQL Net libraries.
>
> Unfortunately, I'm in some kind of configuration hell.
>
> What's interesting is that I can actually access the MS SQL Server using
> osql and can actually create databases and tables using the commandline.
> However, I think I'm more productive using MS Access, especially since I
> am trying to convert an existing MS Access databases to MS SQL Server.
>
> I notice that I have ODBC connectivity (if the test connection is
> correct). But I am unable to get in using ODBC.

• Previous message: Marc: "Using Excell in C# OleDbException on connection.Open"
• In reply to: farqua: "Re: No SQL OLE DB connectivity"
• Next in thread: farqua: "Re: No SQL OLE DB connectivity"
• Reply: farqua: "Re: No SQL OLE DB connectivity"
• Messages sorted by: [ date ] [ thread ]