Search results for query: *

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...

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...

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...

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...

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...

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...

I am sure that anyone who has tried to use XMLType in 9i will know what I am about to say. I have a test table with 1/2 million records (which the live system is likely to have many more). However when using the .extract() function to find a given xml tage for a value of my choosing the query...

Is there an easy way to time how long a query takes? For instance I have a table with 1/2 million test records (each is unique). Part of each record contains an XMLType, and I need to show that searching in an XMLType is slow... and that we should be splitting out certain fields from the XML...

I seem to be having trouble getting Access to called a procedure in Oracle. I am trying to do this via a pass thru method. Essentially I create a query on the fly and pass that through the ODBC link to Oracle. I can run my procedure through SQL*Plus so I know it is fine, and I can view the...

I have a number of PCI NICs all based around the Realtek 8139 chip. Does anyone know of a suitable boot room that I can get for the card? I believe that realtek had a boot rom image on their website, so that just requires me knowing the correct type of eprom, and then blowing the rom image...

I seem to be failing to write a proper procedure and I am not sure why. Initially I tried using the oracle manager gui wizard thing to create a procedure, but it seems to require two lots of names (and then told me my query was invalid at line 1, col 7). I then tried writing via SQL*Plus, but...

While I seem to be quite capable of using this command from the SQL*Plus window, I am unable to get to to work when I try and get it to work through access to my oracle DB. Table: ID - number, unique Name - string mydate - date myxml - xmltype The error message I am getting is "Undefined...

I am new to Oracle, so maybe I am just done something silly, but here goes: Installed 9i, created a user, schema, quota and then a basic table - ID (number)(unique), Name (vchar2). I then inserted 2 records when logged into sqlplus as myself. Then I created an OBDC link to the database, and...