OLEDB and Subreports not returning data

[N11689]

We are using Crystal 9, OLE DB connection to SQL Server.

In a report, I have two subreports. One points to a SQL table, the other to a SQL stored procedure. I have made changes to the SQL table and to the SQL stored procedure.

Now, in our database, there is an original copy of the table and the stored procedure under dbo, and there is the modified table and stored procedure listed under my id.

I have set datasource location in each subreport so that they point to my version of the table and stored procedure.

When I run the report through Crystal developer, it picks up my version of the table and stored procedure. Everything works fine.

When I run the report through my VB application, the subreport with the stored procedure works correctly. It uses my changed version of the stored procedure. However, the subreport with the table is running the dbo copy of the table, not my version of the table. Why? I did set datasource location to my version of the table. The VB app we use logs into the subreports the same way.

What could be the problem? Any ideas?

Thanks.

 

[synapsevampire]

Here's a whitepaper that might help:

http://support.crystaldecisions.com/library/kbase/articles/c2012058.asp

-k

 

[N11689]

I've looked at the whitepaper, and it looks as though we are using the connectionproperties correctly.

I mean, the subreports that use a stored procedure as the database use the correct version of the stored procedure.
However, the subreports that just have a table as the database are still looking to the dbo copy only. They are not looking to the specific version the datasource was set to.

Any other thoughts? Thanks.