Home » Eclipse Projects » DTP » "No connection" on a database that I am connected to
|
| Re: "No connection" on a database that I am connected to [message #42414 is a reply to message #42354] |
Thu, 28 February 2008 16:01   |
Eclipse User |
|
|
|
Originally posted by: brianf.sybase.com
If you right-click on the SQL scrapbook in a blank space, you should see a
"Set Connection" menu item. Also, at the top there is a series of drop-down
lists to select the type of connection profile (Derby), name of th eprofile
(MyProfile), and if it's connected, it'll show "Status: Connected" in that
bar also.
Hope that helps.
--Fitz
"Gigaplex" <gigaplex08@gmail.com> wrote in message
news:fq5plc$g42$1@build.eclipse.org...
>I have been going through the wiki article to set up Derby with DTP for the
>first time:
> http://wiki.eclipse.org/index.php/Getting_Started_with_DTP
>
> I have everything set up and I can execute the stored procedure talked
> about in the article but when I try to execute my own sql as the article
> describes, it doesn't work. The sql is:
> SELECT * FROM SYS.SYSTABLES;
>
> In the results view, the status field on the left shows as failed and it
> says "no current connection" on the status tab to the right. I am
> definately connected since I can browse through the database in the Data
> Source Explorer and even execute stored procedures successfully. On my sql
> file I have specified all the information in the connection profile.
>
> I don't get it. Am I missing something here?
|
|
| |
| Re: "No connection" on a database that I am connected to [message #42490 is a reply to message #42436] |
Fri, 29 February 2008 02:22 |
 Jeff Lins
Messages: 39
Registered: July 2009 |
Member |
|
|
Using the "Set Connection" menu item worked. If I right click on the
connection in the DSE and connect that way, I cannot execute the query
but if I connect through the "Set Connection" menu item, the query will
work. Is this a bug? I can't imagine it's supposed to work that way. It
seems like I should be able to set the connection using the drop down
boxes at the top of the SQL scrap book and never have to use the "Set
Connection" menu item if I don't want to, right?
Gigaplex wrote:
> Yeah, I filled out the stuff at the top and it shows "Status:
> Connected" there. That's why I'm so confused by this. I haven't tried
> right clicking and using "Set Connection" though so I will give that a
> shot. Don't they do the same thing though?
>
> Brian Fitzpatrick wrote:
>> If you right-click on the SQL scrapbook in a blank space, you should
>> see a "Set Connection" menu item. Also, at the top there is a series
>> of drop-down lists to select the type of connection profile (Derby),
>> name of th eprofile (MyProfile), and if it's connected, it'll show
>> "Status: Connected" in that bar also.
>>
>> Hope that helps.
>> --Fitz
>>
>> "Gigaplex" <gigaplex08@gmail.com> wrote in message
>> news:fq5plc$g42$1@build.eclipse.org...
>>> I have been going through the wiki article to set up Derby with DTP
>>> for the first time:
>>> http://wiki.eclipse.org/index.php/Getting_Started_with_DTP
>>>
>>> I have everything set up and I can execute the stored procedure
>>> talked about in the article but when I try to execute my own sql as
>>> the article describes, it doesn't work. The sql is:
>>> SELECT * FROM SYS.SYSTABLES;
>>>
>>> In the results view, the status field on the left shows as failed
>>> and it says "no current connection" on the status tab to the right.
>>> I am definately connected since I can browse through the database in
>>> the Data Source Explorer and even execute stored procedures
>>> successfully. On my sql file I have specified all the information in
>>> the connection profile.
>>>
>>> I don't get it. Am I missing something here?
>>
>>
|
|
|
| Re: "No connection" on a database that I am connected to [message #42529 is a reply to message #42490] |
Fri, 29 February 2008 04:25 |
| Eclipse User |
|
|
|
Originally posted by: brianf.sybase.com
This certainly sounds like a bug. I'd register it against SQL Tools in DTP
if you could create a Bugzilla entry for it.
"Gigaplex" <gigaplex08@gmail.com> wrote in message
news:fq7qbc$468$1@build.eclipse.org...
> Using the "Set Connection" menu item worked. If I right click on the
> connection in the DSE and connect that way, I cannot execute the query but
> if I connect through the "Set Connection" menu item, the query will work.
> Is this a bug? I can't imagine it's supposed to work that way. It seems
> like I should be able to set the connection using the drop down boxes at
> the top of the SQL scrap book and never have to use the "Set Connection"
> menu item if I don't want to, right?
>
> Gigaplex wrote:
>> Yeah, I filled out the stuff at the top and it shows "Status: Connected"
>> there. That's why I'm so confused by this. I haven't tried right clicking
>> and using "Set Connection" though so I will give that a shot. Don't they
>> do the same thing though?
>>
>> Brian Fitzpatrick wrote:
>>> If you right-click on the SQL scrapbook in a blank space, you should see
>>> a "Set Connection" menu item. Also, at the top there is a series of
>>> drop-down lists to select the type of connection profile (Derby), name
>>> of th eprofile (MyProfile), and if it's connected, it'll show "Status:
>>> Connected" in that bar also.
>>>
>>> Hope that helps.
>>> --Fitz
>>>
>>> "Gigaplex" <gigaplex08@gmail.com> wrote in message
>>> news:fq5plc$g42$1@build.eclipse.org...
>>>> I have been going through the wiki article to set up Derby with DTP for
>>>> the first time:
>>>> http://wiki.eclipse.org/index.php/Getting_Started_with_DTP
>>>>
>>>> I have everything set up and I can execute the stored procedure talked
>>>> about in the article but when I try to execute my own sql as the
>>>> article describes, it doesn't work. The sql is:
>>>> SELECT * FROM SYS.SYSTABLES;
>>>>
>>>> In the results view, the status field on the left shows as failed and
>>>> it says "no current connection" on the status tab to the right. I am
>>>> definately connected since I can browse through the database in the
>>>> Data Source Explorer and even execute stored procedures successfully.
>>>> On my sql file I have specified all the information in the connection
>>>> profile.
>>>>
>>>> I don't get it. Am I missing something here?
>>>
>>>
|
|
| | |
| Re: "No connection" on a database that I am connected to [message #590269 is a reply to message #42436] |
Fri, 29 February 2008 02:22 |
Jeff Lins
Messages: 39
Registered: July 2009 |
Member |
|
|
Using the "Set Connection" menu item worked. If I right click on the
connection in the DSE and connect that way, I cannot execute the query
but if I connect through the "Set Connection" menu item, the query will
work. Is this a bug? I can't imagine it's supposed to work that way. It
seems like I should be able to set the connection using the drop down
boxes at the top of the SQL scrap book and never have to use the "Set
Connection" menu item if I don't want to, right?
Gigaplex wrote:
> Yeah, I filled out the stuff at the top and it shows "Status:
> Connected" there. That's why I'm so confused by this. I haven't tried
> right clicking and using "Set Connection" though so I will give that a
> shot. Don't they do the same thing though?
>
> Brian Fitzpatrick wrote:
>> If you right-click on the SQL scrapbook in a blank space, you should
>> see a "Set Connection" menu item. Also, at the top there is a series
>> of drop-down lists to select the type of connection profile (Derby),
>> name of th eprofile (MyProfile), and if it's connected, it'll show
>> "Status: Connected" in that bar also.
>>
>> Hope that helps.
>> --Fitz
>>
>> "Gigaplex" <gigaplex08@gmail.com> wrote in message
>> news:fq5plc$g42$1@build.eclipse.org...
>>> I have been going through the wiki article to set up Derby with DTP
>>> for the first time:
>>> http://wiki.eclipse.org/index.php/Getting_Started_with_DTP
>>>
>>> I have everything set up and I can execute the stored procedure
>>> talked about in the article but when I try to execute my own sql as
>>> the article describes, it doesn't work. The sql is:
>>> SELECT * FROM SYS.SYSTABLES;
>>>
>>> In the results view, the status field on the left shows as failed
>>> and it says "no current connection" on the status tab to the right.
>>> I am definately connected since I can browse through the database in
>>> the Data Source Explorer and even execute stored procedures
>>> successfully. On my sql file I have specified all the information in
>>> the connection profile.
>>>
>>> I don't get it. Am I missing something here?
>>
>>
|
|
|
| Re: "No connection" on a database that I am connected to [message #590287 is a reply to message #42490] |
Fri, 29 February 2008 04:25 |
Brian Fitzpatrick
Messages: 500
Registered: July 2009 |
Senior Member |
|
|
This certainly sounds like a bug. I'd register it against SQL Tools in DTP
if you could create a Bugzilla entry for it.
"Gigaplex" <gigaplex08@gmail.com> wrote in message
news:fq7qbc$468$1@build.eclipse.org...
> Using the "Set Connection" menu item worked. If I right click on the
> connection in the DSE and connect that way, I cannot execute the query but
> if I connect through the "Set Connection" menu item, the query will work.
> Is this a bug? I can't imagine it's supposed to work that way. It seems
> like I should be able to set the connection using the drop down boxes at
> the top of the SQL scrap book and never have to use the "Set Connection"
> menu item if I don't want to, right?
>
> Gigaplex wrote:
>> Yeah, I filled out the stuff at the top and it shows "Status: Connected"
>> there. That's why I'm so confused by this. I haven't tried right clicking
>> and using "Set Connection" though so I will give that a shot. Don't they
>> do the same thing though?
>>
>> Brian Fitzpatrick wrote:
>>> If you right-click on the SQL scrapbook in a blank space, you should see
>>> a "Set Connection" menu item. Also, at the top there is a series of
>>> drop-down lists to select the type of connection profile (Derby), name
>>> of th eprofile (MyProfile), and if it's connected, it'll show "Status:
>>> Connected" in that bar also.
>>>
>>> Hope that helps.
>>> --Fitz
>>>
>>> "Gigaplex" <gigaplex08@gmail.com> wrote in message
>>> news:fq5plc$g42$1@build.eclipse.org...
>>>> I have been going through the wiki article to set up Derby with DTP for
>>>> the first time:
>>>> http://wiki.eclipse.org/index.php/Getting_Started_with_DTP
>>>>
>>>> I have everything set up and I can execute the stored procedure talked
>>>> about in the article but when I try to execute my own sql as the
>>>> article describes, it doesn't work. The sql is:
>>>> SELECT * FROM SYS.SYSTABLES;
>>>>
>>>> In the results view, the status field on the left shows as failed and
>>>> it says "no current connection" on the status tab to the right. I am
>>>> definately connected since I can browse through the database in the
>>>> Data Source Explorer and even execute stored procedures successfully.
>>>> On my sql file I have specified all the information in the connection
>>>> profile.
>>>>
>>>> I don't get it. Am I missing something here?
>>>
>>>
|
|
|
Goto Forum:
Current Time: Fri May 14 03:44:27 GMT 2021
Powered by FUDForum. Page generated in 0.01988 seconds |
Search
Help
Register
Login
Home
