We help IT Professionals succeed at work.

Problem opening dBase Driver connection in asp.net

Medium Priority
865 Views
Last Modified: 2013-11-29
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?
Comment
Watch Question

Author

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.
Can you post the part of the code that gives the error?

Author

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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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.

Author

Commented:
For others that are looking here is the solution for ASP.net
http://support.microsoft.com/default.aspx/kb/894435
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.