Все вопросы: [oledb]

179 вопросов

похожие теги:
0
голосов
1ответов
523 просмотров

Formatting results using SQL select with JET

I have data in Excel files that I am pulling out using the MS JET OLEDB provider. The results of my select are being passed into a component that I cannot change to generate an HTML table on the fly. Some of my data files contain numbers that I need formatted with commas (#,###). As I said I c...

0
голосов
1ответов
608 просмотров

sp_FuzzyLookupTableMaintenanceInstall not found while running SSIS package

I have an error while running a SSIS package: DTS_E_OLEDBERROR. An OLE DB Error has ocurred..... "Could not find stored procedure sys.sp_FuzzyLookupTableMaintenanceInstall" I connect to to my db and I´m able to find the stored procedure. sp_FuzzyLookupTableMaintenanceInstall sys assembly stor...

3
голосов
3ответов
6396 просмотров

How to Open a CSV or XLS with Jet OLEDB and attain Table Lock?

I am trying to figure out how to read/write lock a CSV or XLS file when I read it as a Database via Jet OLEDB. The following code will open a CSV as a DB and load it into a DataTable object: private DataTable OpenCSVasDB(string fullFileName) { string file = Path.GetFi...

6
голосов
6ответов
19077 просмотров

Data type mismatch in criteria expression | Access, OleDb, C#

I read/update data from MS Access using C#. My code is: public static void UpdateLastLogin(int userid, DateTime logintime) ///logintime = DateTime.Now { string sql = @"UPDATE [Customers] SET [LastLogin]=?"; OleDbParameter[] prms = new OleDbParameter[] { new OleDbParameter("@LastLog...

0
голосов
1ответов
129 просмотров

Could inner excel row properties could affect oledb visibility?

ader doesn't show the first row of xls file, selected with select * from [sheet$]. Probably some inner excel row properties could affect oledb visibility?

1
голосов
2ответов
364 просмотров

Need JET 4.0 Drivers

I am using an ExcelProvider with Microsoft.Jet.OLEDB.4.0 and am getting the Cannot Find Installable ISAM from the production machine. Windows Server 2003. I've searched and search for this download. I've Office installed on the Dev machine, so I'm sure that's why it works fine on my end. But ...

6
голосов
1ответов
3045 просмотров

How do I keep an OleDbConnection from trying to enlist in a distributed transaction?

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 (which is inside a TransactionScope()) using (OleDbConnection conn = new OleDbConnection(connectionS...

14
голосов
5ответов
35825 просмотров

There is insufficient system memory in resource pool 'internal'

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 123, Server BRECK-PC\SQLEXPRESS, Line 2 There is insufficient system memory in resource pool 'interna...

0
голосов
2ответов
201 просмотров

What database technology to use for legacy application?

I am looking for advice. I know stackoverflow likes "answerable" questions, I hope this is. I have a large legacy (Windows) application, using a proprietary (ISAM) database. I wish to investigate moving it over to using a SQL database: primarily MS SQL Server, I wouldn't mind Oracle flexibilit...

8
голосов
4ответов
7676 просмотров

Jet Engine - 255 character truncation

I'm needing to import an Excel spreadsheet into my program and have the following code: string connectionString = String.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;IMEX=1;HDR=NO;""", MyExcelFile.xls); command.CommandText = "SELECT * FROM [Sheet1$]"...

2
голосов
2ответов
1973 просмотров

VSTO merged cells

Is there any way in VSTO (/JET OLEDB or other methods of reading excel files) to tell if the data comes from a single cell or merged range of cells and get this range ?

0
голосов
1ответов
649 просмотров

Locking .MDB record and table in .NET

I am trying to lock a record from a .mdb with OLEDB using .NET. How do I do that? How can I lock an entire table as well?

1
голосов
2ответов
1722 просмотров

SELECT through oledbcommand in vb.net not picking up recent changes

I'm using the following code to work out the next unique Order Number in an access database. ServerDB is a "System.Data.OleDb.OleDbConnection" Dim command As New OleDb.OleDbCommand("", serverDB) command.CommandText = "SELECT max (ORDERNO) FROM WORKORDR" iOrder = command.ExecuteScalar() NewOrderN...

1
голосов
1ответов
404 просмотров

Storing diverse value types in a database

I need to store key-value pairs in a database, where key is either e.g. a string, and value can be one of multiple types (integer, string, float/date, GUID, BLOB). The Database is accessed through OLE DB, so I want need to stick to "normal" types. They keys might be involved in "exists" queries,...

17
голосов
3ответов
14501 просмотров

OleDbCommand parameters order and priority

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 fin = @dtFin Then I add the parameters this way, notice that the two last parameters are switched, I...

1
голосов
1ответов
2297 просмотров

How can I specify the character encoding to be used by OLEDB when querying a DBF?

Is it possible to specify which character encoding should be used by OLEDB when querying a DBF file? A possible work-around would be to encode the query string before the OLEDB call to the DBF file's character encoding and then encode all the results when they are returned. This will work but i...

3
голосов
4ответов
13943 просмотров

.Net System.OutOfMemoryException filling a datatable

I need to extract data from a .dbf file and transform it into xml. I wrote a routine that does it just fine. However now we are encountering very large .dbf files - like 2GB +. And this code throws an OutOfMemoryException on those files. Public Function GetData() As DataTable Dim dt As Ne...

0
голосов
2ответов
751 просмотров

Excel OleConnection Insert Statements

How would insert a row into an excel document. This is what I have. String connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + file_path + ";Extended Properties=Excel 8.0;"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); OleDbConnection...

2
голосов
1ответов
5688 просмотров

Connect a Pervasive DB using OLE DB

We have a existing closed source third party application using a Pervasive PSQL database. For Example the PSQL are located in the directory c:\test and have names like holiday.dat, offers.dat and so on. I want to read and if possible write to these files without having installed the Pervasive Wor...

0
голосов
1ответов
3515 просмотров

ASP.NET OleDb Excel Connection to Worksheet

I have an Excel file that the customer is pulling from their financial software and uploading to my web app. I need to connect to the file through ADO and read its contents into a SQL database. The problem is that the file that comes from the financial software is a standalone Excel Worksheet...

5
голосов
2ответов
8435 просмотров

DataTable.Merge and DataTable.ImportRow does not change RowState

I am having issues with ADO.NET 2.0 merging/importing data. I need to update/insert data from one generic table to another table with both tables maintaining an identical schema. The following code works great locally, but does not make changes to the database: OleDbDataAdapter localDA...

26
голосов
7ответов
28099 просмотров

c# reading csv file gives not a valid path

I can't seem to read a .csv file using the following connection string: var fileName = string.Format("{0}{1}", AppDomain.CurrentDomain.BaseDirectory, "Uploads\countrylist.csv"); string connectionString = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}; Extended Properties=""tex...

2
голосов
5ответов
12288 просмотров

Connect to OLEDB data source from Java?

We are trying to connect to a SQL Server instance used by the ACT CRM system. They have managed to lock things down so it isn't possible to connect to the SQL back-end using ODBC (there is some special utility that will add ODBC support that you can install if you purchase the primo version of t...

37
голосов
9ответов
65118 просмотров

Getting the first sheet from an Excel document regardless of sheet name with OleDb

I have users that name their sheets all sorts of crazy things, but I want to be able to get the first sheet of the Excel document regardless of what it is named. I currently use: OleDbDataAdapter adapter = new OleDbDataAdapter( "SELECT * FROM [sheetName$]", connString); How would I go about...

3
голосов
6ответов
4329 просмотров

Using .NET to get data from Excel as a database

I would like get data from Excel files using .NET The Excel file is being used so I can't open it. What I do is connect to it as a datasource using OleDB. The problem is that I get a cell's data but not its style. A date value in Excel changes into a datetime format in .NET and a cell set as cu...

0
голосов
1ответов
4119 просмотров

Update command to update single row in Excel using OLEdb and dataaset. (C#)

I am importing data from Excel an spreadsheet. I am only using OLEDB to read. But i am having trouble saving the result back to the original file. Below is my code so far. string ExcelConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Mode=ReadWrite;" + "E...

1
голосов
1ответов
1179 просмотров

Opening a simple OleDB connection throws OutOfMemory Exception?

I am having troubles with one of our applications. It's .NET 3.5 32 bits process. Upon startup we open a .mdb to read a few "metadata" values. This works on hundreds of systems, but we have a customer with a TabletPC and problems. The operating system is Windows XP Tablet PC SP3, 32 bits, bla bla...

0
голосов
2ответов
17616 просмотров

mysql oledb driver

how to install mysql oledb driver in local system. please give Mysql oledb Connection string

0
голосов
1ответов
2120 просмотров

How to troubleshoot "Property value is invalid. Make sure the value is typed correctly."?

I'm calling a COM library from .NET through a interop assembly and getting the following error: System.Runtime.InteropServices.COMException(0x80040200): Internal error (ADODB.Connection, -2147467259, Property value is invalid. Make sure the value is typed correctly.) I have a test and a product...

11
голосов
4ответов
32145 просмотров

Read password protected excel file using OLEDB in C#

In my c# application I am using OLEDB connection string "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test.xls;Extended Properties=\"Excel 8.0;HDR=NO;ReadOnly=true;IMEX=1\"" to read Excel files. In order to read a password protected file I tried adding password field in connection string but w...