-
hi friends i have written a cfront to transfer data from SQL to NavisionDB . now we converted the nav DB to SQL 2000. so again i written a vb6.0 application to transfer item table . The problem is in item table design view i have tick the allow null except item no field becouse when i am inserting the...
-
I've a problem, who can help me? I've a SQLServer table sorted by a type code field that show the following records A A2 A3 B B2 C Why the same table called like a temporary table, containing the same record and ordered with the same key, show records ordered like the following? A B C A2 A3 B2...
-
We have 8 Citrix servers. 6 of these with 4.02 client with one of the later hotfixes. 4.03 client on the remaining 2 citrix servers because they are newer. It works. No issues so far, I know its not purist but I so far I have no reason to doubt mixing 4.02 & 4.03. I reckon I will schedul in the 5...
-
Can you mix clients like that OK? In any case, why not just put 5.00 executables now. If you are upgrading anyway, surely thats the best so you don't need to do it again later. if you are not ready to risk 5.00 then at least put 4.00 SP3 everywhere, and not just on some work stations.
-
Its what Microsoft advised me to do. Quite a long story and would be happy to discuss again. I have some other posts on this websitre from a while back relating to plan guides, also check http://www.mibuso.com/forum/viewtopic.php?t=16343&highlight=guide where it is also discussed. I am not a SQL...
-
3.7db, 4.02 clients (with some 4.03) & 4.03 stored procs installed, which I think is ok. I Am not going to upgrade the db to 4.03, going to jump straight to 5.0 later in the year. I will set it to 2005 compatibility for now. Thanks. But, I would still like to know if there are any experiences out...
-
It sounds like you may have a coding issue in your function99. Try taking everything out of the function but the call to YOUR functionality. How are you running your functionality, single instance codeunit that starts a timer or what? Also you can debug your code by creating a codeunit that runs the...
-
Hi David, Thanks for your advised, I am almost there. I have this funny warning on my services (barca-classic barca-sql) the translation is like that the service could not be startet with startupparameter "mystartparameter" mystartparameter is the name of my startupparameter. I did checked...
-
You are probably right. Here is the scenario: Single PC with XP pro with MS SQL Server 2000 2 CD's with installation componenets and a developer lisence and I tried several times to do following steps From CD one I clicked on demo and this install the server and to client( classic and sql ). Replaced...
-
Well, if you search this forum for "SQL Performance" you will find plenty of advice how to improve your system ... I don't want to repeat all here ... you need at least 2 GB RAM and probably your index structure is insufficient (did you check the SIFTs?), and the worst thing for the last...