SQL Anywhere for Linux - Help with ASA 9/ODBC on Suse

Author

Help with ASA 9/ODBC on Suse

Mike Dunn

2005-04-05, 8:03 pm

Hi Group!

I know next to nothing about Linux but am an eager learner!

For my initial test, I'm trying to get a connection from Suse Linux to my XP
box which runs the ASA server.

So far, I have downloaded and installed the developer edition of ASA 9 for
linux. I just installed the network client portions of it for now.

Following the linux HowTo, and other sources, this is what I've done so far
after the initial setup:

1) Created environment variables by running asa_config.sh from the console
(in the /opt/sybase directory).

2) Created symbolic links
From console command at /opt/sybase/SYBSsa9/lib

ln -s libodbc9.so libodbc.so
ln -s libodbc9.so libodbc.so.1
ln -s libodbc9.so libodbcinst.so
ln -s libodbc9.so libodbcinst.so.1

3) Create .odbc.ini file and placed it in the /etc directory
[ODBC Data Sources]
MyDB=Adaptive Server Anywhere 9.0

[MyDB]
Driver=/opt/sybase/SYBSsa9/lib/libodbc.so
CommLinks=tcpip(host
=192.168.1.1;DoBroadcast=no)
ENG=NameofDBServer
DatabaseName=TestDB

When I run my application (PB program run via WINE), I get the following
error message:
Can't open lib /opt/sybase/SYBSsa9/lib/libodbc9.so
/opt/sybase/SYBSsa9/lib/libodbc9.so: cannot open shared object file: no such
file or directory.

Is there a better source of information for a configuring ASA/ODBC on Linux?
I thought I was good at figuring stuff out, but this has been a humbling
experience so far.

Thanks!

-Mike

Reg Domaratzki $iAnywhere Solutions$

2005-04-05, 8:03 pm

Does the user running your application have read and execute permission in
the /opt/sybase/SYBSsa9/lib directory?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Mike Dunn" < nospam_mdunn@spiritp
os.com_nospam> wrote in message
news:421f6949$1@foru
ms-1-dub...
> Hi Group!
>
> I know next to nothing about Linux but am an eager learner!
>
> For my initial test, I'm trying to get a connection from Suse Linux to my
XP
> box which runs the ASA server.
>
> So far, I have downloaded and installed the developer edition of ASA 9 for
> linux. I just installed the network client portions of it for now.
>
> Following the linux HowTo, and other sources, this is what I've done so
far
> after the initial setup:
>
> 1) Created environment variables by running asa_config.sh from the console
> (in the /opt/sybase directory).
>
> 2) Created symbolic links
> From console command at /opt/sybase/SYBSsa9/lib
>
> ln -s libodbc9.so libodbc.so
> ln -s libodbc9.so libodbc.so.1
> ln -s libodbc9.so libodbcinst.so
> ln -s libodbc9.so libodbcinst.so.1
>
> 3) Create .odbc.ini file and placed it in the /etc directory
> [ODBC Data Sources]
> MyDB=Adaptive Server Anywhere 9.0
>
> [MyDB]
> Driver=/opt/sybase/SYBSsa9/lib/libodbc.so
> CommLinks=tcpip(host
=192.168.1.1;DoBroadcast=no)
> ENG=NameofDBServer
> DatabaseName=TestDB
>
>
> When I run my application (PB program run via WINE), I get the following
> error message:
> Can't open lib /opt/sybase/SYBSsa9/lib/libodbc9.so
> /opt/sybase/SYBSsa9/lib/libodbc9.so: cannot open shared object file: no
such
> file or directory.
>
> Is there a better source of information for a configuring ASA/ODBC on
Linux?
> I thought I was good at figuring stuff out, but this has been a humbling
> experience so far.
>
> Thanks!
>
> -Mike
>
>

Mike Dunn

2005-04-05, 8:03 pm

Hi!

I have no idea what the permissions are... I guess I would ask - what
permissions did the installer set? ;) Any chance I missed the all important
'read this first' document?

Rather than trying to get you all to troubleshoot my problem, can you point
me to any documents that shows how to install/configure ASA on linux?

Thanks!

-Mike

"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
wrote in message news:421f942d$1@foru
ms-2-dub...
> Does the user running your application have read and execute permission in
> the /opt/sybase/SYBSsa9/lib directory?
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> "Mike Dunn" < nospam_mdunn@spiritp
os.com_nospam> wrote in message
> news:421f6949$1@foru
ms-1-dub...
> XP
> far
> such
> Linux?
>
>

