forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › 4.1 BETA 2 Scheduled ODBC Import Crash
- This topic is empty.
-
AuthorPosts
-
-
July 14, 2005 at 1:15 pm #9107
ekred
MemberI 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
MemberWhich database you are trying to import from?
Can you mail me backup of the database?
-
July 14, 2005 at 2:04 pm #18616
ekred
MemberWow, prompt response! Thanks! I just sent you an email with my backup attached to it.
-
July 14, 2005 at 3:21 pm #18617
Ritesh
MemberThanks. 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
MemberHmmm 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
MemberQuote: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 fromI 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
MemberI'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
ParticipantQuote: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 fromIt 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
MemberThanks 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
Memberpeterlaursen wrote on Jul 14 2005, 08:11 PM:@ekedOK 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
MemberBTW, which OS are you using?
-
July 15, 2005 at 12:53 pm #18626
ekred
MemberOk 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
MemberJust 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.
-
-
AuthorPosts
- You must be logged in to reply to this topic.