I connect to a remote SQL Server using Enterprise Manager. The database opens well, but when I try to see the date in the tables (using "Open Table/Return All Rows"
, I get the error:
"Provider not found. It may not be properly installed."
I went to Microsoft's site for this and it asked me to run
"regsvr32 sqloledb.dll". Even after I did that, the problem persists. Should I run that command on my machine or the machine i am trying to remotely connect to? Is there any other way I can try to solve this.
I am using the 120-day trial version of MS SQL 2000 server available on Microsoft's site.
, I get the error:"Provider not found. It may not be properly installed."
I went to Microsoft's site for this and it asked me to run
"regsvr32 sqloledb.dll". Even after I did that, the problem persists. Should I run that command on my machine or the machine i am trying to remotely connect to? Is there any other way I can try to solve this.
I am using the 120-day trial version of MS SQL 2000 server available on Microsoft's site.