Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Driver's SQLSetConnectAttr failed ERROR - No data source or driver specified
Wed, Oct 12 2011 4:32 PMPermanent Link

Mike Corrente

Getting the following error when trying to connect to a database with version 3 tables:

ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [IM00] [Elevate Software][DBISAM Database System] No data source or driver specified; dialog prohibited ERROR [IM00] [Elevate Software][DBISAM Database System] No data source or driver specified; dialog prohibited

Version 3.30 Build 1 ODBC driver installed on Windows 7 64-bit machine.  The program runs under 32 bit emulation.

       Dim connString As String = _
           String.Format( _
               "" & _
                   "Driver={0};" & _
                   "ConnectionType=""{1}""" & _
                   "PrivateDirectory={2}" & _
                   "CatalogName=""{3}""", _
               "{DBISAM 3 ODBC Driver}", _
               "Local", _
               Environ("%TEMP%"), _
               "\\ATLAS\BKPROData")
       Dim conn As New Odbc.OdbcConnection(connString)
       conn.Open()
       Stop
       conn.Close()
       conn = Nothing

Exception occurs at "conn.Open()".  Any ideas?
Thu, Oct 13 2011 4:17 PMPermanent Link

Mike Corrente

Can't imagine anyone would repeat my noob mistake, but in case you do here's the solution as kindly provided by Tim:

"...you had the connection string syntax slightly off (missing semicolons)"
Image