SQLGetEnvAttr Crystal Reports

[cfriedberg2]

I have created a Crystal Report using CR Developer 9 on an offsite computer. I am trying to move it to another computer that uses CR Standard 9. The underlying data are Visual FoxPro 6.0 free tables. The connectivity is through an ODBC driver that we just downloaded and installed from Microsoft. I also included a file that was placed in the Windows System Folder named vfp6int.exe that was suggested by MS.

The problem happens when I try to transfer the offsite created report to another computer. The report uses a command statement. When trying to set a new location for the date I get and error message "Login failed", followed by "Query Engine Error:'01000:[Microsoft]ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLGetEnvAttr).'"

Now what? Even using SQLGetEnvAttr is a mystery to me.

Does anyone have an answer? I need help.

Carolyn

 

[synapsevampire]

Crystal standard doesn't support ODBC, so that is likely the issue.

If you have CR developer, you can compile the report in VB or some such and distribute that.

-k