Could not find Installable ISAM - asp .net

I am getting this error.  I looked at a previous question with an "answer" but it did not help. I've tried what the microsoft site says but that didn't work either.  I must be just coding something  wrong.  Hopefully you folks can figure it out.

<script language="VB" runat="server" >
      sub Page_Load(Sender as Object, e as EventArgs)
            
'this is one line
dim objConn as new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
 & Data Source=c:\ASPNET\data\banking.mdb")
            
            
            dim objCmd as new OleDbDataAdapter("select * from tblUsers", objConn)
            
            
            dim ds as DataSet = new DataSet()
            objCmd.Fill(ds, "tblUsers")
            
            
            MyDataList.DataSource=ds.tables("tblUsers").DefaultView
            MyDataList.DataBind()
      end sub
            
</script>


I am doing the sams asp .net in 21 days and this is one of their examples.  I cannot get it to work.
oleg27Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
SlimshaneeyConnect With a Mentor Commented:
Note the ampersand...
0
 
SlimshaneeyCommented:
Try changing the connectio to this:
dim objConn as new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\ASPNET\data\banking.mdb")
0
 
oleg27Author Commented:
Um that is exactly what i have.
0
 
SlimshaneeyCommented:
Yours is:
Microsoft.Jet.OLEDB.4.0; & Data Source=c:\ASPNET\data\banking.mdb")
0
 
oleg27Author Commented:
I knew it was going to be something stupid. Of course i left that & in because in the text it is actually on two lines, hence the connector. Cripes.  Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.