excel-2013_active-directory_azure-sql-database_ssis_mysql_excel (page 2) Questionssubmit your own question

Hello There, I have created an ssis package which pulls the data from IBM DB2 to a SQL table. To connect to DB2 i was using a project parameter DB2_ConnectionString as below

Using vba and Microsoft.ACE.OLEDB.12.0 connection to Excel 2013 workbook. Inserting records into worksheet work fine. Problem occurs if I update a field in a record with a blank ("").

I need to know how to open a password protected Excel file using OleDBConnection. I saw a post that provides a work around. I am using Excel 2016. Is there a way in this version? The excel is 2013 and older.

Hi, my name is Marvin and I have little experience in Mysql. I have mysql 5.5 installed with workbench 6.1. I work with vba excel developing small applications, locally I have no problems connecting to databases.

Can I use ADO to open a connection to a shared Excel (Office 365) workbook that resides on SharePoint. I do not want to checkout the work book as Other people are storing information on it.

Hi I am looking to connect LDAP or AD coonection using Alteryx. Please provide steps to connect to Active Directory groups using OLE DB connection via Alteryx. Regards, Anil

I have the Oracle Runtime 11g 32 bits and the 12c Runtime 64bits instaled on my system, and i would like to know if is possible to use the 32bits Oracle 11g(11.2.0.1) ODBC driver on my Excel.

Hi, I use a OdbcConnection string to read xls sheet into a data table (VB.net) is there a property I can use to omit formulas (ex. Vlookup) and use the values instead?

What are steps in connecting VB.net with SQL server?

I'm building an Visual C++ project which is connected to Azure SQL database via ODBC, I placed the following connection string that Azure:

I'm a student learning programming. I need to find out what web address gets my database and server. I need to find out what the database name is.

Hi, I am trying to connect my existing ETL application with Azure SQL Database. But since 29th July 2019, I am getting error Connection Reset/Connection is closed.

add name="xyzEntities" connectionString="Data Source=123.12.132.123;port=3306;Integrated Security=false;Initial Catalog=database name;User Id=myname;password=mypass" providerName="MySql.Data.MySqlClient"/

I'm trying to make use of gMSA's to connect from ASP/X code to an MS SQL 2016 server. I've configured the gMSA with permissions on the target database and set up the gMSA on the source server, but can't get a connection string configured to use the account.

Hi there: I’m trying to load a dbf file generated from Foxpro7 into Excel (programmatically), I don’t want to use any export/import mechanisms because the objective is to carry out this transparently for the user.

Hi everybody, I'm just beginning with MySQL and I try to make a connection between a VBscript and a MySQL Database.

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).

I need a ADO connection string to work with Quick Payroll, I am not a developer but I need it in order to customise reports.

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;

Does anyone have a connection string for SSIS SMO that will connect to an Azure Database using Active Directory Authentication?

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 authentication

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.

I get the error able 'mysql.proc' doesn't exist while executing procedures from .net application using proxysql. MySQL version: 8.0.13 MySQL.Data version: 8.013

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".

Remote MySQL Linked Server deployed in SQL Express Management Studio do not show any content and structure, it only LIST NAME of the tables belongs to the remote connected MySQL database

Hi All, can anyone provide connectionstring for Excel 2010. I tried to set connection string for RPA Automation anywhere but it is throwing an error

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 data

Hi everyone I´m working with Visual studio data tools to create a DTSX that will work in SSIS. when I create the ODBC Connection I need to write a USER and PASSWORD for this connection but the password is not persistent.

I have visual studio 2012 Ultimate on my machine and am trying to connect MySQL on Azure using MySQL .Net Connector 6.8.3 Below is my connection string Server={Server};Port=3306;Database={DbName};Uid={user};Pwd={pwd};sslMode=Prefered;

Is it possible to connect with MySQL 3.1.13 behind a proxy server? Like this : MySQL.ConnectionString = "Driver={MySQL ODBC 5.1 Driver};Server=dbServ;Database=dbName;User=dbUser;Password=dbPass;Option=3;ProxyServer=proServer;ProxyUser=proUser"