Connecting to SQL with VB.NET

  • Thread starter Thread starter TOM
  • Start date Start date
T

TOM

Hello, I am having problems with the server explorer
making a connection to the SQL server. I can see the
instances that i want to connect to but when i try this
error comes up PROVIDER CANNOT BE FOUND. IT MAY NOT BE
PROPERLY INSTALLLED.
I am programming on XP w\SP2 installed, I have MDAC 2.8
installed, i have SQL Client tools install.
When i installed VB on the server it worked fine. So I
think i am missing a piece, that will let VB talk to the
Server.

I could use any help or suggestions?

Tom
 
Try this:
CAUSE
This error occurs because a dynamic-link library (DLL) that is required by
the Microsoft Data Access Components is not registered.
RESOLUTION
NOTE: This resolution uses a SQL Server OLE Provider DLL (Sqloledb.dll) as
an example. Because the unregistered DLL may vary based on the OLE DB
Provider that you are using, modify step 2 accordingly.

To resolve this problem, reregister the faulty DLL as follows: 1. At a
command prompt, change to the C:\Program Files\Common Files\System\Ole DB
folder.
2. At a command prompt, type the following command:
regsvr32 sqloledb.dll
3. You should receive confirmation that the DLL is registered successfully.

For more information you can take a look in this link :
http://support.microsoft.com/default.aspx?scid=kb;en-us;278604

Thanks,

Elena Arzac


--------------------
 
Thanks it worked.

-----Original Message-----
Try this:
CAUSE
This error occurs because a dynamic-link library (DLL) that is required by
the Microsoft Data Access Components is not registered.
RESOLUTION
NOTE: This resolution uses a SQL Server OLE Provider DLL (Sqloledb.dll) as
an example. Because the unregistered DLL may vary based on the OLE DB
Provider that you are using, modify step 2 accordingly.

To resolve this problem, reregister the faulty DLL as follows: 1. At a
command prompt, change to the C:\Program Files\Common Files\System\Ole DB
folder.
2. At a command prompt, type the following command:
regsvr32 sqloledb.dll
3. You should receive confirmation that the DLL is registered successfully.

For more information you can take a look in this link :
http://support.microsoft.com/default.aspx?scid=kb;en- us;278604

Thanks,

Elena Arzac
Click to expand...
 
Back
Top