4.1 BETA 2 Scheduled ODBC Import Crash

[ekred]

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

[Ritesh]

Which database you are trying to import from?

Can you mail me backup of the database?

[ekred]

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

[Ritesh]

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?

[ekred]

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?

[Ritesh]

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?

[ekred]

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?

[peterlaursen]

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!

[ekred]

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

[peterlaursen]

@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!

[Ritesh]

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.

[Ritesh]

BTW, which OS are you using?

[ekred]

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…

[Ritesh]

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