Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Connection Problem of MS Interdev to AS/400" Help!

Status
Not open for further replies.

Plez

IS-IT--Management
Jul 14, 2004
1
US
I have a problem connecting to AS/400 using Visual Interdev.
But if I'll be connecting to a SQL Server, there seems to be no problem. I am using a Connection string on both. But I really having a difficulty when it comes to AS400. Is there something special configuration for that? My current setup is,I have an Web Server and I have a client PC where I develop my Web Page. I have tried creating an ODBC on my client pc but Visual Interdev says it can't find the DSN name. I tried to make an ODBC at the Web Server but the same problem occured. My project in Interdev in in Master Mode.

Sample Code in my Interdev for my connection.

ConStr = "Provider=MSDASQL.1;Driver="
ConStr = ConStr & "Client Access ODBC Driver (32-bit);Password=MOSES;"
ConStr = ConStr & "Persist Security Info=False;UID=OFFICER;Extended"
ConStr = ConStr & "Properties="";SYSTEM=S102AK4M;CMT=0;"
ConStr = ConStr & "DBQ=TLIBDF,HD1100PD,HD1100PO;NAM=0;"
ConStr = ConStr & "DFT=5;DSP=1;TFT=0;TSP=0;DEC=0;XDYNAMIC=1;"
ConStr = ConStr & "RECBLOCK=2;BLOCKSIZE=32;SCROLLABLE=0;"
ConStr = ConStr & "TRANSLATE=1;LAZYCLOSE=1;LIBVIEW=0;"
ConStr = ConStr & "REMARKS=1;CONNTYPE=0;SORTTYPE=0;"
ConStr = ConStr & "PREFETCH=0;DFTPKGLIB=QGPL;LANGUAGEID=ENU;"
ConStr = ConStr & "SORTWEIGHT=0;SSL=2;MAXFIELDLEN=32;"
ConStr = ConStr & "COMPRESSION=1;ALLOWUNSCHAR=0;"
ConStr = ConStr & "SEARCHPATTERN=0;MGDSN=0;"""
Set Con1 = Server.CreateObject("ADODB.Connection")

Con1.open Constr

set rs=Server.CreateObject("ADODB.recordset")
rs.Open "Select PMPNO from TLIBDF.P1PARTP where PMPNO='PA17041630LP'", conn
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top