Dotnetfx.exe does not work with DBConn.Open()!

[Al Repasky]

I have tried to get this to work for weeks. When I run my program on
my development computer, I find my Access DB file fine. When I
install the framework with dotnetfx.exe on another computer, when I
open the DB, it can not find the file or in other words it will not
work. It has got to be the dotnetfx.exe file and install. Because
when I run it on my development computer, where I did not us
dotnetfx.exe it works.

I have tried this install of dotnetfx.exe on now 2 different systems.
The first was a Win98. Thinking it was the operating system, I
installed it on a Win2000 computer. It does not work on either. So
Microsoft must have something wrong in dotnetfx.exe.

The code is:


Dim str As String
Dim int As Integer
Dim Adapt1 As OleDb.OleDbDataAdapter

'Create SQL Statement
str = "SELECT tYear FROM tAutos GROUP BY tYear ORDER BY tYear"

'Load table
Adapt1 = New OleDb.OleDbDataAdapter(str, DBConn)
Try
DBConn.Open()
Catch
MessageBox.Show("Database file can not be found.")
MessageBox.Show(DBConn.DataSource)
Application.Exit()
End Try

Is there a fix for this?

Thanks,
riprip

 

[David Williams , VB.NET MVP]

I rather doubt that there is a problem in the Framework (which is what
dotnetfix.exe installs). It sounds like you need to install MDAC 2.6
also. Be sure to 2.6 not 2.7+ as 2.7+ does not include the Jet engine
which you will need for Access. (At least that is the way that I read
it.)

HTH

David

 

[Nick Malik]

I agree with David... your problem is more likely that you do not have a
good version of MDAC installed, not that the framework is buggy.

--- Nick

 

[riprip]

David and Nick,

Thanks, that was the problem. I downloaded MDAC 2.8 and now it finds
the DB file fine. I now have to find a run time version of Crystal
Reports so that my report runs. Any ideas?