search for: isql

...a repo. I'll try replacing the driver first, then install the server - and I may be good to go. On Fri, Nov 3, 2017 at 10:23 AM, John Harragin <jharragi at mw.k12.ny.us> wrote: > What I have found is that the only new shared objects between the > different versions of the running isqls is: > > < lrwxrwxrwx. 1 root root 24 Oct 31 21:25 /usr/lib64/mysql/libmysqlclient.so.18 > -> libmysqlclient.so.18.0.0 > > lrwxrwxrwx. 1 root root 24 Nov 2 12:13 /usr/lib64/mysql/libmysqlclient.so.18 > -> libmysqlclient.so.18.0.0 > > ... also this is the only share...

...entos-release-openstack-ocata yum -y install mariadb-server ...the cloud repository provides the properly pathed file. # repoquery -l mariadb-server mariadb-libs | grep lib64 | grep libmysqlclient /usr/lib64/mysql/libmysqlclient.so.18 /usr/lib64/mysql/libmysqlclient.so.18.0.0 I installed this and isql was crashing. But (unlike the mariadb.com repository,) is did install: /usr/lib64/mysql/libmysqlclient.so ...in the appropriate subdirectory. However my asterisk server is still running and it still has that file open. I don't know if this keeps new processes referencing the .so file that is o...

What I have found is that the only new shared objects between the different versions of the running isqls is: < lrwxrwxrwx. 1 root root 24 Oct 31 21:25 /usr/lib64/mysql/libmysqlclient.so.18 -> libmysqlclient.so.18.0.0 > lrwxrwxrwx. 1 root root 24 Nov 2 12:13 /usr/lib64/mysql/libmysqlclient.so.18 -> libmysqlclient.so.18.0.0 ... also this is the only shared object with a different node-ID...

...to my remote MS SQL server from Ubuntu. I have followed HowtoConnectToMicrosoftSQLServerFromRailsOnLinux<http://http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux>as best that I can. TSQL is working, example below. My configs are found below. When I run isql : > isql -v pubs name password [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: Could not SQLConnect Does someone have a correctly running configuration that I can review to correct my own? Thanks!! tsql works : root@vmrailsdev:~# tsql...

...: 2 Odbcinst does see the connection, it reads it from /usr/local/etc/odbcinst.ini. # odbcinst -q -d [MySQL] I tried copying my connection information onto those files listed above and I'm not getting any errors in Asterisk logs when restarting Asterisk. However: # echo "select 1" | isql -v MySQL [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: Could not SQLConnect Here's the contents of odbc.ini: [MySQL-asterisk] Description = MySQL Asterisk database Trace = Off TraceFile = stderr Driver = MySQL SERVER = serverip USER...

Hi All, I’m using system commands in R to send requests to my database. CMD=paste(“isql.tcl \’ select xxxx from yyyyy where zzzzz = 501 \’”) Data=system(CMD,intern=T) This works perfectly fine, but if I want to be able to add dates constraints: In command line it would be isql.tcl “ select xxxx from yyyyy where zzzzz = 501 and date>’20021020’ ” Does somebody has an idea how t...

