My project is Housing reservation system for University
I design the interfaces by VB and connect to my oracle data base account
Oracle 11g, VB express edition are used
The proble is with the login form
when I debug and enter the ID & password for User :
according to my code :
Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types Public Class Login_Page Dim cn As OracleConnection Dim cmd As OracleCommand Private Sub Login_Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load End Sub Private Sub NameLabel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cn As New OracleConnection Dim connString As String = "User Id=08120168;Password=8080;Data Source=dell" cn = New OracleConnection(connString) Dim ser = CInt(NameTextBox.Text) Dim pw = PasswordTextBox.Text cn.Open() cmd = New OracleCommand("SELECT * FROM LOGIN_STUDENT WHERE USER_ID like '%" & ser & "' AND PASSWORD like '%" & pw & "'", cn) Dim myreader As OracleDataReader = cmd.ExecuteReader() If (myreader.Read() = True) Then MessageBox.Show("The user is valid!") studentpage.Show() Else MessageBox.Show("Invalid username or password!") End If End Sub
it suppose to connect and show the messege:The user is valid
but it does not and a 'FileNotFoundException was unhandled'window appears and running stop and hang
** The same code had been tried in another computers which are 32 bit and work successfuly but in my computer(64 bit) not work.
** Is 32 bit or 64 bit affect ?
** What can i do to solve this problem?
** could any one help