I use SQL Server about 90% of the time and have never had any problems
reversing on 2000, 2005 or 2008. I always use the SQL Native Drivers
(Either "SQL Native Client" or "SQL Server Native Client 10"), so that
driver should work fine. I try to avoid the "SQL Server" driver as I've had
problems with it in the distant past. You may want to give it a shot though
I also only use machine data sources. Also make sure you are selecting the
correct owner once you connect. I occationaly forget and get a little start
when the database I've been working on looks blank. LOL.
I do get similar issues with Oracle when I have Oracle Enterprise Manager
installed. It needs a little more than basic privileges and for some reason
seems to impact PD.
The only issues I've had with going through through ODBC is in generating
test data. For some reason it will throw a connection refused type of error
seemeingly at random. I've seen this for a long time. (maybe all the way
bask to 10.5?)
<Sandra> wrote in message news:49ee38cc.38e7.1681692777@sybase.com...
> First time I have tried reverse engineering a SqlServer 2005
> database since upgrading to PD15 (and installing EBF 16734)
>
> When I select the database I get Error
> Unable to list the tables
> [Microsoft][SQL Native Client][SQL Server]Statement(s) could
> not be prepared.
> SQLSTATE = 37000
>
> This error occurs on the Tables, system tables and triggers
> tabs
>
> All other tabs either diasplay content (views, users, roles,
> domains, procesures, storage, end points and queue) or are
> blank with no content.
>
> I suspect an error in my sqlsv2k5.xdb - has anyone else
> found this and worked out what fix is needed?
>
> Thanx
> Sandra
|