i have a really problem with the button "Guess schema" of all database module.
When i click on the button, i have an empty widow "connection error" like this :
(is it in french because i'm french ^^)
I try with MySQL and AS/400 database in local server and of my company's server, doesn't work for both...
Can anyone know where it came from and how to fix it? especially since using a registered schema the query works, so it's not a user restriction...
How is the component configured, using context variable or not?
If so, remember that at design time, you cannot use context variables which are setted at runtime.
Replace variables by constant values and retry.
If not... share your component settings.
No, I don't use context variables, moreover I specify that yesterday everything worked correctly...
Here is a screenshot of my MySQL input component settings:
@Minos,can you cretate metadata for that table ,drag that table from metadata into job and change to Built in and keep the columns,which you want.
Can you try this?
Okey, i try in other computer of my company and it's work perfectly...
Finally I switched pc and it works... I don't know why \o/
Thanks, and if it starts again I'll try with the metadata