TNSNAMES and AS/400

Tom_Davidson

Tom_Davidson

VIP Member
I am trying to install JAS on W2K and the database on my AS/400. Can anyone forward and example string for a connection to a data source for me? I need to get this done today and JDE may not get back to me in time?

the string I am looking for is similar to: System - 7333=jdbc:???:server...

TIA

Tom Davidson
 
Here's a sample (attached) for a SQL 2000 database.

Versions - DV7334=
(jdbc:microsoft:sqlserver://WEBSERVER:1433;
databasename=JDE_DV7334;
SelectMethod=cursor;
sendStringParametersAsUnicode=false)


I think you need to remove the 'microsoft', 'SelectMethod=cursor' and
'sendStringParametersAsUnicode=false' for SQL 7.0.


Colin



Colin Dawes, Sr. Technical Consultant
Syntax.net
B733.1 to ERP 8.0
Oracle 8i/9i/SQL Server 2K, DB2
 
Back
Top