Connection failure with dbn after upgrade to Win 10

[Former Member]

I'm baffled about a connection problem when running dbisql after upgrading to Windows 10.

Before Win10 I ran commands like these from batch files or directly from the command prompt:

dbisql -nogui -c "uid=dba;pwd=***;dbn=fred;" START DATABASE 'c:\\fred\\source.db' AS "sourcedb" WITH TRUNCATE AT CHECKPOINT AUTOSTOP OFF;
dbisql -nogui -c "uid=dba;pwd=***;dbn=fred;" read ENCODING CP1252 'C:\\SVN\\fred\\trunk\\Common\\dbinit.sql'
dbisql -nogui -c "uid=dba;pwd=***;dbn=fred;" select * from sys.systable

After upgrading to Win 10 I get no connection. From the command prompt I get "You are not connected to a database".

I tried using the both architectures of the full path to run dbisql.exe.

I can start ISQL if I run dbisql.exe with the connection string and then run individual commands that way, but that doesn't work with my batch files.

If I run:

dbisql -nogui -c "uid=dba;pwd=***;dbn=fred;"

I get a command prompt but any command I run just gives a "(Not Connected)" message.

I tried opening the command prompt in Administrator mode. No joy.

For now I'm using an ODBC connection in my parameters, and that lets me get my work done.

The dbisql with the "dbn" parameter and cmd.exe are not playing well together.

I am using SA 12.0.1.3554.

[VolkerBarth]

