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

Hi , kindly assist.. am trying to import data from excel to sql database. am using excel 2016. am getting the following error " "System.ArgumentException: Keyword not supported: 'provider"

I have trouble to run my app when installing on another system the language is c# and I used DataAdapter and drag table to form to connect to db. when I Install on another system it gives sql server error :

when i was trying to connect my access file to C# program while running i faced the popup with that "The'microsoft.ACEOLEDB.12.0' provider is not registered on the local machine". please provide any solution that can help me to find answer.

I have an access database on a web server with CPANEL and I want to connect an application created in Visual Basic .Net 2010, I want to be able to connect to it and modify data, but I can not find the connection string ... I hope your answer thanks!

I'm fairly new to databases and Web Services. A small project I want to do involves making a Web Service that connects to a database.

I am upgrading an Access 98 to Access 2007 and having problems with "open connection" code. The old code is 'Open connection set ConnObj = server.CreateObject("ADODB.Connection") ConnObj.Open "datatronics"

We have Two Site ( "A" & "B" ) and both site are different subnet (Site "A" 125 sunbet ) (Site "B" 240)and we has been installed Two type of SQL Cluster 2014 one site "A" and another one Site "B"

I'm trying to make a simple connection to a microsoft access 2016 database through a vb.net code, it's very simple: Cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Data\VBtest\ConnectigToSecuredAccessDB\Production3.accdb; Jet OLEDB:Database Password=aros20;"

hi, I am using Oracle SQL Developer version 1.2.1. I want to connect to the Database server using VBScript. I wrote the below code but getting an Error "database source not found and no default driver specified".

Hi, Two questions I wish to ask.... Domain user id and password not working in connection string. Server=IDB01\MS;Database=Tax;User id=in\sqluser; Password=123**;Connect Timeout=0;

Hi All Can we get which application are connected to sql server and also best recommendation document to keep performance good please share documnets

I try to export some data from excel to my access database, but on line 15 rs.open I get the error Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. I can't seem to figure out what is going wrong here. Any help would be appreciated, thanks!

I seem to be having problem with connection a SQL Server 2016 with AlwaysOn feature using the user credentials. Our DBA created a contained database user.

I have to support a VB6 app still in production (ugh). A customer is specifying our software needs to be PCI compliant which requires TLS 1.2.

Hi! I Need make a connection to Adaptive Server Anywhere 8.0 database using Excel 2013+VBA commands, Someone who can help me

the error is in conn.Open("Provider=SQLNCLI10.DLL;Persist Security Info=False;Initial Catalog=backup_db;Data Source=acer\JOSEPH")

I am trying to read from an SQL Server database which is hosted on MS Azure, through an ASP.NET WebForms website, created in Visual Studio 2013. I've stored the connection string in Web.Config, and have referenced it in the Code-Behind.

Hi, I am trying to use Microsoft Azure to host an ASP.NET Web Forms website, and connecting an SQL Server database (also hosted on Azure) to it. So far:

Using C #, connect to a database created with SQL Server 2014 Management Studio using Visual Studio 2015. I am interested to know which string to use to be able to connect from Visual Studio 2015 to "DatabaseProva"

I have a project where I have to send data from an Excel spreadsheet to an Oracle database. I have installed the latest Oracle client and the ODBC drivers.

I've read many questions about that problem but i still can't solve my problem. When I run my website on localhost everything is working. The problem happens when I run my site on SQL Server 2008. I've got an error:

What is the Access OLEDB connection string for Office 365? Thanks.

I'm trying to export the data from multiple database from a single server into one excel using VBA code. Please can anyone help.

Hello, We decided to move towards the ODBC drivers. I installed the ODBC Driver 13 for SQL Server. For that we desided to use MSDASQL provider for ODBC Drivers , our existing application uses ADO and SQL SERVER 2008 R2.

Hi Everyone, need some help on my school homework. I would like to ask what is the connection string of Access 2016? Thank you!

Hi My system reads Excel data using a database approach. I use the following connection string as this returns extended characters: Provider=Microsoft.ACE.OLEDB.12.0;Data Source='';Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";

Hello to all participants, must extract an excel sheet data from MySQL once extracted these data excel sheet processed with many functions, the result of that calculation must be stored in MySQL.

I'm trying to use a third party tool to query an Excel Worksheet. On my old server which had office 2007 the connection string Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp.xlsx;Extended Properties="Excel 12.0 XML;HDR=YES";Persist Security Info=False

Hye, I am really need help right now. Before this i develop a system using Microsoft Visual Basic 6.0 as interface and Access as the database .

I am trying to connect to remote Microsoft sqlServer 2016 Enterprise(ssas) using Visual Studio 2015 community. using (AdomdConnection conn = new AdomdConnection(@";Initial Catalog=CCAnalytics;Data Source=APPSWORLD\MSSQL;User ID=madhubabu;Password=sasa;Provider=MSOLAP.7;"))