help with ADODB.Connection

Hello all,

I need your kind assistance in helping me figure out what is wrong with my code in vba. Let me explain you, I have working with "ADODB.Connection"

my connection is.

Please Login or Register  to view this content.

it seems like does not work when I call this

Please Login or Register  to view this content.

It crashed with the message "no value given for one or more required parameters", what I know until now is the Column name(s) is/are wrong (could be CODIGO or/and other), How can I change that Column name or just is another problem?

Try change to

Please Login or Register  to view this content.

hello Sir,

the result is the same, I forgot where I can see columns in SQL? or just I need to change Data source path

No one can even guess if your sql string is correct or not.

Seems OK to me though...

You probably don’t want to query the open workbook with ado though, it causes a memory leak.

Originally Posted by Ivancovish

... what is wrong ... with "ADODB.Connection" ...

1. Have you seen this guide ?
https://www.connectionstrings.com/excel/

2. Don't use (maybe ?) the "cnn" and "rs" variables as public (Public Cnn As ADODB.Connection, Public Rs As ADODB.Recordset), but as local
You have "so many" connections in modules that maybe they conflict with each other (?)