Hi vbforums,

I was not sure which thread to ask this question in. However I am using Visual Studio 2010, so perhaps a fitting spot. I have a SQL statement that was given to me on another site and this SQL statement always errors out. But I'm told it works on Windows 8.1, which I don't have access too. I thought that perhaps someone here might shed some light as to why Win 10 does not want to run it.

The SQL statement:
Code:
SELECT * FROM [Statement.csv] as m left join [Trans.csv] as d on m.F2=d.F1
The error:
Code:
[Microsoft][ODBC Text Driver] Too few parameters. Expected 2
My text driver DSN:
Code:
DSN=MSTextDriver;DBQ=C:\SPOOL;DefaultDir=C:\SPOOL;DriverId=27;FIL=text;MaxBufferSize=2048;PageTimeout=5;
My data:
  • Statement.csv

Code:
203-010265;203-010265-08;MNR;D;WILLIAMS
203-010265;203-010265-09;MNR;D;WILLIAMS
203-010265;203-010265-17;MNR;D;WILLIAMS
203-010265;203-010265-18;MNR;D;WILLIAMS
  • Trans.csv

Code:
203-010265-08;08/08/2016;62;Interest On Arrears;105.81
203-010265-08;08/08/2016;63;Monthly Service Fee;30
203-010265-09;08/08/2016;62;Interest On Arrears;185.3
203-010265-09;08/08/2016;63;Monthly Service Fee;30
203-010265-17;08/08/2016;62;Interest On Arrears;187.43
203-010265-17;08/08/2016;64;Monthly Insurance Premium;200
203-010265-17;08/08/2016;63;Monthly Service Fee;30
203-010265-18;08/08/2016;62;Interest On Arrears;96.96
203-010265-18;08/08/2016;63;Monthly Service Fee;30
My OS and other info:
  • Windows 10 Home single language, 64 bit. Version 1607, build 14393.82.
  • ODBC Data Sources (32-bit). Microsoft text driver (*.txt, *.csv). Version 10.00.10586.00. Filename ODBCJT32.DLL. Date 2015/10/30.
  • Microsoft Access Database Engine 2010 Redistributable


Any help will be greatly appreciated.

Regards,
S