generate functionFri, 31 Mar 2023

I'm using this command and connection string in Google Apps Script to connect to a MSSQL server: `Jdbc.getConnection('jdbc:sqlserver://;databaseName=sbsql;user=curruser;password=currpass');` But I'm getting the error "Exception: Failed to establish a database connection. Check connection string, username and password." My server is at `` at port 5500. Username is curruser and password is currpass. What am I doing wrong?

function getDBConnection() { var conn = Jdbc.getConnection('jdbc:sqlserver://;databaseName=sbsql;user=curruser;password=currpass'); return conn; }

Generate More

Questions about programming?Chat with your personal AI assistant