gistfile1.txt

import * as odbc from 'odbc';

async function connectToDenodo() {
  const connectionString = `Driver={DenodoODBC}; 
                            Server=your_denodo_server_address;
                            Port=9999; 
                            UID=your_username; 
                            PWD=your_password;`;

  let connection;
  try {
    connection = await odbc.connect(connectionString);
    console.log('Connection successful!');

    // Example query
    const result = await connection.query('SELECT * FROM your_table_name');
    console.log(result);
  } catch (error) {
    console.error('Error connecting to Denodo:', error);
  } finally {
    if (connection) {
      await connection.close();
    }
  }
}

connectToDenodo().catch((error) => {
  console.error('Error in connection process:', error);
});