Everything works perfectly when I compile to 32-bit, but when I compile to 64-bit I get a connection failure. Is there another ODBC plug-in for 64-bit windows?
Hi Bryan,
for sql server connection, install 64 bits native client :
http://go.microsoft.com/fwlink/?LinkID=239648&clcid=0x409
for ODBC driver :
https://www.microsoft.com/en-US/download/details.aspx?id=36434
The MSSQLServerPlugin.xojo_plugin works for a 64-bit windows connection to MS SQL server, but I am unable to get a connection to Microsoft Access in 64-bit windows.
MBS SQL Plugin is also available for 64-bit.
And we can connect to MS SQL Server and ODBC, too.
Download Microsoft Access Database Engine (64 bit version)
https://www.microsoft.com/en-us/download/details.aspx?id=13255