Recent content by gvielliard

Hi all, I want to set up an agent to check if a file is growing or not. My idea was to use TNG (which I don't know yet) to check every 2 minutes a file and to send a warning if the size of my file didn't increase during this period. I want to know if TNG has a function to check either the...

Hi LKBrwnDBA, Thank you, but how can I find this 119706.1?

Hi, I work with Oracle 9i and I have a problem with timeout. At the begining, I had the following error when I tried to connect: ORA-12535: TNS:operation timed out So in my listener.ora I add the line: CONNECT_TIMEOUT_LISTENER = 0 but it still gives me the same error. Does anyone has a clue...

Hi, What is DHCP? BTW, I have something else which is strange: the autentification changes as well alone, I want them to be ahtentified by the SQL login and password. And I don't know why and how, but it happens it changes to Windows NT autentification... Thanks Gilles

Hi all, I am facing a strange problem: I installed for a training session 10 PC. Each of them has SQL Server 2000 installed localy on it. Each of them has its own local Server. These PC are on the same network. And, I don't know why but after rebooting them, they changed randomly the...

Hi, I have just installed a SQL Server 2000 with another program, this program should set the database by its own but I want to be sure it did it correctly. So I am wondering how to know the collation it has set for the database, I don't find it in the properties. Thank you, Gilles

Hello, I am searching around an info wich I can't find anywhere, even on microsoft.com. My question is: How long Microsoft will support Jet Engine 4.0? What I know is Jet Engine 4.0 is included in Access 2002, so it will be supported until June 2006. But does it mean they will support the Jet...

I think the problem is you wrote your two functions in a separate file and you didn't add the *.cpp and *.h files in your project. Go in File View, insert the *.cpp in Source Files folder and the *.h in Header Files folder. Gilles

Hi, I am wondering if there is any existing function converting number of this format 100 1/8 to this format 100.125. Thank you, Gilles

Which version of Crystal Report do you have, I had the same problem with Crystal Report 8.5 because there is a dll wich is not installed on the server when you install Entreprise. The dll is craxdrt.dll which is installed only when you install Crytal Report designer. So in my case I copied this...

I found another trick which can be useful, in your TTX file, you can declare your number as string, the problem is you can't sumarize your numbers on the report unless you convert them back into number... Gilles

I fix the problem, it seems that now you must install Crystal Reports CR 8.5 on the server, installing Crystal Enterprise is not enough for web publishing. For publishing on the web, you need the craxdrt.dll to be registered on the server and this dll is in Crystal Reports 8.5 and not in Crystal...

Hi all, I just moved from CR 7.0 to CR 8.5. I publish reports on the web. When I utilized CR 7.0, layout was OK, but since I installed CR 8.5, the number fields in the smartviewer on the web are slightly upper than other fields. When I look at the preview in the designer, layout is OK. I also...

Hi, I have just installed Crystal Reports 8.5 and Crystal Enterprise 8. Before I worked with the version 7 and it was OK. I use SQL 2000 Server for my database, I send my datas to crystal on the web with the method given by Crystal (ADORecordset.asp and so). I followed very carefully the step to...

Terry, Actually, I tested your programm, it doesn't work, you have to create a temp table for each option otherwise you will have this error: There is already an object named '#tmp' in the database This will work: If @option = 1 Begin Create table #tmp1 (ProductID int, ClientID int, Price...