...ys, Having issue with getting CDR to write to MS-SQL via ODBC. > cdr_odbc: Connected to freetds-connector > cdr_odbc: Error in PREPARE -1 > cdr_odbc: Query FAILED Call not logged! == Spawn extension (cisco, ##########, 2) exited non-zero on 'IAX2/astYYYY-507 Isql test: [xxx at YYYY asterisk]# isql freetds-connector XXXXXXX YYYYYYYYY +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit...

...iki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux but my system (Ubuntu 8.10 - Intrepid Ibex, Rails 2.3, Ruby 1.8.7) isn''t cooperating. I get as far as able to use ''sqsh'' to test the server-side connection and able to run SQL, but ''isql'' or the IRB aren''t able to access my unixODBC DSN. My /etc/odbc.ini: [Server1] Driver = FreeTDS Description = SQLServer Database Trace = No Server = ip_of_server Port = 1433 Database = DB_Name My /etc/odbcinst.ini...

...el4.rf and php-4.3.9-3.9 all but the freetds package came with CentOS-4.2 + updates the problem is that I am getting -1 from the odbc_num_rows(); function, I search the net and it looks that this is a very common problem with MS SQL server and unix ODBC driver, but, my surprise came when I use the isql command (came with the unixODBC package) and the number of rows is returned correctly in the same machine and with the same query. the following is the output from isql command: +--------------+-----------+---------------------------------------+ SQLRowCount returns 2516 2516 rows fetched SQL>...

G'day If I have VFP9 working, a Mysql DSN which I can contact via isql and using unixODBC for this. Do I need to do anything else to wine ie; install MySQL drivers (Windows version) to get connectivity? I just finished checking out Paul McNett's pages, however the MYSQL drivers he used for VFP8 are "no longer supported" when I do "wine setup.exe...

I've installed R-2.9.2 (64 bit), unixODBC-2.2.14-p2 (64 bit) and RODBC_1.2-5 (64 bit) on a 64 bit Redhat Linux server (Red Hat Enterprise Linux Server release 5.4 (Tikanga), x86_64) release 2.6.18-164.2.1.el5. I've tested the ODBC drive via isql and the test was success: [yzhang@ROracleTest ~]$ isql -v DRTST yzhang test +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit...

I notice you have MySQL-asterisk as your definition in your odbc.ini but you are trying to connect to simply 'MySQL' with your 'isql' command. Does isql work with 'MySQL-asterisk' as the DSN instead of simply 'MySQL' ? I have machines that use /etc/odbc.ini and machines that use /usr/local/etc/odbc.ini depending on if I used a package to instal ODBC or if I compiled ODBC myself. On Tue, Feb 3, 2015 at 1:35...

...a MySQl database via Gnu R using the RODBC interface. The conenction workes but I get an empty result string. Gnu R and the MySql DB are running on a 64 bit server. I installed version 5.1 of the mysql ODBC interface files [1]. My unixODBC setup file is given in [2], the setup was tested with "isql" and works [3]. If I connect from GNU R to the database, an empty list of tables is presented and sqlQuery(t.con, "show databases") returns an empty list [4]. What am I doing wrong I tried nearly everyting, but nothing seems to work. Thanks, Henri ---1: INSTALL mysqlOdbc librari...

Hi, Has anyone made a successfull instalation of cdr_odbc?? I've install unixODBC-2.2.8 (made my own RPM) and then built the module. I'm trying to send the cdrs to a M$ SQL server. The sql connection works because I can do any query via isql. When I do the calls I get the following output on the asterisk console: -- Executing Hangup("SIP/test1-a5e1", "") in new stack == Spawn extension (test, h, 1) exited non-zero on 'SIP/test1-a5e1' > cdr_odbc: Connected to SQL1 > cdr_odbc: Error...

...e errors before I put everything into production. I am running: FreeBSD 4.9-RELEASE unixODBC-2.2.8 (installed from FreeBSD port) postgresql-7.3.5_1 (installed from FreeBSD port) R 1.8.1 (installed from R-letter FreeBSD port) RODBC (installed from CRAN) Here is what is happening: When I run "isql": # isql mydb -v +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | |...

Hi, I'm trying to connect to a Teradata database via RODBC on a Linux 64 machine (Red Hat Enterprise Linux 5). The ODBC driver is properly configured and queries sent via unixODBC's isql tool work properly. However, this is what happens when I try to connect via RODBC: > library(RODBC) > conn = odbcConnect("thedsn", uid="theuid", pwd="thepass") *** caught segfault *** address (nil), cause 'memory not mapped' Traceback: 1: .Call(C_ROD...

...tado Pereda > Enviado el: Jueves, 23 de Agosto de 2001 11:38 a.m. > Para: 'wine-users-request@winehq.com'; Alfredo Hurtado Pereda > Asunto: help > > > > Help me Please > > > I have a Problem . I Install Sybase Opclient so i run the > programs isql.exe this program put the Windows this say the > MSVCRT20.DLL this is incompatible with win32s. > > > Please Help me what i do? > > -------------- next part -------------- An HTML attachment was scrubbed... URL: http://www.winehq.org/pipermail/wine-users/attachments/200...

I'm trying to use func_odbc to write to a MS SQL db. Here's my func_odbc conf: [OPTIN] dsn=MSSQL-Optin write=INSERT into OptIn (orgID) values (${VAL1}) Dial Plan exten => +18665551212,n,Set(ODBC_OPTIN()=dave) When I do an odbc show, it shows that I am connected to the db. If I use isql, I can write to the db, however, when I use func_odbc, a record will not write. I'm using asterisk 1.4.9. Any idea what might be wrong? Thanks -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/2009081...

Hi, is cdr logging using odbc buggy? I'im only getting an error "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.". Connecting with isql to the datasource given in cdr_odbc.conf works just fine, and using the database for sippeers also works. The documentation[1] is confusing because it says freeTDS is required and that you must not use multiple database connectors and remains entirely unclear about whether odbc works at all for...

...king for mandatory modules: UNIXODBC... ok configure: creating ./config.status ######################################## And then when I go to make menuselect; [XXX]Res_odbc [XXX] func_odbc [XXX] cdr_odbc Can anyone help out with what I am missing? [I've gotten to a stage where tsql and isql connections to my sql db work, however, getting odbc right is making me pull my hair out a bit]