|
Home > Archive > IQ Server > February 2006 > ISQL Connections
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Juan C. Lopez 2006-01-27, 11:24 am |
| How do I enable Sybase IQ to handle ISQL Connections?
| |
| Sherlock, Kevin 2006-01-30, 8:25 pm |
| Just use your IQ database name as the server named in your interfaces file (or
sql.ini file on windows via dsedit).
isql -Usa -Pmypass -S<yourIQdatabaseName>
should do the trick.
"Juan C. Lopez" <jlopez@borschow.com> wrote in message
news:43da53e7$1@foru
ms-1-dub...
> How do I enable Sybase IQ to handle ISQL Connections?
>
>
| |
| dbmethods 2006-01-30, 8:25 pm |
| On Mon, 30 Jan 2006 15:41:53 -0800, Sherlock, Kevin wrote:
[color=darkred]
> Just use your IQ database name as the server named in your interfaces file (or
> sql.ini file on windows via dsedit).
>
> isql -Usa -Pmypass -S<yourIQdatabaseName>
>
> should do the trick.
>
> "Juan C. Lopez" <jlopez@borschow.com> wrote in message
> news:43da53e7$1@foru
ms-1-dub...
I think -A and -X do not work with IQ.
Anyone has idea how to enable large network packet size, such as 2048
bytes.
| |
| Juan C. Lopez 2006-02-14, 7:24 am |
| I got the following error using ISQL.
Msg 911, Level 16, State 0:
ASA Error -83: Specified database not found
CT-LIBRARY error:
ct_connect(): protocol specific layer: external error: The attempt
to co
nnect to the server failed.
"Sherlock, Kevin" <ksherlock@saionline.com> wrote in message
news:43de9570$1@foru
ms-2-dub...
> Just use your IQ database name as the server named in your interfaces file
> (or
> sql.ini file on windows via dsedit).
>
> isql -Usa -Pmypass -S<yourIQdatabaseName>
>
> should do the trick.
>
> "Juan C. Lopez" <jlopez@borschow.com> wrote in message
> news:43da53e7$1@foru
ms-1-dub...
>
>
| |
| Sherlock, Kevin 2006-02-14, 1:24 pm |
| What is the name of your IQ database? Is it case sensitive? What platform are
you running ISQL from?
"Juan C. Lopez" <jlopez@borschow.com> wrote in message
news:43f1d408$1@foru
ms-1-dub...
> I got the following error using ISQL.
>
> Msg 911, Level 16, State 0:
> ASA Error -83: Specified database not found
> CT-LIBRARY error:
> ct_connect(): protocol specific layer: external error: The attempt
> to co
> nnect to the server failed.
>
>
> "Sherlock, Kevin" <ksherlock@saionline.com> wrote in message
> news:43de9570$1@foru
ms-2-dub...
>
>
| |
| Juan C. Lopez 2006-02-14, 1:24 pm |
| Ok solved the issue. Is an stupid thing
DB must be named the same as the Server.
"Juan C. Lopez" <jlopez@borschow.com> wrote in message
news:43f1d408$1@foru
ms-1-dub...
>I got the following error using ISQL.
>
> Msg 911, Level 16, State 0:
> ASA Error -83: Specified database not found
> CT-LIBRARY error:
> ct_connect(): protocol specific layer: external error: The attempt
> to co
> nnect to the server failed.
>
>
> "Sherlock, Kevin" <ksherlock@saionline.com> wrote in message
> news:43de9570$1@foru
ms-2-dub...
>
>
|
|
|
|
|