MS NT4.0 using IIS and CA/400 ODBC

[KirkG@xxxxxxxxxxxxxx]

I'm trying to get MS Internet Information Server, FTP Server to log to the 
400 via ODBC. 
Here's what I have done:

On the NT box
CA/400 Express 4.4 with SF60796
I've installed IIS 4.0
Setup FTP to use ODBC logging to the file on the AS/400
NT SP 5 and then 6a (with no change)
Installed Excel 97

On the AS/400 with are at 4.4.0 cum C0147440 and DB Group SF99104-09 and 
hypers from a few weeks ago.

With Excel I can use the "GET EXTERNAL DATA" and the retrieve the empty 
file with column name etc.

When I start the logging I can see via the Trace function that I'm getting 
to the file but it says it can't find  the 1st column. the error is a 
SQL0206

Has anyone be able to get IIS ODBC logging to work to the 400 with CA/400 
Express ODBC?




 

---------------------------------
Kirk Goins
IBM Certified AS/400 Technical Solutions
Pacific Information Systems - An IBM Premier Business Partner
503-290-2104              kirkg@pacinfosys.com
"WE KNOW TECHNOLOGY"
---------------------------------



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---