Re: emerge unixODBC freetds

>That indicates your odbc.ini is not correct, or in the wrong place, or
>something on that order.   That's what osql is designed to check and
>report on.

my odbc.ini is at /etc/unixODBC/odbc.ini 
i had a feeling that my odbc.ini is not correct also here's what i've wrote:

[alpha]
Driver          = TDS
Description     = puls3 mssql server
Trace           = Yes
TraceFile       = /tmp/unixodbc.trace
Servername      = elk
Server          = 172.30.79.40
Port            = 1433
Database        = myTestDB
UID             = sa
Language        = us_english

i don't have osql or "bad command" as the linux said or "no manual entry for osql" 
where can i find osql setup so that i can install it on linux server and can you give me a tutorial how to install an osql
for "Linux 2.6.25-gentoo-r8 #4 SMP i686 Pentium II (Deschutes) GenuineIntel GNU/Linux"

>And don't worry!  You'll get it eventually.  No one gets it the first
>time, and it's a rough place for a rookie to start.  It's a bit
>convoluted, but it does work.  

Thank you so much for the advice! I really do hope that I can do this job...

--newKiD




________________________________
From: James K. Lowden <[email protected]>
To: FreeTDS Development Group <[email protected]>
Sent: Tuesday, February 3, 2009 6:18:46 PM
Subject: Re: [freetds] emerge unixODBC freetds

rasiel payumo wrote:
> SQL error: [unixODBC][Driver Manager]Data source name not found


That indicates your odbc.ini is not correct, or in the wrong place, or
something on that order.   That's what osql is designed to check and
report on.  

> so i decided to follow another instruction and reinstall the freetds and
> unixODBC again

If I may say so, not very good advice.  The evidence is you've installed
everything correctly, but have not yet set up the configuration files to
describe your local environment.  

Different advice: Breathe.  Again.  Once more.  Good!  Now, don't install
anything.  Calmly go back to the FreeTDS documentation and decide what
kind of ODBC connection you're configuring.  Then examine your odbc.ini
and see if it says what you think it should.  Run osql and see what advice
it offers.  If all else fails, post your odbc.ini here.  

And don't worry!  You'll get it eventually.  No one gets it the first
time, and it's a rough place for a rookie to start.  It's a bit
convoluted, but it does work.  

HTH.  

--jkl
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds



      Surf faster and smarter with Firefox 3! http://ph.downloads.yahoo.com/firefox/