SQLServer using ODBC?

"Boyer, Galen" <[email protected]> Wed, 20 Jul 2011 15:15:04 -0400
Newsgroups	gmane.comp.db.unixodbc.devel
Message-ID	<[email protected]>
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