Bronco Solutions

April 2005 - Posts

• SQL Server Linked Server to Oracle

  Execute the following in the query analyzer: -- add the linked server EXEC sp_addlinkedserver '<Reference Name>', '<Linked server type>', 'MSDAORA', '<TNS Name>' -- add the login credentials EXEC sp_addlinkedsrvlogin '<Reference Name>', Read More... Posted Monday, April 25, 2005 1:41 PM by rennera | 0 Comments Filed under: SQL Server 2005

• Optimizing VB 6 Code - Getstring vs GetRows vs RS.movenext Loop

  I am posting the results of the test that I recently ran... basically because I can... and because I thought it was interesting. Scenario: Recordset with 55626 rows and 3 columns Language: Visual Basic 6 with Service Pack 6 Code Time File Size GetString Read More... Posted Tuesday, April 19, 2005 4:01 PM by rennera | 0 Comments

• Windows Authentication - ASP.NET

  This took me a while to figure out - but once I got it - it is incredibly simple and very powerful. This would typically be used on a domain where your users are already authenticated... ie intranet application. In IIS disable Anonymous access and be Read More... Posted Friday, April 08, 2005 11:28 AM by rennera | 0 Comments Filed under: ASP.Net 2.0