Michael Buller
01/28/2022, 4:28 PM"Could not find stored procedure 'Case-Clinical.dbo.usp_ProviderSearch'.
I run the query on the database, everything is fine. I run it using prisma and I get that error message. I logged into the database using same user as prisma uses.
// let results = await this.data.$queryRaw<ProviderSearch[]>`exec [dbo].usp_ProviderSearch
// @Search = ${input.search} ,
// @City = ${input.city} ,
// @PostalCode = ${input.postalCode} ,
// @Specialty = ${input.specialty} ,
// @Rating = ${input.rating} ,
// @Latitude = ${input.latitude} ,
// @Longitude = ${input.longitude} ,
// @DistanceMiles = ${input.distanceMiles}
// `
let results = await this.data.$queryRawUnsafe<ProviderSearch[]>(`exec [Case-Clinical].[dbo].usp_ProviderSearch`)