Open - Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another

• HelpMeInOhio

  Hall of Fame

  Points: 3945

  More actions

  September 13, 2004 at 2:04 pm

  #86445

  oRecordset.open strSQL, oConnection

  Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

   

  Any idea what might cause this?

  strSQL hold an SQL I built as follows:

  Dim strSQL

   strSQL = "select AuthorizationNumber from REPRICE_AuthNumbers where AuthorizationNumber = " + DTSSource("Authorization#")

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 14, 2004 at 6:35 am

  #522940

  what's the return type of DTSSource("Authorization#")??

  if this is a string or a date you need to wrap it in quotation marks like this:

  strSQL = "select AuthorizationNumber from REPRICE_AuthNumbers where AuthorizationNumber = '" + DTSSource("Authorization#") + "'"

  if this isn't the problem, I would try to execute the DTSSource("Authorization#") alone to see if this is what throws the error.