Category "dsn"

SQL Update query via VBA using ODBC connection

I have an ODBC connection to a database set up in Control Panel using a DSN. I can use this to see data from tables and Views in Excel. What I need to be able t

How to store encrypted SecretAccessKey in registry for Redshift ODBC driver?

Ideally you create a ODBC DSN using the "ODBC Data Sources" UI. I am creating a Redshift Driver DSN(TestDSN) using Authentication Type "IAM Credentials" The se

sql connection to populate table condenses rows

I have an Excel sheet that has a connection to SQL server to generate some table data into the spreadsheets. There is a strange issue where the spreadsheet get

sql connection to populate table condenses rows

I have an Excel sheet that has a connection to SQL server to generate some table data into the spreadsheets. There is a strange issue where the spreadsheet get

JDBC driver connection problems (sun.jdbc.odbc.JdbcOdbcDriver)

I'm having some issues with the connection with Java and SQL 2008 Express. I'm using sun.jdbc.odbc.JdbcOdbcDriver driver for the connections and have created my