It keeps doing it even in version 17, and I don't know how to stop it from doing that on this connection to this database. From version 5 to version 12 something changed, and when trying to open an ADO.NET connection, it tries to execute a CHAINED=on parameter after opening. SQL Anywhere used to come bundled with sybase powerbuilder, and now is the property of SAP. How to connect to Sybase SQL Anywhere 5 database running on 9 server using native ADO.NET? If someone left a copy of the Powerbuilder CD in the client's computer, look for the folder asa801runtime and install that to get the ODBC driver workingĮxample connection string with default username/password:ĭriver= PORT=2638 UID=admin PWD= ENG= DBN= ')Ĭursor.execute("select top 10 * from dba.") This will work when Windows is installed in C:\WINDOWS, otherwise edit the registry entries. "Adaptive Server Anywhere 8.0"="Installed" Get a copy of the following files from a computer with a working setup of the SQL Anywhere ODBC driver:ĬOPY %~dp0dbcon8.dll %SystemRoot%\system32\dbcon8.dllĬOPY %~dp0dblgen8.dll %SystemRoot%\system32\dblgen8.dllĬOPY %~dp0dbodbc8.dll %SystemRoot%\system32\dbodbc8.dll
0 Comments
Leave a Reply. |