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
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
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 =
My connection to the SQL Native Client keeps of saying.. Named Pipes: Cannot connect to SQL server. what is the problem? I can connect to an ordinary c:\*.mdb file but not to my SQL Expres