ODBC Question

ODBC Question

Post by Mdot Dav » Tue, 10 Aug 1999 04:00:00

I have a VB app that uses ODBC to execute a UNION QUERY against a Jet
using version 4.00.3711.08 of ODBCJT32.DLL.  The query looks like this

SELECT  Plan.GroupNumber,
               Plan.AdminSpecValue as EmpCaseValue,
               "AD" as EEType
FROM Plan, Adminspecialists
WHERE Plan.AdminSpecialistID = Adminspecialists.EmployeeID
UNION SELECT Plan.GroupNumber,
               Plan.AcctSpecValue as EmpCaseValue,
               "AC" as EEType
FROM Plan, AccountSpecialists
WHERE Plan.AcctSpecialistID = AccountSpecialists.EmployeeID;

This query worked fine with the 3.51 version of the Access ODBC driver
but gives the message "Too few Parameters.  Expected 2." in the 4.00
version.  The "AD" as EEType and "AC" as EEType statements
cause the problem.  Take these out and it runs fine.  I was wondering
if anyone else has had a similar problem and what they did to fix it.

Any help appreciated!



1. MS ODBC vs Oracle PO8 ODBC question

Hello All,

When I use Microsoft's ODBC driver for Oracle, my queries return the
populated recordset I expect.

However, when I use change my DSN to use Oracle's ODBC driver on exactly the
same DB I get an empty recordset.  I can see the column headings, but I get
no data.  Anyone know why?

Both DSNs seem to work fine from ODBCTest, which would imply the
configuration is right.

My app & PO8 are on the same machine so the docs say I don't need NET*SQL, I
just leave the Service field empty (to force IPC).

All help gratefully received.

Using PO8, on Windows NT 4.0 SP5

2. Task Switch Yield to Network Packet Received / Sent

3. Looking for old ODBC driver & ODBC question

4. SQL Plus PL/SQL Syntax Question

5. ODBC to OLE DB and a ODBC question

6. Q : VB3 & Access 2.0 - compatibility layer ???

7. Perl Win32::ODBC question

8. identity column problem with transactional replication

9. MSDE/ODBC questions

10. SQL ODBC questions

11. SQL Server/ODBC Question

12. sql server ODBC question help please

13. OLE DB for ODBC question