Data source name not found error 
Author Message
 Data source name not found error

I have just recently upgraded my odbc driver connecting to
a Progress db.

After installing the new driver, queries created in Excel
will not talk to the database. Get the error: "Data source
name not found...". I have created an entry with the same
name in my File DSN and System DSN, but Excel just will
not 'see' the new driver.

How can I make Excel recognize the new odbc driver?

(We are using a DataDirect 4.0 driver)

Thanks!



Fri, 01 Jul 2005 21:36:39 GMT
 Data source name not found error

Hi Boris,

The previous queries may have taken note of the actual Driver Details
as created in the registry, specifically the actual dll name.  This
could be a possible cause.

Also if the driver was installed as a user, you may not have installed
the Driver to the system registry although should be a bit far fetched
as most installation require some form of administrator privileges to
install under windows.

Then again, under Excel when making a connection to ODBC, there is a
setting in the Options button to "Include registry DSN's ..." ensure
that this is checked.

I do suspect more so the first then third options...

Hope this helps... even if just a little

BR

John
OpenLink Software
http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers

Quote:

> I have just recently upgraded my odbc driver connecting to
> a Progress db.

> After installing the new driver, queries created in Excel
> will not talk to the database. Get the error: "Data source
> name not found...". I have created an entry with the same
> name in my File DSN and System DSN, but Excel just will
> not 'see' the new driver.

> How can I make Excel recognize the new odbc driver?

> (We are using a DataDirect 4.0 driver)

> Thanks!



Mon, 04 Jul 2005 01:38:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Data source name not found error

2. Data Source Name not found error

3. ODBC Connection error - Data Source Name not found and no default server specified

4. Error perfoming query: Data source name not found...

5. Error 80004005: Data source name not found and no default driver specified

6. Error: Data source name not found...

7. Data Source Name not found and no default driver specified error

8. Data Source Name not found and no default driver specified

9. Data source name not found and no default driver specified

10. [ODBC Driver Manager] Data source name not found

11. Data source name not found and no default driver specified

12. Data Source name not found : Interdev Project


 
Powered by phpBB® Forum Software