Difficulty connecting to an SQL database. I've looked through posts in the forums and tried the suggested tips but still no connectivity. Any help would be most appreciated. Here's where I'm at:
DAQFactory logging set configured as below reports the error: The specified DNS contains an architecture mismatch between the driver and application
Logging method: ODBC database Windows 32 bit
Authentification windows
Data source: USINE
DAQFactory sequence to open database reports the error: O1002 Unable to open ODBC database. I've tried several variations of the OpenEx() call, examples below. None work:
dbase = db.OpenEx("DSN='USINE';UID= ' ';PWD=' '")
Authentification Sql server
dbase = db.OpenEx("DSN='USINE';UID= 'Sql1 ';PWD='sa '")