Page 1 of 1
Retrieve Columns not working
Posted: Thu Nov 20, 2008 3:56 am
by spencer
Hello,
I have added a new sqlconnection to my designer. And then I added a new Data Source that uses this connection. I set the connection name, alias and the query text to a simple valid sql string. After this when I click on Retrieve Columns the screen flickers for a second but no columns are retrieved. When I add a valid column by hand the report successfully displays its values.
Could you please let me know what I am missing?
best regards
Retrieve Columns not working
Posted: Fri Nov 21, 2008 2:57 am
by Edward
Hello.
A question about that SQL query. Is there a stored procedure in your query? Does it use temporary tables/variable number of columns?
Thank you.
Retrieve Columns not working
Posted: Fri Nov 21, 2008 3:37 am
by spencer
No, the query is SELECT * FROM AIRLINE where AIRLINE is a table with 8 simple columns.
Retrieve Columns not working
Posted: Sun Nov 23, 2008 11:41 am
by Edward
Hello.
Please let us know the type of the Connection in Web Designer and name of the server you connected to.
Thank you.
Retrieve Columns not working
Posted: Mon Nov 24, 2008 12:00 pm
by spencer
The type of connection is SQL Connection and the name of the server is the IP address of our internal SQL 2005 Server.
I can see that it tries to retrieve the columns because a progress bar comes up and then no error comes up and no columns are retrieved in the end.
Retrieve Columns not working
Posted: Tue Nov 25, 2008 6:05 pm
by Edward
Hello Spencer.
Could you please send the script for creating of that table to support[at]stimulsoft.com. We checked 'Retrieving Columns' button and all worked as expected...
Thank you.
Retrieve Columns not working
Posted: Thu Nov 27, 2008 4:37 am
by spencer
Hello the script for the table is this:
CREATE TABLE [dbo].[AIRLINE](
[AIRLINE_ID] [char](3) COLLATE Turkish_CI_AS NOT NULL,
[NAME] [varchar](50) COLLATE Turkish_CI_AS NOT NULL,
Code: Select all
[char](3) COLLATE Turkish_CI_AS NOT NULL,
[COMPANY_URL] [varchar](255) COLLATE Turkish_CI_AS NOT NULL,
[PARSER_BASE_URL] [varchar](255) COLLATE Turkish_CI_AS NOT NULL,
[RESULTS_URL] [varchar](255) COLLATE Turkish_CI_AS NULL,
[TABLE_SEARCH_REGEXP] [varchar](20) COLLATE Turkish_CI_AS NULL,
[EXTRA_TAX] [numeric](18, 2) NULL,
[BATCH_SIZE] [int] NOT NULL,
[PACKAGE_GUID] [varchar](50) COLLATE Turkish_CI_AS NULL,
[IS_ACTIVE] [bit] NOT NULL CONSTRAINT [DF_AIRLINE_IS_ACTIVE] DEFAULT ((1)),
[DATE_FORMAT_CODE] [tinyint] NOT NULL CONSTRAINT [DF_AIRLINE_DATE_FORMAT_CODE] DEFAULT ((112)),
CONSTRAINT [PK_AIRLINE] PRIMARY KEY CLUSTERED
(
[AIRLINE_ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
It is on an sql 2005 database with TURKISH_CI_AS as its collation. Would this info be sufficient?
Retrieve Columns not working
Posted: Thu Mar 26, 2009 5:22 am
by Phoenix
I'm also having the same issues with the column recieve
Retrieve Columns not working
Posted: Thu Mar 26, 2009 1:08 pm
by Jan
Hello,
This is knowing bug of 2008.2 version. Please get latest prerelease build from our website.
Thank you.