Recent content by qqq

Hi All, Is it possible to retrieve information about the PC(such as Modem, Disk Space, Software installed etc) using SQL server? I need to collect and analyse the information from many PCs (MSDE has installed on each of them). We have try to run "msinfo32" and then save it to text...

Hi, My question is : how to compare some date with sysdate and if the difference more than 10 days, delete those records. I've create the trigger and following script supposed to do this but it does not. if (sysdate - :old.trans_date_time)<10 then RAISE_APPLICATION_ERROR(-20000,'Cannot Delete...

Thankyou for reply, but it is not clear for me what I should do to fix this problem? I'm sorry but I'm new in Oracle. Regards

Hello, I have gote a problem to connect to database. When I try to open SQLPlus8 or Enterprize Manager using username &quot;system&quot; and password &quot;manager&quot; it produce error :no listener found or cannot resolve service name. This server and databases were created long time ago by...

I need to connect MSSQL and Cold Fusion servers regards

qof188 I have the same question as albao: is it possible to establishes the db connection and then use normal <cfquery> tags to run my sql statements throughout my application? regards

Dear foxdev, thankyou for reply. As I understund this is work fine when you conect Application and MSSQL server, but in my case I need connect two servers, whithout using Application. regards

My questions is: Is it possible to establish connectivity between MSSQL server and 'NON MSSQL Server(for web application) programmatically. We can do it manually (Control Panel/ ODBC data sourse/System DSN) but we need to do during the installation process. Another words, is it possible to...