Type: Posts; User: Norby mahoney
Search took 0.02 seconds.
September 2nd, 2005, 12:25 PM
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...
September 2nd, 2005, 10:14 AM
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.
September 1st, 2005, 03:23 PM
1.) To create a relationship between these two tables, try this:
"ALTER TABLE table2
ADD CONSTRAINT FK_foreignkeyName
FOREIGN KEY (table1_ID) REFERENCES
September 1st, 2005, 02:44 PM
OK, let me ask this then:
Has anyone every use ADO to retrieve data from an Oracle stored procedure?
September 1st, 2005, 02:41 PM
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...
September 1st, 2005, 01:40 PM
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'...
September 1st, 2005, 01:16 PM
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...
September 1st, 2005, 01:06 PM
1.) GetTables() -from a recordset generated by adSchemaTables
ADODB::_RecordsetPtr rsTables = NULL;
rsTables.CreateInstance( __uuidof( ADODB::Recordset ) );
September 1st, 2005, 12:57 PM
-No OS/NT Authentication
-NO stored procedures support
-Both User AND OS/NT Authentication
-A bit faster
-stored procedures support
-Have to redistribute it...
September 1st, 2005, 11:00 AM
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...
September 1st, 2005, 10:28 AM
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...
September 1st, 2005, 10:18 AM
Var = recordset->Fields->GetItem("FirstName")->Value;
firstName = ( Var.vt == VT_NULL ? _T("") : ((char *) (_bstr_t)Var.bstrVal) );
This above code definitely...
September 1st, 2005, 09:21 AM
I'm using ADO against an Oracle 10g database.
1.) calling the following stored procedures throws an exception on the last line in the code below (DB_E_ERRORSINCOMMAND; IDispatch...
August 10th, 2005, 10:48 AM
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...
August 10th, 2005, 08:36 AM
Iteresting, I'm going to look into this now. Thanks for the tip.
August 9th, 2005, 05:15 PM
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....
June 13th, 2005, 02:59 PM
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...
June 13th, 2005, 01:01 PM
With 2 XP-pro machines in a common workgroup, the following code fails:
pDBConnection.CreateInstance( __uuidof( ADODB::Connection );
March 27th, 2005, 07:10 PM
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...
February 17th, 2005, 02:29 PM
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.
January 25th, 2005, 04:36 PM
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...
January 25th, 2005, 02:32 PM
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); ...
July 29th, 2004, 08:46 AM
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...
July 28th, 2004, 05:24 PM
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...
October 16th, 2003, 06:19 PM
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(),...
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.