Ah, my apologies. It's good that you voted in May, though.

I know, but I have a feeling that most of the readers are here in the United States. 😉

I find that irresponsible. Here we are on the government created Internet engaging in the free exchange of ideas and you don't want to take part.

I think that's wrong....

Continuing along this line, you might want to look at Access Data Projects.

This is how you can effectively use OLE DB on a SQL Server Database. This is only...

What are the permissions for a user on the database? Do you have an example? What are their permission levels?

Nelson

Are you using Windows Authentication or a SQL Server login?

This sounds more like a SQL Server permissions issue. Have you done any thing with the server permissions on this?

If you have, you might have given everyone owner permissions....

You can use a CASE statement.

The code will look something like this:

SELECT fname, lname,

CASE WHEN fname = 'John' THEN '2' ELSE '1' END AS Status

FROM tbl

Hope this...

I would recommend using the Data Reader Source and then create an Oracle connection using the Native OLE DB\Microsoft OLE DB Provider for Oracle through the Connection Manager at the...