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