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

4.1 BETA 2 Scheduled ODBC Import Crash

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › 4.1 BETA 2 Scheduled ODBC Import Crash

  • This topic is empty.
Viewing 13 reply threads
  • Author
    Posts
    • July 14, 2005 at 1:15 pm #9107
      ekred
      Member

      I just upgraded to 4.1 BETA 2 to try out the new scheduled ODBC import. I far as the “scheduled” part is concerned, everything seems to work well. On the other hand, it looks like SJA have some bug(s) in reading the structure of the tables to import. Back in 4.07, I was able to import manually all my tables without any problem. But now, SJA output a 1064 error (SQL error) like if the table CREATION script had some mispelling: “…syntax to use near ') UNSIGNED NULL DEFAULT 'NULL', `PrSellingPrice0_2` double(15” and then simply crashes with a “cannot read memory address…” error.

      That's about all I can tell about my problem. Is there any other information I should give to help fix this bug?

      Thanks

    • July 14, 2005 at 1:44 pm #18615
      Ritesh
      Member

      Which database you are trying to import from?

      Can you mail me backup of the database?

    • July 14, 2005 at 2:04 pm #18616
      ekred
      Member

      Wow, prompt response! Thanks! I just sent you an email with my backup attached to it.

    • July 14, 2005 at 3:21 pm #18617
      Ritesh
      Member

      Thanks. I have recieved the mail.

      The dump seems to be from a MySQL database. Are you trying to import data from MySQL to MySQL using ODBC Import Tool?

    • July 14, 2005 at 3:50 pm #18618
      ekred
      Member

      Hmmm maybe I didn't send you the document that you were expecting? I'm not trying to import from MySQL to MySQL. I use an accounting software which uses his own database system but they sell an ODBC driver for it. Once installed, I “mounted” the db as a System DSN from which I try to import to my online MySQL database. As I said, I went back to 4.07 and when I try it manually everything works well. When you asked me for a backup file, I simply sent you a backup I made from SQLyog containing the data that I had previously imported manually using SQLyog (4.07) ODBC import feature. Did I do something wrong?

    • July 14, 2005 at 4:06 pm #18619
      Ritesh
      Member
      Quote:
      I use an accounting software which uses his own database system but they sell an ODBC driver for it. Once installed, I “mounted” the db as a System DSN from

      I wanted a backup of your original database so that we could reproduce the same environment at our end. Is it possible to send the data file with the ODBC driver?

    • July 14, 2005 at 7:14 pm #18620
      ekred
      Member

      I'm not really sure how I would do that. The only way I know to access the data is by using another application like MS Access or Excel. Is there a straightforward way to do this that apply to any odbc dsn?

      And as for the odbc driver would it really be of any use if you dont have the program and its database installed?

    • July 14, 2005 at 7:44 pm #18621
      peterlaursen
      Participant
      Quote:
      I use an accounting software which uses his own database system but they sell an ODBC driver for it. Once installed, I “mounted” the db as a System DSN from

      It could very well be running over this database:

      http://www.dataaccess.com/home.asp?

      http://www.dataaccess.com/normal.asp?pageid=793

      The DATAFLEX (various versions) software is widely used for that sort of applcations!

      If it is, then it is quite funny. I did a lot of programming with in (1st generation of it) 20 years ago!

    • July 14, 2005 at 8:06 pm #18622
      ekred
      Member

      Thanks for the info peterlaursen but unfortunetly it doesn't seems to be the case for my software 🙁

    • July 14, 2005 at 8:11 pm #18623
      peterlaursen
      Participant

      @eked

      OK then – probably you know better!

      But I really doubt whether this Database underlying your accounting application is not some “branded” standard software. Who would write a complete DB-engine for just one application ??

      I believe Ritesh will need the information of your software (where you got it from etc.).

      The supplier and producer of this software should be as interested as Ritesh to have any connectivity issues fixed!

    • July 15, 2005 at 2:52 am #18624
      Ritesh
      Member
      peterlaursen wrote on Jul 14 2005, 08:11 PM:
      @eked

      OK then – probably you know better!

      But I really doubt whether this Database underlying your accounting application is not some “branded” standard software.  Who would write a complete DB-engine for just one application ??

      I believe Ritesh will need the information of your software (where you got it from etc.).  

      The supplier and producer of this software should be as interested as Ritesh to have any connectivity issues fixed!

      I would really be interested in knowing the software and the underlying DB. There must be a way to take backup of the data.

    • July 15, 2005 at 8:20 am #18625
      Ritesh
      Member

      BTW, which OS are you using?

    • July 15, 2005 at 12:53 pm #18626
      ekred
      Member

      Ok the software I use is called Acomba (www.fortune1000group.com) and I'm running Windows 2000 with SP4. The problem with this company is that they are selling technical support so their website contains close to no information at all. I made some research on the net but can't find what engine its using. I contacted them by email and I'm waiting for a reply. I'll keep you informed…

    • July 15, 2005 at 1:34 pm #18627
      Ritesh
      Member

      Just ask them where the data file is stored and how can we take backups of it. Once we have the data file, making an ODBC connection to it wont be a problem.

  • Author
    Posts
Viewing 13 reply threads
  • You must be logged in to reply to this topic.