Professional Web Applications Themes

ODBC question - IBM DB2

I am trying to connect to a DB2 v7.2 database from Lotus 123 v9.8 on a Windows XP Pro machine. I have the Software Development Client installed on the XP machine and have run the Client Configuration Assistant and registered the SAMPLE and my TEST databases with the ODBC Administrator as System DSN data sources. Everything seems fine, but when I try to connect to "External Tables" through 123 my DB2 databases are not listed under available ODBC_data_sources. The same setup works fine under WIN9x. Is there some sort of ODBC version difference between DB2 7.2 and Windows XP? Any ...

  1. #1

    Default ODBC question

    I am trying to connect to a DB2 v7.2 database from Lotus 123 v9.8
    on a Windows XP Pro machine. I have the Software Development Client
    installed on the XP machine and have run the Client Configuration
    Assistant and registered the SAMPLE and my TEST databases with the
    ODBC Administrator as System DSN data sources. Everything seems
    fine, but when I try to connect to "External Tables" through 123
    my DB2 databases are not listed under available ODBC_data_sources.

    The same setup works fine under WIN9x. Is there some sort of ODBC
    version difference between DB2 7.2 and Windows XP?

    Any help appreciated.

    Thanks,
    Philip Wright
    net

    Philip Guest

  2. #2

    Default Re: ODBC question


    Originally posted by Philip Wright
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     



    Philip,



    did you create a system DSN or a user DSN ?



    marcos oliva


    --
    Posted via http://dbforums.com
    Maor71 Guest

  3. #3

    Default Re: ODBC question

    > Originally posted by Philip Wright 
    >

    >

    >

    >

    >

    >

    >
    >

    >

    >
    >

    >
    >

    >

    >

    >
    >
    >
    >
    > Philip,
    >
    >
    >
    > did you create a system DSN or a user DSN ?
    >
    >
    >
    > marcos oliva[/ref]

    System DSN.

    Thanks,
    Philip

    Lucille Guest

Similar Threads

  1. odbc general question
    By Amaniweb in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: February 17th, 10:49 PM
  2. ODBC Database on IIS question. Where do I start?
    By Charles C. in forum ASP Components
    Replies: 3
    Last Post: June 8th, 07:46 PM
  3. DBI:ODBC-Question
    By Oliver Osterholz in forum Ruby
    Replies: 2
    Last Post: November 20th, 11:07 AM
  4. Replies: 3
    Last Post: September 12th, 04:22 AM
  5. ODBC Question
    By Manas Dadarkar in forum Informix
    Replies: 4
    Last Post: September 2nd, 01:40 PM

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