I am currently attempting to query an SQL Anywhere 12 database. I was able to gain access and write queries using the software aqua data studio. Unfortunately, my Aqua Data Studio trial has run out. Any other software that I use (Sybase Central, ODBC, Altova DatabaseSpy, SQL anywhere Client) all give me the same error: an error occured during the sharedmemory connection attempt. I have no idea why this is happening, and I have even tried turning off the "use shared memory connection" on my DB but to no avail.
I checked my log files and this is what was returned:
09:15:14 Attempting to connect using: UID=DBA;PWD=;DBN=;DBF=;ServerName=;CON='*';ASTOP=YES;INT=NO;ENC=NONE;LOG=client.txt
09:15:14 Attempting to connect to a running server...
09:15:14 Attempting SharedMemory connection (no sasrv.ini cached address)
09:15:14 Failed to connect over SharedMemory
09:15:14 Cannot connect to server
Which sounds like an issue with the sasrv.ini being absent. Does anyone know why? Why was aquadata studio able to connect but these others were not? (I had tried other software before aquadata and got the same error)
How can I fix this issue?
asked 28 Jan '14, 11:39
If you're using a Window OS, try this from a command line prompt
dbeng12.exe -x TCPIP -n LOCAL c:\database\dbName.db
where c:\database\dbName.db is the location and name of your db file, LOCAL will be the instance name of the engine (i.e. server name used in ODBC connection)
if the engine starts, you'll see the lightning bolt.
if your OS is 64 bit
from the Windows Run prompt enter, c:\Windows\SysWow64\odbcad32.exe
if your OS is 32 bit, use the ODBC shortcut
ODBC tab, Data source name, enter LOCAL
login tab, enter the UID and PWD
Database tab, Server name enter LOCAL
Network tab, check TCP/IP, unchedk Shared memory
back to ODBC tab, test connection
if your connection is successful, you should be able to connect in iSQL or Sybase Central using the ODBC datasource option
The file sasrv.ini will only cache information to accelerate server lookup, but connections should be possible independent of it's existence.
answered 28 Jan '14, 12:07