C / C++ / MFC

13-Oct-01 23:17

I hate to do this, but I've asked the question multiple times and it's the only part of my program not finished. I'm hoping that someone who knows the answer missed it this time because it got pushed out of view pretty quickly.

If anyone knows how to create an Access database from scratch using ADOX, could you please answer my question from yesterday ?

Christian

As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet.

Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery.

Anders Molin14-Oct-01 1:48

Anders Molin

14-Oct-01 1:48

I only have seen some VB code to do it:

Const Jet10 = 1
Const Jet11 = 2
Const Jet20 = 3
Const Jet3x = 4
Const Jet4x = 5

Sub CreateNewMDB(FileName, Format)
  Dim Catalog
  Set Catalog = CreateObject("ADOX.Catalog")
  Catalog.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _
     "Jet OLEDB:Engine Type=" & Format & _
    ";Data Source=" & FileName
End Sub

'Create Access2000 database
CreateNewMDB "G:\a2000.mdb", Jet4x

Hope it helps...

- Anders

Money talks, but all mine ever says is "Goodbye!"

Christian Graus14-Oct-01 2:04

14-Oct-01 2:04

Interesting... If I make the line

sprintf(pChar, "Provider=Microsoft.Jet.OLEDB.4.0;Jet Engine Type=5;Data Source=%s;", (char*)DatabasePath);

then I get an error:

Could Not Find Installable ISAM.

Do you know what this means ? BTW the Microsoft exmaples in C++ don't use the 'Jet OLEDB:Engine Type= ' parameter and create useless files just like my code does.

Christian

As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet.

Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery.

Anders Molin14-Oct-01 4:15

Anders Molin

14-Oct-01 4:15

To be honest I just got the code from a friend of mine and thought that maybe you could use it...

- Anders

Money talks, but all mine ever says is "Goodbye!"

Christian Graus14-Oct-01 2:09

14-Oct-01 2:09

Whoops - fixing the syntax gives me a database I can read from but not write to, for some reason...

Thanks for the step forward. Now I just need to figure why I cannot write to it...

Christian

As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet.

Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery.

Christian Graus14-Oct-01 2:39

14-Oct-01 2:39

The specific problem now is when I try to add data:

// Get everything in order first
if (records->RecordCount != 0)
	records->MoveFirst();
CComBSTR bstrPath;
(*it)->get_FilePath(&bstrPath);

char * pStr = new char[bstrPath.Length() + 24]; 
memset(pStr, 0, bstrPath.Length() + 24); 
sprintf(pStr, "[FilePath] = \'%s\'", (char*)(_bstr_t)bstrPath);

try
{
	records->Filter = (bstr_t)pStr;
}
catch (.../*_com_error & e*/)
{
	MessageBox(NULL, "Error", pStr, 0);
}

string renderpath = (bstr_t)bstrPath;

for (string::iterator itr = renderpath.begin(); itr != renderpath.end(); ++itr)
	 if (*itr == '?') *itr = '\'';

// Call our connection point to inform of file name we are about to scan
CComBSTR callback(renderpath.c_str());
Fire_ScanningFile(callback);

if (records->RecordCount == 0)
{

The above code opens the recordset, moves to the start if it has records, replaces ? with ' in the filename ( having ' in my records killed my query statements ), sends a callback and then checks if the record count is 0 after the filter, which means I should add the record. Now if I create the DB programatically, this code always falls through, and records->RecordCount ALWAYS equals 1 ( tried with zero, one and two records in the DB. The odd thing is that everything is fine in Access, I can add & remove records, and they show OK in my program. The *other* odd thing is if I called Records->MoveFirst() when there were zero recordsin the DB created in Access it would crash, unless it crashes if it finds zero for no REAL reason, and for some reason it's finding one, which is OK.

Argh !!!!!

Christian

As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet.

Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery.

Wanderley M14-Oct-01 3:55

Wanderley M

14-Oct-01 3:55

I'm not sure if I got this right, but:

1. How are you opening your recordset? Recordcount returns different numbers depending on cursor type you choose.

2. Use EOF instead of recordcount to check the status of your recordset. You always have to check eof before using Move(...) functions.

HTH

Regards,

Wanderley

Christian Graus14-Oct-01 10:15

14-Oct-01 10:15

Thanks for the reply.

1/

	_RecordsetPtr records = NULL;
	 records.CreateInstance(__uuidof(Recordset));

	try
	{
		records->CursorType = adOpenStatic;
		records->CursorLocation = adUseClient;
		records->Open("SELECT * FROM FileDatabase",
		_variant_t((IDispatch*)m_Connection, true), adOpenKeyset, adLockOptimistic, 
		adCmdUnknown);
	}
	catch(...)//_com_error & e)
	{
//		MessageBox(NULL, e.ErrorMessage(), "", 0);
	}

This works with the db created in Access, but the one I am now creating in ADOX opens fine, reads fine, but the Filter always returns that I have one record.

2/ I was using EOF to start with, I changed it to RecordCount when I was trying to fix this problem. Same result both ways.

Thanks for any suggestions you may have...

Christian

As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet.

Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery.

Wanderley M15-Oct-01 8:44

Wanderley M

15-Oct-01 8:44

Hi
Did you fix you problem? One day away from CodeProject and your message almost disappeared Smile | :)

