cancel
Showing results for 
Search instead for 
Did you mean: 

String connection Sybase 9 (64 bits)

971

I would like the information if sybase 9 64bits accepts the connection string and, What would be the correct string for the connection?

Accepted Solutions (0)

Answers (1)

Answers (1)

Breck_Carter
Participant

I'm not sure what you mean by "the correct string" since there is an infinite variety of possible connection strings.

Here's a Windows 10 command file that works to create, start and connect to a SQL Anywhere 9 database via ISQL...

"%ASANY9%\\win32\\dbinit.exe"^
  -p 4096^
  -s^
  ddd9.db

"%ASANY9%\\win32\\dbspawn.exe"^
  -f^
  "%ASANY9%\\win32\\dbsrv9.exe"^
  -c 100M^
  -o dbeng9_log_ddd9.txt^
  -os 10M^
  -x none^
  -zl^
  ddd9.db 

"%ASANY9%\\win32\\dbisql.exe"^
  -c "ENG=ddd9;DBN=ddd9;UID=dba;PWD=sql;CON=ddd9-1"

"%ASANY9%\\win32\\dbisql.exe"^
  -c "ENG=ddd9;DBN=ddd9;UID=dba;PWD=sql;CON=ddd9-2"

pause
0 Kudos

Thanks!@Breck Carter

I was trying to connect an application to Sybase 9, it worked using the following string:

**Driver=Sql Anywhere 17;ENG=XXXXX;UID=dba;PWD=XXXXXX;DBN=XXXXX;**

I don't have ASA 9 in 64bits, for that reason I used ASA 17.