Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Openrowset datatype issues

Author  Topic 

rcurrey
Starting Member

30 Posts

Posted - 2007-05-23 : 11:49:54
We have a stored procedure that does an Openrowset to a AS/400 ad returns data to a Crystal XI report. The original sproc in production runs successfully and returns appropriate data. When we go into dev and recreate the sproc, Crystal XI then thinks that the data types for ALL columns being returned are number, including Description fields.

Has anyone run into this before? If so, what did you do to get around this?

Thanks in advance for any help available.

Rich

Thanks,
Rich
   

- Advertisement -