EnviroInsite Forum

Members Login
Username 
 
Password 
    Remember Me  
Post Info TOPIC: error loading data: dt_db.OpenOdbcConnection ... ERROR [IM002]...


Senior Member

Status: Offline
Posts: 271
Date:
error loading data: dt_db.OpenOdbcConnection ... ERROR [IM002]...
Permalink  
 


I get this error when I try to connect to an Excel data file.

dt_db.OpenOdbcConnection

Provider=MSDASQL;Driver=[Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm,

*.xlsb)); DBq=C:\Users\Tom\Documents\My EnviroInsite

Work\Tutorial\site1.xls;ReadOnly=False;

Error[IM002][Microsoft][ODBC Driver Manager] Data Souirce name not found

and no default driver specified



__________________


Senior Member

Status: Offline
Posts: 271
Date:
Permalink  
 

It’s likely one of two things.

(1) You don’t have MS Office on your computer, in which case you should install the MS Access Database Engine 2010 Redistributable. Here’s a link: http://www.microsoft.com/en-us/download/details.aspx?id=13255 

(2) You have MS Office installed, but installed the 32-bit version. If that’s the case then uninstall EnviroInsite and install the 32-bit version. This happens all the time, where people think they have the 64-bit version of MS Office, but it turns out not to be the case.

Bruce Jacobs
bjacobs@enviroinsite.com



__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.



Create your own FREE Forum
Report Abuse
Powered by ActiveBoard