BDE to Unidac Migration

sasdua · Post by **sasdua** » Mon 18 Apr 2011 10:32

Hi All,

Can you please let me know how can I migrate the Tsession component of BDE to unidac. Is there any equivalent component in unidac.

Thanks

Regards
AS

AndreyZ · Post by **AndreyZ** » Mon 18 Apr 2011 14:33

Hello,

UniDAC doesn't have any equivalent for the TSession component. The same functionality is included into the TUniConnection component.

sasdua · Post by **sasdua** » Mon 18 Apr 2011 15:39

Hi,

Can you please let me know how can I integrate 2 or more connections in Tuniconnection.

Is there any examples of using them.

Thanks.
AS

AndreyZ · Post by **AndreyZ** » Tue 19 Apr 2011 10:13

Hello,

UniDAC works directly with a database server. You can use unlimited number of components to get access to a database through one UniConnection component. Also UniConnection supports pooling. It means that UniDAC will get a connection from a pool instead of creating a new connection to a server on every disconnect/connect operations. For more information about pooling, please read the UniDAC documentation.
Please describe in details the functionality you need (integration of several connections).

sasdua · Post by **sasdua** » Wed 20 Apr 2011 15:03

Thanks..Can you please provide us the Connection Pooling egs. or any documention for all UniDac components

AndreyZ · Post by **AndreyZ** » Thu 21 Apr 2011 07:54

The UniDAC documentation is supplied with UniDAC. You can find it in the %UniDAC_Install_Directory%\Doc directory. You can access the UniDAC documentation via the Delphi main menu (UniDAC->UniDAC help). Also you can download the UniDAC documentation in the CHM format here: http://www.devart.com/unidac/unidacchm.zip

sasdua · Post by **sasdua** » Wed 11 May 2011 10:45

Hi team,

We had downloaded the trial version of Unidac and it has expired.

We have raised a request for the unidac license and its in the process .

Could you please let us know whethere we can reinstall the trial version in the mean time so that we dont stop in our development.

Thanks
AS

AlexP · Post by **AlexP** » Wed 11 May 2011 11:37

Hello,

We can send you a new trial version with extended trial period.
Please provide the exact version of your IDE and an e-mail address to we can use.

sasdua · Post by **sasdua** » Wed 11 May 2011 12:37

Hi Alex,

We have sent a mail to you regarding the License.

Please reply to the mail.

Thanks
AS

AlexP · Post by **AlexP** » Wed 11 May 2011 13:37

hello,

I have sent you the new trial version to the specified e-mail address.

sasdua · Post by **sasdua** » Thu 12 May 2011 08:30

Hi Alex,

Can you please try zipping the exe and send it via mail or if possible please upload the exe to any site and we can download from there.

Thanks a lot for your help

Regards,
AS

AlexP · Post by **AlexP** » Thu 12 May 2011 08:35

Hello,

You can download the trial edition of UniDAC with extended trial period from http://www.devart.com/pub/unidac14.zip

sasdua · Post by **sasdua** » Tue 17 May 2011 15:06

Hi Team,

Could you please let us know whether Unidac supports DBF Files

In BDE, we are using Ttable component and loading the contents of DBF Files into the database

Can we achieve the same using Tunitable component...

Which component can be used in Unidac to Load a text file with values into a table in Sybase

Thanks for your help

Regards,
AS

AlexP · Post by **AlexP** » Wed 18 May 2011 09:04

Hello,

You can work with DBF files in UniDAC via ODBCUniProvider or DBFUniProvider.

To load data from DBF to Sybase, you can use TUniLoader.
Below is a small sample demonstrating it:

Code: Select all

var
  DBFConnection, ASEConnection: TUniConnection;
  DBFTable: TUniTable;
  UniLoader: TUniLoader;
begin
  ASEConnection:= TUniConnection.Create(nil);
  ASEConnection.ProviderName := 'ASE';
  ASEConnection.Server := 'ASE_Server';
  ASEConnection.Username := 'user_name';
  ASEConnection.Password := 'password';
  ASEConnection.Database := 'dabase';
  ASEConnection.Port := 5000;
  ASEConnection.Connected;

  DBFConnection:= TUniConnection.Create(nil);
  DBFConnection.ProviderName := 'DBF';
  DBFConnection.Database:= 'Path to *.dbf files';
  DBFConnection.Connect;

  DBFTable:= TUniTable.Create(nil);
  DBFTable.Connection := DBFConnection;
  DBFTable.TableName := 'Src_DBF_Table';
  DBFTable.Open;

  UniLoader:= TUniLoader.Create(nil);
  UniLoader.Connection := ASEConnection;
  UniLoader.TableName:= 'Dst_ASE_Table';
  UniLoader.LoadFromDataSet(DBFTable);

sasdua · Post by **sasdua** » Wed 18 May 2011 12:42

Hi Alex,

What do we need to mention on the Unitable.TableName?

Is it the DBF File Name that needs to be imported.

Thanks
AS