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

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 have establish a connection to a server in Excel 2013, but it is not giving me the option to use parameters. Does the connection string impact the ability for a local parameters to be set?

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 am trying to connect XLS file and below is my connection string. Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 12.0 xml;IMEX=1;HDR=Yes;ReadOnly=1;"

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.

Hi, Please help me with the below question i have a vba excel macro developed , i use sql queries and treating each sheet as table develop macros.

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 am working on same solution where i need to update connection strings of multiple files in Bulk.But , Its working for MS Excel 2010 and not for Excel 2013. Exception Result : "Exception from HRESULT: 0x800A03EC"

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.

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.

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.

How do you connect to a SQL server hosted at Amazon RDS via ADO? More specifically, I need to connect via Dreamweaver's Custom Connection String. The format used for virtually hosted instances of SQL Server Express do not seem to work. I get an "unidentified error" message.

Hi everyone, I'm currently doing some research on the MS SQL native client for ODBC driver's security. I would like to seek details on how secure is ODBC driver in MS SQL Native client?

I am executing SSIS packages that override the Connection string by submitting new connection parms from batch execution of the package using dtexec.

I have an sql server command, calling a stored procedure. actually the problem happens with all types of commands but this is my test only. 1- i have tested calling the procedure from inside SQL server management studio, it took 34 Seconds to execute.

I am trying to develop an MVC app on my local computer and I have huge troubles opening a connection to my database. At the same time, I am able to run SQL scripts and they work just fine.

I have a web page that imports translations from a spreadsheet using Microsoft.ACE.OLEDB.12.0; The process works almost flawlessly, except that Japanese (and likely Korean and Chinese) can not be imported with this method.