MDAC -- error enumerating data servers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having a problem using the Database wizard in Visual Studio 2003
(Academic version) to connect in a very basic way (not even any code yet) to
SQLEXPRESS, the only available version of SQL Server 2005 out so far. I was
running MDAC 2.7 XP SP 1 on Windows XP Pro and thought that maybe pulling
down a recent refresh for 2.7 might help (it didn't). So I went ahead and
upgraded to 2.8 and still have the error message 'error enumerating data
servers'. I know my databases are up and running because my management
console tells me so. The whole environment is local to my machine and I
don't think it's a permission problem. I'm wondering if maybe the fact that
Studio runs on .NET framework 1.1 and SQL Server 2005 express is running on
framework 2.x might be part of the problem but have no information so far
that confirms for me that trying to run Visual Studio on framework 2.x will
improve the situation. Component Checker was showing me just a few MDAC
mismatches on 2.7 but 2.8 is showing heavy mismatches ... too many to mention
and I couldn't say which ones are relevant anyway (but no change to the error
message so if something else is broken I'm not suffering from it yet). When
I search for oledb32.dll in the registry, I can't find it (though it is in my
file system) so I'm having trouble figuring out how to register it if it
isn't there now ... Many thanks for any help.
 
Stephanie,
I am going just make a guess here. SQLEXPRESS doesnt listen on TCP by
default, could this be your problem. Can you enable TCP for SQLEXPRESS on
your local machine?
 
Hi Sushil,

I don't believe connectivity is the problem because I have the new computer
manager and have made sure that TCP/IP for both client and server
(SQLEXPRESS) are Enabled. In addition, other things like Jet are working
just fine. I still think it might be a drivers problem in that I might be
missing a DLL somewhere ... when I go to the XP Pro control panel ->
Administrator tools -> data sources (ODBC) and search under the drivers tab
there for OLEDB32.dll, it's not there nor is it in my system32 folder or
elsewhere. I think that this dll is required as well as possibly a .lib
file, and I don't seem to be able to get it in successfully by changing my
version of MDAC around. I had a similar problem with MySQL recently and was
able to find and download the correct MySQL drivers from the MySQL site at
which point my registry was correct as well as my control panel. However,
MySQL isn't the solution I prefer and I think there must be a solution for
the Microsoft problem that I'm just missing somehow.

Thanks,
Stephanie

Sushil Chordia said:
Stephanie,
I am going just make a guess here. SQLEXPRESS doesnt listen on TCP by
default, could this be your problem. Can you enable TCP for SQLEXPRESS on
your local machine?
Click to expand...
 
Back
Top