Re: SQLServer using ODBC?

Hi,
Which DB you are trying to connect to?
If it's a MS SQL Server, you need to install freeTDS found on freetds.org.
It has a good user guide and support is awesome.

You need to grab the latest sources 0.82.pre1 and install it.

If it's other DB, you need to find an appropriate ODBC driver for you DB.

Thank you.

On Wed, Jul 20, 2011 at 12:15 PM, Boyer, Galen <[email protected]> wrote:
> Hi,
>
>
>
> Very much a newbie when it comes to the ODBC on LINUX.  I did not install
> the odbc support on our LINUX box and I need to be able to know what to do
> to get connected (which probably means telling the admin what to further
> install).  I’m using isql to test my connection.  My odbc.ini file found in
> the directory that my ODBCINI exported environmental variable points to has
> the following entry:
>
>
>
> [QUIPS]
>
> Driver       = /usr/lib64/libodbc.so
>
> Description  = Connector/ODBC 3.51 Driver DSN
>
> OdbcConformanceLevel=3.0
>
> ODBC64SqlHandleSize=64
>
> ODBC64SqlLenSize=64
>
> SERVER       = US-BOS-VDB906\QUIPSTST
>
> USER         = XXX
>
> Password     = YYY
>
> Database     = QUIPSTST
>
> OPTION       = 3
>
>
>
> Here are a couple of shell commands to show where I’m at and what the ENV
> variable is.
>
> [bodi_dev@us-bos-ap943 bin]$ echo $PWD
>
> /etl_dev/businessobjects/dataservices/bin
>
>
>
> [bodi_dev@us-bos-ap943 bin]$ echo $ODBCINI
>
> /etl_dev/businessobjects/dataservices/bin
>
>
>
> When I try to use isql I get the following:
>
>
>
> [bodi_dev@us-bos-ap943 bin]$ isql -v QUIPS
>
> [IM002][unixODBC][Driver Manager]Data source name not found, and no default
> driver specified
>
> [ISQL]ERROR: Could not SQLConnect
>
>
>
> I believe my problem stems from the fact that I don’t have an MSSQLServer
> driver actually installed, but my problem could be much more basic.  Any
> help would be appreciated.
>
>
>
> Thanks!
>
>
>
> FYI:
>
>
>
> Here is an ls of the /usr/lib64
>
>
>
> [bodi_dev@us-bos-ap943 lib64]$ ls -ls libodbc*
>
> 1060 -rw-r--r-- 1 root root 1075984 Jul 12  2006 libodbc.a
>
> 148 -rw-r--r-- 1 root root  140414 Jul 12  2006 libodbccr.a
>
>    4 lrwxrwxrwx 1 root root      18 Nov 10  2009 libodbccr.so ->
> libodbccr.so.1.0.0
>
>    4 lrwxrwxrwx 1 root root      18 Nov 10  2009 libodbccr.so.1 ->
> libodbccr.so.1.0.0
>
>   44 -rwxr-xr-x 1 root root   37312 Jul 12  2006 libodbccr.so.1.0.0
>
>    8 -rw-r--r-- 1 root root    2622 Jul 12  2006 libodbcdrvcfg1S.a
>
>    4 lrwxrwxrwx 1 root root      24 Nov 10  2009 libodbcdrvcfg1S.so ->
> libodbcdrvcfg1S.so.1.0.0
>
>    4 lrwxrwxrwx 1 root root      24 Nov 10  2009 libodbcdrvcfg1S.so.1 ->
> libodbcdrvcfg1S.so.1.0.0
>
>   12 -rwxr-xr-x 1 root root    4816 Jul 12  2006 libodbcdrvcfg1S.so.1.0.0
>
>    8 -rw-r--r-- 1 root root    1886 Jul 12  2006 libodbcdrvcfg2S.a
>
>    4 lrwxrwxrwx 1 root root      24 Nov 10  2009 libodbcdrvcfg2S.so ->
> libodbcdrvcfg2S.so.1.0.0
>
>    4 lrwxrwxrwx 1 root root      24 Nov 10  2009 libodbcdrvcfg2S.so.1 ->
> libodbcdrvcfg2S.so.1.0.0
>
>   12 -rwxr-xr-x 1 root root    4512 Jul 12  2006 libodbcdrvcfg2S.so.1.0.0
>
> 276 -rw-r--r-- 1 root root  270608 Jul 12  2006 libodbcinst.a
>
> 1024 -rw-r--r-- 1 root root 1038208 Jul 12  2006 libodbcinstQ.a
>
>    4 lrwxrwxrwx 1 root root      20 Nov 10  2009 libodbcinst.so ->
> libodbcinst.so.1.0.0
>
>    4 lrwxrwxrwx 1 root root      20 Nov 10  2009 libodbcinst.so.1 ->
> libodbcinst.so.1.0.0
>
>   88 -rwxr-xr-x 1 root root   80424 Jul 12  2006 libodbcinst.so.1.0.0
>
>    8 -rw-r--r-- 1 root root    3086 Jul 12  2006 libodbcminiS.a
>
>    4 lrwxrwxrwx 1 root root      21 Nov 10  2009 libodbcminiS.so ->
> libodbcminiS.so.1.0.0
>
>    4 lrwxrwxrwx 1 root root      21 Nov 10  2009 libodbcminiS.so.1 ->
> libodbcminiS.so.1.0.0
>
>   12 -rwxr-xr-x 1 root root    4984 Jul 12  2006 libodbcminiS.so.1.0.0
>
>   12 -rw-r--r-- 1 root root    6798 Jul 12  2006 libodbcmyS.a
>
>    4 lrwxrwxrwx 1 root root      19 Nov 10  2009 libodbcmyS.so ->
> libodbcmyS.so.1.0.0
>
>    4 lrwxrwxrwx 1 root root      19 Nov 10  2009 libodbcmyS.so.1 ->
> libodbcmyS.so.1.0.0
>
>   12 -rwxr-xr-x 1 root root    7760 Jul 12  2006 libodbcmyS.so.1.0.0
>
>    8 -rw-r--r-- 1 root root    2150 Jul 12  2006 libodbcnnS.a
>
>    4 lrwxrwxrwx 1 root root      19 Nov 10  2009 libodbcnnS.so ->
> libodbcnnS.so.1.0.0
>
>    4 lrwxrwxrwx 1 root root      19 Nov 10  2009 libodbcnnS.so.1 ->
> libodbcnnS.so.1.0.0
>
>   12 -rwxr-xr-x 1 root root    4616 Jul 12  2006 libodbcnnS.so.1.0.0
>
> 588 -rw-r--r-- 1 root root  593708 Jul 12  2006 libodbcpsql.a
>
>   12 -rw-r--r-- 1 root root    7262 Jul 12  2006 libodbcpsqlS.a
>
>    4 lrwxrwxrwx 1 root root      20 Nov 10  2009 libodbcpsql.so ->
> libodbcpsql.so.2.0.0
>
>    4 lrwxrwxrwx 1 root root      20 Nov 10  2009 libodbcpsql.so.1 ->
> libodbcpsql.so.1.0.0
>
> 236 -rwxr-xr-x 1 root root  232072 Jul 12  2006 libodbcpsql.so.1.0.0
>
>    4 lrwxrwxrwx 1 root root      20 Nov 10  2009 libodbcpsql.so.2 ->
> libodbcpsql.so.2.0.0
>
> 248 -rwxr-xr-x 1 root root  244104 Jul 12  2006 libodbcpsql.so.2.0.0
>
>    4 lrwxrwxrwx 1 root root      21 Nov 10  2009 libodbcpsqlS.so ->
> libodbcpsqlS.so.1.0.0
>
>    4 lrwxrwxrwx 1 root root      21 Nov 10  2009 libodbcpsqlS.so.1 ->
> libodbcpsqlS.so.1.0.0
>
>   12 -rwxr-xr-x 1 root root    6808 Jul 12  2006 libodbcpsqlS.so.1.0.0
>
>    4 lrwxrwxrwx 1 root root      16 Nov 10  2009 libodbc.so ->
> libodbc.so.1.0.0
>
>    4 lrwxrwxrwx 1 root root      16 Nov 10  2009 libodbc.so.1 ->
> libodbc.so.1.0.0
>
> 412 -rwxr-xr-x 1 root root  411488 Jul 12  2006 libodbc.so.1.0.0
>
>   12 -rw-r--r-- 1 root root    5454 Jul 12  2006 libodbctxtS.a
>
>    4 lrwxrwxrwx 1 root root      20 Nov 10  2009 libodbctxtS.so ->
> libodbctxtS.so.1.0.0
>
>    4 lrwxrwxrwx 1 root root      20 Nov 10  2009 libodbctxtS.so.1 ->
> libodbctxtS.so.1.0.0
>
>   12 -rwxr-xr-x 1 root root    6640 Jul 12  2006 libodbctxtS.so.1.0.0
>
>
>
> --
>
> Galen Boyer
>
> Principal IT Developer
>
> PAREXEL International
>
> 900 Chelmsford Street,
>
> Lowell, MA 01851
>
> Phone: (978) 848-2090
>
> [email protected]
>
>
>
> _______________________________________________
> unixODBC-dev mailing list
> [email protected]
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
>
>
_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev