Home About Us Equipment Services Solutions Resources Contact Us <% Function OpenDataBase dbPath = "D:\inetpub\wwwroot\nitelife\nitelife\new\db\ATC.mdb" ConnectString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open ConnectString Set OpenDatabase = objConn End Function 'then in subsequent pages that require the conn, simply: Set Conn = OpenDataBase %> Search for a Manufacturer PS&L works with virtually all technology providers in the multimedia, audiovisual, communications, security and video conferencing arenas. If you are looking for a specific manufacturer, you can search the partial list below. For an alphabetical listing of manufacturers, <% SQL = "Select Distinct [Brand] From [Functional Categories]" Set RS = COnn.Execute(sql) Do while Not RS.EOF %> " ><%= RS("Brand")%> <% RS.MoveNExt Loop %> For a list of manufacturers by technology / equipment type, <% SQL = "Select Distinct [Functional Category] From [Functional Categories]" Set RS = COnn.Execute(sql) Do while Not RS.EOF %> " ><%= RS("Functional Category")%> <% RS.MoveNExt Loop %> Search for a Manufacturer  |   Sound and Audio  |   Lighting and Effects  |   Video and Projection  |   Security and CCTV  |   Other Technologies   Ready to Buy? Call us today at (800) 548-5403! or go to our "Contact Us" page to place an order.    All major credit cards accepted. <% MyPage= Request.ServerVariables("SCRIPT_NAME") IF instr(1,MyPage,"SoundAndAudio.asp") > 0 then %> PS&L markets sound and audio products from the following manufacturers, among other: <% ElseIF instr(1,MyPage,"Lighting.asp") > 0 then %> PS&L markets lighting products from the following manufacturers, among other: <% ElseIF instr(1,MyPage,"VideoAndProjection.asp") > 0 then %> PS&L markets video & projection products from the following manufacturers, among other: <% ElseIF instr(1,MyPage,"Security.asp") > 0 then %> PS&L markets security products and systems from the following technology providers, among other: <% ElseIF instr(1,MyPage,"PublicAddressPaging.asp") > 0 then %> PS&L markets Public Address & Paging systems from the following technology providers, among other: <% ElseIF instr(1,MyPage,"WirelessAndInternet.asp") > 0 then %> PS&L markets wireless & internet solutions from the following technology providers, among other: <% ElseIF instr(1,MyPage,"Manufacturer.asp") > 0 then %> PS&L markets products and solutions from the following manufacturers, among other: <% ElseIF instr(1,MyPage,"OtherEquipment.asp") > 0 then %> <% end if%> Copyright Performance Sound & Light Inc.