I cant see table in sql server dataset with birt!!!

First off all sorry for my poor english :-(
is first time that I Use Birt so I've some problem..............
I've installed on Win 2003 Server:
SqlServer2005, sqljdbc_2.0 and birt-rcp-report-designer-2_5_1,
I've managed the new driver JDBC for sql server inside birt, then using this driver I've created a new datasource for sqlserver2005,the test connection is OK!
The problem start when I try to create a dataset from my new datasource, instead of the tables I see other objects, it seem schemas like (dbo,guest,db_owner,etc..) but what is this? I want my tables, I'm looking for them, exploring this tree but I have not found ....
Someone can help me please!!!
I'm desperate......
Thanks in advance

Polliux77......

Find more posts tagged with

Comments

mwilliams

Hi Polliux77,

Are these items that you listed above possible schemas from your database? Just not the tables you're looking for? If so, there is a limit that can be set as to the amount of schemas that are shown in the dataSet editor window. You can still use all the tables from the database, they just aren't shown in the editor. To change this value, you go to Window -> Preferences -> Report Design -> Data Set Editor -> JDBC Data Set, then set the max number of schemas to show. Let me know if this helps or not.

rtruban

In you data set you have the option of choosing which schema, so pick the schema you want to query against, and you have 'Type' which is set to a'-All-' by default. Switch Type to 'Table' and it will only show tables in the available items list.

hope that helps!

polliux77

Thank for your reply, now i try your suggestions and then I tell you the result,
thanks for now..........

polliux77

Ok mwilliams I understand what you're saying, but my problem is another one, my tables in sqlserver db are under the dbo schema, in birt, when i try to create my dataset, i can see the dbo schema, but under the schema there is no my tables, i can't see my tables; i don't know may be a driver problem?
But connection is okay and I see the schema, my only problem is that my tables there are not visible, is as if not there were...

polliux77

<blockquote class='ipsBlockquote' data-author="rtruban">In you data set you have the option of choosing which schema, so pick the schema you want to query against, and you have 'Type' which is set to a'-All-' by default. Switch Type to 'Table' and it will only show tables in the available items list. 
 
hope that helps!</blockquote>
 
thank for reply but my problem is another one you can see more info in my previous message! 
 
thank again.

mwilliams

polliux77,

There is also a limit on that same page in the preferences for the number of tables under a specific schema. If you have many tables in that schema, maybe yours are getting left out in the display. I think the default is 100 tables, but I could be wrong. If your table is just getting left out of the display, you'd still be able to query against it because the table is loaded, it's just not listed. But, if you've got a lot of tables in that schema, try going to that preferences page and changing the value for that as well.

p.K

I had a <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/36725-data-set-wizard-doesnt-show-tables-for-oracle-jdbc-data-source/'>similar problem</a> but it was caused with JDBC drivers.