According to the docs, SQL Anywhere 12.0.1 is officially supported on Windows 8.1 starting with EBF 12.0.1.3994 (there's no particular EBF stated for Windows 10), so given you use a way older build, I'd suggest to try with a current one (such as 12.0.1.4403).

What Windows version have you used before?

[Breck_Carter]

Please show us the commands that DO work, so we can try debugging-by-manual-inspection, rather than debugging-by-finding-and-installing-old-build-on-Windows-10... but I will do that if necessary 🙂

FWIW commands similar to yours seem to work OK using SQL Anywhere 16 on Windows 10.

[justin_willey]

Logging the details of connection attempt can often be helpful in these situations. Try adding something like log=c:\\temp\\conlog.txt or whatever path is appropriate to your -c parameter.

[chris_keating]

I am not able to reproduce this. Perhaps you can add more detail?

I believe that dbisql -nogui should report more info than just (Not Connected) but if it does not, please add LOG=<filespec> to get client side connection debug logging as recommended by Justin. Can you also outline the start options used by the engine and whether the engine is a network or personal server.

[Former Member]

With the -nogui option I get no log output.

With no -nogui option I get this (with secure info splatted out):

Wed Jul 27 2016 08:23:50
08:23:50 Attempting to connect using:
UID=dba;PWD=********;DBN=fred;CON=SQL_DBC_50908330;LOG=c:\\temp\\conlog.txt
08:23:50 Attempting to connect to a running server...
08:23:50 Trying to start SharedMemory link ...
08:23:50     SharedMemory link started successfully
08:23:50 Attempting SharedMemory connection (no sasrv.ini cached address)
08:23:50 Connected to server over SharedMemory
08:23:50 Connected to SQL Anywhere Server version 12.0.1.3554
08:23:50 Connected to the default SharedMemory server
08:23:50 Application information:
08:23:50 IP=10.10.30.172;HOST=***;OSUSER=***;OS='Unrecognized Windows version Build 9200 ';EXE='C:\\Program Files\\SQL Anywhere 12\\bin64\\dbisql.exe';PID=0x1abc;THREAD=0xa40;VERSION=12.0.1.3554;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-420
08:23:50 Connected to the server, attempting to connect to a running database...
08:23:50 [   51] Connected to database successfully
08:23:50 [   51] The number of prefetch rows has been reduced to 16 due to the prefetch buffer
08:23:50 [   51] limit. Increasing the PrefetchBuffer connection parameter may improve performance.

More info:

All of the other systems at my company with the same software and configuration and everything works just fine. We have field installations of our software--which includes this SA EBF of course--and they are all running fine. There is something on my system in particular that isn't allowing -nogui when run from cmd.exe; that includes commands run from xp_cmdshell().

Our application (Delphi, using Devexpress) connects just fine on my system. It uses a commercial DB connection package.

My previous Windows version was Windows 7. I don't know which subversion.

What startup settings? Let's make things simple and do this ...

C:\\WINDOWS\\system32>"%SQLANY12%\\BIN32\\dbinit" "c:\\temp\\fred.db"
...
C:\\WINDOWS\\system32>"%SQLANY12%\\BIN32\\dbsrv12" "c:\\temp\\fred.db"
...
C:\\WINDOWS\\system32>"%SQLANY12%\\BIN32\\dbisql" -nogui -c "uid=dba;pwd=sql;dbn=fred" select * from sys.systable
You are not connected to a database.

If I don't create an ODBC connection and I use the dsn parameter I get the "You are not connected to a database." message.

I don't know if this is related, but I created an ODBC connection for "fred" and used the dsn parameter and I got ...

table_id   file_id count                first_page last_page   primary_root creator    first_ext_page last_ext_page table_page_count ext_page_count object_id            table_name                                                                                                                       table_type    *** OutOfMemoryError ***
Request type=3
Request =[ExecuteRequest:sql=select * from 
sys.systable,containsODBCEscapeSequence=false,cachingHint=2,warning=null,error=null,errorMessage=null,resultsProcessor=sybase.isql.Console]
Error! This program has encountered an internal error.
Details have been logged to C:\\ProgramData\\SQL Anywhere 12\\diagnostics\\isqlError-2.err.xml
Exception is:
Database worker thread request failed because of a runtime error.
Request=[ExecuteRequest:sql=select * from sys.systable,containsODBCEscapeSequence=false,cachingHint=2,warning=null,error=null,errorMessage=null,resultsProcessor=sybase.isql.Console]

[Former Member]

The stack trace from isqlError-2.err.xml is ...

stack_trace="java.lang.Error: Database worker thread request failed because of a runtime error.
Request=[ExecuteRequest:sql=select * from sys.systable,containsODBCEscapeSequence=false,cachingHint=2,warning=null,error=null,errorMessage=null,resultsProcessor=sybase.isql.Console]\x0d
\x09at sybase.isql.ISQLConnectionImpl.enqueueRequest(ISQLConnectionImpl.java:5683)\x0d
\x09at sybase.isql.ISQLConnectionImpl.execute(ISQLConnectionImpl.java:6191)\x0d
\x09at sybase.isql.ASAParser.executeSQL(ASAParser.java:1628)\x0d
\x09at sybase.isql.ASAParser.sqlStatement(ASAParser.java:4408)\x0d
\x09at sybase.isql.ASAParser.isqlStatement(ASAParser.java:3519)\x0d
\x09at sybase.isql.ASAParser.isqlStatementList_2(ASAParser.java:3056)\x0d
\x09at sybase.isql.ASAParser.isqlStatementList(ASAParser.java:2832)\x0d
\x09at sybase.isql.ASAParser.parse(ASAParser.java:387)\x0d
\x09at sybase.isql.isql.execute(isql.java:1544)\x0d
\x09at sybase.isql.Console.run(Console.java:218)\x0d
\x09at sybase.isql.isql.main(isql.java:632)\x0d
\x09at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\x0d
\x09at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\x0d
\x09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\x0d
\x09at java.lang.reflect.Method.invoke(Method.java:597)\x0d
\x09at sybase.isql.ISQLLoader.callISQLMethod(ISQLLoader.java:515)\x0d
\x09at sybase.isql.ISQLLoader.main(ISQLLoader.java:322)\x0d
Caused by: java.lang.OutOfMemoryError: Java heap space\x0d
\x09at java.util.Arrays.copyOf(Arrays.java:2882)\x0d
\x09at java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java:100)\x0d
\x09at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:390)\x0d
\x09at java.lang.StringBuilder.append(StringBuilder.java:119)\x0d
\x09at sybase.isql.Console.padString(Console.java:953)\x0d
\x09at sybase.isql.Console.printResultSet(Console.java:792)\x0d
\x09at sybase.isql.Console.processResultSet(Console.java:641)\x0d
\x09at sybase.isql.ISQLConnectionImpl.callCustomResultsProcessor(ISQLConnectionImpl.java:3522)\x0d
\x09at sybase.isql.ISQLConnectionImpl.handleExecute(ISQLConnectionImpl.java:3282)\x0d
\x09at sybase.isql.ISQLConnectionImpl.run(ISQLConnectionImpl.java:356)\x0d
\x09at java.lang.Thread.run(Thread.java:619)\x0d


Thread

[Former Member]

I looked at the query with Windows Process Monitor: Once with the DBN parameter and once with the DSN parameter. I was hoping to find something like a file access failure in case there was something like a file permission setting that is causing the problem. Nothing stood out.

I'm stumped on how to go about debugging this.

[Former Member]

dbping and dbbackup both work with the DBN parameter.

[Former Member]

I did an uninstall, reboot and reinstall of SA.

Good new: That fixed the problem in my test "fred" database. It now queries from the command prompt with DBN and DSN. (woo hoo!)

Bad news: The reinstall hosed my real application, but that is a different problem. (crap! crap! crap!)

[Breck_Carter]

> a different problem. (crap! crap! crap!)

Go ahead and post a new question, if you think it might help.

[Former Member]

It's OK. We got it. It was application specific. Thanks though.