MSSQL CRM error

[Itel628]

Hi
I have setup connection to customer MSSQL DB. When i run the test i get the error below entering the number only...if i put @number = 44XXXXX i get crm is working ok number does not exist, but the number is in the DB ???

 

[Evolute IT]

Hi
I have setup connection to customer MSSQL DB. When i run the test i get the error below entering the number only...if i put @number = 44XXXXX i get crm is working ok number does not exist, but the number is in the DB ???

Just enter a number only to test. Nothing else. No need to do @number = whatever.

As for the @number, make sure you're using the latest v18 .23 update. Before that variables for SQL were different.

 

[Itel628]

when i enter number only i get ,,, System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@number".

 

[Evolute IT]

when i enter number only i get ,,, System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@number".

The update.