Retrieve Columns not working

spencer · Post by **spencer** » Thu Nov 20, 2008 3:56 am

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

Post by **Edward** » Fri Nov 21, 2008 2:57 am

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.

spencer · Post by **spencer** » Fri Nov 21, 2008 3:37 am

No, the query is SELECT * FROM AIRLINE where AIRLINE is a table with 8 simple columns.

Post by **Edward** » Sun Nov 23, 2008 11:41 am

Hello.

Please let us know the type of the Connection in Web Designer and name of the server you connected to.

Thank you.

spencer · Post by **spencer** » Mon Nov 24, 2008 12:00 pm

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.

Post by **Edward** » Tue Nov 25, 2008 6:05 pm

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.

spencer · Post by **spencer** » Thu Nov 27, 2008 4:37 am

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?

Phoenix · Post by **Phoenix** » Thu Mar 26, 2009 5:22 am

I'm also having the same issues with the column recieve

Post by **Jan** » Thu Mar 26, 2009 1:08 pm

Hello,

This is knowing bug of 2008.2 version. Please get latest prerelease build from our website.

Thank you.