Search results for query: *

Hi all, Can i insert into a table from a view by using a trigger on the view. I have 3 tables which I join to create a view. Now i want to create one more table which has all the view columns and one additional new column. I was wondering if i can use an instead of trigger which will insert the...

Thanks for your reply, I'll try to make things more clear, I have a lot of convoluted data which i need to JOIN from 3 tables to make a view, which is say V.(I said two tables before since i wanted to make it easier to explain). I decided to make a view so that whenever the tables are updated...

Hi all, I have a question about instead of trigger. I have a situation in which I have 2 tables A and B, and a view V which is derived from both these tables. Now I need to have a table T which, gets its values from the view V. However, since we can write only instead of triggers on views, and I...

Thanks for your reply, I'll try to make things more clear, I have a lot of convoluted data which i need to JOIN from 3 tables to make a view, which is say V.(I said two tables before since i wanted to make it easier to explain). I decided to make a view so that whenever the tables are updated...

Hi all, I have a question about instead of trigger. I have a situation in which I have 2 tables A and B, and a view V which is derived from both these tables. Now I need to have a table T which, gets its values from the view V. However, since we can write only instead of triggers on views, and I...

If i check out the listing in ODBC sources under administative tools in the control panel it says "SQL Server". Also the driver is SQLSRV32.dll which i think is correct. I even installed MDAC and it still doesnt work. I tried using the IP address of the server, along with the port...

Hi all, I'm trying to set up a dsnless connection to SQL Server using the following code use DBI; my $DSN = 'driver={SQL Server};Server=LAB135_20143;database=test;uid=xxx;pwd=xxx;'; my $dbh = DBI->connect('DBI:ODBC:$DSN') # quit if not able to connect or die "Fatal Error: Couldn't...

Is there any way to access a computers BIOS over a network using PERL? I need to extract service tag information of computers from the BIOS. VB seems to be able to do it, I was wondering if Perl can too. Thanks

Hi all, I have a small program that uses the Win32::TieRegistry module to access the registries of computers in the domain. My problem is I want to make this available on the web and its not working because the user does not have previleges. Is it possible to pass userid/password/domain...

I am trying to use Perl to create a list of all the computers that are one the network. Is there any function available that I can use? Thanks.