where is the odbc created in a Win 7 x64 machine?

Question

Hi, 
 
 I'm running BW in a Win7 x46 machine without problem, I tried to create an ODBC with the "Create DSN Utility" and it seems that it did it, I seelected the company, double click on it and the connection was succesful. But when I click "Create DSN" nothing seems to happen, not sure if the DSN was created somewhere and I cannot find it or if it was not created al all. 
 Please help, 
 Thank, 
 Ignacio

imachin · Accepted Answer

I know, but I was not going to use it with Office but with a custom application I'm developing. As I did not see the ODBC listed I could not be sure that the create_odbc program worked or not.

Coleen Graber · Answer

Ignacio - If you are looking for more information regarding on Excel queries, please refer to resolution #18768 How to query a Sage BusinessWorks database using Microsoft Excel. Since we technically don't train in MS Excel and queries, if you have any additional questions regarding Excel queries, I would refer you to Microsoft support.

imachin · Answer

Hi, 
 
I found the issue, when running on a x64 machine the ODBC created is not listed, not even in Excel. I had to install BW in a x32 VM along with Office to be able to see the tables.

Fortunately enough the odbc even if it is not visible in the x64 machine it does work.

Coleen Graber · Answer

Ignacio - Although Sage BusinessWorks supports a 64-bit operating system like Windows 7, it does not support 64-bit Microsoft Office.

Sage BusinessWorks

where is the odbc created in a Win 7 x64 machine?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING