access-2003_excel-2003_sql-server-2008_access_excel_sql-server (page 14) 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

Hi, I'm trying to add an RC4-128 encripted Access 2007 DataSource to my VB2010 Windows Forms Project through the Add New Data Source Wizard but, when I click the Test Connection button, I am gettin

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

sorry if this is a duplicate post Okay, I am using some older tools here and what I want to do should be easy but I can't get the connection right. I have a access.db setup on a godaddy hosted w

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 all I have a question, we have been entering data into a database that has sQL Server 2005 in the background and Access 2007 on the front end for over a year. We connect to it by entering in our us

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

Sir, The problem on the subject sited above is resloved as per your advice for which i am indebted your credit that will never forget. Sir, another problem related to it is that report cannot gene

sir, The following is the extract written in the module . The access always failed when i tried to access ms access password protected database from within the visual basic 6. Displaying Datareport a