SQL/VB help please

metbandit1 · 21 Mar 2012 at 16:38

What have I done wrong with this SQL/VB? IT doesnt seem to work but can't pinpoint the error.

Been staring at it for 2 hours with no luck.

GravyMonster · 21 Mar 2012 at 16:43

Why does it not work? What errorsdo you get?

dasyad · 21 Mar 2012 at 16:44

What is nsSQLOps.clsMSAccess?
Are you sure the file location for you Access database is correct?
Did you populate your Access database?

metbandit1 · 21 Mar 2012 at 16:47

Spunkey said:
Why does it not work? What errorsdo you get?

It just doesn't populate the list box and im not sure why. Its supposed to populate the list box with the certain data depending on what is selected in a list box.

dasyad said:
What is nsSQLOps.clsMSAccess? Its a class linking the database to my code.
Are you sure the file location for you Access database is correct? Yes
Did you populate your Access database? Yep test data has been put in.

dasyad · 21 Mar 2012 at 18:29

Have you tried putting a break point on ddlEventList.DataBind() and then checking if ddlEventList.DataSource is actually populated. If it isn't populated then I'd say the problem is with nsSQLOps.clsMSAccess.

Tried connecting to the Access database via OLEDB instead?

metbandit1 · 21 Mar 2012 at 20:04

dasyad said:
Have you tried putting a break point on ddlEventList.DataBind() and then checking if ddlEventList.DataSource is actually populated. If it isn't populated then I'd say the problem is with nsSQLOps.clsMSAccess.

Tried connecting to the Access database via OLEDB instead?

Not tried that but ill give it a go! Thanks

metbandit1 · 22 Mar 2012 at 11:01

Ive got it working now.

Only reason it wouldn't work is because of a spelling mistake -_-.

/facepalm.