122 reputation
110
bio website
location
age
visits member for 2 years
seen Jun 29 at 18:05

Jul
2
awarded  Curious
May
29
awarded  Notable Question
Apr
16
awarded  Popular Question
Mar
26
awarded  Popular Question
Oct
21
awarded  Popular Question
Jul
23
awarded  Popular Question
Sep
5
comment SELECT value from database over ODBC wont reach the software
Is there any kind of "buffer"or 2rd party storing etc in between SQL DB and odbc
Sep
4
revised SELECT value from database over ODBC wont reach the software
New updated info.
Aug
31
comment SELECT value from database over ODBC wont reach the software
I dont have access to the software sourcecode so i cant post the query it uses, except what it shows in the log above. It works with clan database and compared to it, when problem started, there wasn't that many new entries added. the hsmt error above occurs only when it selects from that table, manually selecting from it works fine. And there isnt that many rows in there - when it started, there was like 2-3 rows. I wish i could trace/log what "result" it was that kept it busy. The table has no dependencies listed nether that could mess with it.
Aug
30
comment hStmt/cursor error caused by faulty data?
its over odbc. The software problem was eliminated by testing it with original database, also by using clean copy of the software and it runs fine for others who use the same file. It is over sql server driver (the native isn't fully supported by the developer). Its something that has worked fine for years, yet just suddenly failed. The database itself has not been changed and server software ether uses procedures or queries to read/write/select data, but makes no changes to the tables or creates them.
Aug
30
comment hStmt/cursor error caused by faulty data?
for this one it was the tblguild issue, now its related to a tbl general with focused on the hsmt error. The previous one, for a unknown reason vanished by itself.
Aug
30
asked hStmt/cursor error caused by faulty data?
Aug
26
accepted xp_cmdshell bcp wont save file
Aug
25
asked xp_cmdshell bcp wont save file
Aug
24
comment SQL Server and updating windows firewall rules
yeh the firewall cmd line part isnt a problem, im just wondering how do i get access to them, powershell would work too i guess. xp_cmdshell - but can i pass a value to it from SELECT ?
Aug
24
asked SQL Server and updating windows firewall rules
Aug
24
accepted SQL Server trigger (update or insert with inner join problem)
Aug
24
comment SQL Server trigger (update or insert with inner join problem)
that should do indeed, i simply added IF (UPDATE([Kill])) BEGIN to limit the trigger from doing extra unneeded work and only run it if the KILL was actually updated (not when some other column got updated in the table).
Aug
24
comment SQL Server trigger (update or insert with inner join problem)
ok but now that eliminates the primary key violation issue, however it wont update the killer table if the serial already exists.
Aug
24
revised SQL Server trigger (update or insert with inner join problem)
edited title