Search results

  1. W

    TNS:Timing out

    I am having problems connecting with my access databases. this is the mssg I m getting: [Oracle][ODBC][Ora]Ora-12535: TNS: operation timed out (#12535) [Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr failed IM006 0. When creating a new DB and linked to tables it works fine but...
  2. W

    SQL question

    DATE ACCT CLASS 7/28/07 5:31AM 1233 A 7/28/07 5:32AM 1233 B quick question…if I am trying to get “B” on my query results how can I write my SQL statement? I am trying to query from a history table and I am looking for the most recent CLASSES (or current value). thank you in...
  3. W

    Query runs all day

    Dear pro, I am having difficulties running a simple query that it runs all day and I have to kill it at the end of my date because it does not finish. Here is the statement that I would like some suggestions on how to improve it for faster results: SELECT code, acct nbr, date, user, sum(amt)...
  4. W

    ODBC --call failed.

    This error comes when try to run a query in Access. Does someone knows how to fix it? ODBC --call failed. [Oracle][ODBC][Ora]ORA-01013:user requested cancel of current operation (#1013) Any help on this will be greatly appreaciated. Thanks a lot. Wil
Back
Top Bottom