Search:

thanks. The second link didn't work when I downloaded and ran the sample. I'm looking @ the second one ( I'm a VC++ guy, not VB, so will have to parse this one out ). Maybe it's the PL/SQL that is...

Never heard of this database; I did a Google search and found nothing either.
Are you using ADO? If so, and their is an OLDEDB provider for this database, then have a look at ADOX.
...

1.) To create a relationship between these two tables, try this:
strSQL =
"ALTER TABLE table2
ADD CONSTRAINT FK_foreignkeyName
FOREIGN KEY (table1_ID) REFERENCES
table1(ID)
*ON...

OK, let me ask this then:
Has anyone every use ADO to retrieve data from an Oracle stored procedure?

If the user chooses to search for a records that have the work XYZ in the Descrip field, this would be your query:
SELECT * FROM table WHERE table.Descrip LIKE '%XYZ%'

This works in SQL...

Examples:
SELECT * FROM family WHERE alpha_code >= 'B' AND alpha_code <= 'M'

SELECT * FROM family WHERE
(alpha_code >= 'A' AND alpha_code <= 'C' ) OR
(alpha_code >= 'F' AND alpha_code <= 'I'...

Yea, you have 2 options ( that I can think of)
1.) Source Database: Export the data in a form that can be imported into the Target Database.
2.) Using a tool ( like Enterprise Manager for SQL...

Specifically:
1.) GetTables() -from a recordset generated by adSchemaTables


ADODB::_RecordsetPtr rsTables = NULL;
rsTables.CreateInstance( __uuidof( ADODB::Recordset ) );
rsTables...

MS Provider:
-No OS/NT Authentication
-NO stored procedures support

Oracle Provider:
-Both User AND OS/NT Authentication
-A bit faster
-stored procedures support
-Have to redistribute it...

I just wanted to get across to the original poster that:
- Given that he seems to be looking to expand his skill set, it would seem that learning C#.NET would be a better use of his time than...

Hey, since 'popularity of the language' is a big driver for your desire to learn c++, I'd suggest saving your time and learning C#. .NET is about to to go through it's 3rd generation ( with 2005...

Try this:

COleVariant Var;
Var = recordset->Fields->GetItem("FirstName")->Value;
firstName = ( Var.vt == VT_NULL ? _T("") : ((char *) (_bstr_t)Var.bstrVal) );

This above code definitely...

I'm using ADO against an Oracle 10g database.

2 problems:
1.) calling the following stored procedures throws an exception on the last line in the code below (DB_E_ERRORSINCOMMAND; IDispatch...

I've looked around and have only found connection string examples for this provider that use a 'User id' and 'Password'.

My question: Is there a way to use this provider and connect using OS/NT...

Iteresting, I'm going to look into this now. Thanks for the tip.

Using VC++ 6 with ADO.

I'm new to Oracle, so this may be a setup issue. Currently I have to qualify a table name with it's schema name in order for even the simpliest of queries to work ( e.g....

No, and I'm glad you asked. After further scrutiny, it looks like the problem was my single quotes around the user, pwd, etc.

Now it works on both the local and 'remote' machine. Thanks for the...

With 2 XP-pro machines in a common workgroup, the following code fails:

pDBConnection.CreateInstance( __uuidof( ADODB::Connection );

CString sConnect;...

I have a windows cluster with 2 servers running Windows Server 2003. Initially, my client-server application was crashing so I was fixing bugs with my code. Now, periodically one the two cluster...

When my application starts up, it is set to display full screen and to be topmost (there's actually a splashscreen displayed fullscreen until the User logs in). This is an MFC MDI app.

The...

Ok,

I've read through several threads on using SEH to catch exception that would normally not be caught by your standard try-catch blocks.

Using a basic setup, I cannot catch an Access...

Is it possible to reparent an ActiveX control? I've tried calling SetParent(), but when it is time to access a method of this reparented ActiveX control, I receive:

"ASSERT(m_pCtrlSite != NULL); ...

The resource I need to load is a dialog that needs to be loaded up at the time DLL1 is initially loaded. I think what I'm trying to do is not possible; I guess there is one resource handle shared...

I have an MFC application. It loads a DLL (DLL1). DLL1 in turn loads DLL2. DLL2 is used by DLL1 for resources. The problem is when I load DLL2 in DLL1, and call AfxSetResourceHandle(), this...

For anyone else that runs into this problem:
I needed a message pump of some sort; being in a DLL I didn't have one. So create a CWinThread (UI type). From within the thread's Initinstance(),...