Hmm does it work on windows 7 (using it for the tests), seems like everything is working fine but I think it is not allowed to create files in the folder I created in C:\ ... and I think its not working becuz of this.. ideas ?
Hmm does it work on windows 7 (using it for the tests), seems like everything is working fine but I think it is not allowed to create files in the folder I created in C:\ ... and I think its not working becuz of this.. ideas ?
works on w7 32 and 64, and windows 2008, the procedure creates the files, program dont, and only works if the folder is c:\MSSQLTips
The program doesnt even start for me?
What to do?
Caosfox.. it doesn't create any text files and yes the folder is C:\MSSQLTips
Screenshot by Lightshot
Caosfox.. it doesn't create any text files and yes the folder is C:\MSSQLTips
Screenshot by Lightshot
any error? what os?
what sql server version are you using 2008r2?
no errors during sql dll install?
execute this querry to test it
SELECT dbo.WriteTextFile('this is a test', 'c:\test.txt', 0)
and check if test.txt is created at c:\
if not, you installed wrong the dll
if yes, you have wrong the proc
Yes 2008 R2, no errors during install.
http://prntscr.com/1e2w5e
I think it has something to do with premissions of writing/editing files.
Edit : there is nothing like test.txt in C:\
null = file not writed
1 = sucess
that means:
1) no write permisions like you say
2) dll is not correctly installed
what to do
1) no idea, i dont know how sql manages permissions
2) reinstall the dll and try again
Windows Server 2003 R2 Enterprise fully updated.
64 Bit, No errors, at task manager DW20.exe pops up.
Something with the program is wrong.
On another test dedicated server with windows xp 32bit and 64bit, Im getting visual studio error.
never tested it on 2003/xp, only 2008 and 7 (in fact, i really doubt is going to work on xp, but anything can happend)
so cant say if its the program, os or if you need to edit something
dw20.. i have no idea what is that
so far installed on some servers with w2008 and 7 and is working 100%
its working for me too im using it on my server since i was done recreating the gui and adding the settings im using sql server 2008 r2 and windows server 2008 (os)
Is it possible to change the path instead C:\ to be D:\ ?
yes, you need to change on source and recompile
or to make your life easier, pm me where you want to check for files (like x:\files, or w/e you want) , i change, recompile and pm you back with a link with the new file
hmmm what about if i want the auto plus thing start to say when players make + 15 and higher ?
Last edited by saxz; 09-07-13 at 03:13 PM.
in v3 there is a config.xml as its C# i used xml instead of ini file format, look inside the source on how to add a path setting for it and edit it
change the stored procedure read pages 10~13 for more info on that this question was asked many times before but with +8 just change 8 to 15 and youre good to go