Oh Okay. I thought the select * from table, will always retrieve the rows in the same order. I just tried a select on few tables and it results...

Rbarry,

I meant the CIT.descr should be populated with NIT.descr from the first inserted record in NIT.

Below is the test case:

SQL> select * from nit;

CNO ...

Hmm, no success yet ! I am able to change the other regular sql commands in the command text space but not this 'exec' command. It just throws the same...

Ok. I think it should work. I am trying to just test it from Excel using ODBC.

I set up ODBC and I am able to connect to the database from...

Hmm, atlast I just found out that the application that is connecting to the database is using ODBC. So if we can run the

...

Hmm, okay..

I just setup the ODBC data source for the server.

Not sure how I can connect to the server with ODBC..

I appreciate any help. Thanks

THanks Rbarry. THat helps.

ANd if anyone else have used SSL or IPSec for encryption, please let me know. THanks.

Rbarry, It didnt work either.. same error...

Are you using this method currently without encryption?? How does it store the password?? plain text?? and do you where...

Aww okk.. But does it store the password in plain field if we execute this command?

EXEC sp_setapprole 'test',N'test'

And do you know where the password is stored???

Thanks a lot.

Does the below command store the password in encrypted format or plain text??

Please give me your suggestions. Thanks

Rbarry, I tried the below command to exec setapprole it was successful.

But, is the password encrypted in this method or do I have to mention...

Thanks a lot, Rbarry.

One last doubt, I just found the syntax for creating app role is different.

CREATE APPLICATION ROLE application_role_name

WITH PASSWORD =...

Rbarry, THanks for your reply.How can I grant connect only access to the user??

THank you

Yes, my client is looking for providing access to the users only through the application and not at the database level..

I researched a bit and I was able to...

Could it be like a permissions issue??

We just found out that the client has created the database as a seperate instance with its own master database.Could it be the...