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
Location=/usr1/kjain/States/Mass
Hope this helps...
Sorry, wrong print screen select ,
Tnks
Hi Alexandre,
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 ?
Tnks