Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Standart installation of buisness objects.(Win2012)

My sql.ini file is:

[BI4]
master=TCP,localhost,2638
query=TCP,localhost,2638

connection string:

isql -U dba -P password -S BI4 -D BI4_CMS

And error:

Msg 911, Level 16, State 0:
SQL Anywhere Error -83: Specified database not found
CT-LIBRARY error:
        ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.

what's my mistake?

asked 08 Aug '17, 08:49

vantela's gravatar image

vantela
16114
accept rate: 0%

edited 11 Aug '17, 06:46

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050

Try using the dbisql utility that ships with SQL Anywhere. For example:

"%SQLANY12%\bin64\dbisql.com" -c "ENG=B14;DBN=BI4_CMS;UID=dba;PWD=xxx;"
(09 Aug '17, 14:38) Breck Carter

No... I have worked dbisql.exe.

I need isql. For integration with DataProtector

(11 Aug '17, 03:12) vantela
Replies hidden

AFAIK, there's no isql utility to connect with SQL Anywhere.

I don't use BI but here's a howto setup SQL Anywhere 12.0 with BI 4.1:

Using SQL Anywhere for a CMS and Auditing Database with BI 4.1

(11 Aug '17, 03:17) Volker Barth
1

You should be able to use the isql utility from ASE to connect to a SQL Anywhere 12 database... I've seen it done, and I've done it myself, but I just can't remember how :)

I believe it has to do with using Open Client (ct_connect etcetera), and there is a whole chapter in the Help: Using SQL Anywhere as an Open Server

I am guessing (hoping) it is a simple problem with the -S -D parameters, but maybe it is deeper; e.g., maybe dbsrv12.exe wasn't started with -x tcpip since Open Client requires TCPIP.

Update: I got this message when the port number was missing:

C:\projects\$templates\$SA_templates\run\isql_ASE>"C:\Sybase\OCS-15_0\bin\isql.e
xe" -U dba -P sql -S ddd12 -D ddd12
CT-LIBRARY error:
        ct_connect(): directory service layer: internal directory control layer
error: Requested server name not found.

With the port number (49158 in the case of my running copy of dbsrv12.exe), I got a different message, indicating that the connection process actually found the server:

C:\projects\$templates\$SA_templates\run\isql_ASE>"C:\Sybase\OCS-15_0\bin\isql.e
xe" -U dba -P sql -S ddd12:49158 -D ddd12
CT-LIBRARY error:
        ct_connect(): network packet layer: internal net library error: Protocol
 driver call to parse connection information failed

C:\projects\$templates\$SA_templates\run\isql_ASE>PAUSE
Press any key to continue . . .

I then fiddled around with dsedit, but the dsedit ping gave the same parse error, plus "information has invalid syntax".

Maybe you will have better luck.

(11 Aug '17, 05:44) Breck Carter

The following test worked OK when BI4_CMS was used as the -S server name for the ASE isql connection, instead of BI4, when using SQL Anywhere 16.

C:\Sybase\ini\sql.ini

[BI4_CMS]
master=TCP,localhost,2638
query=TCP,localhost,2638

Start dbsrv16 and run ASE isql

"%SQLANY16%\bin64\dbspawn.exe"^
  -f "%SQLANY16%\bin64\dbsrv16.exe"^
  -n BI4^
  -o dbsrv16_log_BI4_CMS_Audit.txt^
  -x tcpip(PORT=2638)^
  BI4_CMS.db BI4_Audit.db

"C:\Sybase\OCS-15_0\bin\isql.exe" -U dba -P sql -S BI4_CMS -D BI4_CMS

Test worked OK...

C:\projects\$templates\$SA_templates\run\isql_ASE>"C:\Sybase\OCS-15_0\bin\isql.e
xe" -U dba -P sql -S BI4_CMS -D BI4_CMS
1> select @@version
2> go
 @@version

 -------------------------------------------------------------------------------
-------------------------------------------------
 16.0.0.2344


(1 row affected)
1>
permanent link

answered 17 Aug '17, 05:48

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%

converted 18 Aug '17, 07:59

Volker%20Barth's gravatar image

Volker Barth
40.2k361550822

YEEEE!!!!!! Worked! Very big thx!

:-)

(18 Aug '17, 07:45) vantela
Comment Text Removed

Please check the SQL Anywhere server to make sure the running server name is BI4 and the running database name is BI4_CMS.

The following test worked OK for me:

Using ASE isql.exe with SQL Anywhere via Open Connect / Open Server

Start SQL Anywhere 12 database with -x tcpip...

"%SQLANY12%\bin64\dbspawn.exe"^
  -f "%SQLANY12%\bin64\dbsrv12.exe"^
  -n BI4^
  -o dbsrv12_log_BI4_CMS.txt^
  -x tcpip^
  BI4_CMS.db

Add section to C:\Sybase\ini\sql.ini...

[BI4]
master=TCP,localhost,2638
query=TCP,localhost,2638

Run ASE isql utility...

"C:\Sybase\OCS-15_0\bin\isql.exe" -U dba -P sql -S BI4 -D BI4_CMS

Result...

C:\projects\$templates\$SA_templates\run\isql_ASE>"C:\Sybase\OCS-15_0\bin\isql.e
xe" -U dba -P sql -S BI4 -D BI4_CMS
1> select @@version
2> go
 @@version

 -------------------------------------------------------------------------------
-------------------------------------------------
 12.0.1.4231

(1 row affected)
1>

Common mistakes

Spelling mistake in the server and/or database name, when starting the server, or connecting from isql, or in the sql.ini file; e.g., B14 instead of BI4.

Coding error; e.g., colon instead of comma ahead of the port number in the sql.ini file.

permanent link

answered 11 Aug '17, 08:19

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%

edited 11 Aug '17, 08:23

Thanx you! But this is my startup string:

D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\bin64\dbsrv16.exe -n BI4 -x tcpip(PORT=2638;DoBroadcast=NO;BroadcastListener=NO) "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_CMS.db" "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_Audit.db"

I tried other variants... and same errror.

(11 Aug '17, 10:11) vantela
Replies hidden
1

I'd suggest that you remove the "DoBroadcast=NO;BroadcastListener=NO" from your -x tcpip option since this will cause the connection failure if the connection string (from isql) does not contain the "LINKS=TCPIP(BROADCAST=NO)" option and I suspect it does not do this!)

(15 Aug '17, 11:54) Mark Culp

I tried -n BI4 -x tcpip(PORT=2638;DoBroadcast=YES;BroadcastListener=YES) "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_CMS.db" "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_Audit.db"

-n BI4 -x tcpip "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_CMS.db" "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_Audit.db"

-n BI4 -x tcpip(PORT=2638) "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_CMS.db" "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_Audit.db"

And same error.

(16 Aug '17, 06:47) vantela
1

Show us the entire command line for starting the server.

Add the following option to the command line, and post the entire file showing the server startup:

-o c:\temp\server_diagnostic.txt

(16 Aug '17, 08:55) Breck Carter
I. 08/16 17:43:57. SQL Anywhere Network Server Version 16.0.0.2213

I. 08/16 17:43:57. OEM Edition, licensed only for use with OEM applications.
I. 08/16 17:43:57. 

I. 08/16 17:43:57. Copyright © 2015 SAP SE or an SAP affiliate company.
I. 08/16 17:43:57. All rights reserved.
I. 08/16 17:43:57. Use of this software is governed by the Sybase License Agreement.
I. 08/16 17:43:57. Refer to http://www.sybase.com/softwarelicenses.
I. 08/16 17:43:57. 

I. 08/16 17:43:57. Connection limit (licensed seats): 100
I. 08/16 17:43:57. Processors detected: 4
I. 08/16 17:43:57. Maximum number of processors the server will use: 4 physical processor(s), 4 core(s)
I. 08/16 17:43:57. This server is licensed to:
I. 08/16 17:43:57.     SAP
I. 08/16 17:43:57.     SAP IT
I. 08/16 17:43:57. Running Windows 2012R2 Build 9600  on X86_64
I. 08/16 17:43:57. Server built for X86_64 processor architecture
I. 08/16 17:43:57. 1343640K of memory used for caching
I. 08/16 17:43:57. Minimum cache size: 18024K, maximum cache size: 60393880K
I. 08/16 17:43:57. Using a maximum page size of 8192 bytes
I. 08/16 17:43:57. Multiprogramming level: minimum:4, current:20, maximum:80
I. 08/16 17:43:57. Automatic tuning of multiprogramming level is enabled
I. 08/16 17:43:57. Starting database "BI4_CMS" (D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_CMS.db) at Wed Aug 16 2017 17:43
I. 08/16 17:43:57. Starting database "BI4_Audit" (D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_Audit.db) at Wed Aug 16 2017 17:43
I. 08/16 17:43:57. Performance warning: Database file "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_CMS.db" consists of 6 disk fragments
I. 08/16 17:43:57. Performance warning: Database file "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_Audit.db" consists of 4 disk fragments
I. 08/16 17:43:57. Transaction log: BI4_Audit.log
I. 08/16 17:43:57. Transaction log: BI4_CMS.log
I. 08/16 17:43:58. Starting checkpoint of "BI4_CMS" (BI4_CMS.db) at Wed Aug 16 2017 17:43
I. 08/16 17:43:58. Starting checkpoint of "BI4_Audit" (BI4_Audit.db) at Wed Aug 16 2017 17:43
I. 08/16 17:43:58. Finished checkpoint of "BI4_CMS" (BI4_CMS.db) at Wed Aug 16 2017 17:43
I. 08/16 17:43:58. Finished checkpoint of "BI4_Audit" (BI4_Audit.db) at Wed Aug 16 2017 17:43
I. 08/16 17:43:58. Database "BI4_CMS" (BI4_CMS.db) started at Wed Aug 16 2017 17:43
I. 08/16 17:43:58. Database "BI4_Audit" (BI4_Audit.db) started at Wed Aug 16 2017 17:43
I. 08/16 17:43:58. Database server started at Wed Aug 16 2017 17:43
I. 08/16 17:43:58. Trying to start SharedMemory link ...
I. 08/16 17:43:58.     SharedMemory link started successfully
I. 08/16 17:43:58. Trying to start TCPIP link ...
I. 08/16 17:43:58. Starting on port 2638
I. 08/16 17:44:03.     TCPIP link started successfully
I. 08/16 17:44:03. Now accepting requests
I. 08/16 17:45:00. Starting checkpoint of "BI4_Audit" (BI4_Audit.db) at Wed Aug 16 2017 17:45
I. 08/16 17:45:00. Starting checkpoint of "BI4_CMS" (BI4_CMS.db) at Wed Aug 16 2017 17:45
I. 08/16 17:45:00. Finished checkpoint of "BI4_Audit" (BI4_Audit.db) at Wed Aug 16 2017 17:45
E. 08/16 17:45:00. Handler for event 'ScheduledLogBackup' caused SQLSTATE '08W46'
E. 08/16 17:45:00. Error during backup/restore: Could not create directory "F:\Backup\incremental\BI4_Audit"-- No such file or directory
I. 08/16 17:45:00. Finished checkpoint of "BI4_CMS" (BI4_CMS.db) at Wed Aug 16 2017 17:45
E. 08/16 17:45:00. Handler for event 'ScheduledLogBackup' caused SQLSTATE '08W46'
E. 08/16 17:45:00. Error during backup/restore: Could not create directory "F:\Backup\incremental\BI4_CMS"-- No such file or directory
(16 Aug '17, 10:52) vantela
Replies hidden
Comment Text Removed
Comment Text Removed

Note that you have two failing backup events...

E. 08/16 17:45:00. Handler for event 'ScheduledLogBackup' caused SQLSTATE '08W46'
E. 08/16 17:45:00. Error during backup/restore: Could not create directory "F:\Backup\incremental\BI4_Audit"-- No such file or directory
E. 08/16 17:45:00. Handler for event 'ScheduledLogBackup' caused SQLSTATE '08W46'
E. 08/16 17:45:00. Error during backup/restore: Could not create directory "F:\Backup\incremental\BI4_CMS"-- No such file or directory
(17 Aug '17, 05:30) Breck Carter
showing 2 of 6 show all flat view
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×46

question asked: 08 Aug '17, 08:49

question was seen: 6,292 times

last updated: 18 Aug '17, 08:00