excel-2010_sql-server-2012_excel_sql-server (page 10) Questionssubmit your own question

Hi I need to write a C#.Net program to read an Excel 2010 file. What is the OLE DB driver that I should use? Is it ACE OLEDB 12.0? Thanks in advance.

I am using the following connection string in web.config file for my application where both web server( Win 2003) and database server (sql 2005 EE) are running in the same machine. Source=.\\SQLEXP

I am trying to make a connection from an HTA to a SQL Server 2000 server on a network but only know the name of the server, not the IP address. The connection strings don't want to work with the serve

I have a problem with connection string for SQL Server 2008. I think it is connection string. It give me error 26 when i try to login. This is the connection string Data Source=192.168.0.1;Initial C

I am running Oracle 10g on an Windows XP system. How do I access data in a MS-eXcel spreadsheet from SQLPlus? I have set up the eXcel ODBC Driver. What does the following SQL Server code translate

I am trying to run a vb 2010 application using sql express 2008. I have the app on the server (ELDSRV1) and an instance og sql 2008 on both the server and my workstation (ELDWK1). I can run the app

Can we get data from table feature of Excel 2007 / 2010? Ex. Select * from Table1 or Table 6, instead of select * from [Sheet1$]

Dear Experts How can connect to mydatabase of sql server express 2008 r2 on a virtual dedicated server of godaddy.com what should be connectionstring kindly help regards dheeaj kumar

I'm converting a web app to run on Azure. I want it to access a SQL\Express instance on my server. I have the endpoint setup, but I can't find a clear example of the connection string that I need. T

Hi Peeps, I am totally confused now. My application uses a direct connection, which works 100%. The string: Public sConn As New SqlConnection("Data Source='JUAN-PC';Initial Catalog='chromepos

Hello everyone! I have a big problem :) How can I export an Excel spreadsheet (only a single worksheet) to a remote MySQL database using VBA code? I have always imported a .csv file with phpmyadmin, b

Hi all, I am trying to figure out how to create my connection string so that I can use current logged on account for authentication with my remote SQL server. Currently I can connect to my SQL server

I need to rewrite a c# app that is accessing an SQL 2008 server via linked tables in MS Access. I have an ODBC connection on my pc to the SQL database located at our hosting facility. I am relatively

I have configured a VPN connection between two offices. I have TCP/IP connectivity between both the server and client machine, and I have the firewalls open to the specific ports I need. I can conne

Hello I want to create a connectionstring for sql server that contains AttachDbFilename . I just found this for sql express in http://www.connectionstrings.com/sql-server-2008 Please help me

We recently have ported our GIS system to a Win 7 box in preperation of converting our whole system and ran into problem accessing a side database (SQL 2000) on one of the applications. The prolem is

hi everybody ... i want ur help about this problem ... i created a tiny project of Company Stores and it's run very well on my Computer, But when i run it on another computer, this message appears .

Which string i can used for my problem,? my problem is: i crate a windows form application in vb.net. my back end is sql server 2005.( sql authandication) using Which connection string i can easily ru

Any one can suggest me for how to connect the sql server from the forms 6i. With Regards Ravi

I used import/export wizard for importing tables from sybase ase12 to mssql2005. I've used .netframework provider for odbc for connection. My odbc works fine. But while using this, the first option is

What is the function within Excel to call a textfile in the same folder, and search within textfile for a keyword? Websites considered: http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/

i know the remote server's address like 114.120.124.112,the login name to the server is ,for example, test,password is test_1.there is a database named testDatabase in the server.there is no password

Hello, I have an iMac with Dreamweaver. I have to connect with Dreamweaver Mac on an SQL Server 2005. With a Windows station, i'm connect with this parameter : Provider=SQLNCLI;Server=myServerA

Hi There, I'm trying to connect to a remote sqlserver using c# in a web application. with no success: authen tication mode="Windows" identity imper sonate="true" add key="Connection Str

I am developing an app in visual studio 2008. This app should run to any computer where it will be installed. I connect it to SQL 2005 express. SQL 2005 express will also be installed to the same co

Hi all, please can any one help me to connect with mdf file using oledb connection string. Thank you.

When I run sql (select count(*) from table_name from xlsx file I result is 65535, but the excel sheet have more that 65535 rows. How fix it? Connection string is : "Provider=Microsoft.ACE.OLEDB.12.0

Hi all, i hope i'll be clear to explain... I've an .xlsx file with 339 columns (used for import a wide range of data) but if i ask ADO to tell me how many columns (to check data integrity) i only ge

I want to create a DataSet from an excel without knowing the name(s) of the sheets inside. Is it possible to get the names of the sheets using OLE DB Provider ? So a I can perform several SELECT orde

I am coding my Project using ASP.Net and C#.My database is ms sql server 2005 express.I publish my project in server but I have a problem. The problem is; error: 40 - Could not open a connection