access_sqlbase_sql-server (page 6) Questionssubmit your own question

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

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

I have executed Teradata Queries using VBA within Microsoft ACCESS for years. Now using the same connection string with ACCESS 2013, I receive the Error Message: Run-time error '-2147467259(80004005):

Does anyone know of the OLEDB drivers will be supported in SQL Server 2014? I read in some post it would not be available after SQL 2012 but in the OLEDB documents on the Microsoft site it shows a topic under SQL 2014. Thanks.

Hi. I have an database in SQL Server 2012 installed in my server machine. When an aplication developed in VB2013 perform access in database, the same aplication in other station don't can access the database.

Hi, I am having a problem connecting MS Access and firebird. Access and Firebird are all 32-bit, running on Windows 7 64 bit.

i working on project using c# and access 2013 , the wrong is : Cannot open database . It may not be a database that your application recognizes, or the file may be corrupt

i need to connect to sql server which is installed on a high-end machine. i have a wpf c# app running on my local machine from which i need to connect to a DB on the sql server of tat high-end machine.

I have been using this connection string with no problem on a number of databases and MS operating systems. Sever 2003, 2008 R2 and 2012 R2 Eval.

I want to import excel data into my database using odbc and in .Net so i used this connection string: OdbcConnection occon = new OdbcConnection ("Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};

Hello, I need help when using a connection string to connect to an access 2007 database within an ASP page. I am using the string "Driver = {Microsoft Access Driver (*.mdb, *.accdb)};Dbq=(path to db);

I have an MS Access 2010 32-bit database that is primarily a front-end. The data is stored in an SQL Server 2008 R2 managed by my company's IT.

Provider can not be found.It may not be properly installed. VB6 service pack 6 is installed. The Programs works on 1 computer, is is copied to 2nd computer won't work. Mike Wright

Dear folks I've just got myself a Windows Server 2012 R2 as web server. I come from a some old 2003 stuff. Now my problem is to get my connection for MS Access 2013 up and running.

Hi, When i was using QTP i was able to connect to Access database using the below connection string "DRIVER{MicrosoftAccessDriver(.mdb,.accdb)}; DBQ=C:\Automation.accdb;Readonly=True"

I am using .NET Framework 4.5,Microsoft Access 2010 64 bit. I've getting an error in asp.net when it is connecting with access. I've also installed 64 bit ACE engine from this link:-

Hi, I use Visual studio 2008, i try to create a new connection for a dataset in a vb application. But the datasource is on a SQL SERVER 2012, it's seem to be a problem of incompatibilty..

I have problem with my application that working properly at runtime( via visual studio ) and update data grid of windows form .net . But after publish the application and run this then , I am getting following error as shown in image.

I have created some apps on my home PC using Visual Studio 2008 (C#) and MS Office 2007 (MS Access) as my database. My OS is Windows Vista. Everything is 32 bit.

Dear All, Thanks for your support in advance :) I am looking to move an Excel Data Base to Access in order to improve efficiency and bring security to the data hold. The problem that I am stacked is related with the loading.