[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [Newsgroup Home]
[news.eclipse.birt] Re: BIRT 2.3.1 using connection profile, no SQB

Using the Data Source Explorer view to create a postgres connection profile 
would work, but not really required.
Alternatively,
>>> 1 -  create a new datasource
>>> 2 -  choose the radial for create connection from connection profile
>>> 3 -  Select next, then new.
>>> 4a -  In the "Create a Connection Profile Store" dialog, select "New..." 
>>> button
        4b - In the "New Connection Profile" dialog, select PostgreSQL, 
press Next to specify your JDBC driver definition and connection profile 
properties.  Press Finish.
        4c - The connection profile that you just created is now added to 
the check box list.  Select the checkbox of that profile.
>>> 5 -  Put in a file name, such as c:/tmp/myprof
>>> 6 -  Finish

Linda

"Jason Weathersby" <jasonweathersby@xxxxxxxxxx> wrote in message 
news:gef3o8$oh8$1@xxxxxxxxxxxxxxxxxxxx
> postgres should work as well.  Can you try to open the Data Source 
> Explorer view:
> window->show view->other->Connectivity->Data Source Explorer
>
> and add your data source under databases.  As a test supply username and 
> password.  Once you create it swap step 4 with your new database.
>
> Jason
>
> jackh wrote:
>> Yes that works.  My db is postgres.  Is it a bug?
>>
>>
>> "Jason Weathersby" <jasonweathersby@xxxxxxxxxx> wrote in message 
>> news:geclfa$a68$1@xxxxxxxxxxxxxxxxxxxx
>>> Can you try the following:
>>> 1 -  create a new datasource
>>> 2 -  choose the radial for create connection from connection profile
>>> 3 -  Select next, then new.
>>> 4 -  Choose BIRT Classic Models Sample Database
>>> 5 -  Put in a file name, such as c:/tmp/myprof
>>> 6 -  Finish
>>>
>>> create a dataset and see if the SQB is available.
>>>
>>> Jason
>>>
>>> jackh wrote:
>>>> I've tried with both RCP and the all-in-one.  I'm creating a new 
>>>> dataset off of a datasource from a connection profile.  The new sql 
>>>> query builder (SQB) is not there.  It only has the old manual SQL entry 
>>>> tool.  Any ideas??
>>>>
>>>> Thanks
>>