J
James
Hello,
I recently discovered that I could not use existing Excel Query files.
Excel appears to hang and nothing appears in the ODBC traces. I've
since decided to create a new Query file which works. When I compared
the old one to the new one, I discovered that the connection string
between the two files differed:
From the one that fails:
DSN=P21 PROD;DRIVER={C:\Program
Files\OpenLink\olod3032.dll};UID=;Database=;FetchBufferSize=30;Host=hal;NoLoginBox=Yes;Options=;Protocol=TCP/IP;ReadOnly=Yes;ServerOptions=;ServerType=Progress
8;
This one works:
DSN=P21 PROD;DRIVER=C:\Program
Files\OpenLink\olod3032.dll;UID=;Database=;FetchBufferSize=30;Host=hal;NoLoginBox=Yes;Options=;Protocol=TCP/IP;ReadOnly=Yes;ServerOptions=;ServerType=Progress
8;
Note the difference in the DRIVER parameter. Well and good -- I see
what the problem is, but I have hundreds of queries using the { ... }
braces and I'd rather not have to make this change to all of them.
My searches online indicate that enclosing the DRIVER parameter in {
....} should work. In other words, all examples of DQY files show that
being used ... but all the DQY files that I've created recently, using
this ODBC Driver and other drivers (like the Microsoft SQLServer one)
lack the {...}.
Therefore, I'd like to know -- what is the format of a DQY file?
Should the DRIVER parameter have the {...} around it? If so, why is
Excel *not* like it now?
Regards,
James
I recently discovered that I could not use existing Excel Query files.
Excel appears to hang and nothing appears in the ODBC traces. I've
since decided to create a new Query file which works. When I compared
the old one to the new one, I discovered that the connection string
between the two files differed:
From the one that fails:
DSN=P21 PROD;DRIVER={C:\Program
Files\OpenLink\olod3032.dll};UID=;Database=;FetchBufferSize=30;Host=hal;NoLoginBox=Yes;Options=;Protocol=TCP/IP;ReadOnly=Yes;ServerOptions=;ServerType=Progress
8;
This one works:
DSN=P21 PROD;DRIVER=C:\Program
Files\OpenLink\olod3032.dll;UID=;Database=;FetchBufferSize=30;Host=hal;NoLoginBox=Yes;Options=;Protocol=TCP/IP;ReadOnly=Yes;ServerOptions=;ServerType=Progress
8;
Note the difference in the DRIVER parameter. Well and good -- I see
what the problem is, but I have hundreds of queries using the { ... }
braces and I'd rather not have to make this change to all of them.
My searches online indicate that enclosing the DRIVER parameter in {
....} should work. In other words, all examples of DQY files show that
being used ... but all the DQY files that I've created recently, using
this ODBC Driver and other drivers (like the Microsoft SQLServer one)
lack the {...}.
Therefore, I'd like to know -- what is the format of a DQY file?
Should the DRIVER parameter have the {...} around it? If so, why is
Excel *not* like it now?
Regards,
James