VB6 apps for Sybase System 11 (16-bit)

[SonGouki]

I need to know if it's possible to use VB 6, which is 32-bit,
to program apps that access a 16-bit Sybase System 11 database.

I've read through some help files, and come across the
concept of 'thunking', which supposedly uses a couple of
dlls (ODBC32.DLL and ODBC16UT.DLL) to provide
the necessary translations to break the barrier. What I
need to know is how do achieve this?

If anyone can help it would be GREATLY appreciated!
You'll be saving me from 16-bit VB4 hell!!

- Thanks, SonGouki

[Serge]

If you have ODBC driver installed for Sybase System 11 then it is very easy to do it:

Dim cn As New ADODB.Connection
Dim strConn As String

strConn = "Driver={Sybase System 11};ServerName=MyServer;LogonID=MyLogon"
cn.Open strConn, , "MyPassword"

'Here do other stuff after you have connection opened.

That's it.

[SonGouki]

Thanks... but,

By the ODBC driver, do you mean Syb32 for the ODBC32? Or can I use the the 16-bit driver for the ODBC that is already installed? I ask because, as is, the code you provided doesn't work. I'm kind of new at the ODBC stuff, so any help that you can provide is greatly appreciated.