Forum Discussion
Waseem_22
5 years agoNew Member
DataSource Error in Connecting Azure Cosmos DB with Sql Statement
Hello,
I am trying to connect to Azure Cosmos DB by writing a sql statement, but I am unable to fetch the data.
It says Datasource error (Screenclip attached).
I am able to get the data with URL and Database name, ,But when I entering Sql Statement it is giving an error.
Can anyone please help me.
Regards,
Waseem
2 Replies
- amitchandak
Super User
Waseem_22 , with _ts it is giving an error. Can you check if that SQL is running directly on DB
- Waseem_22New Member
Thanks for replying amitchandak , I have created a sampleDB provided by CosmosDB, which created a table with just 4 rows, I am trying to write SQL Statement based on that.
I am writing a sql statement as
Select * From Persons where id = '61476e5d-ba88'.Even with this I am getting the same error as