on 2022 Apr 20 11:09 AM
I am trying to connect to a SQL Anywhere 17 Database from Python using pyodbc Module.
The connect looks like: mydb=pyodbc.connect('DSN=mydsn;UID=dba;pwd=mypwd;Company=mycompany;Application=myapp;Signature=mysignature')
The database runs as a service (dbsvc), and the connection works only if the the database doesnt have other connections open. i.e. if I connect to the database using dbisql then has my Python script no any chance to connect to the DB and I get the following error:
Unable to initialize performance monitor data area; server startup continuing SQL Anywhere Personal Server Version 17.0.9.4803 Developer edition, not licensed for deployment. Copyright © 2018 SAP SE or an SAP affiliate company. All rights reserved. Use of this software is governed by the SAP Software Use Rights Agreement. Refer to http://www.sap.com/about/agreements.html. Connection limit (Personal Server): 10 Processors detected: 8 logical processor(s) on 4 core(s) on 1 physical processor(s) Processor license restriction (Personal Server): all logical processors on at most 4 core(s) on at most 1 physical processor(s) This server is licensed to use: all logical processors on at most 4 core(s) on at most 1 physical processor(s) Processors in use by server: 8 logical processor(s) on 4 core(s) on 1 physical processor(s) This server is licensed to: Developer Edition Restricted Use Running Windows 10 Build 19043 on X86_64 Server built for X86_64 processor architecture 51464K of memory used for caching Minimum cache size: 51452K, maximum cache size: 7453104K Using a maximum page size of 2048 bytes Multiprogramming level: 20 Database server shutdown due to startup error Database server stopped at Wed Apr 20 2022 16:08
User | Count |
---|---|
67 | |
10 | |
10 | |
10 | |
10 | |
8 | |
8 | |
7 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.