Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberNope…that should not be a problem?
Which version of MS SQL Server are you using and is the ODBC driver ODBC 3.0 compliant?
Ritesh
MemberHmmmmmmmmmmmmm…..interesting
Check out that the DSN is pointing to the correct database 😮 There should not be any problem with importing data from MS SQL
HTH
Ritesh
MemberHello
SQLyog is known to have problems with different charset. We plan to fix it in one of the future release.
HTH
Ritesh
MemberHello
You dont have permission to remotely access the MySQL DB. Ask lunarpages.com to give you the correct permission
HTH
Ritesh
MemberCan you provide us with the exact error message?
It seems that you dont have the correct permission for remote access. Contact your ISP/MySQL admin to give you proper privileges.
HTH
Ritesh
MemberSORRY but SQLyog does not work with Oracle. It is a front end tool for MySQL. You can try Orafaq for more information.
Ritesh
MemberHello
Quote:where can i donate a couple of $$ to help support youThanks for your consideration 😀
Quote:when will sqlyog be able to log into mysql 4.1 alpha (and beyond)?We will be coming out with a new version of SQLyog later this month which will support MySQL v4.x and later 😀
HTH
Ritesh
MemberYou can execute any type of SQL using SQLyog 😀
Ritesh
MemberQuote:However, I have been experiencing a problem. I tried the 'export resultset' (using the HTML option) to a file on the desktop but failed to see or find the file anywhere. That action failed on all of my three attempts. I would be grateful for some help there (maybe export result set is not what I think it is). Please explainIn the export resultset dialog box, select a file using … button. When the file with the complete path comes in the read-only text box, press Export.
Quote:I tried to update a single table database (which had no primary key)You can not update a table with no Primary Key defined in SQLyog. You have to write your own SQL stmt. to do that.
Quote:Additionally, I noticed that when query results are changed to text (using control l), they can be selected but cannot be copied/cut and pasted to the clipboard.Press Ctrl+C to copy the data into clipboard in tab-delimited format
HTH
Ritesh
MemberHello
Remove the ; at the end
HTH
Ritesh
MemberCan you send me the SQL Batch script for both the databases, so that we can reproduce the bug ( if there are any ) out here :huh:
Ritesh
MemberHello
Execute the following statement for the database that has the concerned tables.
Code:show table status from `yourdbname`Do you see any FK defination in the comment field of the resultset?
Better still if you can post the result out here 😀
Ritesh
MemberWhat I meant to say is instead of switching the database in the dropdown combo box, click on the Sync ( Clipboard ) for the second database
HTH
-
AuthorPosts