Hello Everyone:-) Quick question: Can I use Prism...
# orm-help
p
Hello Everyone:-) Quick question: Can I use Prisma with Azure Database for PostgreSQL server? Because if I formulate my connection string like this on my dev machine
""<postgresql://userName@PasswordWithEncodedSpecialCharacters@MyServer.postgres.database.azure.com:5432/DBName?schema=SomeSchema&connect_timeout=100>"
npx prisma migrate dev --name init
Fails with
Error: P1001: Can't reach database server at..
Maybe to clarify, I basically opened everything up to the outside from within Azure, and using my local SQL Admin Tool to connect to it from the same PC works like a charme..
✔️ 1
Well..after three hours of trying..;-) Just use the IP. Not sure if hyphens or sth were the reason (encoding them in the url did not help. Namen and PW special chars have to be encoded though!), but using the ip directly, it works:-) For future reference.. 🙂
1