Hi i keep getting this error message while trying to start a hook dll,
"Error s800D failed to connect," also this discription of my error mesage "%s: Failed to prepare the command SQL = %s." this i know is a syntax error, is their a programme or xp regedit trick to help me out and get this third party dll hook working, any suggestions would be appreciated thxs
I have written a store procedure in SQL SERVER 2000. It contains lot of transaction. Some times as data is not in proper form transaction gets rolled back so i want to write log file of the error msg that are generated.
How can i do it.
You can write to files and all sorts of other places, but the easiest thing would be to write to a DB table. If you're just debugging, that shouldn't be a problem: just create a table called something like Log, and write to it every time there's a problem.
If you do this in production and there are a lot of problems, the table can fill quickly. It's probably not the best way to do it in a production environment unless you've got a process to clean it out regularly.
I have created a MS service that has to connect to my SQL server. But it never does. I use the exact same code that does the exact same thing that the service does, but it is in an application, and it works perfectly. The only difference that I see is the app is run by the user that is logged in but the service runs under SYSTEM. Here is the error the service is getting:
Error Message = ERROR [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'DomainName\SystemName'.
I connect to the ODBC by using: DSN = "DSN Name"
DSN is configured to use the windows account, I also tested it and it works fine.
I am not able to find any pointers, it works as an application, but not as a service? Any solution will be greatly appreciated.
You're having impersonation problems. When your service runs, it runs as a service account (probably the IUSR account if it's a web service). When the application runs, it runs as you, the logged-in user. You have access, the service account doesn't. Your DSN doesn't seem to specify a username or password.
You can do a couple of things:
1. Change the service to run as someone who does have access. If it's a web service this could have consequences on other web services running on the same machine.
2. Explicitly impersonate someone else in your connection string. Put the username and password of someone who does have access after the DSN param in the connection string.
Hello every body,
I have a problem. I've just creating a database application that use the SQL server 2000 engine but I want, when deploying the application, not to install the MS SQL SErver 2000 on the user's machine. how can i do? please help! (sorry for my poor English)