ODBC Import – Edit a Saved Session

[rbma]

Trying to use this but SQLyog crashes everytime. A window appears with the folowing message “A crash has been detected by BlackBox…” along with other system information to report.

v4.1 beta 3

[Ritesh]

Can you attach the XML file that you are editing?

BTW, which source database are you using?

[rbma]

Ritesh wrote on Jul 21 2005, 06:55 PM:

Can you attach the XML file that you are editing?

BTW, which source database are you using?

[post=”6530″]<{POST_SNAPBACK}>[/post]

MS SQL

[Ritesh]

Bug confirmed.

It will be fixed in BETA 4.

[Ritesh]

http://www.webyog.com/forums/index.php?act…&st=0#entry6571

v4.1 BETA 4 fixes the above bug.

[rbma]

Now, we are getting the following error message:

'Error reading end tag.'

4.1 Beta 4

[Ritesh]

Very strange. I just opened the attached XML file in BETA 4 and it works OK.

Is your XML file generated by SQLyog GUI? Can you open it in IE?

[Ritesh]

SQLyog Enterprise v4.1 BETA 5

[rbma]

I successfully opened it. Added several tables and modified the SQL Where and resaved. Then got the above error message when trying to open it again.

This is what Thunderbird is displaying when opening the XML file.

y>no

[peterlaursen]

I find only length statements like

Quote:

10

which program did you use for editing ?

how does Notepad or another simple texteditor display the file ?

If it displays OK in Notepad, then try saving it from here.

[rbma]

peterlaursen wrote on Jul 28 2005, 05:03 PM:

which program did you use for editing ?

SQLyog

[rbma]

Started from scratch. The value in the 'SQL Where' doesn't show up when editing a saved session.

4.1 Beta 5

[rbma]

Also can't overwrite an existing saved session. Here is the error message.

Could not create JOB file.

32: The process cannot access the file because it is being used by another process

[peterlaursen]

Quote:

The value in the 'SQL Where' doesn't show up when editing a saved session

That's the same here with Beta5 – SQLWHERE does not show up in SQLyog GUI.

But if you edit XML-file in Notepad and execute it from commandline does it then work as it should ?

[rbma]

peterlaursen wrote on Jul 28 2005, 05:19 PM:

That's the same here with Beta5 – SQLWHERE does not show up in SQLyog GUI.

Will this be fixed?

peterlaursen wrote on Jul 28 2005, 05:19 PM:

But if you edit XML-file in Notepad and execute it from commandline does it then work as it should ?

Yes

[Ritesh]

This is awfully strange.

Something must have broken between BETA 3 and BETA 5.

[peterlaursen]

Quote:

Also can't overwrite an existing saved session.

I cant reproduce this problem! It works fine here!

there is not a SJA-process running in background (check taskmanager)

[rbma]

peterlaursen wrote on Jul 28 2005, 05:24 PM:

there is not a SJA-process running in background (check taskmanager)

This was it. Thanks.

[peterlaursen]

SQLyog GUI beta5 has a problem parsing/displaying a SQL_WHERE from an XML-file.

Is there more to it now? Or is it reduced to this?

[Ritesh]

It looks like a bug.

[peterlaursen]

@rbma

The failure to read SQL_WHERE is fixed in beta6.

You also had your select/unselect all request …

I think it would be nice if you confirmed the fix!

[rbma]

peterlaursen wrote on Jul 29 2005, 05:10 PM:

The failure to read SQL_WHERE is fixed in beta6.

It is fixed. Thank you!

peterlaursen wrote on Jul 29 2005, 05:10 PM:

You also had your select/unselect all request …

This is for???

[peterlaursen]

Am I wrong thinking that it was you that requested a select all/unselect all functionality in the ODBC wizard ?

[rbma]

peterlaursen wrote on Jul 29 2005, 05:37 PM:

Am I wrong thinking that it was you that requested a select all/unselect all functionality in the ODBC wizard ?

[post=”6620″]<{POST_SNAPBACK}>[/post]

Yes it was I but it was for to select/unselect fields in the Transform window.

[Ritesh]

This feature has NOT been added in BETA 6. We dont plan to add it in v4.1.

[rbma]

peterlaursen wrote on Jul 29 2005, 05:10 PM:

The failure to read SQL_WHERE is fixed in beta6.

Is there a limit on the number of characters? I have a long statement that is being truncated.

[Ritesh]

We dont have any known limits in SQL WHERE clause. Can you cut-n-paste the where clause?

[rbma]

Ritesh wrote on Jul 29 2005, 06:21 PM:

We dont have any known limits in SQL WHERE clause. Can you cut-n-paste the where clause?

Accounting=1 OR Billing=1 OR Collections=1 OR Computer_Office_Furniture=1 OR Computer_Hardware=1 OR Computer_Software=1 OR Computer_Support=1 OR Consulting=1 OR Office_Equipment=1 OR Radiographic_Equipment=1 OR Radiographic_Film=1 OR Financing_Lending=1 OR Medical_Business_Forms=1 OR Insurance=1 OR Investments=1 OR Financial_Management=1 OR Personal_Management=1 OR Professional_Staffing=1 OR Service_Bureau=1 OR Office_Supplies=1 OR Radiographic_Supplies=1 OR Benefit_Packages=1 OR Publisher=1 OR Marketing=1 OR Other_Desc!=''

[Ritesh]

I will check upon this tomorrow.

[Ritesh]

What happens if you manually put the where clause in the XML file?

[peterlaursen]

that is 530 characters!

[rbma]

Ritesh wrote on Jul 29 2005, 06:26 PM:

What happens if you manually put the where clause in the XML file?

[post=”6633″]<{POST_SNAPBACK}>[/post]

It is saved in the XML file but will be truncated when you edit it again.

[peterlaursen]

but it exexutes correctly from commandline ??

[rbma]

peterlaursen wrote on Jul 29 2005, 06:31 PM:

but it exexutes correctly from commandline ??

Yes.

[peterlaursen]

@rbma

beta7 is out

http://www.webyog.com/forums/index.php?sho…st=0&#entry6679

could you confirm that SQL_WHERE is not truncated any more on your system ?

[rbma]

peterlaursen wrote on Aug 2 2005, 01:09 PM:

could you confirm that SQL_WHERE is not truncated any more on your system ?

It is fixed. 😀

[Author]

Posts