Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB.NET 1.0 > VB.NET 2002/2003 Basics
Password Reminder
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
VB.NET 2002/2003 Basics For coders who are new to Visual Basic, working in .NET versions 2002 or 2003 (1.0 and 1.1).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB.NET 2002/2003 Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 19th, 2003, 01:43 AM
Registered User
Join Date: Jun 2003
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connecting to AS400 via ODBC

I am using the IBM AS400 OLE DB Provider, and when setting up the data link properties I am able test the connection successfully when creating it, however if I then go and try to browse the tables, views etc under the data connection, in the server explorer I simply get a Connection Failure message.

Can anyone offer any advice on how I should go about connecting to the AS400 box through vb.net ??

Reply With Quote
  #2 (permalink)  
Old January 3rd, 2005, 07:43 AM
Authorized User
Join Date: Jan 2005
Location: , , .
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts

I have just now seen your query, it's very much same what I would like to learn.

If you have already got the solution, please send me the guideline (sample VB code, preferably VBA(Excel)-equivalent code if possible) on my email address amjad.s.mahmood@gsk.com


Amjad Mahmood

My query is as follows:

I urgently need help in automating data download from As400 and upload in my Excel-VBA-based Application.

On my PC I have the IBM Client Access which I use to logon to BPCS v.6.4.2

I know the library & Files/Tables names and field names.

Can you please provide me with a sample VBA with SQL (and Reference & connection setup syntaxes) so that I know the basic steps which are required to achieve the objective of connectivity and retrieval of data.

Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Not redirecting after connecting to odbc msacess sairaju_naidu2002 Beginning PHP 1 August 17th, 2005 02:46 PM
ODBC - insert on a linked field - [microsoft][ODBC chimp MySQL 0 April 7th, 2005 04:44 AM
IBM AS400 + VB - retrieving AS400 file definitions gattsi Pro VB Databases 1 July 23rd, 2004 12:55 PM
OleDb.Net vs. ODBC.Net for Connecting to Oracle cjo ASP.NET 1.0 and 1.1 Professional 3 January 13th, 2004 07:18 PM
OleDb.Net vs. ODBC.Net for Connecting to Oracle cjo ASP.NET 1.0 and 1.1 Basics 1 December 23rd, 2003 10:56 AM

All times are GMT -4. The time now is 02:33 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.