(page 28) Questionssubmit your own question

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

OLEDB connection string for sqlbase 11.5 Connection String ****************** Provider=SQLBaseOLEDB;Data Source=DATABASE_NAME;User ID=USERNAME;Password=PASSWORD

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

Hi! I’m accessing an Oracle database via Oracle Provider for OLE DB 11g Release 1 (11.1.0.7.20) using Delphi (several versions). The program works as expected, opening tables and displaying info

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

Hi, do you have any idea how to programmatically connect to a database (access 97) located in a different folder(domain) having a password? Like I want to connect to mydatabase which the location i

I am trying to utilze excel vba to connect to a microsoft access database that is linked to oracle tables at work. I have been able to do this by saving my password in access for the oracle linked ta

Hi Frndz, i need some help. I have a aspx page which needs to be coonected to MS Access DB and fetch the records in SharepointServer. what command should i use to connect to a MS Access DB in Share

I have 2 websites. On the first i have a table with news articles in an access database. Now, my question: On the second site i'd like to open the access-db on the first site and display these new

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

We connected dot net with as400 but it is very very slow when i am trying bring 1 lakh records

Dear All, I am a new user in PostgreSQL dabase. I have problem with my connection to PostgreSQL. When i connected i see the message below: Microsoft OLE DB Provider for ODBC Drivers error '80004

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

I desing a data entry program when we used data file through network(LAN) then the connection become very slow .File opens after a large interwal .The dbf having more than 10,0000 data and im sharing

Sir, Code: Private Sub bkLstMn_Click() Dim sconnectString As String sconnectString = "Provider=Microsoft.Jet.OLEDB.4.0;jet OLEDB:Database user Name=Admin,Password=xxx;Mode=share Deny None;Data S

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

I am trying to make ODBC connection using: 1. Primavera SDK 2. XE in Oracle 3. Microsoft for Oracle but always connection failed. I have windows 7 Ultimate x64 and Primavera P6 V7 with

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 am using asp.net to create a project and i need a connection string to connect it with an Oracle server which is on a LAN network. I know its IP address, and port number I will arrange if required.

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

ya pude hacer la conneccion de la bd a visual basic 6.0 pero no se como conectar esos datos a un datagrid alguien me podria ayudar (Now I can make out connection to the db to Visual Basic 6.0 but n

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