ODBC and Stored Procs Question

[jhein]

I am using Crystal Reports 9.0 and I want to use a stored proc as my data source. I set up an ODBC connection and I have SP's checked off in the options, but I don't see stored procs under my connection. I can see system and user tables along with views, but no stored procs. Is there a step that I am missing somewhere along the line or is the ODBC connection limited in such a way that the SP's won't show up?

 

[pelajhia]

I'm on 8.5 standard w/ODBC, and I just checked to see if I clicked 'stored procedures' in options if this effectively showed the procedures on the fly. I had no problems seeing the sp's in a separate folder:
__-databasename
+___Tables
+___Stored Procedures

Have you verified that you have definitely created at least one stored procedure for that datasource?

 

[jhein]

There are about 75 stored procedures there, so that shouldn't be the issue at all. Thanks for trying though, I appreciate it.

 

[synapsevampire]

In the Data Explorer, select Options->Show Stored Procedures, this is what pelajhia was referring to.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[jhein]

I already have that checked off...this is why I am very puzzled as to why it isn't working.

 

[synapsevampire]

I responded to your other post, are you using the CR ODBC driver?

Have you tested with OLE DB?

Are you certain that it isn't a permissions issue?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[jhein]

I have tested with OLE DB and I am able to see the stored procs. Maybe it has an issue with the DSN I have set up on my local machine. Anyway, we have decided that instead of spending too much time trying to figure out the ODBC issue, we are just going to use OLE DB. Thanks for your help, it's too bad I don't have the time to keep digging into this, I would really like to know what's happening.