dbTalk Databases Forums  

Question about SQL Console ?

comp.databases.gupta comp.databases.gupta


Discuss Question about SQL Console ? in the comp.databases.gupta forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Joey
 
Posts: n/a

Default Question about SQL Console ? - 02-22-2006 , 04:09 PM






Hi everyone,

I'm using SQL Base 1-User Server on my local Windows XP Pro workstation.
I can connect to the local database using SQL Talk. When I try to
connect using SQL Console I see the databases but can't do anything with
them. My goal is to view the tables and data.

Am I doing something wrong or is it just impossible to use SQL Console
with the 1-User Server ? Any suggestions will be greatly appreciated.

Joey

Reply With Quote
  #2  
Old   
Team Developer
 
Posts: n/a

Default Re: Question about SQL Console ? - 02-24-2006 , 01:37 AM






Hi Joey,

I've tried it and to me it seems as if it's not possible to view the
tables and data with SQL Console. However, you can try to use report
builder for that.

Jos

Joey wrote:
Quote:
Hi everyone,

I'm using SQL Base 1-User Server on my local Windows XP Pro workstation.
I can connect to the local database using SQL Talk. When I try to
connect using SQL Console I see the databases but can't do anything with
them. My goal is to view the tables and data.

Am I doing something wrong or is it just impossible to use SQL Console
with the 1-User Server ? Any suggestions will be greatly appreciated.

Joey


Reply With Quote
  #3  
Old   
Hans-Dieter Dreier
 
Posts: n/a

Default Re: Question about SQL Console ? - 02-24-2006 , 01:56 AM



SQLConsole is for administration purposes only. It cannot be used to view
data. Use SqlTalk / WinTalk (which can execute arbitrary SQL commands and
display the result in a console window) to view tables and data.

--


Greetings,

Hans-Dieter Dreier

"Joey" <J_nospam_lancos (AT) moultriega (DOT) net> schrieb im Newsbeitrag
news:11vpkoj1l11rv2c (AT) corp (DOT) supernews.com...
Quote:
Hi everyone,

I'm using SQL Base 1-User Server on my local Windows XP Pro workstation.
I can connect to the local database using SQL Talk. When I try to connect
using SQL Console I see the databases but can't do anything with them. My
goal is to view the tables and data.

Am I doing something wrong or is it just impossible to use SQL Console
with the 1-User Server ? Any suggestions will be greatly appreciated.

Joey



Reply With Quote
  #4  
Old   
Joey
 
Posts: n/a

Default Re: Question about SQL Console ? - 03-02-2006 , 06:01 PM



Do they make such a program or is this possible ????

Microsoft SQL7 uses enterprise manager to connect to the database
and you can view the tables in cell form and even modify the data
in a cell. You can use SQL to link tables and filter and view
the results in cell form and yet make changes to the data there.

I'm using Centura SQL Base 7.01 on a Novell server. Do they make
such a product for Centura SQLBase ??

What I'm wanting to accomplish is to explore the database and
discover what linking needs to be done and possibly make some
changes to the data both here and there and in bulk using SQL.

Any thoughts and ideas for a novice with SQLBase will be greatly
appreciated.

Joey





Team Developer wrote:
Quote:
Hi Joey,

I've tried it and to me it seems as if it's not possible to view the
tables and data with SQL Console. However, you can try to use report
builder for that.

Jos

Joey wrote:

Hi everyone,

I'm using SQL Base 1-User Server on my local Windows XP Pro workstation.
I can connect to the local database using SQL Talk. When I try to
connect using SQL Console I see the databases but can't do anything with
them. My goal is to view the tables and data.

Am I doing something wrong or is it just impossible to use SQL Console
with the 1-User Server ? Any suggestions will be greatly appreciated.

Joey



Reply With Quote
  #5  
Old   
Jack Miller
 
Posts: n/a

Default Re: Question about SQL Console ? - 03-14-2006 , 12:08 PM



Joey,

There are third party products available. My favorite one is WinSQL
(http://www.synametrics.com/winsql)


Joey wrote:
Quote:
Do they make such a program or is this possible ????

Microsoft SQL7 uses enterprise manager to connect to the database
and you can view the tables in cell form and even modify the data
in a cell. You can use SQL to link tables and filter and view
the results in cell form and yet make changes to the data there.

I'm using Centura SQL Base 7.01 on a Novell server. Do they make
such a product for Centura SQLBase ??

What I'm wanting to accomplish is to explore the database and
discover what linking needs to be done and possibly make some
changes to the data both here and there and in bulk using SQL.

Any thoughts and ideas for a novice with SQLBase will be greatly
appreciated.

Joey





Team Developer wrote:
Hi Joey,

I've tried it and to me it seems as if it's not possible to view the
tables and data with SQL Console. However, you can try to use report
builder for that.

Jos

Joey wrote:

Hi everyone,

I'm using SQL Base 1-User Server on my local Windows XP Pro workstation.
I can connect to the local database using SQL Talk. When I try to
connect using SQL Console I see the databases but can't do anything with
them. My goal is to view the tables and data.

Am I doing something wrong or is it just impossible to use SQL Console
with the 1-User Server ? Any suggestions will be greatly appreciated.

Joey



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.