Help with SQL Query

Permanently deleted user

December 12, 2012 03:04

I could use some help with a SQL Query Database activity that is throwing an error..

Connection String: Driver={Microsoft Access Driver (*.mdb)};Dbq=E:\Program Files\Latitude Geographics\Geocortex Essentials\Intranet\REST Elements\Sites\Resources\Data\Devnet.mdb

Provider Name: System.Data.Odbc

This tests OK

Command Text: SELECT * FROM DEVNET

Parameters: none

Results: dataTable1 (System.data.DataTable)

The error: Fill: SelectCommand.Connection property has not been initialized

Thanks

0

• 

  Ryan Cooney

  December 12, 2012 06:04

  Hi Bill,

  Which version of Essentials are you running? This looks very similar to an issue that was resolved in 3.11.1.

  --Ryan

  0
• 

  Permanently deleted user

  December 12, 2012 22:51

  We are currently at version 3.11.0 so will go ahead with the install of 3.11.1.

   

  Thanks Ryan.

  0

Please sign in to leave a comment.