32 bit excel 2013 with 32-bit odbc driver


On Windows 8.1, Lets install the 32-bit ODBC drvier, intending to use the traditional excel data connection:

 

image

http://nationalassociationofrealtors.github.io/ezRETS/

 

Using the 32-bit ODBC console, we take parameters from our SSO Portal and use them to configure the ODBC driver. (The SSO portal has a RETS client of its own).

 

image

image

image

image

image

image

 

Fiddler shows that the exRETS driver self-tests fine.

 

image

 

Then in uninstall our 64-bit excel (office 365 licensed) and reinstall 32 bit versions of all the office tools, binding to the office 365 license. That done, we configure a classical data link, which we see works:

image

 

We also see, from fiddler that after login the driver enumerates various metadata sources, successfully.

image

Now to make Excel fully cooperate we learn (from an expert) to use Microsoft Query  – and the ODBC source.

image

image

image

getting to

image

What we see under the hood is the following definitions for the DSN and query

DSN=bars;LoginUrl=http://rets172lax.raprets.com:6103/Barstow/BARS/login.aspx;
UID=rapstaff;;StandardNames=false;UserAgent=Rapatton1Test/1.7.2;UseHttpLogging=true;
HttpLogFile=C:\Users\Peter\Desktop\httpbars;UseBulkMetadata=true;RetsVersion=1.7.2;
IgnoreMetadataType=true;EncodingType=UTF-8 Encoding;HttpLogEverything=true;

SELECT “data:Property:RESI”.ListingRid, “data:Property:RESI”.ListingOfficeMLSID
FROM “data:Property:RESI” “data:Property:RESI”
WHERE (“data:Property:RESI”.ListingRid>0)

from

image

Advertisements

About home_pw@msn.com

Computer Programmer who often does network administration with focus on security servers. Very strong in Microsoft Azure cloud!
This entry was posted in RETS, odata. Bookmark the permalink.