Another AS400 connectivity question, PLease Help

[techmanbd]

Ok here is my situation. I have an AS400 database I am trying to connect to. If I use in "TOOLS" - CONNECT TO DATABASE it shows for provider IBM AS400 OLE DB Provider. Then I goto connection and for my DATA SOURCE I put in \\nameofdatabase\nameoffilearea and then insert the username for this file and password and I get this error message when I test connection

"Test connection failed becauase of an error in initializing provider. Unspecified error"

Any ideas what this means and a resolution?

 

I have a 2nd one. I tried a different connection which I red from redbook. I used for provider Microsoft OLE DB Prvider for ODBC Drivers. then on the connection I use connection string which when I build I get the built string to the database I am using. Then I test connection and it is successful. t hen I click ok and get the following message

"Unable to connect to database, It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databses with this version of Visual Studio"

Any ideas what this one means and a resolution?

 

Thanks

[techmanbd]

OK I found my problem. I used the odbc connection, but have to hard code it into the program, Can't use the TOOL / CONNECT TO DATABASE Edited November 20, 2003 by techmanbd