Type: Posts; User: Norby mahoney
Search took 0.01 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....
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 );
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); ...
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...
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