Support for Sybase (ASE)

Brought to you by: glenncarr, wellige

#16 Support for Sybase (ASE)

Status: open

Owner: nobody

Labels: None

Priority: 5

Updated: 2004-05-02

Created: 2004-05-02

Creator: Anonymous

Private: No

To support Sybase (ASE) 11.5 / 12.0 (and MS-SQL but
I'm not sure) add a switch to change the following:

File - ute_class.inc
Function - AnalyzeTable

The Sybase ODBC driver fails (and MS-SQL?) on:
rsTemp.Open "[" & m_sTable & "]", m_DB, adOpenStatic,
adLockReadOnly, adCmdTable

Instead, for Sybase, use:
rsTemp.Open "" & m_sTable & "", m_DB,
adOpenForwardOnly, adLockReadOnly, adCmdTable

Have fun,
Sagi S.