Recieving ERROR [HY024]

Question

User1012473103 posted

I am trying to create a simple database and I have getting an error "ERROR [HY024][Microsoft][ODBC Microsoft Access Driver]'(unknown)' is not a valid path.  I have created a data connection in the server explorer with a datasource of "Microsoft ODBC Data Source (ODBC)" and then I build my string.  I have done the same for my data set and I have added a OleDBDataAdapter that also goes to my access file.  Everything works fine on my computer but when I install it on another computer I get the error.

 I am not sure if I am doing this correct or if there is an easier way to create a database let me know....  Any help would be appreciated.

Answer 1

User-1344880287 posted
i think if you create DNS for your database then your problem may get solved

Answer 2

User1012473103 posted

I am not sure what you a talking about... I think I may have created that when I created my string.  When I first create the datasource in the server explorer, choose Microsoft ODBC data source and then I click on connection string and build my string.  I choose the microsoft access driver and that creates a DSN file.  I am not sure if that is the correct way or not... If you are going to create a database what steps do you take to get it started?

Answer 3

User-1506829456 posted

Hi,

That is a correct way to create a DSN. However, when we move to another machine, the DSN doesn't go with your program. It lies in the windows registry. We will have to create a DSN on the new machine.

You can go to Control Panel/Administrative Tools/Data Sources(ODBC) to create it.

Here is a KB article about how to create DSN in Windows 2000. It's the same to do this on an Xp or 2003 system.

http://support.microsoft.com/kb/300596/en-us

HTH. If this does not answer you question, please feel free to mark it as Not Answered and post your reply. Thanks!