Dynamic Application Name in OLEDB/ODC Connection String
I have several (more than 100) Excel reports (files) that use the same data connection file. The data connection file connects to SSAS 2012 Tabular Model.
From the SQL Profile data, I would like to know the name of the Excel report file the connection is coming from. I was hoping to use the Application Name property of the connection string.
However, looks like Application Name property accepts only constants / fixed text. Is there a way to pass Application Name dynamically? I tried using &[File] - like we use in Headers and Footers in Excel. But the profile data just logs "&[File]" in the Application Name column. Any easier way to capture file name/path.
I do not want to use VBA. That would require modifying all Excel copies. I am hoping to make a change in the data connection file (within the connection string) so all Excel files would log dynamic Application Names automatically.
Thanks in advance for your help.
Oracle ODBC x86 and x84 on Excel 32bits.
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(22.214.171.124) ODBC driver on my Excel.0 votes0 answersLucas Pott2 weeks ago
Connection string properties
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?0 votes0 answersjos Clement3 weeks ago
Azure SQL DB connection string is not working unless logged in to azure account
I'm building an Visual C++ project which is connected to Azure SQL database via ODBC, I placed the following connection string that Azure:0 votes0 answersAhmed Ayman3 weeks ago
Making Constant Data Bases to recall in program.
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.0 votes0 answersBrad Harris3 weeks ago
Connection error IIS10/SQL 2016
I try to transfer a classic-asp-application from Windows Server 2008R2/II7 to 2016/II10 and SQL 2008 to SQL 2016. The application works fine with IIS10 and SQL 2008. Also with IIS7 and SQL 2016.0 votes0 answersPaul H. Niederbracht3 weeks ago
SSIS package with ODBC source Teradata Deployment issue
SSIS package works fine in Visual Studio, But when deployed it says gives error, SQL Jobs fails execution0 votes0 answersSandesh J1 month ago
Connect to SQl with gMSA
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.0 votes0 answersSteve Sirag2 months ago
Loading dbf Foxpro file from Excel VBA Project
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.0 votes1 answerKlueze3 months ago
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 Dinos3 months 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 Cykowski4 months ago
- Load more posts