Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • May 15, 2003 at 11:01 am in reply to: moving from MSSQL to MySQL #14269
    ikaufman
    Member

    Thanks, Shadow!

    It works. I was in hurr too much 😀

    May 14, 2003 at 9:24 pm in reply to: moving from MSSQL to MySQL #14267
    ikaufman
    Member

    Hi,

    I faced the same problem converting from MSAccess. SQLyog copy routine doesn't copies indexes and autoincremets (at least I found it works so with Access). So I have got mySQL table with INT field instead of auto-increment. When I tried to convert this field to auto-inc, values have been renumbering sequentally as I have gaps in numbering.

    One solution I see is to index this field as UNIQUE – in this case values aren't changing. But if you will add new rows you should fill this field by yourself (i.e. using MAX(..)+1).

    May 14, 2003 at 9:11 pm in reply to: Forum Suggestion #14272
    ikaufman
    Member

    AFAIR, there should be no problems with mySQL under Win&ASP. You can install myODBC or myOleDB drivers – and get connection to mySQL from your ASP script. I didn't try, but…

    May 13, 2003 at 9:19 pm in reply to: Amazing… #14200
    ikaufman
    Member

    Absolutely! I have downloaded SQLyog this morning and enjoyed a lot. I have found a friendly interface and full set of very useful routines. I have been able to convert my MsAccess base to mySql quickly and easily. Thanks, it is a really good job.

    Well, there are some bugs of course (I work under 2000), and I have got Access violation error twice in different points. But… do we know “bug-free” programs? 🙄

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)