Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 4 of 4 total |
OLEDB? |
Thu, Jun 29 2006 1:14 PM | Permanent Link |
Peter Schott | I'm trying to link into different sets of DBISAM files and use that data from within MS
SQL Server. The DBISAM data is maintained in its own system and SQL Server is also its own system. I'd prefer to do this via OLE-DB if possible. From what I've seen of most OLE-DB providers, there's a direct table-access option where ODBC requires entering a command such as "select * from table where...". We're not worried about blocking as the access from SQL Server will be done when the DBISAM database is not in use. Does anyone have any pointers on how I could go about setting up a connection through OLEDB or will I need to use ODBC through OLEDB (which seems to be my only real option for a linked-server or DTS/SSIS type option). Thanks for your help. -Peter Schott |
Thu, Jun 29 2006 2:57 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Peter,
<< Does anyone have any pointers on how I could go about setting up a connection through OLEDB or will I need to use ODBC through OLEDB (which seems to be my only real option for a linked-server or DTS/SSIS type option). >> For DTS you'll need to use the OLEDB->ODBC bridge provider with our ODBC driver. However, it should be fairly simple to get running by using the provided OLEDB->ODBC bridge dialog for setting up the connection string. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jun 30 2006 9:45 AM | Permanent Link |
Peter Schott | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
Peter, << Does anyone have any pointers on how I could go about setting up a connection through OLEDB or will I need to use ODBC through OLEDB (which seems to be my only real option for a linked-server or DTS/SSIS type option). >> For DTS you'll need to use the OLEDB->ODBC bridge provider with our ODBC driver. However, it should be fairly simple to get running by using the provided OLEDB->ODBC bridge dialog for setting up the connection string. -- Tim Young Elevate Software www.elevatesoft.com -------------------------------------- What if this is DTS or SSIS and I want to change which DBISAM database I'm connecting to and loop through a bunch of different (but structurally identical) databases? That's more what I'm concerned with in this case? Is OLEDB just not a consideration at this point unless it's OLEDB for ODBC? Am I asking this question in the correct group? Thanks. -Pete |
Fri, Jun 30 2006 4:09 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Peter,
<< What if this is DTS or SSIS and I want to change which DBISAM database I'm connecting to and loop through a bunch of different (but structurally identical) databases? That's more what I'm concerned with in this case? >> In that case you'll need to change the initial catalog that you're using for your connection in the connection string: Provider=MSDASQL.1;Persist Security Info=False;Data Source=Test4;Initial Catalog=G:\test4 <<<<< Change this << Is OLEDB just not a consideration at this point unless it's OLEDB for ODBC? >> Yes, we only have an ODBC driver. However, the ODBC driver works fine in most cases with the only exceptions being trying to use dynamic cursors with the OLEDB->ODBC bridge. OLEDB has basically been replaced by ADO.NET at this point, and we will have a native ADO.NET data provider for our upcoming ElevateDB product in addition to an ODBC driver. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |