ADO/ATL/Jet 4.0 Provider problems with INSERT-sql 
Author Message
 ADO/ATL/Jet 4.0 Provider problems with INSERT-sql

Hi,

Im trying to use a stored procedure with an INSERT-string from
a Jet-database. The table im inserting values to have a Jet-counter,
so im living that values to be created from the database engine.
But to the other two columns would a like some text-values.
m succeed with this Stored Procedure when im usering the ODBC-provider.
But, because its a single user/stand alone system with a Jet database, I
would prefer to use the Jet Provider instead.

Please....i need your help!

Some code:
void CADO_VC_test_2Dlg::OnInsertfaltJetProvider()
{
 CString        strData;
 char         str[21];
 CINSERTfalt_b  jflt;
 HRESULT        hr;

 strData = "XXXYYY";
 strcpy(str, strData);

// hr = skjflt.OpenDataSource();
// if (FAILED(hr))
//  return;

 strcpy(skjflt.m_whereparmbenamning, str);
 skjflt.m_whereparmfarg = 1;
 skjflt.m_whereparmkartomrid = 1;
 skjflt.m_whereparmvisa = 1;
 hr = skjflt.Open();
 //hr = skjflt.OpenRowset();
 if (FAILED(hr))
  return;

 skjflt.Close();
 return;

Quote:
}



Mon, 27 May 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. ADO/ATL/Jet 3.5 Provider problem

2. ADO Jet 4.0 performance problem vs Jet 3.51

3. DataGrid Control and ADO Jet 4.0 Provider

4. ADO 2.5, Jet 4.0 Provider, Error: Query too complex

5. ADO 2.1, Jet 4.0 as a Provider ?

6. ADO Data Control fails to refresh with Jet 4.0 provider

7. Replace OLEDB provider Jet 3.51 with Jet 4.0

8. Data Environment/Jet 4.0 OLE DB Provider problem

9. Problem with Jet OLE DB Provider 4.0

10. Problem with provider OLE DB jet 4.0

11. INSERT INTO works with Jet 3.51 but fails with Jet 4.0

12. insert tables in ATL OLE DB Provider Templates


 
Powered by phpBB® Forum Software