Odbc Data Adapter Issue

[JesseH]

When I try to connect to AS400 using the Data Adapter Wizard - ODBC DataAdapter selection. I am able to see the ODBC connection. This is used for MSAccess and it works. When I select it, I get -

"Unable to connect to database. It is only possible to connect to SQL Desktop Engine databases and Microft Access databases with this version of Visual Studio".

Am I doing something wrong in the selection process? I have the latest update that is available. I did not know there were other "versions".

Any ideas.

Thanks in advance for the help.

 

[DavidT_macktool]

This link may help you.

http://www.connectionstrings.com/

 

[TechGnome]

Don't use the wizard... that's what's wrong... the wizard only allows for connections to certain DB types. That's what that error msg means. But, if you do it through code, then you'll be able to connect to anything you want. If you look in my sig, there's a couple of ADO.NET tutorials... they're done for SQL Server and so use the SQLDataAdapter... but the prinicples are the same.

-tg