+ Reply to Thread
Results 1 to 4 of 4

ora-06413 connection not open. driver's sqlsetconnectattr

  1. #1
    Registered User
    Join Date
    11-22-2017
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    4

    ora-06413 connection not open. driver's sqlsetconnectattr

    Good Day!

    I am using Excel 2007 and with Windows 7 32bit OS.

    With the other computers I have no problem in doing a query to automatically update the data in my excel from my server.

    The procedures I am doing as follows below,

    Data Tab >

    From Other Sources >

    From Microsoft Query >

    On the Databases tab <New Data Source>

    *I input the name of the data source

    *Then I choose microsoft odbc for oracle for the driver

    Upon clicking connect the error displayed was "ora-06413 connection not open. driver's sqlsetconnectattr"

    Seeking your assistance regarding this matter.

    Thank you.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: ora-06413 connection not open. driver's sqlsetconnectattr

    Try setting up the connection with the Windows Control Panel > Administrative Tools > Data Sources (ODBC). If you can get it set up there then MS-Query should recognize it. If you can't set it up there, well then at least you know the issue isn't with Excel.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    11-22-2017
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    4

    Re: ora-06413 connection not open. driver's sqlsetconnectattr

    Hi Sir,

    Upon trying it on the administrative tools I got an error setting up odbc,

    "The setup routines for the Microsoft ODBC for Oracle ODBC driver could not be loaded due to system error code 193:

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: ora-06413 connection not open. driver's sqlsetconnectattr

    In that case, I think you have a driver issue and not an Excel issue. You'll need someone with more knowledge than me to help you fix it. This is more of a windows-type question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sybase Connection: Data source name not found and no default driver specified
    By VAer in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-20-2017, 12:11 AM
  2. Macro to open .dqy connection instead of manual way
    By fokeiro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2016, 02:49 PM
  3. Replies: 2
    Last Post: 05-15-2015, 04:12 PM
  4. run a sql file on a connection open in excel
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-24-2014, 09:55 AM
  5. ODBC Connection to OPEN Workbooks
    By hawkwind in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-15-2013, 12:09 PM
  6. [SOLVED] Leave OLEDB connection open
    By ngirrens in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-09-2012, 02:30 PM
  7. Replies: 2
    Last Post: 12-10-2007, 07:43 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1