dsn_excel_sql-server-2008_sql-server (page 7) Questionssubmit your own question

Need to host an excel file (2003, 2007) on a Static server. Want to be able to allow multiple users to modify the file and have the data displayed in a static web page. Is this possible?

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.

I have a system DSN set up and working. My VBA looks like: Dim cn As New ADODB.Connection cn.Open "DSN=test;Uid=myID;Pwd=myPwd"

I am really needing a solution for this if anyone can help! I am not a programer, but am proficient with Excel, Adobe, Adobe, Livecycle Designer, etc.

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 am using Excel 2010 on Windows 7. My objective is to retrieve data from an unopened workbook into the active workbook. I keep getting the message "Compile error: Expected: end of statement". that highlights ".12" right of the "Provider=Microsoft.ACE.OLEDB" part. The code I am using is -

Hello Experts, I am facing issues when connecting from asp.net to lotus notes.8.5.3. I have both lotus notes and notessql driver 8.5.3 version. i careated data source the Lotus ntes driver(.nsf) when i am trying to trying to connect it throws errs:

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.

Hi, I am starting to work with a file written in excel 97 & access 97 for forecasting, it is fairly involved and does a great job of profiling etc.

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.

Hi, I am using OleDbDataAdapter to read data from a excel sheet, which have a column having data of 'INT' type in staring some rows after that 'VARCHAR' type.

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 .

I wanna import an excel file to C# and using the guidelines on internet (forums), I installed a 32bit version of access database engine and then "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine"

Hi there, the connection from Excel VB to Oracle 10g and 11g using the Microsoft OLE DB-Provider 'MSDAORA' and installed Oracle Client works fine with this connection string:

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

Hi All, I am trying a Tricky one here, Request your help on the same. I have access 2007 Data base, Present in Share point. I have a Excel macro which Interacts with Access Database.

Hi there, I came across an Excel file that is sourcing data from an outside server. I'd like to understand how the connection string works so I can recreate it elsewhere. The connection string is in following format:

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.

Hi, I have created my Sql database in my local server using sql authentication..Created windows application using vb.net.When i install my setup file in my networks computers it runs successfully..but

Connection string to SQL Server 2012 "LocalDB" April 2, 2014 Hello, Could I get a little help on my very first attempt to write an app with code that connects to my own database table on my own computer. Using Windows8.1, Visual Studio 2013 Express bundled with SQL Server2012 Express localDB.

Now I'm using oledb in order to database connection on the c/c++ application program. Provider=SQLOLEDB;Data Source=127.0.0.1,1433; FailoverPartner=Partner_datbase_server_name;Database=databasename;User Id=id;Password=password;Network=DBMSSOCN;

I'm trying to create a simple app that has a search field that looks for records in a database. Once a record is found, it can be clicked on which populates a template with info to print a certificate.

hello .. im developing vb.net windows application with sqlserver 2008 database but i face aproblem with multi client lied in different location .. since making a network between them is costly ..