RE: Problems With Mapics/Lotus Notes/ADO

Iain,

I'm not familiar with the code you are using (not my area).  However, just
glancing through your question I immediately recognised the value "65535" in
the line, 

Properties("Force Translate") = "65535"

On the iSeries, CCSID 65535 is what is used to prevent any data conversion
between language code pages when a file is moved around.  For example, if
you set data in a file in one language setting and the save it (i.e. to
poratable medium), and you want the data to be completely unchanged if the
file is restored to an iSeries with different language settings (e.g. you
don't want the crosshatch character to be changed to the British pound
sign), you make sure the file has CSSID 65535.

Now, I don't know where that fits exactly into what you are doing here, but
do you always use the above "force translate" line in this process - what
happens if you don't use it, or what happens if you force translate to the
US English CCSID (37 I think) ?


Bernard Green
Momentum Utilities
Sydney, Australia

bgreen@xxxxxxxxxx


-----Original Message-----
From: IWilson@xxxxxxxxxxxxxxxxxx [mailto:IWilson@xxxxxxxxxxxxxxxxxx] 
Sent: Thursday, 19 February 2004 3:20
To: mapics-l@xxxxxxxxxxxx
Subject: Problems With Mapics/Lotus Notes/ADO



Hi All

Hope someone can help me here as I am losing the plot fast.
I am attempting to import data from an AS400 table (The application is
Mapics)
into forms in a Lotus Notes application
Below is the code that I use to connect to the AS400. However when I attempt
to display any value from the record set I get a type mismatch error. If I
change the connection to point to a table in a non-mapics library I am able
to display the value with no problem. The user profile I am logging on with
has the required authority. I have retrieved data using ADO and Delphi
before so this should work. Has anyone any ideas please. Thanks in advance
for any help.

' ============================================
' The code used
' ============================================
Dim workspace As New NotesUIWorkspace
Dim session As New NotesSession
Dim db As NotesDatabase
Dim doc As NotesDocument
Dim OpDoc As NotesDocument
Dim mConn As Variant
Dim mRS As Variant
Dim OperationsView As NotesView
Dim LString As String

Set db = session.CurrentDatabase
Set mConn = createobject("ADODB.Connection")
With mConn
.Provider = "IBMDA400.DataSource.1"
.Properties("Data Source") = "IP ADDRESS"
.Properties("User Id") = "USERNAME"
.Properties("Password") = "PASSWORD"
.Properties("Transport Product") = "Client Access"
.Properties("SSL") = "DEFAULT"
.Properties("Force Translate") = "65535"
.Properties("Convert Date Time To Char") = "TRUE" .Properties("Catalog
Library List") = "AMFLIBA" .Open End With

Set mRS = createobject("ADODB.Recordset")
Set mRS.ActiveConnection = mConn
LString = "select * From AMFLIBA.MOMAST"
mRS.Open LString

Set OperationsView = db.GetView("DTrackingByLineItem")
If (Not OperationsView Is Nothing) Then
Do While Not mRS.eof
                  ' I Get A Type Mismatch here
Messagebox  Cstr(mRS.fields("CALD").Value)
mRS.movenext
Loop
End If

mRS.close
Set mRS =Nothing

mConn.close
Set mConn = Nothing


Best Regards

Iain

Here is my disclaimer

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a
message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.