Connectivity to Informix Database

I am evaluating MS SQL Server Reporting Services and during the process, I
encountered issues pertaining to connectivity with Informix Database.
I want to design a report by retrieving data from Informix
database. I have a code that generates the .RDL file (which is in XML
format). When I deploy the .RDL file on the server, it does so successfully.
But when I try to view it through the IE 6.0 its gives me an error -
An attempt has been made to use a data extension '****' that is not
registered for this report server. (rsDataExtensionNotFound)
How could I solve this problem ?
Hi
The account that is running the Reporting Server Service, does it have
permission to access the Informix database?
Is the Informix driver installed on the server? Have you checked
connectivity from the Web Server to the DB?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Skeptic45" <Skeptic45@.discussions.microsoft.com> wrote in message
news:AD68D8B3-0B49-488F-B09A-D41D129E6344@.microsoft.com...
> I am evaluating MS SQL Server Reporting Services and during the process, I
> encountered issues pertaining to connectivity with Informix Database.
> I want to design a report by retrieving data from Informix
> database. I have a code that generates the .RDL file (which is in XML
> format). When I deploy the .RDL file on the server, it does so
> successfully.
> But when I try to view it through the IE 6.0 its gives me an error -
> An attempt has been made to use a data extension '****' that is not
> registered for this report server. (rsDataExtensionNotFound)
> How could I solve this problem ?
>

Connection problem to Informix from SQL Server 2005 with Unicode data

I have Informix 9.4TC6 and SQL Server 2005.
DB_LOCALE in Informix DB is en_US.utf8 (en_US.57372).

First, I created DSN to Informix. Then tried to get data with WinSql
tool and it works fine.
But when I created linked server in SQL Server 2005 I have problems
with languages other than English.
I get a string like:
' -|工 1/4 1/43/4

It seems to me that SQL Server splits 2-byte characters in 2 1-byte
characters.
If in options of linked server we set Collation Name to exact
language
we want --then string data will be correct (of course only of
language that we choose).

Do you have any suggestions???

P.S. I don't want to use SSIS (DTS) for extraction from Informix DB(denis.carabadjac@.gmail.com) writes:

Quote:

Originally Posted by

I have Informix 9.4TC6 and SQL Server 2005.
DB_LOCALE in Informix DB is en_US.utf8 (en_US.57372).
>
First, I created DSN to Informix. Then tried to get data with WinSql
tool and it works fine.
But when I created linked server in SQL Server 2005 I have problems
with languages other than English.
I get a string like:
' ?-|工 1/4 1/4?3/4
>
It seems to me that SQL Server splits 2-byte characters in 2 1-byte
characters.
If in options of linked server we set Collation Name to exact
language
we want --then string data will be correct (of course only of
language that we choose).
>
Do you have any suggestions???

This looks like a difficult case. SQL Server does not support UTF-8.
You can set a server option, "Collation name" as you found, but that
should be a collation that exists in SQL Server, but SQL Server does
not have any UTF-8 collations.

I have no experience with Informix, but it seems to me that either you
need to find a way to convert UTF-8 to UTF-16, or you will have to
go over the file system. The tool BCP as well as the command BULK INSERT
is able to handle files with UTF-8 data.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx