ODBC using Visual Basic.

[peteh@xxxxxxxxxxxxxxxx (Pete Hall)]

>> is VB/Windows 95, CA95 and OS/400 V3R7. I've tried using the connect
statement but keep getting the connection failed message. In the
previous version (win 3.1) I had the same problem and used the SQLIBM
program to <<

Check out the May 1996 article from News/400, titled "ODBC and AS/400
Stored Procedures" by Paul Conte. It's decidedly 16 bit, but it should
be similar enough to help. He has a VB3 module for establishing AS/400
connections. I've used it with VB4, and it works fine. I've not
converted it to 32 bit, but I have converted several vb apps, and mostly
that's a matter of changing Ints to Longs. 

hth
Pete


--
 - Pete Hall peteh@earth.inwave.com
http://www.inwave.com/~peteh/

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *