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!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Seagate Info and SQL Server Stored Procedure

Status
Not open for further replies.
Fahim

Fahim

Programmer
Jul 4, 2001
6
AU
Hi
I have a crystal report that has a stored procedure as a data source. There are two date parameters I am passing as string. The report runs fine in CR 7.0. When I add the report to Seagate Info 7.0 the report does not return any data. I ran a trace on SQL Server and found that Seagate Info passes the parameters as NULL.
Are Stored Procedures with Parameters supported in Seagate Info 7.0?
Any help will be appreciated.
Thanks
Fahim
 
Sort by date Sort by votes
Sure they were supported. Although SI 7 no longer is by BO. Could be a known issue that a service pack resolved, but I doubt that you can find them now.

Perhaps you have different connectivity in SI?

Try putting CR 7 on the SI server and see if it runs there.


-k
 
Upvote 0 Downvote
I was using the PDsSQL.dll driver. I changed to PDsODBC.dll and created a DSN. It worked. Maybe it is a bug in SI.
Thanks for your reply
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

pcdudekc3585
  • Locked
  • Question
Seagate 7.5 info desktop
Replies
0
Views
247
pcdudekc3585
pcdudekc3585
eknight1010
  • Locked
  • Question
Seagate Info Desktop 7.5 - Can't view reports 5
Replies
15
Views
704
eruji
eruji
max10
  • Locked
  • Question
Seagate Info 7.5 Service pack 5
Replies
1
Views
289
nn1111
nn1111
mikekask
  • Locked
  • Question
Download Seagate Crystal SQL Designer
Replies
1
Views
349
mikekask
mikekask
matthewd2
  • Locked
  • Question
Locked out of Info Administrator
Replies
0
Views
253
matthewd2
matthewd2

Part and Inventory Search

Sponsor

Back
Top