#Odbc driver for sql server 2012 manual#

This is the code: SELECTĭateDiff('m', CVDate(wInTime), ) >= 0) The input parameters are used in the WHERE clause. It retrieves data FROM a view LEFT JOINing it with one table on two IDs. I enter them in this format when I trigger the qry manually as described above. '2180'), parB is a string like a German date (e.g.

parA is a string consisting of 2.4 numerical characters (e.g. ParA and parB are both input values derived from two unbound combo boxes sitting on an unbound form on which the button cBCreate is clicked. Has anybody ever experienced this and might have a solution? Any help or ideas are greatly appreciated. Qdf.Parameters!parDate = bInputValue //from unbound combo box Qdf.Parameters!parAbrg = aInputValue //from unbound combo box The code in question comes down to: Private Sub cBCreate_Click()

#Odbc driver for sql server 2012 manual#

However, when I try to call certain query in VBA code, it takes about 10x the time of the manual exec or I even get a timeout (Runtime Error 3164: ODBC call failed). doubleclick it in the 'Queries' section in MS Access, then I'm asked to input the two input parameters and it takes some few seconds for the qry to return the data (into a temp. The connection between the two is established via the ODBC driver 'SQL Server'. The setup is MS SQL Server 2012 as a backend with a GUI implemented in MS Access 2010 using linked tables, views, pass-through queries, stored procedures and functions. I am having trouble retrieving data from an MS SQL Server 2012 in MS Access 2010 using DAO.QueryDef.