Invalid object name 'syscomments' when connecting to SQL database in Azure

Question

I am trying to use the SqlDataConnection type provider to connect to a SQL database on Azure.

type dbSchema = SqlDataConnection<"Server=tcp:123456.database.windows.net,1433;Database={database};User ID={user};Password={password};Trusted_Connection=False;Encrypt=True;Connection Timeout=30;">

When I try to connect to the database with the associated connection string I get the following error:

Invalid object name 'syscomments'.

I cannot seem to find a solution to this problem other that using a different method to connect to the database (such as FSharp.Data.SqlClient). I believe this is related to the Azure implementation of Sql Server however I am unable to find any information on how to solve this problem. Any help is much appreciated.

Answer 1

I was having the same problem with the Microsoft Sql Type Provider. I started using this Sql Type Provider to better results: http://fsprojects.github.io/SQLProvider/

Thanks to Ross McKinley for pointing me to it.