Bronco Solutions

June 2005 - Posts

• VB.NET Date String Formats

  Standard Format Definitions Format Description d Short Date D Long date f long date & short time F long date and long time g short date and short time G short date and long time M or m month and day Y or y year and month t short time T long time s Read More... Posted Monday, June 20, 2005 2:43 PM by rennera | 0 Comments Filed under: ASP.Net 2.0, VB.NET 2005

• SQL Server Linked Server to MS Access

  Execute the following in the query analyzer: -- add the linked server EXEC sp_addlinkedserver '<Reference Name>', '<Linked server type>', 'Microsoft.Jet.OLEDB.4.0', '<Full Path to DB>' -- add the login credentials EXEC sp_addlinkedsrvlogin Read More... Posted Tuesday, June 14, 2005 1:44 PM by rennera | 0 Comments Filed under: SQL Server 2005