Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 18 total
Thread Linux SQL connectivity to dbisam
Mon, Mar 13 2006 8:03 PMPermanent Link

Jon Alexander
Hi,

Can someone please help me to connect my dbisam table to a SQL server.

I have been instructed to use an onTimer event within the OnTimer component, but am too
ignorant to figure it out and have
done extensive search on the internet but yet no solutions.

Please help.

Jon Alexander
Mon, Mar 13 2006 8:15 PMPermanent Link

Jon Alexander
Jon Alexander <jonalexander370@earthlink.net> wrote:

Hi,

Can someone please help me to connect my dbisam table to a SQL server.

I have been instructed to use an onTimer event within the OnTimer component, but am too
ignorant to figure it out and have
done extensive search on the internet but yet no solutions.

I have a TDataSource, TDBISAMTable, and a TTimer on a form.

Any and all suggestions would be gratefully appreciated.

Please help.

Jon Alexander
Mon, Mar 13 2006 8:32 PMPermanent Link

Eryk Bottomley
Jon,

> Can someone please help me to connect my dbisam table to a SQL server.

Unfortunately your question is far too vauge to answer. The problems
include:

1) "Linux SQL connectivity to dbisam" - there is no such thing as "Linux
SQL"

2) "...my dbisam table to a SQL server." - WHAT SQL server? The term
"SQL Server" in isolation typically means "Microsoft SQL Server" but
since that doesn't run on Linux that cannot be what you intend here.

3) Database engines, as a general rule, are not designed to access data
in alien formats so it is probable that whatever you mean by "SQL
Server" has no capability to read DBISAM files interactively.

4) TTimers have absolutely nothing to do with database operations per se
so it is impossible to guess why someone may have instructed you to use one.

Eryk
Mon, Mar 13 2006 8:36 PMPermanent Link

Jon Alexander
OK, great let me get the specifics within the next 15 minutes.

Jon




Eryk Bottomley <no@way.com> wrote:

Jon,

> Can someone please help me to connect my dbisam table to a SQL server.

Unfortunately your question is far too vauge to answer. The problems
include:

1) "Linux SQL connectivity to dbisam" - there is no such thing as "Linux
SQL"

2) "...my dbisam table to a SQL server." - WHAT SQL server? The term
"SQL Server" in isolation typically means "Microsoft SQL Server" but
since that doesn't run on Linux that cannot be what you intend here.

3) Database engines, as a general rule, are not designed to access data
in alien formats so it is probable that whatever you mean by "SQL
Server" has no capability to read DBISAM files interactively.

4) TTimers have absolutely nothing to do with database operations per se
so it is impossible to guess why someone may have instructed you to use one.

Eryk
Mon, Mar 13 2006 10:46 PMPermanent Link

"J. Lee"
Jon,


Here are some general principles:

1) You can run the DBISAM database server on a Windows or Linux based
computer.

2) The DBISAM database server program contains the DBISAM database engine

3) The DBISAM database engine reads DBISAM database files (usually
located on the same machine as the running engine)

4) For purposes of simplicity, the DBISAM database engine is the only
program that can read DBISAM database files

5) You can compile the DBISAM database engine into your programs so that
they can read DBISAM database files directly (shared-file mode) or make
requests to a DBISAM database server program (client/server), which
processes the request and returns results back to the requesting program

6) You can directly view DBISAM database tables using the TDBISAMTable
component or you can issue SQL commands using a TDBISAMQuery component.

That is for starter....I hope it helps you a little. Come back if you
have more questions.

~J. Lee




Jon Alexander wrote:
> OK, great let me get the specifics within the next 15 minutes.
>
> Jon
>
Mon, Mar 13 2006 10:56 PMPermanent Link

Eryk Bottomley
J,

> 1) You can run the DBISAM database server on a Windows or Linux based
> computer.

Correct. Subject to the Linux distribution in question being one that
Borland Kylix V3 supports.

> 2) The DBISAM database server program contains the DBISAM database engine

Correct.

> 3) The DBISAM database engine reads DBISAM database files (usually
> located on the same machine as the running engine)

Correct.

> 4) For purposes of simplicity, the DBISAM database engine is the only
> program that can read DBISAM database files

Correct, generally speaking.

