Recent content by mbames

Just installed Exchange 2000 and sp3 onto a 2000 server (member server), but it appears that the GAL does not appear on all the machines when you click on the address list button in Outlook, or on the 'to' button when composing an email. Also experiencing problems when trying to allow a user to...

I tried that and it did not do a thing :-( I also not that on Exchange 5.5 the event appeard in the other peoples diaries even before they accept it, but this is not the case on my test Exchange 2k install at work. I'll check to see what happens with my Ex 5.5 install at home. Cheers, Matt

In Exchange 5.5 I believe there was an option to set an "auto accept" of meeting requests so they appeared directlt in your calendar, rather than having to approve them via the email that is sent to your inbox. Does anyone know how to do this under Exchange 2000? The background to...

Just tried it from code, and it executes fine from there, so I assume this is a limitation that has being imposed by SQL*Plus :-(

I have written a nice long query that uses multiple joins, however when I started adding in the names of the fields from the tables that I required SQL*Plus has started to throw a wobbly, but deleting just one field name makes it work. A working command is 1023 characters long, but any longer...

Hi Dima, As I am not too familar with Oracle I am a little lost here! I know that indexes exist for my primary keys, but I don't see any for my foreign keys - how would I go about generating them? Is it some simple command to issue from SQL*Plus, or though the (slow) Oracle Java GUI? Cheers...

I have a master table (tbl_track) which has approx 22million records in it. I also have a number of subtables, such as tbl_optional, tbl_bearing, etc which contain data relating to the tbl_track table. I have a unique record number assigned to each record in tbl_track, and this is the primary...

The trouble was I needed to access this value in C++, and my DB <--> C++ skills on handling returns were not too good, but I know how to handle a recordset! Cheers,m Matt

I think that I have managed to resolve what I was trying to do. The background to this, was that when I insert a new record into a table, I wanted to be able to return the new autonumber field (currval from a sequence). What I have done is written a package that does an insert and then returns...

Hi, Is there a way that I can reference a field in a recordset via a number, rather than by its actual name? eg. select id, name, age from people then then I could access field(1) which would be the same as the 'name' field. Cheers, Matt

Hi, I am new to both Oracle and C++, so this many be a simple problem, but I would appreciate your help with it! I am using the basic code found at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdaexamples_vc02_11.asp However that I need to do is insert data...

The double quote was a typo - I copied the line from my c++ code: _bstr_t strSQLChange(&quot;UPDATE tblRegCode SET rDescription = 'moretime in bed' WHERE rCode = '/'&quot;); and _bstr_t strSQLRestore(&quot;UPDATE tblRegCode SET rDescription = 'Morning' WHERE rCode = '/'&quot;);

I am trying to a write a little application that read / write data from 9i. I have some C++ code that works with Access and SQL Server via ODBC. However when I try and run it on 9i, it then gets upset, giving me the following error: ORA-00900: invalid SQL statement although I can quite...

I am new to C++ (and C in general). I need to write a small console app, that will eventually end up life as a service (but I am not worried about that at the moment). I need to be able to connect to an Oracle database in order that I can: (i) store a new record (ii) retrieve a record I have...

this of course assumes that you are returning your recordset as adStatic (or similar), otherwise the recordset.recordcount variable will not be set..... Matt