I'm using Windows 7, C++ Builder XE, dbExpress (XE package), MySQL 4.1.18-nt on a webserver and MySQL 5.1.53-community local.
The following parameters are set:
Code: Select all
SQLConnection1->DriverName = "MySQL";
SQLConnection1->GetDriverFunc = "getSQLDriverMYSQL";
SQLConnection1->LibraryName = "dbxmys.dll";
SQLConnection1->VendorLib = "libmysql.dll";
SQLConnection1->Params->Clear();
SQLConnection1->Params->Add("DriverName=MySQL");
SQLConnection1->Params->Add("HostName=domain.net");
SQLConnection1->Params->Add("Database=***");
SQLConnection1->Params->Add("User_Name=***");
SQLConnection1->Params->Add("Password=***");
SQLConnection1->Params->Add("Port=3306");
SQLConnection1->Params->Add("BlobSize=-1");
SQLConnection1->Params->Add("ErrorResourceFile=");
SQLConnection1->Params->Add("LocaleCode=0000");
SQLConnection1->Params->Add("Compressed=False");
SQLConnection1->Params->Add("Encrypted=False");
SQLConnection1->Params->Add("ConnectTimeout=60");
SQLConnection1->Params->Add("ServerCharSet=utf8");
SQLConnection1->LoginPrompt = false;
SQLDataSet1->GetMetadata = false;
I'm using the following code for reading:
Code: Select all
SQLDataSet1->Close();
SQLDataSet1->CommandText = "SELECT * FROM table";
SQLDataSet1->ExecSQL(true);
SQLDataSet1->Open();
SQLDataSet1->First();
Memo1->Clear();
while(!SQLDataSet1->Eof)
{
Memo1->Lines->Add(SQLDataSet1->FieldByName("field")->AsString);
SQLDataSet1->Next();
}
SQLDataSet1->Close();
I'm using the following code for writing:
Code: Select all
SQLDataSet1->Close();
SQLDataSet1->CommandText = L"INSERT INTO table ("field") VALUES ('エンバカデロ・テクノロジーズは');";
SQLDataSet1->ExecSQL(true);
SQLDataSet1->Close();