Thread: QODBC Database cannot be found

I am currently in the process of creating a custom set of financial statements in excel using the data I pull from approximately 15 sets of quick books. I individually import the data for each company (3 columns, about 300 rows) using a Microsoft query. It allows me to successfully refresh once I establish the connection but after I shut down for the day and return the next morning, I'm prompted with "[Sybase][ODBC Driver][SQL Anywhere]Specified database not found" when I go to refresh. What do I need to do to prevent this? I'm really looking to run reports weekly with current data so it is important that I can just click refresh and all my connections will update. Thank you!

Update: It may be helpful to note that the quickbooks files are stored on a coworkers computer that is shared with our work network. Although I would like to try putting the quickbooks files on my computer, this is not feasible because several employees here must access the files.

From what you describe your are not using Microsoft Access and that it is Excel that is giving you the problem. Perhaps if you posted in the Excel Forum you would get a relevant responose.

In my experience ODBC links can be hard to maintain from one work session to another; and any iterruption in a connection will cause the link to be dropped. Were yours an Access issue I would suggest you use a VBA procedure to re-link to any ODBC source on start-up of your application.