Category : ms-access

I have a new application uploaded to Windows server that is attempting to read MS Access DB and I get the error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Tracing shows that I get the error at the point where I try to open the connection. This ..

Read more

I am trying to connect to an Access DB in the local drive using TFDConnection. But My code is getting stuck or hanged while trying to open the connection. Please find the code snippet below: CreateBOTSchema(AnsiString accesslocation){ AnsiString db; db = "Database=" + accesslocation; FDConnection1->Params->Clear(); FDConnection1->DriverName="MSAcc"; FDConnection1->Params->Add(db); FDConnection1->Connected=true; FDQuery1->Connection=FDConnection1; FDQuery1->SQL->Clear() ; FDQuery1->SQL->Add("CREATE TABLE COMPONENTS "); ..

Read more

I’ve found some working code from this link, Connect and Insert data into a MS Access table using C++ however I don’t want to insert data I want to retrieve data. The documentation is horrendously hard to follow https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/odbc-reference?view=sql-server-ver15 and I don’t really have 100,000 hours spare to understand what each parameter means for any ..

Read more