RM Studio 9.5.001 - New Connection SQL Server - tables not showing
I just got a new win10 rebuild and installed RM 9.5.001 -- I went to add my new connection (vs the old legacy method) to a 2017 SQL Server. I connected with following URL
(Note - I replaced my real server and db name in string)
jdbc:sqlserver://SQLSERVER:1433;databaseName=MYDBNAME;integratedSecurity=true
I have a Local Repository-->Connection-->MYSQLServer_Connection - I can pass the TEST CONNECTION and I am able to +Import a data table.
In my prior version of RM Studio, I was able to use down arrow on the DBName to see all my tables and then access them via retrieve. When I pull in the retrieve operator now, I just see the MYSQLServer_Connection and no way to get to the data.
I assume I am not using the right driver or something -- PLEASE HELP.
thanks...litia
(Note - I replaced my real server and db name in string)
jdbc:sqlserver://SQLSERVER:1433;databaseName=MYDBNAME;integratedSecurity=true
I have a Local Repository-->Connection-->MYSQLServer_Connection - I can pass the TEST CONNECTION and I am able to +Import a data table.
In my prior version of RM Studio, I was able to use down arrow on the DBName to see all my tables and then access them via retrieve. When I pull in the retrieve operator now, I just see the MYSQLServer_Connection and no way to get to the data.
I assume I am not using the right driver or something -- PLEASE HELP.
thanks...litia