> 5) You can compile the DBISAM database engine into your programs so that
> they can read DBISAM database files directly (shared-file mode) or make
> requests to a DBISAM database server program (client/server), which
> processes the request and returns results back to the requesting program

Correct.

> 6) You can directly view DBISAM database tables using the TDBISAMTable
> component or you can issue SQL commands using a TDBISAMQuery component.

Correct.

> That is for starter....I hope it helps you a little. Come back if you
> have more questions.

I did not have a question in the first place. 'You' have the question
(apparently) and I was attempting to define what it was/is.

Eryk
Mon, Mar 13 2006 11:21 PMPermanent Link

"J. Lee"
Eryk,

Sorry, I was trying to help Jon. I know I am very correct on the
statements I made, since I have been a very active developer using
DBISAM since v1 Smiley

I just switched to Thunderbird and am still getting used to it from the
horrible OE, so I apologize if it appears I am replying to you.

If I may be presumptuous for a moment, it appears our friend Jon has
been 'elevated' (no pun intended) to IT person in charge of taking over
a project using DBISAM. How can I guess this (it is just a mere guess,
btw)? The nature and content of the questions he asked.

Warmest regards,

Jason Lee


Eryk Bottomley wrote:
> J,
>
>> 1) You can run the DBISAM database server on a Windows or Linux based
>> computer.
>
>
> Correct. Subject to the Linux distribution in question being one that
> Borland Kylix V3 supports.
>
>> 2) The DBISAM database server program contains the DBISAM database engine
>
>
> Correct.
>
>> 3) The DBISAM database engine reads DBISAM database files (usually
>> located on the same machine as the running engine)
>
>
> Correct.
>
>> 4) For purposes of simplicity, the DBISAM database engine is the only
>> program that can read DBISAM database files
>
>
> Correct, generally speaking.
>
>> 5) You can compile the DBISAM database engine into your programs so
>> that they can read DBISAM database files directly (shared-file mode)
>> or make requests to a DBISAM database server program (client/server),
>> which processes the request and returns results back to the requesting
>> program
>
>
> Correct.
>
>> 6) You can directly view DBISAM database tables using the TDBISAMTable
>> component or you can issue SQL commands using a TDBISAMQuery component.
>
>
> Correct.
>
>> That is for starter....I hope it helps you a little. Come back if you
>> have more questions.
>
>
> I did not have a question in the first place. 'You' have the question
> (apparently) and I was attempting to define what it was/is.
>
> Eryk
Tue, Mar 14 2006 4:47 PMPermanent Link

Jon Alexander
Thank you all for your kind assistance.

I apologize for improperly stating my request.

I have a Dedicated LinuxRH server, and on that LinuxRH server is MySQL installed, and in
the SQL database are tables of data.

I am requesting help and assistance and any code snippets that may assist me in connecting
a DBISAM Memory Table to retrieve that same data.

The data would be requested by a Delphi Desktop application, into a DBISAM database memory
table FROM a server side SQL database on our LinuxRH server.

Attached is a screen shot of the data on the LinuxRH SQL server.

Any and all advice would be most greatly appreciated.

Cordially,

Jon Alexander
jonalexander370@earthlink.net


"J. Lee" <computerguy@wavecable.com> wrote:

Eryk,

Sorry, I was trying to help Jon. I know I am very correct on the
statements I made, since I have been a very active developer using
DBISAM since v1 Smiley

I just switched to Thunderbird and am still getting used to it from the
horrible OE, so I apologize if it appears I am replying to you.

If I may be presumptuous for a moment, it appears our friend Jon has
been 'elevated' (no pun intended) to IT person in charge of taking over
a project using DBISAM. How can I guess this (it is just a mere guess,
btw)? The nature and content of the questions he asked.

Warmest regards,

Jason Lee


