423,850 Members | 1,661 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,850 IT Pros & Developers. It's quick & easy.

Pass Through query error -7778

Seth Schrock
Expert 2.5K+
P: 2,908
I'm trying to create a pass-through query and I'm getting an error -7778 'no message with this error'. A google search seems to point to the connection string. However, I'm copying and pasting from the connection string that I used to create an ADODB recordset that works just fine. Is there a difference for a pass-through query (other than the ODBC; at the beginning)? I'm using a DSN-less connection.

It works just fine if I use a DSN, but I don't want to.
3 Weeks Ago #1
Share this Question
Share on Google+
4 Replies


Stevan Bias
100+
P: 200
Seth,

Do you mind posting the snippet that is causing the error?

-Bril
3 Weeks Ago #2

Seth Schrock
Expert 2.5K+
P: 2,908
This is my connection string (with username and password changed).
Expand|Select|Wrap|Line Numbers
  1. DRIVER={Progress OpenEdge 11.6.3 driver};
  2. HOST=ibm;
  3. PORT=2500;
  4. UID=myUser;
  5. PWD=myPwd;
  6. DB=vision;
  7. EncryptionMethod=1;
  8. CryptoProtocolVersion=TLSV1,TLSV1.1,TLSv1.2;
  9. ValidateServerCertificate=0;
  10. DIL=0;
On the query it has ODBC; at the beginning.
3 Weeks Ago #3

Seth Schrock
Expert 2.5K+
P: 2,908
A little more troubleshooting...

I just tried to append a link to one of the tables in my query using the same connection string and it failed with the same error message.
3 Weeks Ago #4

Stevan Bias
100+
P: 200
Yeah... I am still researching, but it tends to be a common problem when attempting pass-through queries DSN-less. Most (from what I have read) just move to a DSN file based connection and give up... Still looking though.

-Bril
3 Weeks Ago #5

Post your reply

Sign in to post your reply or Sign up for a free account.