How to setup ODBC query with schema

[RandallW]

I am trying to setup DIAdem to query a SQLserver database that was orginally created by Rockwell's Historian (a PLC database). This database is structured around a schema called "RSBizWare". To properly query the database, this schema name must be in the naming structure. I have been attemping to use some of the SQL examples posted in this forum but I cannot figure out how to include this schema field. Any help would ba appreciated.

Thanks

[Brad_Turpin]

Hi RandallW,

You have two options, you can set up a Windows ODBC Administrator profile that successfully applies the required schema, then use the DIAdem ODBC functions, which all start with SQL_...(), or you can construct an ADO connection string which successfully applies the required schema, the use native Windows ADO objects in a VBScript to query the data base.  If both are available, and you have DIAdem 10.1 or higher, I would recommend the ADO approach.  I really don't know how to tell you to apply this schema in your connection to your data base.  Do you have any other software that can connect to that data base?  There may be information on connecting to that data base available on the web.  Once you can connect to it, we can help you use that connection in DIAdem.

Brad Turpin
DIAdem Product Support Engineer
National Instruments