SQL Server ODBC Connection only showing stored procs

[lunchbox88]

Crystal Reports 8.5 Pro, 10 Pro, and 11 Pro...

When connecting to a SQL Server 2000 database via ODBC, only the stored procedures are showing in the Database Expert window. It's only one database that's doing this. Other SQL Server 2000 database will show tables as well.

Any ideas as to what could be causing this?

Thanks!

 

[MisterMo]

Permission rights?

Mo

 

[lunchbox88]

It's not the permission rights. I just gave myself full permissions, and it's still doing the same thing.

I had seen this happen before with Oracle databases, and I can't remember what the resolution was.

Any other ideas?

 

[MisterMo]

check on the file>options>database with crystal sometimes depending on the settings you may or may not see tables, views or Stored Proc.

other than that check the settings on two of the databases databases to see what's different




Mo

 

[synapsevampire]

Sounds like permissions to me...

Can you query the tables of that database using the same login account from Query Analyzer?

-k

 

[lunchbox88]

Yes, I can query those tables with the same login.

 

[synapsevampire]

ACK...

Well then, the only other thing I can think of is the "table name like" has a setting, I've never heard of this before, sorry.

-k

 

[MisterMo]

Why don't you try and log to database using ADO and go stright to the server.

Mo