Chip Clark

02/11/2021, 5:26 PM
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")   }


02/12/2021, 7:53 AM
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?

Julius de Bruijn

02/12/2021, 7:58 AM
it's either a bug in the
crate we created in https://github.com/prisma/connection-string or you have a faulty connection string, missing escaping etc.
😛lus-one-+1: 1
did you check if any of the values have characters such as
and so on, you can wrap the whole value into
so all of the characters in value will be escaped
💯 1

Chip Clark

03/22/2021, 5:48 PM
solved issue by adding: trustServerCertificate=true;
👍 1