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

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

I need to connect a local sql server compact edition file (.sdf) file from another computer in my application. How it can be done without sharing the folder? can it be connect as in the case of sq

I have a SQL database that I am trying to access from a web server. I created an ODBC connection and it works just fine, but when I try to connect from my script using the DSN=Datasource option, I g

i uploaded my webSite online by using PLESK i need to change my ConnectionString add name="DB" connectionString="Data Source=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|\XXX.mdf; Initial Catalo

Hi, I am able to connect to my database using the Connection string below. I am receiving the message "Failed to Open the Specified Database". I am not sure what can be wrong. I have tried two d

No matter what I try to enter in my code (ex: "dsn=mydatabase"; "Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;") I get this same error: M

There is some way to limit the number of returned rows?

Hi I learnt from connectionstrings.com that "HDR=Yes" in Connection String for Excel indicates that 1st row is not values but Column Names. I have a requirement where I need to consider 2nd row

Some one know how to make DSN with SQl 2008. I am getting error

I use Win Untimate 7 and SQL server 2008 Standard. I want to use Dreamweaver 8 to connect to the database in SQL but when imported connectionString error message: "[Microsoft] [ODBC Driver Manager] D

I have a Delphi Win32 application that uses TAdoConnection to connect to MS SQL Server. It works fine in at least a hundred of users, in different environments, OSs, SQL versions and servers. The c

I created my connection string in Dreamweaver MX as shown below: <% ' FileName="Connection_ado_conn_string.htm" ' Type="ADO" ' DesigntimeType="ADO" ' HTTP="false" ' Catalog="" ' Schema="" D

I'm looking over the Excel examples and see a problem: what if I don't know the exact name of the Excel file I'm trying to open? All of the examples need a full name either in the Dbq or the Data Sour

my database attach in my asp website I'm connected with the following conection string in my pc : Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=true;User

Hi Thanks for the best website and it really helps, but I have question. I am coding my Project using .Net and C# and My database is SQL Server 2005. When I connect by using connection string =