Tech-Today
I am currently developing a certain application in MS Access and I need to link 2 databases, select data from one and move it to the second. In access I have no problem using the TransferDatabase command.
But since our application must support multi database via ODBC, I also run the script on 2 mysql databases. Unfortunately, I have encountered this error, when executing update statements.
But before this, I have encountered and solve another error which is:
The solution to this problem according to some article is to auto press ESC key when needed, which is done like this:
When I have encountered the second error - the title of the blog, I google it and found several suggestions including giving rights to IUSR*, IWAM users [http://support.microsoft.com/kb/175168], still I haven't solve my problem.
That's when I thought about the 1st error was related to the second, and going deep into the article mentioned, I've tried adding index to a table that cause the error (yes it doesn't have one since it's just a link table).
And my problem was gone just like that. If you will read the mysql documentation you will find out that it doesn't allow UPDATE statements without primary/unique keys not like in MS Access which ignores this. So when using other database always set your primary key :-D.
- Csharp Development
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.How to implement an ajaxcontrol toolkit cascading dropdown with databaseThe process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC)Error...
- Gsmcomm Message Received 321 Occurred
Recently I've encountered this error while developing a gsmcomm powered device up couple with 500 error. To know what these errors mean, you can refer to: http://www.developershome.com/sms/resultCodes2.asp#16.2.1.1.Table of +CMS Error Codes and Their...
- Fopen() [function.fopen]: Url File-access Is Disabled In The Server Configuration
I am checking it my link verifier script is working when I have encountered this error. This is my function that checks if a url is existing. function ipiel_ping_link($obj) { $flag = 0; try { $handle = fopen($obj, "r"); if (!$handle) { $flag = 0; }...
- Magento: Cannot Add Or Update A Child Row: A Foreign Key Constraint Fails
I am in the stage of migrating my local database of magento to public when I have encountered this error. How did it happen: 1.) I use phpmyadmin3.2 to export the sql statements. 2.) In my host mysql's phpmyadmin, I have executed the dump statements....
- Staxmem.dll Not Found...
Recently, I've encountered this error during IIS installation and don't know what to do or where to start. The error said it can't find the file though I can see it in the CD, I thought it was corrupted to I tried copying the i386 directory...
Tech-Today
Operation must use an updateable query
I am currently developing a certain application in MS Access and I need to link 2 databases, select data from one and move it to the second. In access I have no problem using the TransferDatabase command.
DoCmd.TransferDatabase acLink, "Microsoft Access", databaseFile.mdb, acTable, tableName, newTableName
But since our application must support multi database via ODBC, I also run the script on 2 mysql databases. Unfortunately, I have encountered this error, when executing update statements.
But before this, I have encountered and solve another error which is:
Select Unique Record Identifier - (1st error)
The solution to this problem according to some article is to auto press ESC key when needed, which is done like this:
SendKeys ("{ESC}") 'this solves the 1st error
DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=" & localDSN, acTable, tableName, newTableName
When I have encountered the second error - the title of the blog, I google it and found several suggestions including giving rights to IUSR*, IWAM users [http://support.microsoft.com/kb/175168], still I haven't solve my problem.
That's when I thought about the 1st error was related to the second, and going deep into the article mentioned, I've tried adding index to a table that cause the error (yes it doesn't have one since it's just a link table).
And my problem was gone just like that. If you will read the mysql documentation you will find out that it doesn't allow UPDATE statements without primary/unique keys not like in MS Access which ignores this. So when using other database always set your primary key :-D.
- Csharp Development
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.How to implement an ajaxcontrol toolkit cascading dropdown with databaseThe process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC)Error...
- Gsmcomm Message Received 321 Occurred
Recently I've encountered this error while developing a gsmcomm powered device up couple with 500 error. To know what these errors mean, you can refer to: http://www.developershome.com/sms/resultCodes2.asp#16.2.1.1.Table of +CMS Error Codes and Their...
- Fopen() [function.fopen]: Url File-access Is Disabled In The Server Configuration
I am checking it my link verifier script is working when I have encountered this error. This is my function that checks if a url is existing. function ipiel_ping_link($obj) { $flag = 0; try { $handle = fopen($obj, "r"); if (!$handle) { $flag = 0; }...
- Magento: Cannot Add Or Update A Child Row: A Foreign Key Constraint Fails
I am in the stage of migrating my local database of magento to public when I have encountered this error. How did it happen: 1.) I use phpmyadmin3.2 to export the sql statements. 2.) In my host mysql's phpmyadmin, I have executed the dump statements....
- Staxmem.dll Not Found...
Recently, I've encountered this error during IIS installation and don't know what to do or where to start. The error said it can't find the file though I can see it in the CD, I thought it was corrupted to I tried copying the i386 directory...