Mike Dunn

2005-04-05, 8:03 pm

The instructions I followed were for version 7

I think I've scrwed up the symbolic links.
Note that I typed this:

> ln -s libodbc9.so libodbc.so
>
as the instructions indicated a libodbc7 - change the version number, right?

Where is the documentation for version 9 ? The file names have changed.

"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
wrote in message news:421f942d$1@foru
ms-2-dub...
> Does the user running your application have read and execute permission in
> the /opt/sybase/SYBSsa9/lib directory?
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> "Mike Dunn" < nospam_mdunn@spiritp
os.com_nospam> wrote in message
> news:421f6949$1@foru
ms-1-dub...
> XP
> far
> such
> Linux?
>
>

Greg Fenton

2005-04-05, 8:03 pm

Mike Dunn wrote:
>
> Where is the documentation for version 9 ? The file names have changed.
>

The ASA 9.x for Linux/Unix/MacOSX ships with a Very Useful document
called "readme.pdf" whose title is "SQL Anywhere Studio for UNIX Read Me
First" (I believe).

It is a Most Worthwhile Read!

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Mike Dunn

2005-04-05, 8:03 pm

Hi Greg!

That was the first thing I read. The only thing that appears relevant is
the last paragraph on page 5 of chapter 1 "..you have the option of using
the new libdbodbc9 library that is shipped with SQL Anywhere 9."

Nowhere does it show how to setup the ODBC.INI file. The HowTo that I
followed for setting up ASA on Linux was for version 7 and doesn't appear to
be valid for ver 9.

I tried to do this the easy way. Now I'm going to call sybase tech support
and bother them. If the documents are there that explains any of this -
they sure hid them well!

Thanks!

-Mike

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:42208ad5$1@foru
ms-1-dub...
> Mike Dunn wrote:
>
> The ASA 9.x for Linux/Unix/MacOSX ships with a Very Useful document called
> "readme.pdf" whose title is "SQL Anywhere Studio for UNIX Read Me First"
> (I believe).
>
> It is a Most Worthwhile Read!
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Mark Culp

2005-04-05, 8:03 pm

To setup your ODBC.INI file, just yse dbdsn
eg.
dbdsn -w foo -c " uid=dba;pwd=sql;eng=
bar;links=tcpip"
will create a DSN called 'foo' that connects to an engine 'bar'
over TCP/IP.
--
Mark Culp
ASA Research and Development
-------------------------------------------------------------------------
** Whitepapers, TechDocs, bug fixes are all available through the **
** iAnywhere Developer Community at http://www.ianywhere.com/developer **
-------------------------------------------------------------------------

Mike Dunn wrote:[color=darkred
]
>
> Hi Greg!
>
> That was the first thing I read. The only thing that appears relevant is
> the last paragraph on page 5 of chapter 1 "..you have the option of using
> the new libdbodbc9 library that is shipped with SQL Anywhere 9."
>
> Nowhere does it show how to setup the ODBC.INI file. The HowTo that I
> followed for setting up ASA on Linux was for version 7 and doesn't appear to
> be valid for ver 9.
>
> I tried to do this the easy way. Now I'm going to call sybase tech support
> and bother them. If the documents are there that explains any of this -
> they sure hid them well!
>
> Thanks!
>
> -Mike
>
> "Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
> news:42208ad5$1@foru
ms-1-dub...

Mike Dunn

2005-04-05, 8:03 pm

Thanks Mark!

Other than the driver= entry, that worked!

-Mike

"Mark Culp" < reply_to_newsgroups_
only_please_nospam_m
ark.culp@iAnywhere.com>
wrote in message news:42246BC7.DA83589F@iAnywhere.com...[color=darkred]
> To setup your ODBC.INI file, just yse dbdsn
> eg.
> dbdsn -w foo -c " uid=dba;pwd=sql;eng=
bar;links=tcpip"
> will create a DSN called 'foo' that connects to an engine 'bar'
> over TCP/IP.
> --
> Mark Culp
> ASA Research and Development
> -------------------------------------------------------------------------
> ** Whitepapers, TechDocs, bug fixes are all available through the **
> ** iAnywhere Developer Community at http://www.ianywhere.com/developer **
> -------------------------------------------------------------------------
>
> Mike Dunn wrote:

Sponsored Links