I am having some problem on Data Link properties about the connection option for “Microsoft OLE DB Provider for SQL Server” (Reverse Engineering Wizard" -> Data Link Properties).
At the moment I chose “Connection via ADO” -> then on “Data Link Properties” on the “Provider” tab I chose SQL Native Client and enter the correct Data Source name, it works fine.
But When i change the provider to “Microsoft OLE DB Provider for SQL Server”, when I click on the drop down list about “Use data source name” / the “Refresh” button it come up an error message. Please find the attachment for more information. I am wondering if it is a problem cause by my computer, because of using SQL SERVER 2005 Express edition? or it is a bug? As the error message display (Error enumerating data servers. Enumerator reports ‘Unspecified error’ )
Please let me know if you want me to explain more.
query.sql (7.83 KB)