Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread OLEDB?
Thu, Jun 29 2006 1:14 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image