Yes! I followed the instructions <a href="http://wiki.freeswitch.org/wiki/Mod_spidermonkey_odbc#Manual_Installation">here</a> for setting up ODBC, including linking the .ini files in freeswitch/etc. Based on the test below it seems that the driver is working properly. Is the code below correct (i.e. &#39;require &quot;luasql.odbc&quot;;&#39; and &#39;env = assert(luasql.odbc());&#39;)?<div>

<br></div><div>Thanks,</div><div>Neil<br><div><br><div class="gmail_quote">On Mon, Mar 29, 2010 at 7:55 AM, Aloysius Lloyd <span dir="ltr">&lt;<a href="mailto:lloyd.aloysius@gmail.com">lloyd.aloysius@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Did you uncomment from the following line in config file.<div><br></div><div><div><br></div></div><div><div>T= odbc</div>

<div><br></div><div>Thanks</div><div>Lloyd</div><div><div></div><div class="h5"><br><div class="gmail_quote">On Mon, Mar 29, 2010 at 3:30 AM, Neil Patel <span dir="ltr">&lt;<a href="mailto:neilp@cs.stanford.edu" target="_blank">neilp@cs.stanford.edu</a>&gt;</span> wrote:<br>


<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Thanks all, got it to compile and seems like my odbc connection is working properly:<div><br></div><div>[root@topaz bin]# isql maxpowersoft_odbc &lt;myUser&gt; &lt;myPwd&gt;<div>


+---------------------------------------+</div>

<div>| Connected!                            |</div><div>|                                       |</div><div>| sql-statement                         |</div><div>| help [tablename]                      |</div><div>| quit                                  |</div>




<div>|                                       |</div><div>+---------------------------------------+</div><div>SQL&gt;</div><div><br></div><div>In my lua script I have</div><div><br></div><div>require &quot;luasql.odbc&quot;</div>




<div><br></div><div>But am getting this error:</div><div><br></div><div><div>2010-03-28 22:21:42.080859 [ERR] mod_lua.cpp:182 /usr/local/freeswitch/scripts/AO/paths.lua:49: [unixODBC][Driver Manager]Data source name not found, and no default driver specified</div>




<div><br></div><div>The line it&#39;s failing on is:</div><div><span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse"><pre style="white-space:pre-wrap;word-wrap:break-word">env = assert (luasql.odbc());</pre>


</span></div><div>Thanks in advance for letting me know what I&#39;m doing wrong.</div><div><br></div><div>Best,</div><div>Neil</div><font color="#888888"><div><br></div></font></div><div class="gmail_quote"><div><div></div>


<div>On Sun, Mar 28, 2010 at 10:03 PM, mayamatakeshi <span dir="ltr">&lt;<a href="mailto:mayamatakeshi@gmail.com" target="_blank">mayamatakeshi@gmail.com</a>&gt;</span> wrote:<br>

</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div></div><div><br><br><div class="gmail_quote"><div>On Mon, Mar 29, 2010 at 1:44 PM, Neil Patel <span dir="ltr">&lt;<a href="mailto:neilp@cs.stanford.edu" target="_blank">neilp@cs.stanford.edu</a>&gt;</span> wrote:<br>




<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
Hi Lloyd,<div><br></div><div>Even after the change to the config file below, I can&#39;t get the package to compile:</div><div><br></div><div><div>[root@topaz luasql-2.1.1]# make</div><div>export MACOSX_DEPLOYMENT_TARGET=&quot;10.3&quot;; gcc -O2 -fPIC -Wall -Wmissing-prototypes -Wmissing-declarations -ansi -pedantic -I../compat/src -DUNIXODBC -I/usr/local/include -I/usr/local/include  -o src/odbc.so -shared  src/luasql.o src/ls_odbc.o  -L/usr/local/lib -lodbc</div>







<div>/usr/bin/ld: src/luasql.o: relocation R_X86_64_32 against `a local symbol&#39; can not be used when making a shared object; recompile with -fPIC</div><div>src/luasql.o: could not read symbols: Bad value</div><div>collect2: ld returned 1 exit status</div>







<div>make: *** [src/odbc.so] Error 1</div><div><br></div><div>Anything I need to change or do other than add -fPIC to CFLAGS?</div></div></blockquote></div><div><br>Here&#39;s<br>the script I use.<br></div><br></div><br>





<br></div></div><div>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></div></blockquote></div><br></div>
<br>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br></div></div></div>
<br>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br></div></div>