StarSQL Frequently Asked Questions (FAQs)

The following FAQs are designed to answer common questions regarding StarSQL.

• With what level of ODBC is StarSQL 2.X compliant?
• Does StarSQL bypass RACF security?
• Does StarSQL work with secondary authids?
• Does StarSQL work with MTS?
• Does StarSQL work with ADO?
  For example, I can't get the MSDataShapeProvider to work with StarSQL and I'm having trouble with UpdateBatch.
• Does StarSQL work with OLE/DB?

StarSQL is core SQL compliant, ODBC API version 2, level 1 compliant and also supports the additional level 2 ODBC functions.

StarSQL works with the ODBC Driver Manger version 2.0 and later, including 3.5.

Does StarSQL bypass RACF security?

StarSQL does not bypass RACF security, unless the verify=optional is coded in the APPL statement. Please see the DRDA Connectivity Guide for details.

Does StarSQL work with secondary authids?

StarSQL works with secondary authids. You may need to set it after you login with the command "SetCurrentSQLID="

Does StarSQL work with MTS?

Yes. You can use MTS with StarSQL 2.x for writing VB DLLs, or COM objects. We also work with connection pooling implemented by MTS. In order to use two phase commit, you need to upgrade to StarSQL 3.0 Pro Server. It supports two phase commit using the Microsoft DTC (Distributed Transaction Coordinator) COM interfaces. Microsoft provides mappings from the DTC interfaces to XA. We will provide an XA compliant interface only through MSDTC. A future release of StarSQL 3.x will support two phase commit over TCP/IP.

Does StarSQL work with ADO?

Yes, StarSQL works with ADO. For the best results with ADO, we recommend you upgrade to StarSQL 2.62 or later. (MSDataShapeProvider works with StarSQL 2.62 or later.)

We have written several technical documents that address ADO issues with StarSQL. Please check our Knowledge Base for detailed information and sample code.

Does StarSQL work with OLE/DB?

Yes. If an application looking for an OLE/DB interface to StarSQL, chose the OLE/DB provider for ODBC, and then chose your StarSQL data source. Microsoft has a free and generic OLE/DB Provider for ODBC which allows OLE/DB to access relational table data using an ODBC driver, such as StarSQL. StarSQL does not have a direct OLE/DB interface at this time.

DISCLAIMER
The information in these technical documents comes without any warranty. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The information in these documents is gathered from various sources including IBM, Microsoft, Cisco and others.