Prisma

ERROR:  Error parsing connection string: Conversion error: Invalid JDBC token in ...

 `<sqlserver://SQLAM11>,4411;database=MDD_Test;user=app_user;password=Xx/Xx/Xx'

I get this error when running: npx prisma introspect

I do NOT get this error when running: npx prisma generate

schema.prisma:

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["microsoftSqlServer", "nativeTypes"]
}

datasource db {
  provider = "sqlserver"
  url      = env("DATABASE_URL")

  }

`prisma generate` does not validate the datasource url so that’s expected it works

your DATABASE_URL probably has something wrong in it? can you connect to the database using the same url with TablePlus for example?

it's either a bug in the `connection-string` crate we created in <https://github.com/prisma/connection-string> or you have a faulty connection string, missing escaping etc.

did you check if any of the values have characters such as `;` , `{` ,`}`,`[`,`]` and so on, you can wrap the whole value into `{value}` so all of the characters in value will be escaped

solved issue by adding:  trustServerCertificate=true;