DSN-less "ODBC" connections on Unix 
Author Message
 DSN-less "ODBC" connections on Unix

Hi,

I have an ODBC application that I'm trying
to "port" to Unix/Informix Online. We use
SQLDriverConnect to perform "DSN-less"
connections. However, I've not been able to get
this to work. The Informix driver typically
returns "general error". I have got DSN
connections of the form "DSN=xyz;" to work so I
think the connectivity is OK.

My build/test environment is:

OS: HPUX 10.20
Server: Online 9.20
Client SDK: 2.40.UC11
Informix Driver: 3.3 32-BIT

IMHO the documentation is very poor when it comes
to the build environment - the release notes tell
me NOTHING about which libraries I need to link
with - I've had to guess from the demo makefile.

I've ended up using
$INFORMIXDIR/lib/cli/libifdrm.sl and
$INFORMIXDIR/lib/cli/libifcli.sl as these are the
only ones that a) link and b) provided any
connectivity at all (via DSN based connection).

What I'm trying to produce is a program that
links DIRECTLY to the informix driver i.e.
without the Driver Manager - I'm not convinced
this is happening using the above linkage.

The runtime documentation in this area is equally
bad. Details of which connections strings to use
differ from manual to manual - and there are even
contradictions in a single manual.

I'm trying to use something like:

"DRIVER=/usr/informix9.20/lib/cli/iclis09b.sl;SERV
ER=online_server;DATABASE=demo;UID=informix;PWD=pa
ssword;"

iclis09b.sl is the single threaded shared library
3.3 Informix Driver (supposedly)
online_server points to a shared memory server
references in my sqlhosts file
demo is a valid database and UID/PWD are correct.

I've also ensured my $SHLIB_PATH environment
variable is set to
$INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/esql

Is DRIVER only required if the Driver Manager is
involved ?

What are the valid connection parameters ?

Which shared object libraries should I be linking
to if I want "miss out" the driver manager ?

Any and all help gratefully received.

Regards

Nick Rumble

So, my quest

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. "DSN-less" connection

2. DSN-less connections using INFORMIX 3.3 Unix ODBC

3. "Client-less" database connections

4. DSN-less Connections Versus DSN Connections

5. max of ("...","...","..")

6. Error in using "DSN-Less" ODBC Connections with RDO

7. ODBC Error 08S01 "connection broken"

8. ODBC and "Use trusted connection"

9. "ODBC--call failed" on connection

10. ODBC Connection in .NET being "global"

11. performance different between DSN to DSN-Less Connection

12. DSN vs DSN-less connections


 
Powered by phpBB® Forum Software