C / C++ / MFC

FirstPrevNext

Re: Database Sonu Kapoor4-Jan-02 2:45 Sonu Kapoor 4-Jan-02 2:45  Yes, i have experience in making querys. If i am working with databases, i always use the technique which you said, just open at the required moment, read and display....I am closing the tables always in the destructor. Shall i close the table after finishing with that table ??? I was using MsAccess, but this database allows only access for one user at a time. Which Database Technique should i use ADO or ODBC or something else and which Database shall i use ??? Maybe MySQL ??? regards Sonu Re: Database Carlos Antollini4-Jan-02 3:41 Carlos Antollini 4-Jan-02 3:41  You can use Access for 5 or 8 users, without problems. But you need to open the database in Shared mode for several users can to open de database.... I think that is beter that use ADO, because is more easy to use that ODBC, The performance is similar. You can find a couple of classes of ADO or ODBC in CP... I love to work with Databases.. Best Regards... Today is Friday!!! and Party!!! Carlos Antollini. Sonork ID 100.10529 cantollini Re: Database Sonu Kapoor4-Jan-02 4:11 Sonu Kapoor 4-Jan-02 4:11  I need a database which is able to gain access for more then 8 users. What do you think, which database should i use ? I am still thinking to work with MySql...Have you ever worked with MySQL related with VC++ ??? Thanx for your help Best regards Sonu Re: Database Carlos Antollini4-Jan-02 5:22 Carlos Antollini 4-Jan-02 5:22  Yes I think that MySql is a good Idea, Is free, is not eavy, and is easy to use. In mysql.com you can download the ODBC drivers for access to MySql, for use it with ADO And also you can find the librarys and header for work with the MySql engine... I used MySql only a little, because I work with SQL Server every day. I found that MySql is a excelent option for a chepper Installation, and several users, more than 10, for example 20 o 30 users. Only You need a good PC for get a good performance over the Database... Ask me that I can help you... Best Regards and Good Luck... Today is Friday!!! and Party!!! Carlos Antollini. Sonork ID 100.10529 cantollini Re: Database Sonu Kapoor4-Jan-02 5:25 Sonu Kapoor 4-Jan-02 5:25  Great thanx for you offer. If i start, i will email you if i got some problems with the Project. Best regards Sonu Re: Database Hadi Rezaee4-Jan-02 7:19 Hadi Rezaee 4-Jan-02 7:19  Hi Mr.Carlos, Can you tell me about MySQL ? Is MySQL = SQL Server ? My month article: Game programming by DirectX by Lan Mader. Please visit in: www.geocities.com/hadi_rezaie/index.html Hadi Rezaie Re: Database Jon Sagara4-Jan-02 7:34 Jon Sagara 4-Jan-02 7:34  MySQL is an open source rdbms. You can find a wealth of info on their website: MySQL Jon Sagara What about ? Re: Database Carlos Antollini4-Jan-02 7:42 Carlos Antollini 4-Jan-02 7:42  Mysql is a Rdbm. Is MySQL = SQL Server ? No, is from other Company : MySQL AB MySql Supports ANSI SQL sintax. Don't have Stored Procedures, triggers, but have all the power of most polular RDBMs and the most important: It's free. Best Reagrds. Today is Friday!!! and Party!!! Carlos Antollini. Sonork ID 100.10529 cantollini Re: Database Carlos Antollini4-Jan-02 7:51 Carlos Antollini 4-Jan-02 7:51  Hadi, I'm sorry MySql was Free Now the cost of a license is 200 U$D Best Reagards... Today is Friday!!! and Party!!! Carlos Antollini. Sonork ID 100.10529 cantollini Re: Database Carlos Antollini4-Jan-02 7:52 Carlos Antollini 4-Jan-02 7:52  Hadi, I'm sorry MySql was Free Now the cost of a license is 200 U$D Best Reagards... Today is Friday!!! and Party!!! Carlos Antollini. Sonork ID 100.10529 cantollini Re: Database Jon Sagara4-Jan-02 8:00 Jon Sagara 4-Jan-02 8:00  It's free if you use the Unix/Linux version AND your app is freeware. As I understand it, if you want the Windows version, you have to buy a license regardless of whether you use it for freeware or not. Licensing for MySQL Jon Sagara What about ? Re: Database Jon Sagara4-Jan-02 5:35 Jon Sagara 4-Jan-02 5:35  If transactions are important to you, then you should use PostgreSQL. Jon Sagara "There are lies, damned lies and statistics." -- Mark Twain. Re: Database Philip Patrick4-Jan-02 2:47 Philip Patrick 4-Jan-02 2:47  Use ADO it is faster. And yes, you can keep the database table opened... when you need it. If you have 20-30 computers and each of them makes queries every 5 seconds... your database server will die (I mean will work slow). Yes this is tested, on Pentium III 800, dual processor, with MS Windows Database Server OS and SQLServer 7.0 (2000 was much faster though). The speed I mean, when you really need speed, close to Real time. Of course you won't do this when you have GUI in your application, that means that the speed is depends on user So use ADO it is faster than ODBC Philip Patrick "Two beer or not two beer?" <shakesbeer> Web-site: www.saintopatrick.com Re: Database Sonu Kapoor4-Jan-02 2:53 Sonu Kapoor 4-Jan-02 2:53  And which Database shall i use ? What about MySql ? Is that compatible with vc++ ??? regards Sonu Re: Database 4-Jan-02 3:30 4-Jan-02 3:30  sonu wrote: What about MySql ? Is that compatible with vc++ ??? What do you mean compatible? ODBC/ADO etc. make things transparent so that as long as you have the right driver it doesnt matter what DB you are connecting to. Just get MyODBC or some such library and get going. Postgres also has an ODBC library Nish p.s. from a cafe. so am not logged in. Re: Database Jon Sagara4-Jan-02 5:37 Jon Sagara 4-Jan-02 5:37  If you do choose MySQL, they have a C++ API available for custom programming. It's called MySQL++, and you can download it from their website. Jon Sagara "There are lies, damned lies and statistics." -- Mark Twain. Re: Database Nemanja Trifunovic4-Jan-02 5:35 Nemanja Trifunovic 4-Jan-02 5:35  Philip Patrick wrote: So use ADO it is faster than ODBC I don't think so. The best performance is with direct calls to db API, ODBC is a layer on the top of it, and ADO includes COM. AFAIK, ODBC is faster than ADO, and there are some pretty good ODBC wrapper classes, which can make your life much easier. I vote pro drink Re: Database Philip Patrick4-Jan-02 5:47 Philip Patrick 4-Jan-02 5:47  That's right, ODBC has CRecordset, CDatabase classes in MFC that is easy to use, but ODBC is an old technology - first, and second, we tested ADO and ODBC perfomance in the company I worked... and ADO was much faster. So I'm not guessing, I'm pretty sure ADO is faster than ODBC Philip Patrick "Two beer or not two beer?" <shakesbeer> Web-site: www.saintopatrick.com Re: Database Nemanja Trifunovic4-Jan-02 6:12 Nemanja Trifunovic 4-Jan-02 6:12  Philip Patrick wrote: That's right, ODBC has CRecordset, CDatabase classes in MFC that is easy to use Actually, I had in mind OTL or DTL. They are very fast. Philip Patrick wrote: we tested ADO and ODBC perfomance in the company I worked... and ADO was much faster With what database did you test it? I vote pro drink Re: Database Philip Patrick4-Jan-02 6:16 Philip Patrick 4-Jan-02 6:16  Well... we worked with MFC database classes, so have no idea about perfomance of other libraries. Tested with MS SQL Server 7.0 and 2000 (the last was much faster ) on Pentium III 800 dual processor with MS Windows 2000 Database Server lol Philip Patrick "Two beer or not two beer?" <shakesbeer> Web-site: www.saintopatrick.com Re: Database Nemanja Trifunovic4-Jan-02 6:19 Nemanja Trifunovic 4-Jan-02 6:19  Philip Patrick wrote: Tested with MS SQL Server 7.0 and 2000 Well, that explains it. MS databases have very good OLEDB drivers, but with MySQL I'm pretty sure ODBC would outperform ADO. I vote pro drink Re: Database Philip Patrick4-Jan-02 6:28 Philip Patrick 4-Jan-02 6:28  Well, if you say so I can't say nothing about MySQL, but MSSQL was the best of other big non-free databases, like Oracle for example But if you say that MySQL is better with ODBC, I can only listen and take in mind, lmao Waiter, one for Nemanja, please Philip Patrick "Two beer or not two beer?" <shakesbeer> Web-site: www.saintopatrick.com Re: Database Nemanja Trifunovic4-Jan-02 6:37 Nemanja Trifunovic 4-Jan-02 6:37  Philip Patrick wrote: Waiter, one for Nemanja, please LOL, cheers! I vote pro drink How can I know the margins for a page... Braulio Dez4-Jan-02 0:39 Braulio Dez 4-Jan-02 0:39  Hi, How can I know the margins for the printer ? ( and it´s too much size that ?). Thanks, Bye ! Braulio Re: How can I know the margins for a page... Tim Deveaux4-Jan-02 8:42 Tim Deveaux 4-Jan-02 8:42  There's an MSDN article that might be helpful - "HOWTO: How to Use a Program to Calculate Print Margins" - looks like you need to use GetDeviceCaps with PHYSICALOFFSETX and PHYSICALOFFSETY. There's some other stuff here as well.

Last Visit: 31-Dec-99 18:00     Last Update: 29-May-24 0:32 Refresh ᐊ Prev1...17622176231762417625176261762717628176291763017631 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.