Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 10 of 18 total |
Linux SQL connectivity to dbisam |
Mon, Mar 13 2006 8:03 PM | Permanent 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 PM | Permanent 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 PM | Permanent 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 PM | Permanent 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 PM | Permanent 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 PM | Permanent 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 PM | Permanent 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 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 PM | Permanent 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 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 PM | Permanent 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 ~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 > > 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 PM | Permanent 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 ~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 > > 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 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Thursday, March 28, 2024 at 06:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |