I want to use a stored procedure as my data source, but when I set up an ODBC connection, I am unable to see the stored procs under that connection. I do have stored procedures checked off in the options, but they are not appearing. I can see system tables, user tables, and views, but no stored procs. Is this a limitation of the ODBC connections in Crystal Reports 9.0, or am I missing a step somewhere along the way?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ODBC Connection Question
- Thread starter jhein
- Start date
synapsevampire
Programmer
I haven't heard of this limitation, but try setting up an OLE DB connection to test if it's ODBC related.
Also, make sure that you use the CR supplied ODBC drivers.
-k kai@informeddatadecisions.com
Also, make sure that you use the CR supplied ODBC drivers.
-k kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question