MS Access ODBC Import Failed

Steven Camitta

MS Access ODBC Import Failed
Just installed UDB ESE 8.1 on my desktop. Upgraded maintenance to fixpack
4. Local database functionality works fine. Used Configuration Assistant
to catalog the OS/390 datasource. Bound the dbrms. Able to see OS/390
tables from the development center.

Attempting to import data to MS Access using External Datasource.
Receiving error message

ODBC--call failed
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified (#0)

When I use Control Panel, ODBC Data Sources, system dsns appear OK and I
can connect from there. Driver tab looks OK too.

Any ideas on how to correct this?

Thanks,
Steve

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Scott Hodgin

Re: MS Access ODBC Import Failed
(in response to Steven Camitta)
Steve,

I'm going to be very interested in any answers you get on this. I recently
upgraded my Personal Edition to 8.1 and I am also having problems with
Access. At first, on one of my sub-systems, I was getting your 'Data source
name not found' error. I even got this in Excel. I reran the binds on that
sub-system and was able to get data loaded into Excel from my test and beta.
On Access, I get -7731 reserved error from both test and beta. I can also
get data from test and beta from a .NET web page running on my local
machine.

Scott Hodgin, Database Administrator
South Carolina Farm Bureau Insurance Company
[login to unmask email]

-----Original Message-----
From: Steven Camitta [mailto:[login to unmask email]
Sent: Tuesday, December 16, 2003 2:57 PM
To: [login to unmask email]
Subject: MS Access ODBC Import Failed

Just installed UDB ESE 8.1 on my desktop. Upgraded maintenance to fixpack
4. Local database functionality works fine. Used Configuration Assistant
to catalog the OS/390 datasource. Bound the dbrms. Able to see OS/390
tables from the development center.

Attempting to import data to MS Access using External Datasource.
Receiving error message

ODBC--call failed
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified (#0)

When I use Control Panel, ODBC Data Sources, system dsns appear OK and I
can connect from there. Driver tab looks OK too.

Any ideas on how to correct this?

Thanks,
Steve

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Brennan

Re: MS Access ODBC Import Failed
(in response to Scott Hodgin)
Have you tried applying the patches for ODBC problems?
Go into the Advanced CLI/ODBC settings.
Under the Services tab you can find the patches.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Scott Hodgin

Re: MS Access ODBC Import Failed
(in response to Mike Brennan)
I'm having similar Access import problems.

Where is the "Advanced CLI/ODBC" settings tab? In DB2 Connect somewhere?

Scott Hodgin, Database Administrator
South Carolina Farm Bureau Insurance Company
[login to unmask email]

-----Original Message-----
From: Mike [mailto:[login to unmask email]
Sent: Wednesday, December 17, 2003 4:49 PM
To: [login to unmask email]
Subject: Re: MS Access ODBC Import Failed

Have you tried applying the patches for ODBC problems?
Go into the Advanced CLI/ODBC settings.
Under the Services tab you can find the patches.

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Don Cross

Re: MS Access ODBC Import Failed
(in response to Scott Hodgin)
Settings are in Windows2000.Control Panel..Administration Tools(?)..ODBC
Data Sources.
Go into the latter ..find your driver..most likely IBM ODBC/CLI..etc..and
click on configure..
Don

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Brennan

Re: MS Access ODBC Import Failed
(in response to Don Cross)
Sorry I should have been more specific.
I'm assuming a Windows 2000 client here.
Go to Start>programs>IBM DB2>Client Configuration Assistant.
Highlight/select the database you'd like to configure.
Click on Properties to get to the CLI/ODBC box.
Click on Settings.
Click No.
Click on Advanced button.
Click on Services tab.

Then highlight the patches you wish to apply.
Mike

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm