Question about SQL Console ?

[Database Administrator]

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

[Database Administrator]

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

[Database Administrator]

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" schrieb im Newsbeitrag
news:11vpkoj1l11rv2c@corp.supernews.com...
> 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

[Database Administrator]

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
>
>

[Database Administrator]

Joey,

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


Joey wrote:
> 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
>>
>>