the following worked
msconnstr='Driver={ODBC Driver 11 for SQL Server};Server=10.231.93.64,1434;Database=dev1;Uid=sa;Pwd=sa'
create virtualtable persons connstr msconnstr as select * from...
Type: Posts; User: Phjr
the following worked
msconnstr='Driver={ODBC Driver 11 for SQL Server};Server=10.231.93.64,1434;Database=dev1;Uid=sa;Pwd=sa'
create virtualtable persons connstr msconnstr as select * from...
Hi, can't yet define a virtual table connecting to a MS Sql Server DB
Defined in Windows a SQLDEV1 ODBC Data Source using "ODBC Driver 11 for SQL Server"
Tested successfully SQLDEV1 data source...