sql-server_sql-server-2017 (page 4) Questionssubmit your own question

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

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.

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

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.

Hi, Help!! How do I use a variable in a select statement in vba? This is a standard query Select IngredientID, Quantity, from Recipes where RecipeID = 7 This is what I would like to do, but do not know how to.....

web.config connection string to SQL named instance on cluster works for some time and suddenly stops working. I do the stops start of app pool and it is working again, but after some time (of inactivity) it stops working!!!

I want to use multiple DSN connection string in my web.config file. But its giving error as default driver not specified. Any one please help me

Hello guys I was directed to this site as THE place to find information on how to write the connection string I need. I am still quite new at this coding stuff so any help would be appreciated.

Having trouble connecting to a MS SQL database. The OS I'm running is opensuse 13.1 64bit. I've manage to run both tsql and isql successfully. However, when I try to connect via python I get the following error message:

I am working using VBA macros in Excel (2007) to execute Stored Procedures (SP) in a SQL Server Express 2014 instance. When the SP is simply SELECTing data to return, the connection works fine.

Hi, trying to create a SSIS flow to extract data from source (AS400) to destination (SQL) db. The flow is relatively easy: connect, extract and put it in destination folder.

hi friends have connected my database to sql server but the problem is setup file when make a setup file it doest not includes database(tables of that data base) the setup works in that system only if i tried to install the setup file in another pc it does not work..

I'm Brand New to SqlServer. I've never used it before. And I have been given the task of creating a user/database that our jboss server can connect to. I created a user testuser and I gave this user a default schema of testschema.

Wonna select table-rows in sql-server (2012) from access (2010) 3 different ways testet, but all dont function: SELECT * FROM 1) [Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=H:\Temp\REALUMSATZ.accdb;

Hi Guys, I want to access the SAGE DB i have server name and password and all. but in my system don't have an SAGE driver.. are you able to access SAGE DB without SAGE driver installed in my machine.

First for some background on my situation: I am working in Access 2010 user frontend with a Microsoft SQL Server 2008 backend. I have a stored procedure that inserts new values(supplied by the parameters) into a table.

I am using VB.NET 2010 and am trying to create a connection string to my SQL Server 2012 Express database on the local machine, to support ADODB. I want to use be able to use ADODB recordsets in my program.

i have task to connect from local data base in c# but i dont have sql server so how can i connect those local database? to be view in grid view? thank you

Hi all Together ! How to Connect VB.NET to SQL Server? Please Answer when you saw my question , I'm waiting .

Hi, I'm having trouble in connection string, I successfully linked Sybase to SQL server 2008 R2 using Sybase OLEDB Provider. I am using C#.net and asp.net for the front end. here is my connection string:

How to set the connection string for app_data folder for hosting, kindly help me out in this my current connection string is :-

Hello, I am a newbe to programming. Is there a way to connect to multiple databases using ADO. I'm currently using the following string to connect to one database. dbname1 = "FireReportingTest"

I've got some long running data profiling queries that I am running against a SQL Server 2008 DB. Here is the connection string that I am using with the .NET System.Data.SQLClient provider.