Connect to Azrue SQL via 443?
Is there a provider and connection string that will allow me to connect to Azure SQL via port 443 the way Access App does? Both SQL Native Client and ODBC seem to only use 1433 which is blocked by my corporate firewall. I'm especially interested in connecting via Excel--possibly with the Power Query add-in.
For that purpose you can try to download this SQL Azure ODBC driver.
All necessary connectivity information you will find on that page.
VBA update sharepoint inserts
I think I'm almost there. Except the update is inserting into sharepoint. Using Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0. See code below. Situation: I'm refreshing in an excel table from a power query a Sharepoint list (Sharepoint server 2016).0 votes3 answersThe Dinos2 days ago
Need connection string for Office 2019
I wrote a VB .NET program using VS17 that opens Excel files and loads the data into an Access database. For .xls files, I use the connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source= ...;Extended Properties Excel 8.0;1 vote2 answersMark Cykowski2 weeks ago
SSIS SMO Connection String?
does anyone have a connection string for SSIS SMO that will connect to an Azure Database using Active Directory Authentication?0 votes0 answersTed Walsh3 weeks ago
Azure SQL, Mulesoft
Hi Everyone, I have a use case where i need to connect to Azure SQL Server Database which is hosted on cloud and i can able to connect through SSMS by providing username password and authentication0 votes0 answersAneesh Doddapaneni3 weeks ago
Excel VBA ERROR ODBC connection failed
Hi, it is working in Excel-32 bit version, but not working in excel-64 bit. I have a linked table in ms-access which is linked to a sql server table, and when I am trying to fetch the data in excel via VBA from ms-access linked table the error message "ODBC connection failed" showing.0 votes1 answerKashif Khan1 month ago
[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified.
I have a VBA code (in excel 2016) that i use to grab information from a MS SQL server (2008R). The connection works fine on the computer i wrote it on. When i run it on another computer i get the error "[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified".0 votes1 answerlee avery3 months ago
Hi All, can anyone provide connectionstring for Excel 2010. I tried to set connection string for RPA Automation anywhere but it is throwing an error0 votes1 answerSiva Shanker4 months ago
Excel 2016 VBA OLE SQL connection help
Excel 2016 VBA to create an OLE connection to a sql 2014 db and then execute a stored procedure returning the results starting cell A1 on sheet :StoredProcData. Server & instance is QGZZZ\MYINSTANCE db is data0 votes0 answersRichard5 months ago
C# connection string to PostgreSQL Using Dapper
I have a C# application and needs to connect it postgresql using Dapper My Database name is Tournaments My connection string is shown below using (IDbConnection connection = new System.Data.OleDb.OleDbConnection(GlobalConfig.CnnString(db)))0 votes0 answersKayode Oluwole8 months ago
Passthrough query connstring from Access VBA to Azure SQL works on one PC and not on others!
Hi, We have an Azure SQL database and a local Access app that needs to interact with it. Using VBA-generated pass-through query definitions to grab data as needed, no linked tables and no permanently saved queries.0 votes0 answersMike Noviskie10 months ago
- Load more posts