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. 'require "luasql.odbc";' and 'env = assert(luasql.odbc());')?<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"><<a href="mailto:lloyd.aloysius@gmail.com">lloyd.aloysius@gmail.com</a>></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"><<a href="mailto:neilp@cs.stanford.edu" target="_blank">neilp@cs.stanford.edu</a>></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 <myUser> <myPwd><div>
+---------------------------------------+</div>
<div>| Connected! |</div><div>| |</div><div>| sql-statement |</div><div>| help [tablename] |</div><div>| quit |</div>
<div>| |</div><div>+---------------------------------------+</div><div>SQL></div><div><br></div><div>In my lua script I have</div><div><br></div><div>require "luasql.odbc"</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'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'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"><<a href="mailto:mayamatakeshi@gmail.com" target="_blank">mayamatakeshi@gmail.com</a>></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"><<a href="mailto:neilp@cs.stanford.edu" target="_blank">neilp@cs.stanford.edu</a>></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'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="10.3"; 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' 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'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>