oledb Questions
1
Solved
I have a database in .ACCDB format with some tables.
I'm successfully loading it into an OleDbDataReader with the following code:
string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;data...
1
Solved
I've recently made another question about connecting to MS-ACCESS database with .NET in C# or VB.NET. It worked just as intended with MDB, but with accdb it caused an exception in
conn.Open();
w...
7
Solved
Possible Duplicate:
CSV File Imports in .Net
In .net, is there a standard library that should be used to read in csv files? All the samples on the web roll their own csv reader / pars...
2
Solved
I have simple database in Access .mdb file, but I don't know how to deal with: "parameter not valid" exception when Im creating Image from stream.
I'v read that I need to strip 78 bytes offset (fro...
1
Solved
I am using OleDB to connect to an excel file using this connection string
@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0 Xml;HDR=YES"""
But when I do this (...
Overzealous asked 9/10, 2009 at 17:20
5
Solved
My application will need to reference addresses. Street info will be stored with my main objects but the rest needs to be stored seperately to reduce redundancy. How should I store/retrieve ZIPs, c...
2
Solved
I have text files that are Tab delimited. I created a Schema.ini like so:
[MY_FILE.TAB]
Format=TabDelimited
ColNameHeader=False
Col1=id Short
Col2=data Text
This is the code I use to read it (C#...
Phocis asked 27/11, 2009 at 15:6
1
Solved
Does anyone know a good custom LINQ provider to query data from Excel spreadsheets?
2
Solved
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 bei...
Foramen asked 6/11, 2009 at 15:57
1
Solved
I'm attempting to take Excel 2003 and connect it to SQL Server 2000 to run a few dynamicly generated SQL Queries which ultimately filling certain cells.
I'm attempting to do this via VBA via ADO ...
Unwatched asked 3/11, 2009 at 19:58
5
Solved
SQL Server 2008 Linked Server and ad-hoc INSERTs cause a rapid memory leak which eventually causes the server to become non-responsive and ends with the following error:
Msg 701, Level 17, State 1...
Eufemiaeugen asked 8/10, 2009 at 13:30
3
Solved
I have been debugging this query for the last 40 minutes, and the problem apparently is the order of the parameters after all.
SELECT * FROM tblSomeThing WHERE id = @id AND debut = @dtDebut AND fi...
3
I have an Access file with 7 fields:
DocID - text - primary
SourceID - text
ReceivedDay - Date/Time
Summary - text
DueDay - Date/Time
Person - text
Status - Yes/No
Now I want to update this fil...
3
Solved
Can I use PHP with Oledb connection?
As far as I know database connection as provided by PHP extension are all odbc.
5
Solved
I'm using OleDb to select data from excel spreadsheets. Each spreadsheet can contain many small tables, and possibly furniture like titles and labels. So it might look like this, where we have two ...
3
Solved
I found this question here: OLEDB v/s ODBC
Which gave me more information, but did not really answer the question I'm asking, so I shall proceed from there.
I am working in C#. I'll spare you the...
2
Solved
We are upgrading/converting several old Access databases to MS-SQL. Many of these databases have OLE Object fields that store PDF files. I'm looking for a way to extract these files and store them ...
5
As part of a project I'm working on in C# I need to read in a .dbf file. The first thing I want to do is to get the schema table from the file. I have code that works as long as the filename (witho...
6
Solved
I'm creating an Access DB for use in an C# application at school. I've not had much experience working with DB's so if this sounds stupid just ignore it. I want the user to be able to select all th...
Hayashi asked 8/4, 2009 at 21:18
1
Solved
Apparently (MSDN) sometimes OleDbConnection.ResetState() does nothing, so even if the connection fails OleDbConnection.State will still be set to Open. I am looking for best workaround for this, so...
Rudiger asked 9/3, 2009 at 16:26
3
Solved
I'm working on a stock exchange information platform and we are thinking in provide a link between our platform and home-made Excel files. The financial market is still bound to the old DDE server ...
Tenney asked 26/12, 2008 at 17:5
1
Solved
When communicating to a SQL Server database using one of the typical systems, ODBC, OLEDB or ADO.NET, is the underlying basic protocol the same? Are all the differences between these systems basica...
Thora asked 27/11, 2008 at 2:4
1
Solved
What is the difference between OLEDB and ODBC? When do I use which and how do I know what I am looking at is a OLEDB driver v/s an ODBC driver?
1
Solved
I'm trying to create an OleDb connection to an Excel file that is located on a SharePoint server. The example code I'm playing with at the moment throws an OleDb exception "Invalid internet address...
7
Solved
I have a query that I'm executing from a .NET application to a SQL Server database and it seems to take quite a while to complete (5+ Minutes). I created a test app in c# to try to see what was tal...
Smithy asked 29/9, 2008 at 18:32
© 2022 - 2024 — McMap. All rights reserved.