« Previous Next »

Thread: Connecting to Oracle XE from Log Parser 2.0

Last post 06-23-2008 7:36 PM by NathanBlakley. 1 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (2 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 06-20-2008, 6:13 PM

    Connecting to Oracle XE from Log Parser 2.0

    Reply Contact

    Hi, I am having trouble connecting to Oracle XE to import IIS logs. Each time that I try a variation on (some names changed to protect the innocent):

    LogParser.exe -i:IISW3C file:iislogquery.sql?logpath="V:\\Logfiles\\XYZ" -o:SQL -oConnString:"Driver={Oracle in Home_Default10g};DBQ=111.111.111.111:1521/XE;Uid=mydw;Pwd=mypswd" 

    The following error is presented:

    Task aborted.
    Error connecting to ODBC Server
      SQL State:     IM002
      Native Error:  0
      Error Message: [Microsoft][ODBC Driver Manager] Data source name not found
      and no default driver specified

    Attempts to sent to a CSV have been successful. The switch to SQL seems to break. Any ideas of what I am doing wrong?
    Many thanks.

    Nathan 

    Have a great day
    Tags:

  • 06-23-2008, 7:36 PM In reply to

    Re: Connecting to Oracle XE from Log Parser 2.0

    Reply Contact

    Cat's got your tongues :) Figured it out. The solution, proven to work, is as follows:

    LogParser.exe -i:IISW3C file:iislogquery.sql?logpath="V:\\Logfiles\\XYZ" -o:SQL -oConnString:"Driver={Oracle in XE};DBQ=XE;Uid=mydw;Pwd=mypswd" 

    The IP address can be included in DBQ, but is not needed when operating locally.

    To find the driver name (between the squiggly brackets), look in (Windows XP Professional):

    Control Panel -> Administrative Tools -> Data Sources (ODBC) -> System DSN tab -> Drivers tab and look for a reference for Oracle. Mine said "Oracle in XE," which was the only reference to 10g Express Edition, and it worked.

    Nathan 

    Have a great day
Page 1 of 1 (2 items)
Microsoft Communities