Error at a Query about more than one Tables (with ODBC)

[Bibi]

Hi,

i have a SqlWindows Program which made a connection to a MS Access
Database about ODBC. I can get all datas with a select about one table. But when
i made a select with more than one table, i get the following message:

"ACCESS:-3010[Microsoft][ODBC Microsoft Access Driver] 1 Parameter
wurden erwartet, aber es wurden zu wenig Parameter übergeben."

Can somebody help me ?

This message means, that the program wait for 1 parameter, but there
are too little parameters received.

The select like this:
" select a, b, c from lks_abc, lks_xx, lks_yy into :cola, :colb, :colc
where abc = xx.abc and abc = yy.abc"

I run this select with "SqlPrepareAndE xecute" and then "SqlFetchNe xt".

It´s MS Access 2000 and SqlWindows 2000.

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Usually, that error means there is a general error in the SQL (not,
necessarily, a parameter error). If you are using something like the
Access "SQL Pass Through Query" in Windows SQL then your SQL string will
not work in an Access (JET) db. I don't believe you can use another
program to initiate parameterized queries in Access unless you open
Access as an Automation object (OLE). This means you will have to
dynamically create a valid Access SQL string to send to the Access query
engine.

Get the Access Help file or a book on Access SQL programming. There
are, probably, articles on the Internet about Access SQL programming.
Search via Google.

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQbVel4echKq OuFEgEQJnSwCdFG USPL3GcA0YDe20C Vvsty72tzgAoKRP
t6eGFdFeD+hSMsg LjQz3rYuS
=tHjq
-----END PGP SIGNATURE-----
Bibi wrote:

Hi,

i have a SqlWindows Program which made a connection to a MS Access
Database about ODBC. I can get all datas with a select about one table. But when
i made a select with more than one table, i get the following message:

"ACCESS:-3010[Microsoft][ODBC Microsoft Access Driver] 1 Parameter
wurden erwartet, aber es wurden zu wenig Parameter übergeben."

Can somebody help me ?

This message means, that the program wait for 1 parameter, but there
are too little parameters received.

The select like this:
" select a, b, c from lks_abc, lks_xx, lks_yy into :cola, :colb, :colc
where abc = xx.abc and abc = yy.abc"

I run this select with "SqlPrepareAndE xecute" and then "SqlFetchNe xt".

It´s MS Access 2000 and SqlWindows 2000.

[VOIA]

Try to check types of parameters and fields in the table. They have to be
same.

"Bibi" <Cy*****@web.de > wrote in message
news:de******** *************** ***@posting.goo gle.com...

Hi,

i have a SqlWindows Program which made a connection to a MS Access
Database about ODBC. I can get all datas with a select about one table. But when i made a select with more than one table, i get the following message:

"ACCESS:-3010[Microsoft][ODBC Microsoft Access Driver] 1 Parameter
wurden erwartet, aber es wurden zu wenig Parameter übergeben."

Can somebody help me ?

This message means, that the program wait for 1 parameter, but there
are too little parameters received.

The select like this:
" select a, b, c from lks_abc, lks_xx, lks_yy into :cola, :colb, :colc
where abc = xx.abc and abc = yy.abc"

I run this select with "SqlPrepareAndE xecute" and then "SqlFetchNe xt".

It´s MS Access 2000 and SqlWindows 2000.