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 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&#39;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">&lt;<a href="mailto:mayamatakeshi@gmail.com">mayamatakeshi@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;"><br><br><div class="gmail_quote"><div class="im">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>_______________________________________________<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>