access-2003_excel-2003_sql-server-2008_access_excel_sql-server (page 7) Questionssubmit your own question

Hi, I have an excel which password protected. I have to read that excel in .NET I am able to read excel which are not protected using ODBC driver.

I am having issues getting failover working with mirrored databases. Below is my information on driver I am using and connection string info. Any help would be greatly appreciated!

My company use 5 main documents. SalesInv, CreditorsInv, BankReceipt, BankPayment, Journals. I created a table for each, and formatted the Auto Number, my choice 3 letters and 6 numbers. I.e.

How do I Hide Zero. If calculations are done and there is a null value(No Zero) the result is an error. I would like in the final printing of report of accounts, if the debit or credit is Zero it should not display a zero but the calculations should not be errors.

Access 2013. A Rookie that put in 10 hours a day since 90 days. Progress good. What is the expression to have an opening balance when I print an account. Many debits and credits happened i.e. till 31Oct2015.

I am using Excel 2013 and I created an excel data file on a shared drive. I created a connection file (using data connection wizard in excel) to pull that data into a pivot table.

SQL Express connection string for vb6. Need to connect SQL Server2005 with VB6 i have below code.. i have to change Username and password to open the software. but it is in windows authentication to open,

Hello, i am using "Excel 2007 ODBC", connection string: Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; DBQ=C:\MyExcel.xlsx; for write in blank file. and when i save file, it in "xlsb" format.

Good afternoon, we're using SSRS reports and have a C# .dll to run the reports from an Access code program. the server name has a '\' in it, and when trying to run the report through the dll, it's raising an error.

Hello. I'm using VS Framework 4.5 C#. Trying toget data sfrom Excel. I've gor a trouble - “The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine” - i tryed to install some soft from msdn, but i had no result.

We have the following set up: Windows Mobile Device with GPRS connection (win empedded handheld 6.5 Prof) Windows Server PC with SQL Server 2012 VPN Network where both devices contained (the cell carrier routes certain IPs inside VPN)

I have setup a Word 2013 macro to fill a combobox from an iseries (HTE-sun) data-source, the query works from excel and fills the spreadsheet - macro works fine.

Pls everyone am using vb.net2010 to design a database application using Access db as my back end, i have connected successfully and my record are inserting fine but my problem is publishing the application

I was trying to read data from excel2010 which is "intermixed" data format in each cell to matlab workspace using below command: connString = 'Provider=Microsoft.ACE.OLEDB.12.0;';

Hi, I 'm making a connection from VSExpress 2012 with a database of Access 2013 and the following error message: " Microsoft.ACE.OLECB.12.0 ' provider is not registered locally on the machine" . How I can fix it? "

How can I connect rumba through excel. I want to extract data from Rumba to Excel. I have code the extract deatils from IBM mainframe to Excel.But I believe the codes should be different for rumba.

Hello, I am using Microsoft.ACE.OLEDB.12.0 with a 32-bit C# application on a 64-bit PC and an Access 2007 backend. The connection string works fine, however depending on where the database is located

I was using Ole db connection to connect the excel.Then Read the data & display on it on screen and then save it to database after validation. But now excel is not getting connected via Ole db connection,as it is encrypted by some other program.

Installed SQL Server 2014, and using MS SQL Server Management Studio, if that matters. Very simple question: how do I get the Import-Export function to actually....work. (I believe I should be using the 32-bit version.)

How to connect to an AlwaysOn Availability Group failover cluster either for SQL Server Management Studio or for a Customer application ? regards

I have an aspx web page that connects to an Access database through an ASP.NET connection string. The code works perfectly when I preview the page on my local machine. But I get this error when I publish the web site to a Windows server at my hosting company:

I have a problem that I don't understand. I have two VS 2008 programs one gives me a Crystal Report just the way it should work. connection string in App.Config "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\QBData\racklist.accdb"

Hi, I am trying to make a new ODBC connection to our company's SQL Server Reporting Services 2012 server to reach an Oracle db, however I've been unsuccessful trying to create the connection string.

I have used connection string as below in my VB macro. ConnectionString="Data Source=(DESCRIPTION = (ADDRESS=(PROTOCOL=TCP)(HOST=servername)(PORT=portno))(CONNECTDATA=(SERVICENAME=servicename))));uid=username;pwd=password;"

I have created an app in VB 2012 and cannot connect to the database. the error: 'Microsoft.ACE.OLECB.12.0' provider is not registered on the local machine. I am using Access 2013

How to connect SQL Server 2000 Database over internet? I have written the code as follows: db.Provider = "SQLOLEDB; Data Source=xxx.203.xxx.135,1433; Network Library=DBMSSOCN; Initial Catalog=accinv; User Id=sa;"

Target: Microsoft SQL Server Express Edition with Advanced Services (64-bit) OS: Microsoft Windows NT 6.1 (7601) Version: 10.50.1600.1 I have tried close to 30 various of the following, none of which work, any insight/suggestions would be great appreciated!

Hi,I have developed an application using Visual Studio 2008 on C# for stand-alone device, working under Windows Embedded Compact 7. Application work with SQLCompact 3.5 . using System; using System.Linq;

I have an ASP.NET C# application with a SQL server 2012 database that has consolidated membership provider and application database. I am trying to modify my web config according to the instructions provided by the hostforlife.eu hosting service but I think I'm missing something.

I am trying to connect to sql server 2008 r2 from Excel 2010 (VBA). the process is for internal purposes only. I need to pass an id and password to connect to the db from excel.