Good (Free) Database Choice For Simple Local Database For Delphi 2009
For years I have used the BDE and dVolga ( no longer abailable ) but want to
learn how to use other third-party and/or Delphi 2009 vcl components for
For a simple local database with only one table and 6-8 string fields with
graphic field support for one field what is a good choice?
What is available to do this without buying anything or possibly with a
Should I use DBExpress?
Is a commercial database application necessary to create the database?
Is something available from Microsoft as a free download to create and
possibly edit a...Delphi and Oracle Database
I have a need to be able to read data out of an Oracle database. I
know how I can access it - but now I need to bring the databases
inhouse for development purposes.
So - I need to install an oracle server - but only for my development
needs - but it needs to be able to handle some large databases - from
5GB to 50GB approximately.
I have been dealing with MSSQL and MySQL for a while - and I have
those servers licenses and running. However, I am not familiar with
how Oracle does things.
Does anyone out there have some suggestions as to what type of licens...Database with Delphi XE3
I've been using Delphi 7 Pro for years and have had to deal with the PDOXUSR.NET access denied problem with Vista OS and up anytime my application uses the Borland Database Engine. I'm thinking of buying Delphi XE3. Can someone tell me if the PDOXUSR.NET Access Denied problem has been taken care of in this version? With Windows 7, it seems that my apps will only run if I have the user reduce their User Account Control to a level the access is no longer denied. I'm hoping this is not an issue with XE3.
I'm sorry if this is not the proper forum for my question. I there is a be...delphi 2010 database
I’m new to this forum, currently I have application with MS Access and all works good for me.
But I need more reliable without DLL or other dependencies (for Delphi 2010)
I found many databases for Delphi,
I prefer free or less than $100.00
On 2010-11-28 19:09:31 -0500, Falah Latino <> said:
> I’m new to this forum, currently I have application with MS Access and
> all works good for me.
> But I need more reliable without DLL or other dependencies (for Delphi 2010)
> I found many databases for Delphi,
> I prefer free or less tha...copy database one database to onther database
hii want to copy one database table to onther database table using script?my database is ms-sql server 2000 Nothing is really over,untill the moment stop trying for it...Amitsp(MCTS,MCP)sqlreporting.blogspot.com
You can use import/export task and DTS package created automatically by Enterprise manager or just try
select * INTO [newdatabase].dbo.[newTable] from [sourceDatabase].dbo.[sourcetable]
no dear i want to this programatticallyiusing c #,source is my database in local machine and target is other computer means server Nothing is really...Delphi Array to Oracle Database
I have a Oracle Package:
CREATE OR REPLACE PACKAGE Array_Test
TYPE my_array IS VARRAY (10) OF String;
PROCEDURE proc_array_test (
p_param1 IN Varchar2,
p_array IN my_array);
In Delphi I created an array
InfoArray : array[0..9] of String;
and would like to pass InfoArray to the Oracle Package Array_Test as a parameter. How do I do that?
dmMyDatamodel.stpMyStoredProcedure.ParamByName(‘p_param1’).Text := ‘TESTING’;
dmMyDatamodel.stpMyStoredProcedure.ParamByName(‘p_array’) ???????? .... this is where I get stuck.
I'm using DBExpress.
...database in database solution
i have a database in the database solution. but i want to add the database from database solution to App_data folder in solution explorer.
how to do this ?Jai Ganesh. J , GSD ,IndiaPlease Mark As Answer If my reply helped you.
i am having visual studio express edition and sql management express.
i have opened solution explorer for a asp.net project. I have the database solution and i have the App_data in the solution Explorer.
I have added a existing sql database in the database solution and wanted the newly added sql database in the App_data of solution...how to access other database in this database ?
Hi,Everyone,I used to use oracle 8i,but now for some reasons,I must change
to ASE11.5,at the beginning,I don't know how to access tables among
databases,in oracle, if I grant "select" to some user,this user will access
other user's table in username.tablename format,I want to know how to
implement this functions,please help me! thanks!
Very similar in sybase ASE.
grant SELECT on <user>.<tbl> to <newuser>
for new user:
select * from <user>.<tbl>
> Hi,Everyone,I used to use oracle 8i,but now for some rea...Database profile and databases
I have installed Syabse on linux and PB 6.5 on windows 2000. I am able to
connect to the sybase server through dsedit utility and I am also able to
connect PB development environment(database profile) to particuler database
on sybase server. But when I want to see all the tables while clicking on
database menu option an error messagebox displayed "Stored procedure
pb60table not found. Specify owner.objectname or use sp_help to check
whether object exist.(sp_help may produce lot of output" . This error
messagebox is displayed. I am not able to make any datawi...Delphi and Delphi for .Net
It seems that Delphi for .Net is slower than Delphi Win32 native applicaiton.
I would like to know is it true all .Net application is slower than Win32 native applicaiton or it is Delphi for .Net only.
Your information is great appreciated,
On 2011-06-21 18:20:17 +0100, Inung Huang said:
> It seems that Delphi for .Net is slower than Delphi Win32 native applicaiton.
> I would like to know is it true all .Net application is slower than
> Win32 native applicaiton or it is Delphi for .Net only.
If you are only running the code in the application once then, yes, yo...Backup a MySQL database from Delphi
Is there an easy way to backup/restore a MySQL tables from my Delphi application. The database is hosted by my Web host. To remotely connect to my MySQL database, I use ADO (dbGo tab) components. My tables use MyISAM.
Can I use mysqldump or mysqlhotcopy from Delphi via ADO?
BTW, I use Delphi 2009.
> Can I use mysqldump or mysqlhotcopy from Delphi via ADO?
mysqldump does not need any additional connectivity layer,
like ADO, ODBC or what else. mysqldump uses TCP/IP
to connect to MySQL server.
So, all what you need:
- mysqldump of the your MySQL server version;
- run mysqldum...How to upgrade database changes in remote databases and consolidated databases
I am Working in a project which uses Sybase Mobilink server as the
replication system. Now I have been given a requirement to automate the
upgrade databases chages in remote databases and consolidated database.
I heard the about "Passthrough" but I don't know how to use it.
I saw below topic in our forum
PASSTHROUGH Question. How do I replicate DML ...
1.- Created a Version_Tracking Table (contains columns
Unique_Record_ID, DB_Remote_ID, DB_Version, DB_Update_Time_Stamp and
2.- The new Version_Tracking table is part of a publication that...Delphi embedded Database with Pivot
We currently have a database app that works with Microsoft SQL Server. We want to have the option of switching to a native Delphi database to ease deployment issues.
All our code is standard SQL, except for the call to the PIVOT command, which we need, and seems specific to SQL server. Do any of the native delphi databases have commands similar to Pivot?
David Novo wrote:
> We currently have a database app that works with Microsoft SQL Server. We
> want to have the option of switching to a native Delphi database to ease
> ...Coping Database objects from one database to another blank database.
I want to create a duplicate database in sql 2000 using asp.net from a webform
I created a database using CREATE DATABASE .......
But how to copy tables, views, stored procedures to newly created
database from old using asp.net from webform
Is there any another method to create a duplicate database with another name
from existing database on same server ?
yes you can do have another DB with different name and that has everything the same .....!!!Fadil Alnassar www.fadilalnassar.com | FREE Nodil Tab Controlhttp://www.mefranchising.com
One way it can be done is with...