Problem using code to access external data
Posted: Wed Mar 28, 2018 4:30 am
This VAR declaration to access data in sql server 2016 worked as expected in Rel v3.004 but does not work with v3.010 or v3.011:
It returns the error:
In both v3.010 and v3.011 with the (New variable) Choose the kind of variable you wish to create window,
entering in the connection string and other information leads to a successful outcome.
Interestingly, the text for attribute Definition in sys.DefinitioinHistory after the above executes
is the same as the variable declaration except for the implied AUTOKEY at the end of the string.
It would be convenient if the var definition also worked.
Also I could never get the driver for sql server in Accessing External Data Sources, jdbc:sqlserver, to
work. Entering in the following connection string:
"jdbc:sqlserver://localhost:1433;databaseName=JUDYDB1" and the other information leads to the error:
Only the jdbc:jtds:sqlserver driver seems to work with sql server.
thanks
Code: Select all
VAR TEST4 EXTERNAL JDBC "jdbc:jtds:sqlserver://localhost:1433;databaseName=JUDYDB1,**,********,TEST1";
Code: Select all
ERROR: Encountered "VAR" at line 12, column 1.
Was expecting one of:
"BEGIN" ...
"TCLOSE" ...
<TUPLE> ...
"WITH" ...
<TUPLE> ...
entering in the connection string and other information leads to a successful outcome.
Interestingly, the text for attribute Definition in sys.DefinitioinHistory after the above executes
is the same as the variable declaration except for the implied AUTOKEY at the end of the string.
It would be convenient if the var definition also worked.
Also I could never get the driver for sql server in Accessing External Data Sources, jdbc:sqlserver, to
work. Entering in the following connection string:
"jdbc:sqlserver://localhost:1433;databaseName=JUDYDB1" and the other information leads to the error:
Code: Select all
ERROR: RS0450: EXTERNAL relvar definition failed due to: org.reldb.rel.exceptions.ExceptionSemantic:
EX0016: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:1433;databaseName=JUDYDB1.
Drivers available: oracle.jdbc.OracleDriver, org.postgresql.Driver, net.sourceforge.jtds.jdbc.Driver,
org.mariadb.jdbc.Driver
thanks