Professional Web Applications Themes

iSeries DB Access from ASP - ASP Database

Hi all, Would anyone happen to have a DSN-less block of code for accessing a DB2 database on an iSeries (AS/400) server? I need to access some information on it, but I'm having some trouble writing (or even finding) code for a connection. If not, is there a way I can access the DB in MS SQL by linking a table? Thanks! Brian....

  1. #1

    Default iSeries DB Access from ASP

    Hi all,

    Would anyone happen to have a DSN-less block of code for accessing a DB2
    database on an iSeries (AS/400) server? I need to access some information
    on it, but I'm having some trouble writing (or even finding) code for a
    connection.

    If not, is there a way I can access the DB in MS SQL by linking a table?

    Thanks!

    Brian.


    Brian Guest

  2. #2

    Default Re: iSeries DB Access from ASP

    "Brian Piotrowski" <simcoeparts.com> wrote in message
    news:phx.gbl... 

    http://www.able-consulting.com/ADO_Conn.htm

    oConn.Open "Provider=IBMDA400;" & _
    "Data source=myAS400;" & _
    "User Id=myUsername;" & _
    "Password=myPassword"


    McKirahan Guest

  3. #3

    Default Re: iSeries DB Access from ASP

    Note that IBMDA400 provider is part of IBM Client Access. You need to
    install the OLEDB driver on you server from Client Access, at a minimum.
    I've never found a way to just install the driver without getting all that
    Operations Navigator nonsense that is totally unnecessary on an IIS server.

    There's also the Library List parameter of the connection string that I
    recommend using.

    "Provider=IBMDA400.DataSource.1;Persist Security Info=False;User
    ID=as400User;Password=thePassword;Data Source=theHostNameOrIP;Catalog
    Library List=yourLibraryFile(s)"

    Also, there's some differences in SQL when querying data from DB2. For
    example, instead of "SELECT TOP 10 something FROM somewhere...," it's
    "SELECT something FROM somewhere FETCH FIRST 10 ROWS ONLY"

    Ray at work



    "McKirahan" <com> wrote in message
    news:dHV8d.78825$.. 
    >
    > http://www.able-consulting.com/ADO_Conn.htm
    >
    > oConn.Open "Provider=IBMDA400;" & _
    > "Data source=myAS400;" & _
    > "User Id=myUsername;" & _
    > "Password=myPassword"
    >
    >[/ref]


    Ray Guest

Similar Threads

  1. iSeries question
    By Bob_Johnson in forum Coldfusion Server Administration
    Replies: 3
    Last Post: April 3rd, 12:00 PM
  2. Coldfusion and iSeries
    By Bob_Johnson in forum Coldfusion Server Administration
    Replies: 4
    Last Post: December 12th, 02:01 PM
  3. iSeries V5R2 to Coldfusion
    By tegger in forum Coldfusion Database Access
    Replies: 0
    Last Post: March 9th, 04:29 AM
  4. iSeries Connection
    By newmarx in forum Coldfusion Database Access
    Replies: 0
    Last Post: August 19th, 08:16 PM
  5. Connecting Unix to iSeries AS/400 DB2
    By Biegster in forum PERL Miscellaneous
    Replies: 1
    Last Post: July 12th, 09:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139