Class not registered

[Guest]

Hi Every one,

I am developing web application using c# in Visual Studio 2005 Beta 1. When
I try to connect my SQL database, I am getting error
"System.Data.OleDb.OleDbException: Class not registered". My database is in
Sql Server 2000. I am using OLEDB namespace. For some specific business need
I am using oledb namespace instead of sql name space of system.data. Can any
body help me in resolving this.

Thanks in advance.
Shailesh.

 

[harmeet]

use System.Data.SqlClient namespace to connect with SQL Server 7.0 or Later.

 

[Guest]

Harmeet,

I have to use OLEDB namespace instead of SqlClient due to some specific
reason. I know if I use SqlClient namespace instead OLEDB then I wan't be
having any problem.

 

[Carlos J. Quintero [.NET MVP]]

Try to re-register (using regsvr32.exe) the SQL Server OLE DB provider:

C:\Program Files\Common FIles\System\Ole DB\sqloledb.dll

If that fails, reinstall the whole MDAC package.

You can also spy registry activity with regmon.exe (www.sysinternals.com) to
get the name of the class not registered and get a clue about its COM dll.

You can also reinstall VS 2005 Beta 1, or better yet, to install VS 2005
Beta 2.

--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com

 

[Guest]

Hi Carlos,

first of all thnx for ur reply.
Carlos can u tell me which version of MDAD I need to re-install. And how can
I konw the current intalled MDAC's version.

Thnx

 

[Carlos J. Quintero [.NET MVP]]

AFAIK, MDAC 2.8 is the latest:
http://www.microsoft.com/downloads/...E3-C795-4B7D-B037-185D0506396C&displaylang=en

You can know the one installed through
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess registry entry.
--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com

 

[Guest]

Hi Carlos,

I re-installed MDAC 2.8, and now its working fine.

Thnkx for ur kind help.
Shailesh.