search for: sqlconnect

...st be ready to head home. I've added a small debug line to cdr_odbc.c as follows: if((ODBC_res != SQL_SUCCESS) && (ODBC_res != SQL_SUCCESS_WITH_INFO)) { if(option_verbose > 10) ast_verbose( VERBOSE_PREFIX_4 "cdr_odbc: Error SQLConnect %d\n", ODBC_res); SQLGetDiagRec(SQL_HANDLE_DBC, ODBC_con, 1, ODBC_stat, &ODBC_err, ODBC_msg, 100, &ODBC_mlen); >> if(option_verbose > 10) >> ast_verbose( VERBOSE_PREFIX_4 "cdr_odbc: Error Details: %s\n", ODBC_ms...

...ERVER=my_special_database [Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:229 load_odbc_config: Adding ENV var: INFORMIXDIR=/opt/informix [Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:508 odbc_obj_connect: Connecting mysql [Feb 22 18:21:46] WARNING[21214]: res_odbc.c:519 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not found, and no default driver specified [Feb 22 18:21:46] WARNING[21214]: res_odbc.c:444 ast_odbc_request_obj: Failed to connect to mysql [Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:302 load_odbc_config: Registered ODBC class 'mysql'...

...71 in get_charset_number () from /usr/local/lib/mysql/libmysqlclient_r.so.14 #2 0x0000002a960761a6 in get_charset_by_csname () from /usr/local/lib/mysql/libmysqlclient_r.so.14 #3 0x0000002a960909a2 in mysql_real_connect () from /usr/local/lib/mysql/libmysqlclient_r.so.14 #4 0x0000002a95f28ba3 in SQLConnect () from /usr/local/lib/libmyodbc3_r.so #5 0x0000002a95baf4e9 in SQLConnect (connection_handle=0x655380, server_name=0x6007f0 "asterisk", name_length1=-4992, user_name=0x770300 "asterisk", name_length2=-6000, authentication=0x60cfb0 "*******", name_length3=-3)...

...b are possible (bind-address = 0.0.0.0 and the user asterisk is allowed to connect from each ip). The password in the config is the right one i already double checked it. Jul 23 12:31:54 WARNING[10380]: res_odbc.c:559 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=1044 [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for u ser 'asterisk'@'%' to database 'asterisk' Any suggestions? Thanks

...b/site_ruby/1.8/DBD/ODBC/ODBC.rb:95:in `connect'' from /usr/local/lib/site_ruby/1.8/dbi/dbi.rb:584:in `connect'' from /usr/local/lib/site_ruby/1.8/dbi/dbi.rb:384:in `connect'' from (irb):2 from :0 Output from isql test: [ISQL]ERROR: Could not SQLConnect I followed the troubleshooting section in the above RubyOnRails Wiki page, but am not able to get unixODBC to see the freeTDS driver it seems. Thanks in advance, Andy Pflueger --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google...

...[app_dbodbc.so] => (Database access functions for Asterisk extension logic) == Parsing '/etc/asterisk/odbc.conf': Found > app_dbodbc: dsn is MySQL-asterisk > app_dbodbc: username is asterisk > app_dbodbc: password is [secret] > app_dbodbc: Error SQLConnect -1 Jul 22 13:15:18 ERROR[8192]: app_dbodbc.c:441 odbc_load_module: app_dbodbc: Unable to connect to datasource: MySQL-asterisk > app_dbodbc: Unable to connect to datasource: MySQL-asterisk == Registered application 'ODBCget' == Registered application 'ODBCput' == Reg...

...[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). Connection failed: SQLState:'08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][Shared Memory] SQL Server does not exist or access denied. So if isql lets me conenct and show tables etc. and "sqlconnect()" in foxpro brings up the dialogue. What is between those two to stop it? WINEDEBUG=+odbc32 is set, but I haven't seen anything helpful yet, unless I'm looking in the wrong place. Is there a more up-to-date set of instructions I overlooked? So close.......;-( -- ldb

.../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 -S remote_server -U name -P password locale is "en_US.UTF-8" locale charset is "UTF-8" 1> use pubs 2> go 1> select count(*) from aut...

...nd SIP compatible VOIP client $: asterisk -U asterisk -vgc give me some WARNING like : ,---- | WARNING[21806]: res_musiconhold.c:852 moh_register: Unable to open | pseudo channel for timing... Sound may be choppy. | | WARNING[21806]: res_odbc.c:565 odbc_obj_connect: res_odbc: Error | SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not | found, and no default driver specified `---- but asterisk daemon start well. the pb is when I start ekiga I always get : IN FRENCH : L'inscription de ekiga a 10.0.0.1 a echoue IN ENGLISH :ekiga cannot subscribe I don't know...

...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 = myuser PASSWORD = mypass PORT = 3306 DATABASE = asterisk And odbcinst.ini: [MySQL] Description = ODBC for MySQL Driver...

.... The connection to my database server depends on a VPN tunnel being up, and if Asterisk starts before that tunnel is functional, I get messages such as the following in the Asterisk log file: [2020-06-23 10:40:22.384335] delta WARNING[1697]: res_odbc.c:958 in odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=1045 [unixODBC] [ma-3.0.6]Access denied for user 'Trimble'@'delta.example.net' (using password: YES) The problem is that this is not a fatal error as far as Asterisk is concerned, so it continues to start up to the point where I get: [2020-06-23 10:40:26.076377] delta V...

...bc.conf, odbc.ini, odbcinst.ini and voicemail.conf When I start My Asterisk server it give me Some Warning, When I googled , a proper Docummentation is not found, it found in some there languages, the First Warning is. Warning [30188] res_odbc.c 565 odbc_obj_connect: res_object:Error SqlConnect =-1 Error=0 [UnixODBC][Driver Manager]Data Source Name Not Found and No default Driver Specified And Second one is Warning [30202] app_application.c 2107 MessageCount : Failed to Obtained for ' Asterisk' ! help me this.............................. -- Thanks and Regards Ravi Prak...

...stalled unixODBC from the source files. I've built and tested an odbc connection. I'm trying to install Asterisk 1.4. I can't get it to recognize the unixODBC installation. I've tried using the "--with-odbc=/usr/local" flag to the configure process. .... checking for SQLConnect in -lodbc... no configure: *** configure: *** The unixODBC installation on this system appears to be broken. configure: *** without explicitly specifying --with-odbc The above example is with the odbc flag specified to Configure. However, there's no difference in results with or without the...

...mysql-connector-odbc-3.51.12-2.2 mysql-5.0.22-2.1 Contents of odbcinst.ini # Driver from the MyODBC package # Setup from the unixODBC package [MySQL] Description = ODBC for MySQL Driver = /usr/lib/libmyodbc.so Setup = /usr/lib/libodbcmyS.so FileUsage = 1 checking for SQLConnect in -lodbc... no configure: *** configure: *** The unixODBC installation on this system appears to be broken. configure: *** Either correct the installation, or run configure configure: *** without explicitly specifying --with-odbc -- ----- Chris Stinson Network Operations Center ISDN-Net, Inc....

...i searched and there is no file available with name libodbcpsql.so. How do can i make it possible to work ? Thanks in Advance, Balakrishnan M root at astserver: ~#isql -v banking [IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed [ISQL]ERROR: Could not SQLConnect root at astserver: ~# -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100413/f85ecd51/attachment.htm

...ERVER=my_special_database [May 3 13:29:14] NOTICE[7477]: res_odbc.c:235 load_odbc_config: Adding ENV var: INFORMIXDIR=/opt/informix [May 3 13:29:14] NOTICE[7477]: res_odbc.c:530 odbc_obj_connect: Connecting asterisk [May 3 13:29:14] WARNING[7477]: res_odbc.c:541 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not found, and no default driver specified [May 3 13:29:14] WARNING[7477]: res_odbc.c:463 ast_odbc_request_obj: Failed to connect to asterisk [May 3 13:29:14] NOTICE[7477]: res_odbc.c:316 load_odbc_config: Registered ODBC class 'asterisk...

...ose 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 = myuser > PASSWORD = mypass > PORT = 3306 > DATABASE = asterisk > >...

Hi all, I'm new to asterisk. I have it installed and 1 x100p card. I'm trying to use kphone to connect out. But, when I start * it gives me sound card busy error. I've checked ps aux and nothing seems to have the sound card. Any ideas? Does starting asterisk automatically take the sound card? Also, can you use the phone connected into the XFO card w/ asterisk or do you need an XFS card

...erisk Aug 26 15:43:57 VERBOSE[13818] logger.c: -- cdr_odbc: username is voip Aug 26 15:43:57 VERBOSE[13818] logger.c: -- cdr_odbc: password is [secret] Aug 26 15:43:57 VERBOSE[13818] logger.c: -- cdr_odbc: table is cdr Aug 26 15:43:57 VERBOSE[13818] logger.c: > cdr_odbc: Error SQLConnect -2 Aug 26 15:43:57 ERROR[13818] cdr_odbc.c: cdr_odbc: Unable to connect to datasource: MSSQL-asterisk Aug 26 15:43:57 VERBOSE[13818] logger.c: -- cdr_odbc: Unable to connect to datasource: MSSQL-asterisk Another reload and it's fine again (no restart this time): Aug 26 15:44:19 VERBOSE[13...

Dear all, platform i386-pc-mingw32 arch x86 os Win32 system x86, Win32 status major 1 minor 2.3 year 2001 month 04 day 26 language R I wrote the following to import tables in different database formats (Access, Visual FoxPro, etc.): getTable <-