Problem opening dBase Driver connection in asp.net

I am trying to test an ASP.net application on a windows vista 64bit machine when I get the following error when trying to open the connection:

ERROR [IM003] Specified driver could not be loaded due to system error  193 (Microsoft dBASE Driver (*.dbf)).

I believe this is something to do with Vista 64bit because I can get it to run on other machines but I need to test it from this vista machine. Any ideas on how to make the dbase driver work with Vista 64bit?
LVL 2
jmarbuttAsked:
Who is Participating?
 
jmarbuttAuthor Commented:
That was actually the first part of my question that I asked earlier in the day. I managed to get the ODBC driver to work when running the configuration program from the SysWOW64 folder but my problem now is I need to dynamically build the connection string in my app but I get this error.

So I guess I have been chasing this problem for a while and haven't come up with a good answer.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
CB_ThirumalaiCommented:
Can you post the part of the code that gives the error?
0
 
jmarbuttAuthor Commented:
The InFolder = "c:\temp" which has my dbf files.
  OdbcConnection1.ConnectionString = "Driver={Microsoft dBASE Driver (*.dbf)};Dbq=" + InFolder + ";"
 
        Try
            OdbcConnection1.Open()
        Catch ex As Exception
        End Try
        If OdbcConnection1.State = ConnectionState.Open Then
            Return True
        Else
            Return False
        End If

Open in new window

0
 
CB_ThirumalaiCommented:
0
 
jmarbuttAuthor Commented:
The answer for everyone else's benefit is to switch to 32bit under the advance configuration on the compile options.

This works but has caused some other minor issue with some 3rd party controls in my web application and I am researching that now.
0
 
jmarbuttAuthor Commented:
For others that are looking here is the solution for ASP.net
http://support.microsoft.com/default.aspx/kb/894435
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.