LeonelSanchezJr
Programmer
I am trying to get the SYNTAX to perform a DIRECT MS SQL PASS thru as such:
REMOTE DEST = WIN2000
-REMOTE BEGIN
SET SQLENGINE=SQLMSS
SQL SQLMSS SET USER EGLSMSQL06/username,password
SQL SQLMSS
SELECT *
FROM PROFILEZONES
;
-REMOTE END
But I get the following ERROR:
(FOC1488) SQL INTERFACE IS NOT INSTALLED
: Subphysical interface not found for SUFFIX=SQLMSS . Module name: ODBPINT
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1479) ERROR CONNECTING TO SQL DATABASE
Thanks,
Leo ;-)
REMOTE DEST = WIN2000
-REMOTE BEGIN
SET SQLENGINE=SQLMSS
SQL SQLMSS SET USER EGLSMSQL06/username,password
SQL SQLMSS
SELECT *
FROM PROFILEZONES
;
-REMOTE END
But I get the following ERROR:
(FOC1488) SQL INTERFACE IS NOT INSTALLED
: Subphysical interface not found for SUFFIX=SQLMSS . Module name: ODBPINT
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1479) ERROR CONNECTING TO SQL DATABASE
Thanks,
Leo ;-)