[sballios]

No issue connecting via odbc, we get the table we want to query against and set that up in crystal when we go to put in a sql statement

{CUSTOMERS.ENROLLMENT_DATE}=today-1

we consistently get the error

failed to open rowset

and then

failed to open rowset

details: 26000 : [Open Access]Open RDA ODBC Invalid SQL Statement Identifier

So if this basic sql today-1 doesn’t work anyone have any suggestion on this
This is a cached copy. Click here to see the original post.

[ivan.parra]

RE: sql statements bomb when using ns odbc connection

What query are you running?

[sballios]

RE: sql statements bomb when using ns odbc connection

Customer Records

[jswift]

RE: sql statements bomb when using ns odbc connection

We have a sql query with customers that I run via DAFT. If you would like to send me your sql, I will try and help you.

Thanks

[ivan.parra]

RE: sql statements bomb when using ns odbc connection

try datediff(‘day’,getdate(),create_date)

In a few days, getdate() can be replaced with sysdate() or current_date.

[Author]

Posts