|
SmartWare provides an ODBC driver which can be
used by other applications such as Excel to access data from a
SmartWare database. The ODBC driver allows concurrent
connections equal to the number of nodes purchased. ODBC is
a very common technology in the database field. SQL queries
can be executed in conjunction with an ODBC connection.
A new feature to SmartWare is ODBC Linking. If
the data source you wish to link to provides an ODBC driver, a
link between that data source and a SmartWare database file can be
configured. Any update to either source is reflected in the
other data file.
Now, an ODBC connection can be used to create
SmartWare views of data from external data sources which provide
an ODBC driver. Once the ODBC connection is made, the data
can be imported into a SmartWare view. The import can use a SQL
query to restrict the data being imported. Once the data is in a
SmartWare view, that view can be treated like any other SmartWare
view.
OBDC
drivers are available for SQL and ISAM Faircom database files.
Also there are ODBC drivers available for web server based
applications. The licensing agreement does not allow for the
accessing of data via a web based application without proper
access licensing. Please call to obtain price and the
correct driver. 608.489.4122
Connection Strings are used in ADO, websites and in SPL
code to connection to SmartWare data sources. Their
potential uses are many. Below are three examples, refer to
documentation for more information.
DRIVER=SmartWare Driver (*.db);SERVER=fnew@workpc;DBTYPE=C/S-Smart5;DBQ=.
DRIVER=SmartWare
Driver(*.db); SERVER=Smart4; DBTYPE=Smart4;DBQ=c:\conf\ex6
DRIVER=SmartWare Driver (*.db);SERVER=Smart5-Loc;DBTYPE=Local-Smart5;DBQ=c:\conf\ex6
|
