Hi,

i have a VB6 app which connects via SQL native client 2005 to a SQL Server
2005 Express Edition SP3 Instance.
OS: XP Prof SP3

On 1 XP machine, i cannot connect to the Server as a normal user. When i
grant admin rights, it works.
As other computers don't need admin rights i think it's a config. problem,
but i dont't know what rights i should give the SQL client / the user.

I've also tried the def. ODBC driver in MDAC. It works in user mode.
When i open the ODBC cpl i can config a connection using the native client.
The connection test is then successful, even with user rights.

The VB app says that it cannot find the Provider. Err source: ADO

Thx
Chris....

When you are connecting it as another use did you give that user access to
the database?

After creating server login you have to use database user in order for use
to have access.

Thanks.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Christopher Schlueter" wrote:

The User has the right to connect to the DB.
Maybe its related to an MDAC 2.8 Problem on XP SP 3....

"Mohit K. Gupta" <mohitkgupta (AT) msn (DOT) com> schrieb im Newsbeitrag
news:060ADCBD-5058-4304-8DC7-FCF8E70FAC79 (AT) microsoft (DOT) com...

Hi,

problem solved.
All this had to do with the registry permissions.
HKEY_CLASSES_ROOT didn't grant read permissions to users.

The problem is easy to fix but difficult to identify....
No idea why XP hadn't set these permissions correctly during the
installtion....


you live and learn....
especially wth MS...

KR
Chris

"Christopher Schlueter" <DataLtCommander (AT) web (DOT) de> schrieb im Newsbeitrag
news:epDMcpjoJHA.3500 (AT) TK2MSFTNGP03 (DOT) phx.gbl...