Notes on Convert 2 application

Copyright 2003 MiniSolve.com

This application requires ODBC drivers set up on your
local computer. You need one for Microsoft SQL server
and one for the AS/400 (we use two, so we have two ODBC drivers,
one for each.)

We use HIT software ODBC server, but you can use anything
that connects you to the AS/400, like Client Access ODBC

You'll need to go through the code and find
asfile= and sqlfile=

Change the parameters for the ODBC drivers, as in this example:

asfile = "[ODBC;DSN=MyODBCDevelop;uid=MyAS400Id;pwd=MyAS400Pwd;DATABASE="
MyODBCDevelop is the NAME of the ODBC driver
MyAS400ID is your As/400 ID
MyAs400Pwd is your password

DATABASE=" The program is going to append the library and file to this
string.

sqlfile = "[ODBC;DSN=MyODBCSqlServer;uid=sa;pwd=MySaPwd;DATABASE=MySQLDB]." + Text1.Text
DSN is your ODBC driver. uid is sa in this case, but could be your id also
pwd = the password
MySQLDB is the name of the SQL data base, like Northwind or Pubs, or your
production data base.

This program will work in VB5 or VB6. 
It uses OLE Automation in your project references,
Microsoft DAO 2.5/3.51 Compatibility Library
and Microsoft ActiveX Data Objects Library 2.5

Minisolve makes no warranties express or implied that this application will
work for you. This program is freeware and you can use it or modify it
as you like.