ERROR Error parsing connection string Conversion error Inval

Question

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

Joël · Answer

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

Joël · Answer

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

Julius de Bruijn · Answer

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

Julius de Bruijn · Answer

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

Chip Clark · Answer

solved issue by adding trustServerCertificate=true