Questions on Convert.ToInt for ODBC Command

[jsscott]

I am using the code below (one of way too many samples) trying to accept strings from form and pass them to ODBC connect query. No matter which way I twist it, I always get a Format exception error.
I can not get the input string to accept the three parameters in the correct format.
Any ideas?

Private Sub btn_search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_search.Click

Dim p_tax_year As Integer = Convert.ToInt32(cbx_tax_year.SelectedText)
Dim p_taxpayer_doc_num As Integer = Convert.ToInt32(tb_taxpayer_document_nm.Text)
Dim p_taxpayer_ssn As Integer = Convert.ToInt32(tbx_taxpayer_ssn.Text)
Dim OdbcDataAdapter_all_forms_list As DataSet_all_forms_list
OdbcConnection2.Open()

Add Parameters and set values
listSelectCmd.Parameters.Clear()
listSelectCmd.Parameters.Add(p_tax_year)
listSelectCmd.Parameters.Add(p_taxpayer_doc_num)
listSelectCmd.Parameters.Add(p_taxpayer_ssn)

Dim DataSet_all_forms_list1 As DataSet = New DataSet
Dim TAXPAYER As DataTable = DataSet_all_forms_list1.Tables("TAXPAYER")
Try
listSelectCmd.ExecuteNonQuery()
Catch SqlExceptionErr As SyntaxErrorException
MessageBox.Show(SqlExceptionErr.Message)
End Try
OdbcConnection2.Close()
End Sub

 

[PlausiblyDamp]

What are the text values you are trying to convert to integers?

 

[jsscott]

What are the text values you are trying to convert to integers?

They are a year written as a four digit number, a social security number written as a nine digit number, or a document number written as an eleven digit number.
I kept them as numbers as that is our standard for these fields. I am using ODBC because this will eventually go against an oracle database (not the Access one I am testing against) and I do not want to have to rewrite everything.

I do not think the problem comes from the conversion or the fields themselves, I think it comes from the passing of the values to the parameters.
I can find no good documentation on how to do this for ODBC.