Title
c

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")   }
j

Joël

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?
j

Julius de Bruijn

02/12/2021, 7:58 AM
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.
😛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
{value}
so all of the characters in value will be escaped
💯 1
c

Chip Clark

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