EntMgr "Provider could not be found"

When doing open table-return rows - got the above
message... is this some sort of ODBC problem? thx
I'm having same problem,
"Shelley" wrote:

> When doing open table-return rows - got the above
> message... is this some sort of ODBC problem? thx
>
sql

EntMgr "Provider could not be found"

When doing open table-return rows - got the above
message... is this some sort of ODBC problem? thxI'm having same problem, :(
"Shelley" wrote:
> When doing open table-return rows - got the above
> message... is this some sort of ODBC problem? thx
>

Enterprise Manager connection question ..

Hi ;)

I have a database on my server provider ..and i connect via Enterprise Manager ...the thing i want to know is if theres a way to connect direct to my own database ..instead of having all databases in the tree layout and then selecting mine

is there a way in Enterprise Manager to point the Register Sql Server direct to my database ??

Thanksyes, you can create groups at the top of the tree. So I have "Local" and "Others". That way I don't see, or try to comm to, the ones in the "other" node when I look at my "local" one

enterprise manager "return all rows" error

in enterprise manager, when i select a table and "return all rows" or "query" , SQL returns an error "provider cannot be found". I can successfully run a query in query analyzer. I've reinstalled SQL and it's still not working. It seemed to be working fine a couple weeks ago when i was working on crystal reports.Hi,
It could be an MDAC problem. Try loading the MDAC for the version of SQL
you are using.
I hope this helps
regards
Greg O MCSD
http://www.ag-software.com/ags_scribe_index.aspx. SQL Scribe Documentation
Builder, the quickest way to document your database
http://www.ag-software.com/ags_SSEPE_index.aspx. AGS SQL Server Extended
Property Extended properties manager for SQL 2000
http://www.ag-software.com/IconExtractionProgram.aspx . Free icon extraction
program
http://www.ag-software.com. Free programming tools
"az" <anonymous@.discussions.microsoft.com> wrote in message
news:8E3D5D69-C0E8-43D6-BE2C-8D24DE519A6D@.microsoft.com...
> in enterprise manager, when i select a table and "return all rows" or
"query" , SQL returns an error "provider cannot be found". I can
successfully run a query in query analyzer. I've reinstalled SQL and it's
still not working. It seemed to be working fine a couple weeks ago when i
was working on crystal reports.
>