|
Ok I'm going to take a couple of guesses
1.)
ShellExecute uses the default file association in your case "html" to open the document.
So in effect you are probably using your browser to print for you. And probably you are using IE4+ to do your dirty printing.
Check to see it's just not your PC that has this problem,
(Us coders are quite likely to abuse file associations on development boxes)
So maybe your code will run OK on a neighbours PC but not yours.
2.)
Consider changing your NULL paramaters to empty variants, And turn off the "Active_Dektop"
3.)
Try using OLECMDEXECOPT_DONTPROMPTUSER
as a paramater, I think its the third one ?
4.)
Make sure your Browser can actually print without errors ocurring.
Regardz
Colin J Davies
Sonork ID 100.9197:ColinI live in Bob's HungOut now
A good example of "Fully Managed" coding
|
|
|
|
|
Hi Guys,
i want create a app which is able to connect to a database. This database is placed on the server. How should i connect to that database: ADO or ODBC or something else. Once i used ODBC to connect to a database but after i tryed to open 4-5 tables at the same time the computer becomes was very slow to show the data...I want to avoid this in future, HOW ??? Which database should i use ? The database must be able to guarentee access for more than one user.
Thanx
Sonu
|
|
|
|
|
That depends of you want...
You can find several classes for use ADO.
Do You have experience making querys?
When you work with databases, don't need open the tables all time...
You need to open, read the data, display only that you want, Update, or insert records.
Never Keep the tables open.
A question more?
What Database are using you?
Best Regards.
Today is Friday!!!! and Party!!!
Carlos Antollini.
Sonork ID 100.10529 cantollini
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Great thanx for you offer. If i start, i will email you if i got some problems with the Project.
Best regards
Sonu
|
|
|
|
|
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
|
|
|
|
|
MySQL is an open source rdbms. You can find a wealth of info on their website:
MySQL
Jon Sagara
What about ?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 ?
|
|
|
|
|
If transactions are important to you, then you should use PostgreSQL.
Jon Sagara
"There are lies, damned lies and statistics."
-- Mark Twain.
|
|
|
|
|
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
|
|
|
|
|
And which Database shall i use ? What about MySql ? Is that compatible with vc++ ???
regards
Sonu
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|