Eryk Bottomley wrote:
> J,
>
>> 1) You can run the DBISAM database server on a Windows or Linux based
>> computer.
>
>
> Correct. Subject to the Linux distribution in question being one that
> Borland Kylix V3 supports.
>
>> 2) The DBISAM database server program contains the DBISAM database engine
>
>
> Correct.
>
>> 3) The DBISAM database engine reads DBISAM database files (usually
>> located on the same machine as the running engine)
>
>
> Correct.
>
>> 4) For purposes of simplicity, the DBISAM database engine is the only
>> program that can read DBISAM database files
>
>
> Correct, generally speaking.
>
>> 5) You can compile the DBISAM database engine into your programs so
>> that they can read DBISAM database files directly (shared-file mode)
>> or make requests to a DBISAM database server program (client/server),
>> which processes the request and returns results back to the requesting
>> program
>
>
> Correct.
>
>> 6) You can directly view DBISAM database tables using the TDBISAMTable
>> component or you can issue SQL commands using a TDBISAMQuery component.
>
>
> Correct.
>
>> That is for starter....I hope it helps you a little. Come back if you
>> have more questions.
>
>
> I did not have a question in the first place. 'You' have the question
> (apparently) and I was attempting to define what it was/is.
>
> Eryk



Attachments: MySQL on LinuxRH.jpg
Tue, Mar 14 2006 5:01 PMPermanent Link

Jason Lee
Jon,

Typically, you cannot select records from one database server (e.g.
MySQL) into a destination table of a different database server (e.g.
DBISAM table) all from within an SQL statement or script.

Your solution would involve something like:

a) select MySQL records using SQL in MySQL and save them to an
intermediate format that can then be imported into a DBISAM database

b) select MySQL records using SQL in Delphi (using the MySQL direct
access components or ODBC), then iterate the record set adding the
necessary records to a DBISAM database table (using DBISAM's components)

c) maybe MySQL has a "reverse engineer" feature like DBISAM that can
include the data. the result would be an SQL script that could then be
run in DBISAM to re-create the table(s)

d) combination of all, some, or none of the above Smiley

~Jason Lee

Jon Alexander wrote:
> Thank you all for your kind assistance.
>
> I apologize for improperly stating my request.
>
> I have a Dedicated LinuxRH server, and on that LinuxRH server is MySQL installed, and in
> the SQL database are tables of data.
>
> I am requesting help and assistance and any code snippets that may assist me in connecting
> a DBISAM Memory Table to retrieve that same data.
>
> The data would be requested by a Delphi Desktop application, into a DBISAM database memory
> table FROM a server side SQL database on our LinuxRH server.
>
> Attached is a screen shot of the data on the LinuxRH SQL server.
>
> Any and all advice would be most greatly appreciated.
>
> Cordially,
>
> Jon Alexander
> jonalexander370@earthlink.net
>
>
> "J. Lee" <computerguy@wavecable.com> wrote:
>
> Eryk,
>
> Sorry, I was trying to help Jon. I know I am very correct on the
> statements I made, since I have been a very active developer using
> DBISAM since v1 Smiley
>
> I just switched to Thunderbird and am still getting used to it from the
> horrible OE, so I apologize if it appears I am replying to you.
>
> If I may be presumptuous for a moment, it appears our friend Jon has
> been 'elevated' (no pun intended) to IT person in charge of taking over
> a project using DBISAM. How can I guess this (it is just a mere guess,
> btw)? The nature and content of the questions he asked.
>
> Warmest regards,
>
> Jason Lee
>
>
> Eryk Bottomley wrote:
>
>>J,
>>
>>
>>>1) You can run the DBISAM database server on a Windows or Linux based
>>>computer.
>>
>>
>>Correct. Subject to the Linux distribution in question being one that
>>Borland Kylix V3 supports.
>>
>>
>>>2) The DBISAM database server program contains the DBISAM database engine
>>
>>
>>Correct.
>>
>>
>>>3) The DBISAM database engine reads DBISAM database files (usually
>>>located on the same machine as the running engine)
>>
>>
>>Correct.
>>
>>
>>>4) For purposes of simplicity, the DBISAM database engine is the only
>>>program that can read DBISAM database files
>>
>>
>>Correct, generally speaking.
>>
>>
>>>5) You can compile the DBISAM database engine into your programs so
>>>that they can read DBISAM database files directly (shared-file mode)
>>>or make requests to a DBISAM database server program (client/server),
>>>which processes the request and returns results back to the requesting
>>>program
>>
>>
>>Correct.
>>
>>
>>>6) You can directly view DBISAM database tables using the TDBISAMTable
>>>component or you can issue SQL commands using a TDBISAMQuery component.
>>
>>
>>Correct.
>>
>>
>>>That is for starter....I hope it helps you a little. Come back if you
>>>have more questions.
>>
>>
>>I did not have a question in the first place. 'You' have the question
>>(apparently) and I was attempting to define what it was/is.
>>
>>Eryk
>
>
Tue, Mar 14 2006 6:09 PMPermanent Link

