ODBC Connectivity

[amy88]

Hi!

I have written a small VFP6.0 program to extract some info to an Excel file per request of a vendor. I generated an executable file so that it could be easily used on a couple of other computers at my company.
This .exe works fine on one computer, but on a second one it doesn't. It gives me a connectivity error:

Connectivity Error [Microsoft][ODBC Manager] Data source name not found and no default driver specified.

As far as I can tell, the ODBC settings are the same on both computers. Does anybody have any suggestions?

 

[Mike Lewis]

You say the ODBC settings are the same. Are you using a DSN or a connection string? If a DSN, is it physically present on all the PCs? Is it a System DSN (which is sharable, as opposed to a user DSN which is not)?

Perhaps you could provide more details of your setup. You might also paste a copy of the DSN or connection string here.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[amy88]

Thanks,

Based on what you said, I took a closer look at the DSN configuration and discovered a slight difference in the data source name. The computer where the prog was not running had an inappropriate <space> in the data source name. The <space> was not in the data source name on other computers. So when the prog ran on the computer with the <space>, it didn't recognize it.

Obviously, I didn't see the <space> when I made the first comparison of the ODBC setup.