J
Jay Graff
I have a spreadsheet that a co-worker sent to me that has
various queries embedded within the cells that connects to
an Oracle database via an ODBC connection. I cannot
refresh the data because when it tries to connect to the
database, I get a "Driver's SQLSetConnectAttr failed"
error followed by a "Invalid Connection String Attr"
error. I believe that the problem stems from the fact
that he set up his ODBC connection as a System DSN, rather
than a File DSN. How do I change the DSN used the
spreadsheet and/or how do I resolve these 2 errors?
various queries embedded within the cells that connects to
an Oracle database via an ODBC connection. I cannot
refresh the data because when it tries to connect to the
database, I get a "Driver's SQLSetConnectAttr failed"
error followed by a "Invalid Connection String Attr"
error. I believe that the problem stems from the fact
that he set up his ODBC connection as a System DSN, rather
than a File DSN. How do I change the DSN used the
spreadsheet and/or how do I resolve these 2 errors?