hello my friends.
I have a suuuuuper weird question about sql server, at my work we are about to migrate our database from a windows server to an Azure server , currently we use toad for oracle to do our query's and stuff when the new azure server comes we also will change from toad to sql server , so im trying to connect sql server to one of our database in our current windows server, i have created the connection using odbc data source admin and the connection is successful, but when i try to open a table or something an error message saying:
Then a co-worker told me i have to check with a query the connection between my new linked server which if i click in test connection it says the test connection to the linked server succeeded
and sql server, so i checked how the connections query's are checked in our oracle toad database and it says this:
my question here is how to write that but in sql server ??? , i hope mi previous explanation helps to understand what my question is XD it looks kinda confusing but i wanted to give it a try, or if you know how to fix that error message i would highly appreciate
Thanks a lot if you are able to answer.