Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Connecting to Advantage database server (Read 6994 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Connecting to Advantage database server
09.11.05 at 16:25:51
 
SQL*XL was tested against the Advantage database server (ref: www.advantagedatabase.com)
 
Making connections through OLEDB work fine. I have tested all features and everything seems to work properly against the Advantage database.  
 
General information:
Advantage Database Server is a client-server, relational database management system that provides you with Indexed Sequential Access Method (ISAM) table-based and SQL-based data access.
http://www.sybase.com/products/databasemanagement/advantagedatabaseserver
 
Instructions how to setup a connection to Advantage through OLE DB:
http://www.oraxcel.com/projects/sqlxl/help/techniques/connecting/advantage_oledb .html
 
Back to top
 
« Last Edit: 14.08.14 at 19:48:07 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Connecting to Advantage database server
Reply #1 - 14.11.05 at 14:05:18
 
In addition to the OLE DB connections to the Advantage database I have tested ODBC as well. The connections work fine. The multiple rows update feature does not seem to work with ODBC. Other features seem fine.
 
Reference: setting up a connection to Advantage through ODBC:
http://www.oraxcel.com/projects/sqlxl/help/techniques/connecting/advantage_odbc. html
http://www.oraxcel.com/projects/sqlxl/help/techniques/odbc_data_source_administr ator/create_data_source.html#advantage
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1