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 class="Apple-style-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><div><br></div></div><div class="gmail_quote">On Sun, Mar 28, 2010 at 10:03 PM, mayamatakeshi <span dir="ltr"><<a href="mailto:mayamatakeshi@gmail.com">mayamatakeshi@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><br><br><div class="gmail_quote"><div class="im">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>_______________________________________________<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>