Page 1 of 2
BDE to Unidac Migration
Posted: Mon 18 Apr 2011 10:32
by sasdua
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
Posted: Mon 18 Apr 2011 14:33
by AndreyZ
Hello,
UniDAC doesn't have any equivalent for the TSession component. The same functionality is included into the TUniConnection component.
Posted: Mon 18 Apr 2011 15:39
by sasdua
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
Posted: Tue 19 Apr 2011 10:13
by AndreyZ
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).
Posted: Wed 20 Apr 2011 15:03
by sasdua
Thanks..Can you please provide us the Connection Pooling egs. or any documention for all UniDac components
Posted: Thu 21 Apr 2011 07:54
by AndreyZ
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
Posted: Wed 11 May 2011 10:45
by sasdua
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
Posted: Wed 11 May 2011 11:37
by AlexP
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.
Posted: Wed 11 May 2011 12:37
by sasdua
Hi Alex,
We have sent a mail to you regarding the License.
Please reply to the mail.
Thanks
AS
Posted: Wed 11 May 2011 13:37
by AlexP
hello,
I have sent you the new trial version to the specified e-mail address.
Posted: Thu 12 May 2011 08:30
by sasdua
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
Posted: Thu 12 May 2011 08:35
by AlexP
Hello,
You can download the trial edition of UniDAC with extended trial period from
http://www.devart.com/pub/unidac14.zip
Posted: Tue 17 May 2011 15:06
by sasdua
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
Posted: Wed 18 May 2011 09:04
by AlexP
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);
Posted: Wed 18 May 2011 12:42
by sasdua
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