Access to database problem

  • Thread starter Thread starter Benny
  • Start date Start date
B

Benny

Hello Experts,

I have developed a windows application using vs.net 2002 with C#. The
customers loves it and everything works fine on windows XP. However,
when I deployed the application on a client windows 2000 computer (with
the latest dotnet framework installed), the application was unable
connect to the database (MS SQL 2000). I then installed the application
on the server computer (windows 2000) where the database is located,
and everything works fine. So I am suspecting it is the security issue
difference between windows xp and 2000 that caused this problem. Can
anyone tell me exactly what the problem is and how can I solve this?


Thanks in advance,

Benny
 
How are you connecting to SQL Server - trusted or SQL authentication?

If trusted, the connection will only work if the logged on Windows user has
been granted permission in SQL Server. Check your SQL Server Security
settings.

If using SQL authentication, your user account doesn't have execute or other
permission. However this behavior should be consistent regardless where the
app is run.

good luck,
kevin aubuchon
 
Hello Kevin,

I have just found out the cause of the problem was because microsoft
data access component was not installed. Another question now is how can
I included the MDAC in the deployment and auto install when deploy?


Thanks,

Benny
 
The MSDN Library has your answer. Search for the topic "Adding a Launch
Condition for Microsoft Data Access Components". There are line by line
instructions.

Good Luck.
_____________________________
C Addison Ritchie, MCSD
Ritch Consulting, Inc.
 
Back
Top