hello everyone, I followed the tutorial and it did not work;
http://knowledgebase.progress.com/articles/Article/3409
Directory/File :
File (edited);
RUN(execute);
Anyone know what error,
Tanks,
Alexandre
Hi Alexandre,
Actually, the sample worked that way you configured it to work, but not perhaps as you wanted it to work.
Your syntax error from the last screen snapshot is correct, because the proper syntax is:
SHOW CATALOGS ALL
Now, if you wanted to connect multiple databases, then you should have configured your oesql.properties differently.
Here is the example taken directly from the documentation "OpenEdge® Data Management: SQL Development" page 171 :
[sql-configuration]
configuration-names-list=NortheastSales, ALBSales
[configuration.NortheastSales]
database-id-list=MA, NH
[database.MA]
Name=Mass
Catalog=Mass
Location=/usr1/kjain/States/Mass
[database.NH]
Name=NewHampshire
Catalog=NH
Location=/usr1/kjain/States/NewHamp
[configuration.ALBSales]
database-id-list=Ny, Ma1
[database.Ny]
Name= NewYork
Catalog=Lions
Location=/usr1/kjain/States/NewYork
[database.Ma1]
Name= Mass
Catalog=Bears
Hope this helps...
______________________________________________________There is a time to laugh and a time not to laugh, and this is not one of them.
Sorry, wrong print screen select ,
Tnks
I still don't see where is the error in your last post.
What are you trying to achieve ?
Have you tried configuration as I suggested in my previous post ?
Working!! Thanks for your help and patience Sasha !
Cya.
Morning,
ODBC has SUCESS on test,
On execute SQL, show me this error,
SELECT "denominacao","nat-operacao","emite-duplic","tipo" FROM PUB."natur-oper" WITH(NOLOCK)
Why ?