Pass Through query error -7778

[Seth Schrock]

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.

[Brilstern]

Seth,

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

-Bril

[Seth Schrock]

This is my connection string (with username and password changed).

DRIVER={Progress OpenEdge 11.6.3 driver};
HOST=ibm;
PORT=2500;
UID=myUser;
PWD=myPwd;
DB=vision;
EncryptionMethod=1;
CryptoProtocolVersion=TLSV1,TLSV1.1,TLSv1.2;
ValidateServerCertificate=0;
DIL=0;

On the query it has ODBC; at the beginning.

[Seth Schrock]

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.

[Brilstern]

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