Jon Alexander
Thank you Jason,

As I understand, an sql statement that exports the data to the server hard drive, in a
format such as XML.

Then can dbisam or some third party component import over the web via IP same data
directly into DBISAM?

Am I on the right track in this thinking?

Please advise.

Thank you.

Cordially,

Jon Alexander





Jason Lee <computerguy@wavecable.com> wrote:

Jon,

Typically, you cannot select records from one database server (e.g.
MySQL) into a destination table of a different database server (e.g.
DBISAM table) all from within an SQL statement or script.

Your solution would involve something like:

a) select MySQL records using SQL in MySQL and save them to an
intermediate format that can then be imported into a DBISAM database

b) select MySQL records using SQL in Delphi (using the MySQL direct
access components or ODBC), then iterate the record set adding the
necessary records to a DBISAM database table (using DBISAM's components)

c) maybe MySQL has a "reverse engineer" feature like DBISAM that can
include the data. the result would be an SQL script that could then be
run in DBISAM to re-create the table(s)

d) combination of all, some, or none of the above Smiley

~Jason Lee

Jon Alexander wrote:
> Thank you all for your kind assistance.
>
> I apologize for improperly stating my request.
>
> I have a Dedicated LinuxRH server, and on that LinuxRH server is MySQL installed, and in
> the SQL database are tables of data.
>
> I am requesting help and assistance and any code snippets that may assist me in connecting
> a DBISAM Memory Table to retrieve that same data.
>
> The data would be requested by a Delphi Desktop application, into a DBISAM database memory
> table FROM a server side SQL database on our LinuxRH server.
>
> Attached is a screen shot of the data on the LinuxRH SQL server.
>
> Any and all advice would be most greatly appreciated.
>
> Cordially,
>
> Jon Alexander
> jonalexander370@earthlink.net
>
>
> "J. Lee" <computerguy@wavecable.com> wrote:
>
> Eryk,
>
> Sorry, I was trying to help Jon. I know I am very correct on the
> statements I made, since I have been a very active developer using
> DBISAM since v1 Smiley
>
> I just switched to Thunderbird and am still getting used to it from the
> horrible OE, so I apologize if it appears I am replying to you.
>
> If I may be presumptuous for a moment, it appears our friend Jon has
> been 'elevated' (no pun intended) to IT person in charge of taking over
> a project using DBISAM. How can I guess this (it is just a mere guess,
> btw)? The nature and content of the questions he asked.
>
> Warmest regards,
>
> Jason Lee
>
>
> Eryk Bottomley wrote:
>
>>J,
>>
>>
>>>1) You can run the DBISAM database server on a Windows or Linux based
>>>computer.
>>
>>
>>Correct. Subject to the Linux distribution in question being one that
>>Borland Kylix V3 supports.
>>
>>
>>>2) The DBISAM database server program contains the DBISAM database engine
>>
>>
>>Correct.
>>
>>
>>>3) The DBISAM database engine reads DBISAM database files (usually
>>>located on the same machine as the running engine)
>>
>>
>>Correct.
>>
>>
>>>4) For purposes of simplicity, the DBISAM database engine is the only
>>>program that can read DBISAM database files
>>
>>
>>Correct, generally speaking.
>>
>>
>>>5) You can compile the DBISAM database engine into your programs so
>>>that they can read DBISAM database files directly (shared-file mode)
>>>or make requests to a DBISAM database server program (client/server),
>>>which processes the request and returns results back to the requesting
>>>program
>>
>>
>>Correct.
>>
>>
>>>6) You can directly view DBISAM database tables using the TDBISAMTable
>>>component or you can issue SQL commands using a TDBISAMQuery component.
>>
>>
>>Correct.
>>
>>
>>>That is for starter....I hope it helps you a little. Come back if you
>>>have more questions.
>>
>>
>>I did not have a question in the first place. 'You' have the question
>>(apparently) and I was attempting to define what it was/is.
>>
>>Eryk
>
>
Page 1 of 2Next Page »
Jump to Page:  1 2
Image