Database

I have tried that also, but it didn't solve the problem. I have also tried CComPtr<_Connection> m_pConnection; . . . m_pConnection.CopyTo(*pdbReturnValue); but it also failed to return the correct connection pointer.

Hello again, Carlos Antollini ! Tanks for your helps. Regards!!!!;) Mehrdad.

use the free version of toad (oracle equivalent to Enterprise Manager) from www.toadsoft.com Top Oracle tool

You need to call AddNew or Edit Methods before you call Update. Your code currently has them commented out.

From now I will always use "Try and catch" even with small and simple ADO connections, i found the problem. Thanks Rashid This was very useful: catch( _com_error &e){ _bstr_t bstrSource(e.Source()); _bstr_t bs = _bstr_t(" Error: ") + _bstr_t(e.Error()) + _bstr_t(" Msg: ") + _bstr_t(e.ErrorMessage()) + _bstr_t(" Description: ") + _bstr_t(e.Description()); MessageBox(0,bs,bstrSource, MB_OK);

Thanks for the response, Carlos. I'm using Oracle 8I and had tried to use that but continually got errors from the parser. Once I put the brace characters around the query with the unions, it worked like a champ. None of my books even gave an example such as yours. You helped me out a lot. Thanks again. Chris

I had guessed as much :(. Why oh why did the original designers of SQL not think people would need that functionality? It's common sense if you just want to retrieve, say, 20 rows from a fifty million row table, that you would rather not return the first 49,999,980 only to ignore them. David Wulff dwulff@battleaxesoftware.com

I have done this a couple of times. Go in to the SQL Server admin, and script yopur database. Then you get a SQL file with a lot of SQL "Queries" in. After each query there is a "GO" statement. Just take each of those queries, without the GO part, and execute them from your installer. There's a lot of articles here on CodeProject about how to connect to a database and execute SQL Queries. - Anders Money talks, but all mine ever says is "Goodbye!"

Hi I think what you want to do is almost the same as what the RDS.DataFactory can do for you. If you need to extend the functionality - you can create your own based on the DataFactory. Search for RDS in the MSDN

You also have the choice of using OLE DB Consumers, the prefered way in Visual C++ when using OLE DB.

Sorry to correct you, but in the new ADO 2.7 docs are a lot examples in VC++ using the import statement

Parameters is a collection, so you have to use. In VB the Item property is the default property of the parameters collection. But in C++ there are no default properties. BTW I don't thing defaulting everthing as done in VB does the programmer do an favour. Defaulting rules can change, because there are defined by the type lib you are coding againts. So if you happen to have a newer type lib installed where the default props have changed, you will run into trouble. So I have the attitude to never depend on default probs and methods in any language I use (VB, C++, VB script) pCommand->Parameters->Item[_T("@pkMbtID")]->Value = _T'160' And is your parameter really a string or is it a number ? The Value is a _variant_t, so you can stuff in a number, if that's what you really want.

My descriptive powers of the written word have failed me again, I'm a moron. What I was trying to say was - When creating a database from within Access itself I couldn't just name the tables and fields they contained anything I wanted, a wizard kept getting in my road and pissed me off so much I went to SQL Server which was overkill. I will pul my head in, try all this again and learn to express my question better next time. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018 "Don't belong. Never join. Think for yourself. Peace" - Victor Stone

Perhaps calling the IIdle::Idle would remove the locks? The Jet OLE DB docs makes it clear that we should call this methods frequently. Cheers Steen. "To claim that computer games influence children is rediculous. If Pacman had influenced children born in the 80'ies we would see a lot of youngsters running around in dark rooms eating pills while listening to monotonous music"