Hi!
I really need help here. I’ll try to be the more clear as i can!
The facts:
- IDE: Mac Xojo 2018r1.1 / Actual ODBC Drivers
- Compiled CGI LINUX 64Bit (the linux is a debian 8)
- MSSQL server 2003
LINUX and MSSQL SEVER 2003 are on the SAME network
ON MAC
From my mac, remotely, i CAN connect to MSSQL server 2003, using ODBC and ACTUAL drivers.
this is the connection:
dim db as new ODBCDatabase
db.DataSource="girassol"
db.UserName="alemac"
db.Password="xxxx"
if db.Connect then
// IT'S OK!!!
ON LINUX
root@S11:~# odbcinst -j
unixODBC 2.3.7
DRIVERS…: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES…: /etc/ODBCDataSources
USER DATA SOURCES…: /root/.odbc.ini
SQLULEN Size…: 8
SQLLEN Size…: 8
SQLSETPOSIROW Size.: 8
root@S11:~# odbcinst -q -d
[ODBC Driver 17 for SQL Server]
root@S11:~# odbcinst -q -s
[girassol]
and the “girassol” is inside “SYSTEM DATA SOURCES: /etc/odbc.ini”
#### #### #### #### #### #### #### #### ####
[girassol]
Driver = ODBC Driver 17 for SQL Server
Server = 192.168.2.6 // i’m on SAME network of MSSQL server 2003
Database = girassol
UID = alemac
PWD = xxxx
#### #### #### #### #### #### #### #### ####
On Linux on SAME network of MSSQL server 2003 if i execute:
- isql -v girassol alemac xxxx
±---------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
±--------------------------------+
i can connect to MSSQL server 2003
The problem is, i can’t figure out HOW to configure the project to do the CGI (on linux) connect to MSSQL (on same network)
What I KNOW:
- if i use this configuration:
db.Host="192.168.2.6"
db.DatabaseName="girassol"
db.UserName="alemac"
db.Password="xxx"
I can’t connect, that’s the message:
[iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded
- if i include:
db.DataSource="dsn=girassol"
- if i include:
db.DataSource="Driver={ODBC Driver 17 for SQL Server};"
- if i include:
db.DataSource="Driver={/etc/odbcinst.ini};"
error:[iODBC][Driver Manager]{/etc/odbcinst.ini}: cannot open shared object file: No such file or directory
or if
db.DataSource="Driver={/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.3.so.1.1};"
error:[iODBC][Driver Manager]{/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.3.so.1.1}: cannot open shared object file: No such file or directory
The application it’s 100% and this is the only fucking thing i don’t know how to fix!
Please, i really need help!
I’m sure someone on XOJO.inc can help not only me, but all Xojo users, just answering here and putting just a little more examples on documentation
Thank you all,
Alex