Member Avatar for yuenli
yuenli 0 Newbie Poster

Hi, I am trying to connect to sql server by using ADO to insert a record via stored procedure. I keep on encountering this error message (Source: Microsoft OLE DB Provider for SQL Server Description: The precision is invalid.)I had read on several blogs and forums and it said that one of the parameters which is adNumeric type need to define the numeric scale and precision during parameters append. May I know how to define the numeriv scale and precision value for adNumeric during parameters creation?

Thanks.

  • 1 Contributor
  • 0 Replies
  • 47 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.