Is there any reason to use Filter instead of opening your recordset using WHERE in your SQL statement? This way you can check for EOF right after you open the recordset.

I have no clue why it works when you create your db in Acess - maybe a bug in ADOX... Anyway, could you send me some files to check if I have the same problem here?

Regards,

Wanderley

Christian Graus15-Oct-01 10:46

simple client program for ATL ! Please HELP !!!

15-Oct-01 10:46

Thanks for the reply.

Two reasons:

1/ I am filtering by each potential new record in order to find out if it exists, so I don't want to open the recordset over and over

2/ When I've tried to impliment filter, it crashes every time.

The thing I don't get is if ADOX is the problem, why is the created DB file exactly the same as the one Access creates and allows me to add data within Access... I'll send you a zip of some files, thank you.

Christian

As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet.

Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery.

13-Oct-01 21:25

I created ATL and I want to use it in my project (MFC Dialog project)

But I dont success to create Instance of my ATL.

I maked so :
---------------------------------------------------------------------
insert the files: MyAtl.dll /.h/_i.c to my folder
---------------------------------------------------------------------
#include "MyAtl.h"
#include "MyAtl_i.c"
---------------------------------------------------------------------
HRESULT hr = CoInitialize(NULL);

if (FAILED(hr)){ .....}

IAtlObj *pHello=NULL;
hr =CoCreateInstance(CLSID_CIQS, NULL,CLSCTX_ALL,IID_ICIQ, (void**&pHello);
if (FAILED(hr)) {.......} //==>> and in runtime it is failed here

----------------------------------------------------------------------

What is the problem ?
Confused | :confused:

Re: simple client program for ATL ! Please HELP !!!

Christian Graus13-Oct-01 23:12

Re: simple client program for ATL ! Please HELP !!!

13-Oct-01 23:12

It's easier to use #import if you can. Have you checked to see what the error is ? Does the above line have a typo so that you're really casting to void ** ( no close brackets ) ? Also should it be CLSID_CIQ*S* but IID_ICIQ ?

Christian

As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet.

Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery.

13-Oct-01 23:42

Thank you Christian ! Smile | :)

I checked it and is all right (Have not typo):
void** in close brackets and I writed : IID_IMyObject
and although it dont succeess. It passed compilation ok but it dont create the instance in run time.

Are you sure that this is all right in my steps as I tell you that I did ? Confused | :confused:

if so it seems that the problem is in my ATL Dead | X|

Please answer me !!!! It is very URGENT !!!

13-Oct-01 23:46

Christian Graus14-Oct-01 0:00

14-Oct-01 0:00

If you expect an answer within four minutes, you'll need to register so I get an email to say you replied to my post.

Have you tried #import ? Did you check the error ?

Christian

As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet.

Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery.

14-Oct-01 0:10

excuse me on my nervous and on my stupid question :
How can I use at #import ?
Can you write me a line code for example ? Confused | :confused:

Christian Graus14-Oct-01 0:31

14-Oct-01 0:31

No worries - questions are what this area is for. If you read the lounge at the moment, I've commented there on my feelings regarding anonymous posts, but I'm still glad to help if I can.

You can access your ATL object in one of two ways. First you can do the #include thing, which gives you named guids and the headers you need, so you can do what you've tried. #import looks like this:

#import "..\ATL\SADatabase\SADatabase.tlb" no_namespace named_guids

This imports the type libray, the options I specified mean there is no namespace ( for example if I import ADO without this option I need to using namespace ADO;, or ADO:: everything. ), and give me those named guids. They also give me smart pointers I can use to easily create things and not worry about releasing them.

Like so:

IEnumSAFileEntryPtr pIEnumDB;

ISAFileDBPtr pIFind(__uuidof(SAFileDB));

HRESULT hr;

try
{

    if (pIFind == NULL) return;

    if(FAILED(pIFind->Connect(m_DBPath)))
    {
        AfxMessageBox("Failed To Connect");
        return;
    }

    hr = pIFind->GetDatabase(&pIEnumDB);

    pIFind->CloseDB();
}
catch (...)
{
    pIFind->CloseDB();
    AfxMessageBox("Error reading dabatase");
    return;
}

These are blocks of code from my current home project, and they all work nicely. The smart pointers are the interface name with Ptr after them, and IEnumSAFileEntryPtr is an enumeration object, created later. The line ISAFileDBPtr pIFind(__uuidof(SAFileDB)); creates the object in my smart pointer - much nicer, doncha think ?

Try that and let me know how you go. If hr still fails, find out what the value is ( in terms of what error it is reporting )

Christian

As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet.

Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery.

14-Oct-01 1:02

Thank you !
But I dont find in my computer the path: ...ATL\SADatabase\SADatabase.tlb
So what is your mean in the line :
#import "..\ATL\SADatabase\SADatabase.tlb" no_namespace named_guids

Christian Graus14-Oct-01 1:07