All Questions
Tagged with connection-string oledb
79
questions
57
votes
4
answers
106k
views
Quick ways to test OLE DB Connection String
For debugging purpose I'd like to know ways to test OLE DB connection string quickly.
I've found this free software, it works on my machine, tested successfully.
Is there a even quicker way to do so,...
- 10k
36
votes
4
answers
101k
views
What is IMEX within OLEDB connection strings?
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=localhost;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2"
What is the purpose of IMEX=2 in the above connection string?
- 3,841
13
votes
2
answers
31k
views
Readonly connection string to an access database
I'm trying to connect to an Access database file using a System.Data.OleDb.OleDbConnection. I need to connect in readonly mode because another application uses it at the same time. I can connect to ...
- 371
10
votes
3
answers
52k
views
Microsoft.ACE.OLEDB.12.0 CSV ConnectionString
I know questions this kind are asked from time to time but i can't find any satisfying solution.
How can I open a CSV-File using MS ACE OLEDB 12?
I try it with the following code.
DbConnection ...
- 2,743
6
votes
2
answers
28k
views
What is the default value of IMEX in OLEDB?
string strConn = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" + filename + ";Extended Properties=\"Excel 12.0 Xml;HDR=Yes;IMEX=1\";";
I search on google, and got no results. I think the default ...
- 187
6
votes
2
answers
19k
views
Load csv into oleDB and force all inferred datatypes to string
Im trying to load a csv file into a datatable using oledb.
This is no problem but unfortunately one of the fields which looks numeric has a string value in about 3% of the fields and so is not being ...
- 4,828
4
votes
2
answers
5k
views
Changing Application Name on SQL Server Connection
Can the Application Name passed to SQL Server (via the ADO Connection string) be changed once the connection is open without closing and re-opening the connection?
In particular, I'm using ADO, not ...
- 605
4
votes
2
answers
14k
views
OLEDB connection string for excel 2013
I'm trying to adapt my old connection string to an excel 2007 file for an excel 2013 file (.xlsx)
Here is my old one:
strConnectionString = string.Format(
"Provider=Microsoft.ACE.OLEDB.12.0;Data ...
- 113
3
votes
3
answers
7k
views
OleDb Connection not reading all the rows from excel file
I am using an OleDb in C# connection to read data from an Excel sheet. And fill it in a Datatable.
The sheet contains 275 rows and 27 columns. After I read it, Rows 1,2 and 3 are empty. All the other ...
- 10.3k
3
votes
3
answers
16k
views
Can OLEDB connection strings be configured to use Windows Authentication?
My knowledge on OLEDB is minimal at best.
Is there a way to build a connection string to use a trusted Windows authentication rather than using User ID and Password?
- 1,180
3
votes
1
answer
4k
views
Increase connection pool size in OLE DB connection string
I am attempting to increase the pool size in the connection string for an SSIS package that connects to an Access database on my desktop (holy run-on sentence...). I can not find the synatx for doing ...
- 10.5k
2
votes
2
answers
33k
views
SSL / certificate validation error in spite of TrustServerCertificate=true in connection string
At first, please note that I am aware that this question has already been asked several times. However, the accepted (and non-accepted) solutions given so far did not work in my case, so something ...
- 4,135
2
votes
2
answers
422
views
Excel VBA to parse SQL Connection Strings
I have an Excel VBA that connects to a SQL DB using the connection strings, but I would like to know if it's possible to parse into the connection string from a cell? For instance, if I have SQLSVR1\...
- 23
2
votes
2
answers
3k
views
SSIS 2012 Dynamic OLE DB ConnectionString using a parameter
I have a project which I will need to deploy to servers not in our network and thus will not know certain attributes such as the server and database names. So I set up a parameter in the "Project....
- 21
2
votes
2
answers
3k
views
C# Excel INSERT Error using OleDb and the Access Database Engine
All, there are many question on this subject but none solve my problem. I have written a fairly involved routine to export a passed DataSet/DataTable to Excel (I have Office 2010 running under Win7) ...
- 23.6k
2
votes
0
answers
71
views
ConnectionString Jet.OLEDB.4.0 | read Localdb from serverside
I have following
ConnectionString='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db\;Persist Security Info=False;Extended Properties="dBASE IV"'
ProviderName="System.Data.OleDb" SelectCommand="...
- 35
2
votes
1
answer
3k
views
How do I setup OLEDB to connect to a remote database?
I am locally running an Oracle 11g database. I have a small program connecting to it in code via OLEDB in VC++ (It only runs some database tests, I'm making sure I have all the basics down before I go ...
- 787
2
votes
3
answers
2k
views
c#, oledb connection string issue
I'm using .net4.0 and c# language.
In my code i have a connection string
oleConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;
Data Source = " + filepath + ";
...
- 173
1
vote
3
answers
241
views
MsAccess Database
I'm trying to have my connection string to connect to my Access database but I encountered this problem.
When I wrote this as the connection string:
string cs = "Provider=Microsoft.ACE.OLEDB.12.0;...
- 11
1
vote
1
answer
561
views
How are OLE DB connection strings mapped to DLLs?
How does the OleDbConnection constructor know what provider DLL (I assume it's a DLL) to call for a given provider name in the connection string? For example, in the following code...
string cnStr = "...
- 19.2k
1
vote
7
answers
2k
views
What is best way to read CSV data?
I am using C# and trying to read a CSV by using this connection string;
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\rajesh.yadava\Desktop\orcad;Extended Properties="Text;...
Rajesh
1
vote
2
answers
2k
views
Cannot set Connection String to LocalDb using OLEDB
Good morning guys,
I feel quite silly to ask this question, but I have looked everywhere and possibly at all questions in this matter and could not find a solution that would work for me.
Long ...
- 77
1
vote
2
answers
5k
views
IMEX=1 seems to have no effect
I use ADODB to pull data from Excel file to another Excel file without opening the source. I have a strong suspicion that the IMEX=1 parameter is not accepted in my connection. I start my connection ...
- 23.7k
1
vote
1
answer
7k
views
Microsoft.ACE.OLEDB.12.0 driver for x64 app - how to make it work with x86 MS Office installed?
Microsoft.ACE.OLEDB.12.0 driver is not working on my PC, I am trying to fix it.
Error on connection opening is: "Provider cannot be found. It may not be properly installed."
Here is what i got now:
...
- 6,807
1
vote
1
answer
2k
views
Strange Thing: getting error if using SQLOLEDB instead of ODBC in connection string
BACKGROUND:
Our Classic ASP & SQL Server based application was working perfectly with ODBC connection string.
However, after a recent windows update, application went DOWN, application was ...
- 334
1
vote
1
answer
2k
views
Reading excel data when the file is open
Few days back I asked a question but could not find enough answers. I analyzed the problem a bit more and decided to create a new thread. If I should have not, let me know or close the question.
I ...
- 11.6k
1
vote
1
answer
229
views
VB.Net OleDb Connecting to Previous Source
I have a simple application that's retrieving data from two different sources using the same OleDb provider. If I click btnSource1 it's supposed to retrieve data from url1 and if I click btnSource2 it'...
- 656
1
vote
1
answer
713
views
Connecting Azure Analysis services from Node.js
I am trying to connect Azure Analysis Services with connection string from Node js api. I am using OLEDB module for this connectivity.
Problem is: When I try to connect, Login prompt is getting ...
- 11
1
vote
1
answer
279
views
get old values of connectionstring from app.config
I have an existing connectionString in my app.config and I want to read all the properties. The connection string is something like below
<add name="Toast" connectionString="Provider=SQLNCLI10.1;...
- 55
1
vote
1
answer
1k
views
A design pattern to decide what SQL query to choose
I am developing a Winforms application that contains a connection string to connect to a SQL Server database and say I have 15 different queries that I need to run throughout my program called query1, ...
- 7,170
1
vote
1
answer
11k
views
Finding the correct OleDb connection string VB.Net
I am creating a 32bit app on an old XP machine, this app will run on Win7 or later as well.
so I am trying to test for what connection string will work. Such as:
Private Function test_ace_or_jet(...
- 2,576
1
vote
3
answers
2k
views
C# extract formatted text from Excel through OLEDB
I am reading data from a large excel file which has got formatted texts. I extract the data to DataTable object through oleDBConnection & GetOleDbSchemaTable. But the extracted data doesn't ...
- 418
1
vote
1
answer
591
views
Provide a URI as a parameter for an ODBC or OleDB provider connection string?
Is there any way of specifying a URI (rather than a physical path) as the "Data Source" parameter in an OleDB connection string, or the "Dbq" parameter in an ODBC connection string, such that the ...
- 117k
1
vote
0
answers
127
views
File already in use with database MS-ACCESS in VB.NET
I'm trying to open the database by access and then I run the application in vb.net then an error appears
File already in use.
If I don't open the MS-ACCESS database then running the application has no ...
user22579796
1
vote
0
answers
576
views
Oracle connection string provider error from OraOLEDB.Oracle to MSDAORA.1
When I change my Oracle connectionstring provider from "OraOLEDB.Oracle" to "MSDAORA.1"
it's not connecting and giving "ORA-01017: invalid username/password; logon denied&...
1
vote
0
answers
562
views
Microsoft OLE DB Provider for DB2 V6 connection time out and command timeout not working
I am using Microsoft OLE DB Provider for DB2 V6 provider to connect to db2 database in my .NET 4.5.2 application using C# and this is my connection string:
Provider=DB2OLEDB.1;Password=xxx;Persist ...
- 21
1
vote
1
answer
1k
views
External table is not in the expected format for xls file
I have problem in connection while getting datas from excel. It is working very well in .xlsx file but it is not worked fot .xls file for format of Excel 8.0. How can I solve this problem? I tried to ...
- 49
1
vote
1
answer
409
views
ConnectionString property. The connection's current state
Here is the current coding for my login form
Option Strict On
'-------------------------------------------
' Imports required for DB Connectivity
'------------------------------------------
Imports ...
- 81
1
vote
1
answer
2k
views
Make connection string ADO.NET
How can you make a connection string for an OleDbConnection? I have tried a lot of combinations and variants, but nothing works. I use a MS-SQL platform with C# to make the connection for SQL EXPRESS.
...
- 14.1k
1
vote
1
answer
1k
views
OraOleDB Provider error
I have created a website that has an oracle connection in it that works when I launch it in Visual Web Developer Express. However, when I launch the site from the server on IIS 7, I get
The 'OraOleDB....
- 31
1
vote
0
answers
625
views
excel data to datagridview through dataset using OLE skips the initial blank rows and blank columns
I am using OLE related API's for reading data to DataSet and later to view in DataGridView. The source is an excel file. If the first row or column is empty than that row or column is getting skipped. ...
- 418
1
vote
0
answers
474
views
Excel OLEDB /Jet connection strings & %APPDATA%
I have what is likely a common scenario. I have an MS-Access application split into front-end and back-end files. I want to set up users with an Excel spreadsheet that connects to data on the back-end....
- 1,292
1
vote
2
answers
3k
views
ACE Oledb 12.0 and XLSX problems
I'm using the following code to set a connection string on my local PC that has Office 2007, SQL Server 2008:
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + MapPath(Request....
- 4,498
1
vote
0
answers
956
views
Intermittent Oledb connection error "Cannot open database ''."
We are occasionally seeing this error:
Cannot open database ''. It may not
be a database that your application
recognizes, or the file may be
corrupt.
This is a Winforms .NET 2.0 product on ...
- 15.8k
0
votes
2
answers
144
views
What does it mean if I don't provide an InitialCatalog in a OLEDB connection string?
I have a connection string (to an SQLServer 2005 database) which specifies a server, username and password, but does not specify an InitialCatalog. When I try and open connection it works, and I can ...
- 32.8k
0
votes
2
answers
4k
views
Hard code credentials in MS Access connection string (password protected)
I want to hardcode the credentials for connection to an Access database.
My connection string currently looks like
$strConn = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = $dbName;
And this ...
- 315
0
votes
1
answer
334
views
Problem with Excel file reading with C# , ACE problem
I have read a lot of information about this issue.
And there are many questions in SO for this , but the problem still remains and it is the following:
I have understand that this connection string ...
- 841
0
votes
2
answers
239
views
Why doesn't the update OLEDB query do nothing?
I'm using OLEDB in my program to update an excel sheet. The Execute returns 1 as row update count, but doesn't change nothing.
My code is as below:
public static void updateExcel(string sql, string ...
- 46
0
votes
1
answer
363
views
Using a variable in connection string for a portion of Database name so it doesnt have to be hard coded for every user
My program uses a Database that is named (County Hunter - K8EMS.mdb) on my computer. What I want to do is use a variable that a user can enter on their screen and pick the DB to search on their ...
0
votes
1
answer
3k
views
DB2 Connection String in IBM iSeries/AS 400
I tried searching in the internet for the right connection string for this DB2. Just wanted to know if anyone is familiar with this. Below are the details of the database I want to connect to.
Driver ...
- 21