Skip to Content.
Sympa Menu

freetds - Re: [freetds] Create a shell to get data from SQL Server using FreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: dmarrer AT bci.cl
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Create a shell to get data from SQL Server using FreeTDS
  • Date: Wed, 12 Nov 2008 15:09:37 -0300

I read this in the documentation:

configure will not cause the ODBC driver to be built unless this option is
used or a DM is detected/specified.

What's this mean?

If i want to access SQL Server using FreeTDS then I need to configure
using:

./configure -prefix=mypath -with-odbc-nodm=location of .h files

I try to do this:

copy sql.h, sqlext.h and sqltypes.h to /usr/local/include dir

./configure -prefix=mypath -with-odbc-nodm=/usr/local/include

And the result is

checking compile-time options
configure: error: sql.h not found

What's wrong?

Thanks a lot





dmarrer AT bci.cl

Enviado por: freetds-bounces AT lists.ibiblio.org
12-11-2008 14:44
Por favor, responda a
FreeTDS Development Group <freetds AT lists.ibiblio.org>


Para
freetds AT lists.ibiblio.org
cc

Asunto
[freetds] Create a shell to get data from SQL Server using FreeTDS






Hi guys

I new in Unix and FreeTDS and need your help.

I install FreeTDS 0.82 to connect to SQL Server using the default install:

./configure -prefix=mypath
make
make install

Then I configure my freetds.conf like this:

# MyServer
[MyServer]
host = xxx.xxx.xxx.xxx
port = 1433
tds version = 8.0

I test the connection with tds and the result is OK

# tsql -S myServer -U user -P password
locale is "C C C C C C"
locale charset is "roman8"
1>

Now I want to create a shell that connect to SQL Server using FreeTDS and
write result data in a text file

How I write this shell? Which libraries I have to use?

I need install unixOdbc to use libtdsodbc.so library or I can create the
shell using only FreeTDS?

Thanks

Daymel
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page