excel_sql-server (page 4) Questionssubmit your own question

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:

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

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;"))

I have an MS Access application that currently connects to a SQL Server instance using Trusted Connection via the following file DSN settings: [ODBC] DRIVER=SQL Server TrustedConnection=Yes DATABASE=APUBMARTY

I am very new and very green to SQL. I am just learning and have downloaded SQL 2012 Express to experiment with. My apologies if this question is basic, something I should know.

I am using below connection string to read the data from excel Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path of the file + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\""

I am using vb.net and I try to insert from my web in visual studio to my sql DB but it does not work also there is no any Error pleas help me " Imports System.Data Imports System.Data.SqlClient

Good morning, I'm new here, live in Venezuela, glad to know about you, come here to solve a problem with a connection between a Visual Basic 6, and Sql Server 2000, converted my Access database to Sql database with Access, .adp, and move to Sql server 2000 with access2003.

Hello; I has and old web application begin with windows 2000 and SQL 200. Then Windows 2003 and SQL 2005. In the 2 scenarios I change in this string the data source (server name and the password and then work fine.

Hello All, I am facing one issue like "External table is not in the expected format." with 2013 micro enable excel . when i am trying to open the connection string for reading the excel file i.e oleConn.Open(); .

hi friends i want create a connection string to a sql server database by asking connection string parameter values from user in a cosole application?? anyone can help me on this ??

We're trying to reconcile what we see under the "ODBC Administrator" application for Windows 7/8 versus what has been referenced on this site under the following drivers/providers:

I need to connect netezza from EXCEL. When I am going (DATA --FROM OTHER SOURCES --FROM DATA CONNECTION WIZARD--Other/Advance--IBM NATEZA OLE DB DATA PROVIDOR --(In Data source I am putting IP , and user name and password) but it is not working.

I have a VB6 application that runs correctly from the system that contains the sql server and the source code, either when compiled as an exe or directly from the VB6 developer. It uses this connection string.

Hi, I am fairly new to VBA I have some syntax problems that I do not understand with the connection strings that you give. For example for XL 2007 With the following, the first ( which you give ) and the Third give Syntax errors.

Can anyone share the syntax for a SQL connection string that has variables for the different parameter values? Need to pass the values of some textbox fields into the connection string but I get an End of Statement Expected Error with my string in Visual Studio 20102:

Drop down lists without arrows. I have a spreadsheet created by someone else, there are multiple cells with drop down lists that can only be seen when right clicking the cell and selecting "drop down list".