mysql - 使用 SQLProvider 时出现 "CreateSemaphore"错误

Question

module test = 

  let [<Literal>] resolutionPath = __SOURCE_DIRECTORY__ + @"/../packages/SQLProvider/lib/"
  let [<Literal>] connectionString = "Data Source=localhost"
  type sql = SqlDataProvider< 
              ConnectionString = connectionString,
              DatabaseVendor = Common.DatabaseProviderTypes.MYSQL,
              ResolutionPath = resolutionPath,
              IndividualsAmount = 1000, 
              UseOptionTypes = true>

这是我得到的确切错误信息

The type provider 'FSharp.Data.SqlTypeProvider' reported an error: CreateSemaphore (FS3003)

不确定从这里做什么，任何建议将不胜感激!

Answer 1

此错误来自 MySQL 而不是类型提供程序。我认为您的连接字符串不是 MySQL 连接字符串。试试这个:

let [<Literal>] connectionString = @"server=localhost;database=myDatabase;uid=root;pwd=..."

您也可以尝试添加 Owner-parameter 作为您的数据库名称。