Questions tagged [ODBC] (48)

0
answer

Why not fire a python script in Asterisk?

Now engaged in the transfer and adjustment Bekasovo the asterisk server. And faced with the problem that python script can not get data from mysql database to handle calls to asterisk. ODBC is configured, the logins and passwords to the database are entered correctly everywhere, please Tell me in which direction to look fo...
Mckayla_Bay asked April 9th 20 at 10:19
1
answer

How to add a variable Python to the SQL query?

Tell me how to add a variable to the query? The project is a chat bot using dialogflow. When receiving a specific command you want to record client data into the database. How to transfer data received from the input line to a database on MS SQL server? A little googling and did this: print('Enter message...') message = i...
Timothy.Farrell asked April 9th 20 at 09:44
1
answer

The external processor 1C and not working. How to decide?

{Vneshnetorgbank.Texturing.Form.Form.Form(816)}: Error calling context method (Open): caught exception (Microsoft OLE DB Provider for ODBC Drivers): [Microsoft][ODBC driver Manager] data Source name not found and no driver specified default I read from the Internet, tried but did not help. How to solve a problem who knows ...
Gaylord.Fisher asked April 8th 20 at 10:36
2
answers

Synchronization and two-way exchange of base 1C of the store, with the MySQL database of this online store?

There is a retail store where in the database is 1C 8 trade management 10.3 It is planned to make an online store, where to be the goods with the same base, with the possibility of shopping online, with the MySQL database. How to synchronize the exchange of information in both directions? Ie if a person came into the stor...
Chandler_Crooks asked April 8th 20 at 02:52
1
answer

How to configure MS SQL and can connect using pyodbc?

1) Installed MS SQL Server 2014 Express Managmtnt Studio have created a database "logins" added user with password "1". Included a TCP connection on port 1433. In the Windows firewall added the port and MSSQL exception. Installed ODBC plugin for MSSQL. 2) to execute a python script:import pyodbc con = pyodbc.connect('DRIV...
Anya_Moscis asked April 3rd 20 at 16:57
0
answer

How to connect to mssl in php7.2?

Unable to connect to database ms sql server 2000. there is code:$dbh = new PDO ("odbc:Server=10.1.1.1,1433;Database=database", "user", 'password'); error: PHP Warning: PHP Startup: Unable to load dynamic library 'msql.so'.... installed packages unixODBC freetds freetds-devel freetds-libs php-pdo-dblib file msql.so no. How...
linda.Kuvalis85 asked March 31st 20 at 21:09
1
answer

Zabbix ODBC, monitoring data in table in Mysql database?

Dear Hello! the real question is this! I created a data Item in Zabbix and with help of the SQL query will determine what it matters but I only have two 1 or 0. When you test all this item screams everything works fine but data not.
Jeff_Tremblay asked March 31st 20 at 19:50
1
answer

How to convert cp1251 to utf8 in zabbix?

Hello! Monitor Oracle zabbix.SELECT Nvl(Listagg(Reg_Date || Chr(13) || Er, Chr(13) || Chr(13) || Chr(13)) Within GROUP(ORDER BY Reg_Date DESC), '1') "Emp_list" FROM ( SELECT MAX(j.Req_Start_Date) AS Reg_Date, j.Additional_Info AS Er FROM dba_Scheduler_Job_Run_Details j WHERE j.Owner || '.' || j.Job_Name = '{#JBN}' AN...
ocie_Nader asked March 29th 20 at 23:30
2
answers

Why is the ODBC driver (SQL Server 2012) returns data in wrong encoding?

Faced such problem - there is a remote database in SQL Server 2012, which has functions that return data. The application is deployed in dev (ubuntu 18.04), the connection is configured through the ODBC driver, 17th version (because with the built-in driver failed to "negotiate"):user@vm:~$ odbcinst -j unixODBC 2.3.7 DRIVE...
billy.Batz asked March 21st 20 at 12:13
1
answer

How to force Asterisk to write data to DB in UTF-8 encoding?

CentOS Linux release 7.6.1810 (Core) Kernel: localhost.localdomain 5.0.7-1.el7.elrepo.x86_64 MariaDB Ver 15.1 Distrib 10.4.4-MariaDB, for Linux (x86_64) using readline 5.1 Asterisk: 16.3.0 built by root unixODBC 2.3.1 mysql-connector-odbc 8.0.15-1 Set up record cdr and cel in the base, wherever he could, set UTF-8, Cyrillic...
victor_Maye asked March 19th 20 at 19:18