Search DaniWeb - oledb

Re: How to open an Excel Document in VB.NET 3 Weeks Ago by JamesMichaelm I see it's been a while since you posted, but I'm curious if anyone here has tried using the Open XML SDK instead of Interop or OleDb for reading Excel files. I found it faster and doesn't require Excel to be installed, though it can be more complex for writing. Wondering how others handle big Excel files or ones with tricky formatting? Re: OLEDB "select, where, like" Query 14 Years Ago by Momerath OleDB doesn't handle the SQL query at all, it just passes it to the database. So I don't understand why you think a where clause won't work, unless your database doesn't support them. OLEDB 12 Years Ago by sayakc5 … code i get an error ...as follows.. The 'Microsoft.JET.OLEDB.4.0' provider is not registered on the local machine… oledb issue 14 Years Ago by tendaimare … Public Shared Function getAllTableNames() As String() Dim con As OleDb.OleDbConnection Dim com As New OleDbCommand Dim i As Integer…Connection = con Dim dtable As DataTable Try dtable = con.GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "… Oledb Context 14 Years Ago by tet3828 …System.Windows.Forms; using System.IO; using System.Data.OleDb; namespace WindowsFormsApplication1 { public partial class formProcessor : Form {…shifts.mdb;"; cnn = new System.Data.OleDb.OleDbConnection(connetionString); try { cnn.Open(); MessageBox.… Re: OLEDB Connection Issue 14 Years Ago by Mike Askew …; & SelectedProduct & "';" DA = New OleDb.OleDbDataAdapter(SQL, Con) DA.Fill(DS, "Stock") …; & SelectedProduct & "';" DA = New OleDb.OleDbDataAdapter(SQL, Con) DA.Fill(DS, "Location") … Re: OLEDB Insert Into statement and parameter questions 14 Years Ago by ticktock …StackTrace: at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams,…behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at CalendarApplicationLibrary.MeetingEntryDA.WriteDataToFile(… Re: oledb issue 14 Years Ago by tendaimare I have removed the server name and other sensitive infor but it looks a little like this: [CODE] con = New OleDb.OleDbConnection("provider=OleDb;server=sql...;uid=....;pwd=....;database=.....") [/CODE] OLEDB Connection Issue 14 Years Ago by Mike Askew …; & SelectedProduct & ";" DA = New OleDb.OleDbDataAdapter(SQL, Con) DA.Fill(DS, "Stock") …; & SelectedProduct & "';" DA = New OleDb.OleDbDataAdapter(SQL, Con) DA.Fill(DS, "Location") … OleDB Update Database Problem 11 Years Ago by bogdan.buduroiu …"SELECT * FROM tbl_Transaction" Dim cb As New OleDb.OleDbCommandBuilder(da) Dim dsNewRow As DataRow ... Private Sub SaveToLog…() Try da = New OleDb.OleDbDataAdapter(sqlStat, cnn) da.Fill(dSet, "TransactionLog"… Re: OleDB Connection 20 Years Ago by snufse … or ?? Code: Imports System.Data.OleDb Dim myAS400Connection As New OleDb.OleDbConnection Dim myAS400Command As New OleDb.OleDbCommand myAS400Connection.ConnectionString = "Provider=… does not support COM aggregation. Exception Details: System.Data.OleDb.OleDbException: Non-NULL controlling IUnknown was specified, and either … OLEDB using ConfigurationManager 14 Years Ago by ypdev …; using System.Data.SqlClient; using System.Data; using System.Data.OleDb; using System.Configuration; public class acData : IHttpHandler { public void ProcessRequest… connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=db.mdb; Jet OLEDB:Database Password=pass;")) //using (SqlConnection… OLEDB Connection Test Problem 14 Years Ago by jamshed ahmed …'con = New OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=C:\Develop\trainingapps\PCM\…;) 'con = New OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + My.Settings.ConnectionAccess…;) con = New OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + DbPath + … Re: OLEDB decimal issue 15 Years Ago by TobbeK … anyone experienced this problem with Excel data types below and OLEDB . Excel using is own set of datatypes, and this …why some datatypes cannot be read from Excel sheet into OLEDB. Is it possible to convert any Excel data type …to plain string for use in OLEDB DataReader used in my provided code in earlier post. Excel… Re: OLEDB "select, where, like" Query 14 Years Ago by Mike Askew …when this SQL is now executed through my OLEDB connection I get a negative response. Below …Provider 'DBS = Source DBP = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" DBS = "Data Source = H:\… searching and fills data adapter DA = New OleDb.OleDbDataAdapter(SQL, Connection) 'Fills data sheet from… Re: OLEDB Connection Issue 14 Years Ago by prvnkmr194 … WHERE Product_Number = '" & SelectedProduct & "';" DA = New OleDb.OleDbDataAdapter(SQL, Con) DA.Fill(DS, "Stock") MaxLocations… Re: OLEDB Connection Issue 14 Years Ago by prvnkmr194 … WHERE Product_Number = '" & SelectedProduct & "';" DA = New OleDb.OleDbDataAdapter(SQL, Con) DA.Fill(DS, "Stock") MaxLocations… OleDB Connection 20 Years Ago by snufse …me what to do. Thanks Code: Dim myAS400Connection As New OleDb.OleDbConnection myAS400Connection.ConnectionString = ("Provider=SNAOLEDB;" &…") myAS400Connection.Open() Error: Exception Details: System.Data.OleDb.OleDbException: No error information available: REGDB_E_CLASSNOTREG(0x80040154). Line 46… Re: OleDB Connection 18 Years Ago by amolasu … me what to do. Thanks Code: Dim myAS400Connection As New OleDb.OleDbConnection myAS400Connection.ConnectionString = ("Provider=SNAOLEDB;" & _…=vbuser") myAS400Connection.Open() Error: Exception Details: System.Data.OleDb.OleDbException: No error information available: REGDB_E_CLASSNOTREG(0x80040154). Line 46: … OleDb in C# Express? 17 Years Ago by fishsqzr I can't seem to get OleDb controls to show up in C# Express. Are they excluded … code so long as I add "using.System.Data.OleDb". Using them in code alone is a pain. Does… OleDb database retrieval 15 Years Ago by sephora … data from an SQLBase database using C#.net, System.Data.OleDb namespace on visual studios 2008. i have executed the SQL….Linq; using System.Text; using System.Data; using System.Data.OleDb; using AmlibObjects; using AmlibdataBase; namespace DataTest { public class Program { protected… oledb database update problem 15 Years Ago by Raged …]Dim cn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Hospital.accdb" Dim connString As… String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Hospital.accdb" Dim connection As… OLEDB decimal issue 15 Years Ago by TobbeK … parse foreign decimal/double values from a Excel file with OLEDB? However, searches on Google shows this is not a new… I have tested ALL OF THE existing datatypes according to OLEDB. And yes I have done searches on Google. Re: OLEDB decimal issue 15 Years Ago by TobbeK … string for Excel connectionStringExcel = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileNameExcel + ";Extended Properties=\'Excel… string for Access ConnectionStringAccess = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileNameAccess + ";Persist security Info… oledb to read Excel file 15 Years Ago by KatyHex I have always used Excel.interop before but I thought oledb would be simpler because, for this application, I only have … System.EventArgs) Handles btnSubmit.Click sExcelConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = c:\myfile.xls; Extended Properties="… OLEDB "select, where, like" Query 14 Years Ago by Mike Askew … reading around it has come to my attention that an OLEDB connection will not handle the SQL query below as it… put into a listbox. Is there anyway to make the OLEDB SQL query work so that the returned entries will correctly… Oledb excel writing - error - dataset 13 Years Ago by deva.v Hi i am trying to write dataset into excel using oledb connection. I get an error "The microsoft access database … dataset. [code] Dim excelConn As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=""E:\Test1.xls"… OLEDB syntax error 11 Years Ago by kindofsudden … NO error on the following code: Dim cmd As New OleDb.OleDbCommand("CREATE TABLE [" + empTableName + "] ([ID] DOUBLE, "…. Can anyone tell me why? Thanks! Dim cmd2 As New OleDb.OleDbCommand("CREATE TABLE [" + bulkCashAmountsTableName + "] ([ID] DOUBLE, "… Re: oledb v/s odbc 16 Years Ago by Jx_Man …://database.ittoolbox.com/documents/popular-q-and-a/odbc-vs-oledb-2412"]http://database.ittoolbox.com/documents/popular-q-and…-a/odbc-vs-oledb-2412[/URL] [URL="http://www.issociate.de/board/goto… Re: oledb database update problem 15 Years Ago by Raged … well as adding this line [CODE] Dim cb As New OleDb.OleDbCommandBuilder(DAHospital)[/CODE] however I am still getting the error…