Hacker News AI· darekd·· 17 days agoAI score38
Teaching a 1999 VB6 app to talk to AI agents
Teaching a 1999 VB6 app to talk to AI agents
AI summary
The author added a headless mode to the VB6-based SQL Server Comparison Tool (SCT) that runs saved comparisons and emits versioned JSON, plus a small C# MCP server (SctMcpServer.exe, .NET Framework 4.8) that lets Claude Desktop list and run those comparisons. A key bug was that Claude Desktop starts MCP servers with a stripped-down environment missing %CommonProgramFiles%, causing ADO error 3706 until the server restored standard Windows variables. The design restricts the AI to saved comparisons with no server choice, credentials, writes or row data, and shipped in SCT version 6.0.
Source: Hacker News AI · sql-server-tool.com