win7 - data source name not found and no default driver specified

[rsymonds]

I just loaded up a Win7 64 bit machine and installed the Macola Progression Client. When I attempt to run System Manager I receive the following message - "[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified"... I am running SQL 2005 SP3, Macola Progression 7.6.400B.

Any clues as to what's wrong here?

 

[dgillz]

Did you log nto progression explorer or progression workflow explorer?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[rsymonds]

pwe

 

[dgillz]

Well, 76400 is not suported on Windows 7. Is there some reason you do not upgrade?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[rsymonds]

there are many reasons I have not upgraded yet. I do have many WIN7 systems using Macola. This one is mine and I need System Manager on it. We will be upgrading to the latest version in about 6 weeks. (after our year end) It is unfortunate that we have not upgraded in a while but my hands have been tied.

 

[dgillz]

Yet you have other Win 7 workstations using 76400? Am I correct?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[rsymonds]

yes, turn off UAC on win7 systems and Macola runs with no issues - except SM.

 

[crystalreporting]

What are you running in System Manager that is giving you this error? I'm betting earlier versions of Macola were not smart enough to recognize 32 bit versus 64 bit ODBC drivers...

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com

 

[dgillz]

If you are trying to run visual menu builder, this requires the full SQL tools - SQL management studio or Enterprise manager. If you are doing something else, please tell us what it is and give us the detail of the error message.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[rsymonds]

I goto Visual Menu Builder | Connect| and get a pop up error message - "[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified"...

 

[dgillz]

But the rest of System Manager works OK?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[rsymonds]

yes, the rest of SM works...

 

[dgillz]

Do you have the full SQL client installed on this machine? This is required for Visual Menu Builder.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[rsymonds]

yes, I did the full client install

 

[dgillz]

SQL Client, not Macola client. Are we on the same page?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[crystalreporting]

It could be that the DMO components aren't there - VMB requires SQL DMO. This is an optional component of SQL2005 and not shipped at all with SQL2008. Check the Exact portal for more info. on SQL DMO.

I'd still compare the ODBC datasources in the 64bit and 32bit ODBC administrators (Windows/SysWow64 for the 32 bit administrator).

Of course, it might just be easier to upgrade Progression....



Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com

 

[rsymonds]

yes, sql client... I am backed into a corner on the upgrades here... we are heavily customized and i have to get Exact programmers involved and also have to upgrade all my clients. I really need to get everything moved and 100% on a new server prior to the upgrade process. Additionally we run Sharepoint databases on the server and do a large amount of SQL reporting. I really need to get SM running on my workstation prior to all this.