[freetds] [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified

[rasiel payumo]

Hi,

Sorry if my question had been posted many times...

i have installed freetds and unixodbc driver to our linux (gentoo) server i follow the instruction as it said to http://www.rockfloat.com/howto/gentoo-mssql-freetds.html but when i run a sample odbc php connection file, an error occurs:
[freetds] [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified

i really don't know what to do please help... i am losing hope to this problem.


Bring your friends to the fun. Invite your friends from Hotmail, Gmail to Yahoo! Mail today! http://www.trueswitch.com/yahoo-ph

[James K. Lowden]

Post by rasiel payumo
[freetds] [IM002][unixODBC][Driver Manager]Data source name not found,
and no default driver specified

http://www.freetds.org/userguide/usefreetds.htm#UTILITIES

In your FreeTDS source tree, you should find:

src/apps/osql
doc/osql.txt

"man osql" should also show the man page.

If you don't have these in your distribution, you can use any more recent
distribution or download them from CVS.

osql is a Bourne shell script that checks your ODBC setup. If it
succeeds, it invokes unixODBC's isql utility. If it fails, it points out
where you went wrong. If neither of those happens for you, it's a bug,
and I'd be much obliged if you'd report it. (Patches also accepted!)

You can also use TDSDUMPCONFIG to log the severname lookup process. ODBC
also has a trace facility, but I don't think that would be much help here.


HTH.

--jkl

[rasiel payumo]

sorry, i'm new to linux but could you please tell me where i can find the FreeTDS source tree?
when i typed "man osql" in my putty it's said that there's no manual entry for osql..







________________________________
From: James K. Lowden <jklowden at freetds.org>
To: FreeTDS Development Group <freetds at lists.ibiblio.org>
Sent: Tuesday, February 3, 2009 2:46:31 PM
Subject: Re: [freetds] [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified

Post by rasiel payumo
[freetds] [IM002][unixODBC][Driver Manager]Data source name not found,
and no default driver specified

http://www.freetds.org/userguide/usefreetds.htm#UTILITIES

In your FreeTDS source tree, you should find:

src/apps/osql
doc/osql.txt

"man osql" should also show the man page.

If you don't have these in your distribution, you can use any more recent
distribution or download them from CVS.

osql is a Bourne shell script that checks your ODBC setup. If it
succeeds, it invokes unixODBC's isql utility. If it fails, it points out
where you went wrong. If neither of those happens for you, it's a bug,
and I'd be much obliged if you'd report it. (Patches also accepted!)

You can also use TDSDUMPCONFIG to log the severname lookup process. ODBC
also has a trace facility, but I don't think that would be much help here.


HTH.

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds



Importing contacts has never been easier.. Bring your friends over to Yahoo! Mail today! http://www.trueswitch.com/yahoo-ph

[James K. Lowden]

Post by rasiel payumo
could you please tell me where i can find the FreeTDS source tree?

If you want the complete sources (not that many files, but more than two,
you can download the current stable release version from:


http://www.freetds.org/

(http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz).

To get the two files you need from CVS, also on the main page you'll find
a link to "Browse CVS". If you follow that, three or four clicks will
take you to osql revision 1.7 (
http://freetds.cvs.sourceforge.net/viewvc/freetds/freetds/src/apps/osql?revision=1.7&view=markup).
Navigate similarly to the doc directory for the man page text.

Post by rasiel payumo
when i typed "man osql" in my putty it's said that there's no manual entry for osql..

You might have an old version, or it might not be installed, or not
installed in the right place. No matter. Run the osql script, see if it
helps, and let us know. Also read up in the manual for the TDSDUMP and
TDSDUMPCONFIG variables; they can help troubleshoot connection problems.

Post by rasiel payumo
sorry, i'm new to linux

No matter. Everyone starts somewhere. It gets better with time. :-)

--jkl