similar to: Can't MS SQL Server 2000 Client/Server

I just started investigating Ruby on Rails and am trying the tutorial. I need to connect to a SQL Server 2000 database for testing purposes. I followed the instructions in the How-To on the wiki for SQL Server. The problem is that when attempting to connect to the database I receive the following errors: DBI::DatabaseError in RecipeController#new Open OLE error code:80004005 in

Help! I've been using mysql for cdr storage, I need to switch to MS SQL. I must be stupid or something but I cannot figure out how to setup the cdr_tds. I have FreeTDS configured properly, but my unixodbc is not working properly either... I'd be happy with either solution, but I'm in need of assistance. Luke Catranis

Hi guys, 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

The SQL Server adapter can currently operate in two modes, ADO and ODBC, each of which uses a different interface to access the db. The ADO interface is currently the default, while ODBC can be specified as an option. I propose this situation is reversed, and that use of the ADO interface is deprecated, if not removed altogether. Here are some reasons, I'm sure there are more: a) ADO uses

I am trying to get * to write CDR records to an MS SQL table. I am used the freeTDS set up (not using UNIX ODBC), and it appears to be making the connection to the database, but I make a call, I get this error: WARNING[3369]: cdr_tds.c:180 tds_log: Reconnected to SQL database. ERROR[3369]: cdr_tds.c:191 tds_log: Failed to insert Call Data Records into SQL database. I've assigned all rights

Hi, I have Asterisk 12.7.1 installed through Asterisk@Home CD. and explicitly I have installed UnixODBC and FREETDS in order to access MS SQL 2000 Database which in on Windows 2003 Server on remote location. I tested connectivity through isql and tsql, both utilities are working fine. I need to access MS SQL 2000 Database through PHP. When I tired to check the connectivity through a Test PHP

Hi -- I''ve been having problems connecting to a SQL Server database that I thought might be related to the fact I was upgrading Rails to 2.0. However, I also was moving the project to my shiny new macbook. Anyway, after jumping through a few hoops (instaling DBI, etc.), I finally get to my latest error message: <error> DBI::InterfaceError: Could not load driver (no such file to

I would appreciate any tips/clues/advice very much. I have started using ruby on rails and when the MS SQL Server database is on a different box than my dev box (where the RoR app is located) I can connect fine. However when I try to connect to a MS SQL Server database on the same box as my RoR app I get an error. I have tried to use the IP address of the dev box as the value of

I have a project that is requiring the use of MS SQL from asterisk. I get an error when the pjsip contact tries to update the contact table. [Oct 15 21:34:55] WARNING[3033]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 22018: [FreeTDS][SQL Server]Conversion failed when converting the varchar value '3.000000' to data type int. (101) The datatype

hi all I want to connect my asterisk system with a MS sql .I have done it with MYSQL but i want to connect it with MS SQL.I have tried a lot but not getting anything.Can anybody help me on this.' Thanks in advance Rahul -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080301/48ee67ee/attachment.htm

I have a question for RODBC users out there. I have used the package with good results for some time. However, I have just switched from an OpenLink proprietary driver for MS SQL to the FreeTDS driver (I think it is MS SQL Server 2000 I'm connecting to if it matters). I was/am running them from unixODBC on a Linux Client. I think I have it set up fine since I can use "isql"

Have installed ruby-one-click installer 1.8.4-16 and rails. Am unable to get an app to talk to by SS2000 database using adapter: sqlserver. Is Sql Server support built-in, or do I need to install something else? -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson -------------- next part -------------- An HTML attachment

Hi, i?m trying to access a MSSQL server (in a windows machine in the network) from a Visual Basic Application running under wine, using an ODBC driver. Since there aren?t any MSSQL drivers for linux i decided to use de native ones, so i installed mdac_typ.exe . Then i configured the DSN using odbcad32.exe but when i tested the connection (configured using tcp/ip) an error message appeared

Hi there, I am looking around, is there anyone did any integration asterisk talk to / connect to MS SQL? Thanks -- Regards, Sharon Lim *Good memories are to be folded neatly and tucked away into the back pocket * -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20061114/8ef6aad2/attachment.htm

I am trying to write a customized app using C that would fetch voice file from SQL Server 2000 using ODBC and FREETDS. Currently I am only able to fetch first 63 KB chunk from the DB, and not able to fetch the rest of the file, below is the code that i am using to do so, fd = open(fullpath, O_RDWR | O_CREAT | O_TRUNC, 0770); if (fd < 0) { ast_log(LOG_WARNING, "Failed to write

Hi, In an app I''m developing I''ve run into a strange problem. I''ve created some controllers and models using the scaffolding generator and everything seemed to work fine. However I''ve noticed that a particular model I''ve created always fails its tests and I can''t test it out in a browser due to the same error I''m getting which is:

I've got an Asterisk switch that is going to run an IVR menu with a database interface that will be doing lookups based on the user entered data and then reading back strings with the appropriate data integrated into the text. I have found quite a bit of data on using MySQL as a database with Asterisk, but I haven't found much about using MS SQL Server with Asterisk... We have a SQL

Hello, after putting ADO.rb into Directory \ruby\lib\ruby\site_ruby\1.8\DBD\ADO\ I created a Rails-Application with MS SQL Server 2000 as Database. Everything works fine, but into the nvarchar-Field "notice" i can''t store more than about 50 or 60 characters MS SQL Server Query analyzer says, this field has a length of 510 characters. What can i do to save up to the 510

One of my clients use a software product that is "upgrading" and will shortly utilize micro$oft SQL server 2005. Currently the clients are XP on older machines with the database residing on a Samba / CentOS server and this works very well. Question: Does anyone run SQL server from XP in a virtualbox on CentOS? Any other configuration that works on a linux server? I do not want to have

I''m having an error from Linux via freeTDS/ODBC to SQL Server with cod that runs fine against SQLite and MySQL. Here''s the code: def find_recipes_for_workorder_by_id @recipe_pages, @recipes = paginate_with_sort :recipes, :per_page => 10, \ :conditions => ["recipe.workorder_id = ?", params [:workorder]] render :template =>