odbc

import odbc from 'odbc'; async function runQuery() { let connection: odbc.Connection | null = null; try { // Ensure your DSN is configured in odbc.ini and odbcinst.ini // For example, if you have a DSN named 'my-db-dsn' configured to connect to your database. // Or you can pass a full connection string directly. const connectionString = process.env.ODBC_CONNECTION_STRING ?? 'DSN=my-db-dsn'; connection = await odbc.connect(connectionString); console.log('Successfully connected to the database.'); const result = await connection.query('SELECT 1 AS MyColumn, \'Hello, World!\' AS MyText'); console.log('Query result:', result.length ? result[0] : 'No rows returned.'); const insertResult = await connection.query(`INSERT INTO MyTable (id, name) VALUES (?, ?)`, [2, 'Test User']); console.log('Insert result:', insertResult.count + ' rows affected.'); // Example of calling a stored procedure (replace with actual procedure and parameters) // const procedureResult = await connection.callProcedure('MySchema', 'MyProcedure', [1, 'param2']); // console.log('Procedure result:', procedureResult); } catch (err: any) { console.error('Database operation failed:', err.message); } finally { if (connection) { try { await connection.close(); console.log('Connection closed.'); } catch (closeErr: any) { console.error('Failed to close connection:', closeErr.message); } } } } runQuery();