Koozali.org: home of the SME Server

Mysql Access problems

Offline ronaldson40

  • ****
  • 96
  • +0/-0
Mysql Access problems
« on: June 14, 2007, 11:20:50 PM »
Hi

I am having a rather peculiar problem.

I have created two groups i.e Domain Admins and Domain Users to create a Windows Network.

I have made a program that uses the mysql db as the backend.

I am using the mysql.dll connector for interfacing it with the db and the code is written in C#

Now this is my dilemna. Whenever I log into the windows domain as a Domain Admin I am able to connect to the mysql db on a regular basis.
But when I login as a Domain user and use my program. most of the time, I get this error when i either try to add/retrieve a record.
The error is of this sort : Datagram has no sendto address.

Please note I also have netlogon policies for each user(Made using poledit)

Please advise what could be the reason.

Offline Confucius

  • *****
  • 235
  • +0/-0
Mysql Access problems
« Reply #1 on: June 14, 2007, 11:33:58 PM »
When as Administrator you can make the changes without any error and as a Domain User you can't it seems to me that we're talking about a Windows issue since Windows does the rights on the local machine and there fore also controls the dll and it's actions.
I would suggest to open rights on the registry & file system for 1 specific Domain User in th policies and try again. And ofcourse try 1 of the not adjusted Domain Users to see if it makes a difference.

I would certainly advice to use a registry and/or file monitor to see what's going on.

I really don't think that MySql has caused this error.

Offline ronaldson40

  • ****
  • 96
  • +0/-0
Registry/File monitor
« Reply #2 on: June 14, 2007, 11:39:33 PM »
Hi
Thanks for your earlier reply..

Can you suggest some registry/file monitor...

Regards

Offline Confucius

  • *****
  • 235
  • +0/-0
Mysql Access problems
« Reply #3 on: June 14, 2007, 11:45:06 PM »
Hmmm... not really the place to continue this thread... but well..

http://www.microsoft.com/technet/sysinternals/utilities/regmon.mspx

M$ bought recently the company that made all these great tools.
This makes clear that I dislike to credit M$ for these tools.

Offline kruhm

  • *
  • 680
  • +0/-0
Mysql Access problems
« Reply #4 on: June 17, 2007, 02:12:05 PM »
try making them POWER USERS (instead of DOMAIN USERS).

Be sure to use the group name as the group description.
http://wiki.contribs.org/User-Groups

Offline ronaldson40

  • ****
  • 96
  • +0/-0
Mysql Access problems
« Reply #5 on: June 18, 2007, 12:04:33 AM »
I will try it out

Thx