Search found 3 matches

by NikosM
4 years ago
Forum: Tools
Topic: Error Embedded Python Code - sqlalchemy
Replies: 1
Views: 4014

Error Embedded Python Code - sqlalchemy

Hello, I am trying to retrieve data from a database table using sqlalchemy Set sec sectors ; $onEmbeddedCode Python: import sqlalchemy import pandas as pd from sqlalchemy import create_engine engine = create_engine('mssql://LAPTOP-HdfDNQL8E4/POLIFOLIO_DB?driver=SQL+Server+Native+Client+11.0?trusted_...
by NikosM
4 years ago
Forum: Wishes
Topic: Support SQL2gms for Unix version
Replies: 1
Views: 7260

Support SQL2gms for Unix version

Would it be possible to add support for sql2gms tool in a future unix release? It is almost impossible to connect with an sql database in a unix environment.
I have to use unix because i need to setup a r-shiny server and it is only feasible in unix (without large costs).
by NikosM
4 years ago
Forum: Tools
Topic: GAMS Ubuntu
Replies: 1
Views: 2938

GAMS Ubuntu

Hi, I have installed GAMS for windows in Ubuntu via wine because in unix version the sql2gms tool does not work and I need it in order to upload data from an sql server database. Unfortunately although I have installed it successfully, when I am trying to run my code it shows an error when trying to...