COM

FirstPrevNext

Com interface with SQL to MSDE database Bigge10-Jul-01 23:27 Bigge 10-Jul-01 23:27  Can someone give me an example how i can connect to a MSDE database throw a COM interface with SQL qustenions. My problem is: There is an database based om MSDE and there are diffrent applications who vill store and read data from the database, i will make an COM-interface who access the database with SQL questions. The meaning of this is to make it so easy as possible to access data to the database, the programmers that programing the applications will not no how the database struture is. They will connect with a procedure an with a couple op parameters like this: addfuntion(operator, date, car_typ, modell_number, ......, .....,.....) There will be a couple of interface with a method in each interface. I will use COM ATL and SQL in Visual C++. Please can someone here give me a example of this? Re: Com interface with SQL to MSDE database 11-Jul-01 8:35 11-Jul-01 8:35  Use OLE DB or ADO there are plenty of examples out there. Re: Com interface with SQL to MSDE database Bigge12-Jul-01 1:22 Bigge 12-Jul-01 1:22  The company i work for said that i should use ATL, ADO gives more code then necessary. Please anyone give me some URL:s to my problem. Re: Com interface with SQL to MSDE database 12-Jul-01 2:04 12-Jul-01 2:04  Are you using VC++? If so you have all you need. Look at MSDN for OLE DB. In VC++ start a new ATL project and insert a new object, choose Data Access and select Consumer. Using A Collection - Newbie AJ1239-Jul-01 11:48 AJ123 9-Jul-01 11:48  Hi, I am making use of a COM object. One member function returns a collection. I index the object i need with the 'Item' Function. My problem is the object returned as a variant. And i have little clue how to turn it into the object it show be. Thanks in advance Rich PS I have little experience! So please make it as simple as possible Re: Using A Collection - Newbie 9-Jul-01 14:42 9-Jul-01 14:42  VariantChangeType - So simple you would over look it Lots o' quick ATL COM/DCOM questions Pavlos Touboulidis9-Jul-01 10:08 Pavlos Touboulidis 9-Jul-01 10:08  I'm starting with ATL, I've written several 'test' COMs but now I face the following problems. I want to create a COM object (class) that will be used from remote machines (DCOM). The COM will be an out of process server. Let's say my object is named MyObj and the C++ class CMyObj. 1. How do I get the count of open objects? Should I use a static member variable and increase/descrease it everytime an object is constructed/destructed? If yes (or even if no), where should I put the code for this? In the constructor/destructor of CMyObj or in the FinalConstruct-FinalRelease? 2. How to I prevent a client to create an object of that class based on runtime conditions? For example, in order to disallow more than 10 objects at the same time. Should I throw in the constructor? throw what? 3. What's the best way to destroy my object, even if the client hasn't done so yet? 'delete this;'? For example, if the client passes an invalid parameter on one method, I would like to be able to destroy the object (at least on the srv-side). 4. What happens when (in DCOM) the network layer fails? Is the object on the server and/or client side automatically destroyed? If not, can I catch an event or something (I'm more concerned on the server side) when that happens and ... do what? 5. How can I pass my object (and all the data it holds) through the network? Are there any functions I would have to override (something like ReadFromStream or WriteToStream, I don't know)? 6. What's the best way to inform the client of critical failures of a method he just called? Should all these methods have an [out,retval] long *result? Should I use the IErrorSomething that the ATL object wizard allows you to support? Can I return anything else than S_OK, or is HRESULT used internally from the COM/DCOM layer? Any help would be greatly appreciated. Moreover, the one who answers all of my questions, will win a free copy of my free Tetris game;) Re: Lots o' quick ATL COM/DCOM questions 9-Jul-01 14:54 9-Jul-01 14:54  I can't pass up the chance for a free tetris game. 1. Thats one way to do it. Put it where ever you would like. In the ctor you can catch it before creating the object. In the FinalConstruct you can be sure the object was successfully created. 2. Don't throw just return an E_FAIL or some HRESULT of your own creation, using the MAKE_HRESULT macro. You could then set the IErrorInfo for more detailed explaination of the failure. 3. Release the object. 4. Don't know (Damn, there goes the Tetris) 5. Pass an interface pointer. You don't want to pass a 500mb object instance down the wire. 6. You could have a retval or use HRESULTs and IErrorInfo, refer to 2. Re: Lots o' quick ATL COM/DCOM questions Pavlos Touboulidis9-Jul-01 22:02 Pavlos Touboulidis 9-Jul-01 22:02  Thanks a lot. I decided I'll give you a copy of Tetris, since you're so excited about it. Get it from users.otenet.gr/~gtoub/ Btw, it's for DOS (but works on 3.1,95,98,2000 *maybe, it worked for me*). Win2000 COM issue (maybe) Chris Klecker6-Jul-01 5:55 Chris Klecker 6-Jul-01 5:55  When running my program on a 98 box, everything seems to go through smoothly. When running on a Win2000 box, it crashes. I have isolated a commonality between this issue and few other issues in that somewhere along the line it has to display the MSFLEXGRID OCX control. Does there happen to be an extra step in getting the MSFLEXGRID control registered for Win2000? Or perhaps it is registered and it's just something else. It seems 98 recognizes the control. Thanks! Chris Customer: "It seems you have bugs that are inconsistent!" Support: "We have a patch that makes them consistent." catching COM event in console app 4-Jul-01 13:53 4-Jul-01 13:53  all Is there any way to catch com event from console app?? a short sample code will be great. psksvp how do I implement IStorage methods pathi3-Jul-01 22:39 pathi 3-Jul-01 22:39  Hi I have serialized my data into an xml file.Now I want to implement IStorage methods and expose those methods to encapsulate my xml code. To achieve this what I have to do?I want to pass IXMLDOMDocument pointer to IStorage methods.Can I do this?or how to do? Thanks in advance Pathi bhikshapathi_g@semanticspace.com Re: how do I implement IStorage methods 4-Jul-01 12:17 4-Jul-01 12:17  Why can't you use the IXMLDOMDocument methods load and save? WTL/ATL & CDateTimePickerCtrl 3-Jul-01 9:34 3-Jul-01 9:34  I was trying to create a WTL based dialog app that had a DateTimePicker on it but can't seem to get it working. When I try to create the contol all I get in return is NULL. CDateTimePickerCtrl Date; HWND hWnd = Date.Create(...) if(NULL == hWnd) //What happened? Re: WTL/ATL & CDateTimePickerCtrl Michael Dunn3-Jul-01 10:25 Michael Dunn 3-Jul-01 10:25  Did you call InitCommonControls() ? --Mike-- http://home.inreach.com/mdunn/ "Holding the away team at bay with a non-functioning phaser was an act of unmitigated gall. I admire gall."   -- Lt. Cmdr. Worf Re: WTL/ATL & CDateTimePickerCtrl 3-Jul-01 17:06 3-Jul-01 17:06  Its always the simple things. Thanks. Interface with CString as parameter Aky3-Jul-01 5:27 Aky 3-Jul-01 5:27  How do i add an interface with CString as its parameter i.e. HESULT Calc(CString) Since CString is a mfc class ,the compiler cannot recognise CString defined in the .IDL file? please help its urgent. Re: Interface with CString as parameter J Patel3-Jul-01 5:36 J Patel 3-Jul-01 5:36  To use string use BSTR. HRESULT Calc(BSTR strParam). HTH Jignesh Re: Interface with CString as parameter Jim Howard3-Jul-01 6:54 Jim Howard 3-Jul-01 6:54  Jignesh is correct, the correct way to pass strings in COM is the hated BSTR. There is a good article by Joseph Newcomer on CString that covers CString to BSTR to CString conversions very well. It is at: http://www.pgh.net/~newcomer/cstring.htm#CString to BSTR Jim Re: Interface with CString as parameter 3-Jul-01 9:45 3-Jul-01 9:45  Why reinvent the wheel. USES_CONVERSION; A2OLE, OLE2A, A2BSTR, BSTR2A, etc... COM crashing Chris Klecker2-Jul-01 8:36 Chris Klecker 2-Jul-01 8:36  I had an eariler issue dealing with DAO access causing a program to crash. Apparently installing MDAC and DAOSDK solves that issue. (thanks to those who helped on this matter ) However now I am noticing a problem with COM, more specifically MSFLEXGRID. I have a MSFLEXGRID control in the program and I am noticing that within the main window it is not showing up and within a dialog box it is causing the program to crash long before it paints. Are there more installs that need to happen? I noticed this all worked when I had VC++ installed. Thanks! Chris "Why are we hiding from the police, Daddy?" "We use VI, son. They use Emacs." passing map ? parag29-Jun-01 3:09 parag 29-Jun-01 3:09  how can i pass a map as a in parameter or out parameter ? I need [out,retval] mymap and [in] mymap something like this how can i achieve this ? parag Re: passing map ? 1-Jul-01 19:51 1-Jul-01 19:51  YOu can't. At least not without some serious hacking. C++ specific entities such as maps, lists, etc. were never made to be passed across COM boundaries. You cannot define them sufficiently for MIDL to handle them. COM+ Programmers/Trainers 28-Jun-01 6:55 28-Jun-01 6:55  I would like to talk to Programmers/Trainers that would be interested in teaching COM+ courses for Absolute Solutions, Inc. Absolute Solutions, Inc. is a computer training and consulting firm that is located in Bloomingdale, IL. If someone is interested, please, email your resume to mverma@absolutesolutions.com. Also, if you know someone that might be interested, please, pass this information on to them. Thank you. Async Queries + ADO Mukesh27-Jun-01 19:46 Mukesh 27-Jun-01 19:46  Hi Guys, I have been using ADO to execute queries asynchronisly. I am using adUserServer as Cursor location and adAsyncExecute flag to run the query using Recordset-->Open method.But the problem is if i cancel the query in between i get the following error: Error No : 3712 Description: Opeartion has been cancelled by the user. I don't understand why. And if i use Command object's Execute method to run my query, then the query dosen't seems to run asynchrosnly. Did anybody worked with ADO async queries? Any help in this regard would be highly appreciated. Cheers, Mukesh

Last Visit: 31-Dec-99 18:00     Last Update: 2-May-24 19:53 Refresh ᐊ Prev1...441442443444445446447448449450 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.