On Fri, 22 Oct 2010 04:53:06 -0500, Cosimo Guglielmucci
<cosimo.guglielmucci / gmail.com> wrote in
<c34bbdec0a4759315d54d7c13d36e23c / ruby-forum.com>:

>I've found very few on the net in regards of Windows and the option
>available in the ODBC Driver/ODBC Driver Manager.
>So the following problem still remain unsolved:
>
>irb> require 'odbc'
>irb> conn = ODBC::connect('giomai_db_dsn', 'sa', 'password' )
>irb> query = conn.prepare("select * from cittwhere idcitt= 1)
>irb> query.execute
>ODBC::Error: 37000 (170) [Microsoft][ODBC SQL Server Driver][SQL
>Server]Riga 1: sintassi non corretta in prossimit? di '.
>                  from (irb):xx:in `execute'
>                  from (irb):xx

This is really a problem with the ODBC driver for SQL Server.  You'd
be much more likely to get answers in the newsgroup for that topic.
See microsoft.public.sqlserver.odbc, which you can access via
Microsoft's "Communities" function
<http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.odbc>
or Google Groups
<http://groups.google.com/group/microsoft.public.sqlserver.odbc/topics>.

-- 
Charles Calvert
Moderator - alt.computer.consultants.moderated
Submission Address: accm / celticwolf.net
Contact Address: accm_mod / celticwolf.net