Click here to Skip to main content
15,867,453 members
Everything / OleDb

OleDb

OleDb

Great Reads

by Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
by Sujith Karivelil
In Master - Slave replication, Changes in master will reflect in Slave. but any changes made in the slave Database will not reflect back in Master, this article will help you to implement Bidirectional Replication.
by Ryszard Dżegan
How to get around restrictions for parameters in OLE DB connection type while working with SSIS and BIDS.
by Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.

Latest Articles

by DiponRoy
Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.
by WernfriedD
Single .exe to verify if your Oracle Client is properly installed and working. Verify supported technologies for Oracle connection.
by Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)

All Articles

Sort by Score

OleDb 

29 Dec 2015 by Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
28 Jan 2015 by Sujith Karivelil
In Master - Slave replication, Changes in master will reflect in Slave. but any changes made in the slave Database will not reflect back in Master, this article will help you to implement Bidirectional Replication.
30 Jan 2013 by Mantu Singh
Use the following code as the Excel 2007 vcersion files are Excel 12.0Dim connectionString As String =[String].Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1;""", filepath)Best of luck!!
17 Nov 2016 by Richard Deeming
As I suspected, you're sharing a single OleDbConnection instance across multiple calls. All of the errors you're describing are caused by multiple threads trying to access that single object at the same time.For example:Thread 1: Gconn = New OleDb.OleDbConnectionThread 1:...
11 Feb 2013 by Jibesh
Update your insert statement like thiscmd.CommandText = "INSERT INTO Accountstbl (Username, Password)" + " VALUES (@Username,@Password)";this is because you are already passing the arguments to the query parametercmd.Parameters.AddWithValue("@Username",...
1 Jul 2014 by Ryszard Dżegan
How to get around restrictions for parameters in OLE DB connection type while working with SSIS and BIDS.
10 Apr 2015 by Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
30 Jan 2013 by bbirajdar
You need OLEDB 12 drivers installed on your machine.Install from this linkhttp://www.microsoft.com/en-us/download/details.aspx?id=13255[^]And the code will be like this .string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFileName + ";Extended...
4 Feb 2013 by Adam R Harris
Forget OleDb and look at LINQ.There are a few great articles here regarding parsing CSV files with LINQ, after a quick search this is the best one i found: LINQ to CSV library[^]
27 Jun 2013 by Pheonyx
I would suggest re-instantiating your redr object for each iteration of the outer loop as I do not believe there is a way to more an OLEDBReader back to the start.As an alternative you could populate a datatable with the information then just read through that.so outside your outer loop...
6 Aug 2013 by Zoltán Zörgő
Not this way, since the ole interface is giving you access to the cells only. The images are not in the cells, they are separate objects shown above the actual Excel grid. But you can use Excel interop[^] or third party libraries that can read excel files without excel being installed. But with...
24 Aug 2013 by Dave Kreskowiak
That code does not update a DGV. It updates a DataTable, which you then have to bind to a DGV.You can find an example of using the OleDataAdapter here[^].
14 Mar 2015 by Dave Kreskowiak
Because you're not using parameterized queries your result SQL statement looks like this:select count(*) from [LoginDB] where (Username ='username') = (Password'password')See anything wrong with that statement?Because of the string concatenation stuff you're not seeing the problem in...
28 Jan 2016 by OriginalGriff
If you mean that you have taken an .MDE file that works with Access 2003, and updated it as an .MDB file with a later driver, then the chances are that the file has been corrupted or converted to the later version - which from the point of view of the 2003 application is the same thing. Think...
26 Jun 2016 by OriginalGriff
Don't do it like that. Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.The chances are that this will cure your problem at the same time: it's...
22 Sep 2016 by Wendelius
Try truncating the dates with a query like followingSELECT * FROM srvtrans WHERE DATEVALUE(dt)=DATEVALUE(@a) ORDER BY sno DESCJust use a normal date/time as a parameter value. For more information have a look at DateValue Function - Access[^]
13 Oct 2016 by OriginalGriff
I'm pretty sure that the first thing they would have told you is: Don't do it like that. Never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.And have...
18 May 2017 by Suvendu Shekhar Giri
UPDATE: I am putting a hold to my question. I got some clue and missed few things to mention here. Sorry to waste your valuable time. Will update the question very soon and will post the answer too if I succeed with it. Thanks all for your valuable time. Well, this can be very basic question...
18 May 2017 by Jochen Arndt
I can not give a final answer but stumbled upon this some years ago too. The following is what I can extract from my C++ source code comments. OLE DB (and ODBC) are database interfaces that treat Excel files like databases. They use two kind of table types that are of interest here: System...
10 Mar 2018 by Maciej Los
Take a look at your query: "INSERT INTO DBChild (C_Name,C_Code) VALUES (@Name,@Code) " & "SELECT * FROM DBParent WHERE P_ID = " & UniqeID & ";" You did concatenate 2 queries in one. You can't do this , becuase .ExecuteNonQuery() accepts only INSERT | UPDATE | DELETE statements. You have to...
25 Apr 2018 by Richard Deeming
Looking at your screen-shot, the CurrentMeterReading field is an integer in one table, and a floating-point number in another. The Field extension method does not attempt to change the type of the source field. It simply tries to unbox it to the requested type. If the source type doesn't...
11 Dec 2019 by F-ES Sitecore
Try; OleDbCommand1.Parameters.Clear(); OleDbCommand1.Parameters.AddWithValue("@pivot", pivotValueString); OleDbCommand1.Parameters.AddWithValue("@id", int.Parse(dt.Rows[i]["ID"].ToString()));
5 Jan 2020 by OriginalGriff
No, you can't add a set of credentials to a file path - which is what you'd need to connect to the share and specify the path in an DB connection string. You can do this: Connect to a UNC Path with Credentials[^] - but I'd go with establishing a mapped drive letter to the share in Windows, and...
24 Aug 2021 by OriginalGriff
And autonumber column is the same as any other column, except you can't write to it yourself. So a normal SELECT will retrieve it. If you are trying to INSERT a new row and then get the number that was assigned, then SELECT @@Identity...
11 Oct 2012 by chaau
I have a Notes table with the structure CREATE TABLE Notes (ProviderNo CHAR(9), Note CHAR(29))The wizard has created an Accessor class and probably an additional class that is derived from the accessor class. So you should have something like this.class...
17 Oct 2012 by chaau
you need to initialise the variable for m_ProductId with the status, like this:class CProduct:{public: int m_ProductId; DBSTATUS m_IdStatus; //.. your other columns, like m_Price, m_Quantity, etc BEGIN_COLUMN_MAP(CProduct) COLUMN_ENTRY_STATUS(1, m_ProductId,...
18 Oct 2012 by chaau
use this function to retrieve the errors (pass the HRESULT returned after you called Insert() method) and post it here:CString GetDatabaseError( HRESULT hrErr ){ CDBErrorInfo ErrorInfo; ULONG cRecords; HRESULT hr; ULONG i; CComBSTR bstrDesc,...
24 Oct 2012 by Member 3892343
Hello,I have a strange behaviour of an sql search query, I have added parameters to an oledbcommand object in an sql query, I use a combobox to select the appropriate parameter, the strange thing is at design time when I preview the data and give value to one of the parameters it displays the...
24 Oct 2012 by Frank R. Haugen
So this is a noobish question but I'm failing to get the correct results.I have a table (Data Table 1) in a DB that I have successfully connected to and extracted to a DataSet. Now I used the MSDN-website provided example code to test the information, and the code (Code Snippet 1) prints out...
24 Oct 2012 by Member 3892343
Here is the code but I wonder if it has to do that vb 2008 is without service pack 1, maybe I must update?sql command in oledbcommand (note that in design time "preview data" the command works)SELECT id, car_num, owner, afm1, address, phone, owner2, afm2, address2, phone2, owner3,...
14 Dec 2012 by srikrishnathanthri
Below code is to update a value of one row in MS-ACCESS db.If i use the same code(sqldb) to update sql table , keeping break point on '.commit' then no other connection(user) can read or update the same row (a = 1), but can update other rows of same tableBut for ms-access, keeping break...
10 Jan 2013 by Pete O'Hanlon
ExecuteNonQuery is designed to issue commands like INSERT, DELETE or UPDATE. It's not intended for use in SELECTs. What you could do, is use ExecuteDataReader like this:private List names = new List();public void Search() { using (OleDbCommand ocm = new...
3 Feb 2013 by sagarjainhr
I solved it by my self there was no problem with the connection string and everything was fine over there. The problem was with I was checking whether the file is open or not and I have not closed that file after that process. so it was used by other process and connection string was failing to...
19 Feb 2013 by Lotus90
Hello I'm still getting this error and I try different solutions but it's not work !Here are my code I put the connection string in app.config file like this :
22 Mar 2013 by Prasad Khandekar
Hello,There is no need to have a list of OleDBCommand. IDbCommand infact is used when your SQL is static and only data values are changing e.g. Insert 1000 emplouees. This way database does not have to recompile the SQL each time and there by getting improved performance in such operations....
2 Apr 2013 by SalouaK
I used the below code to create a .DBF file and filling it, everything works fine. The problem is the name of the file is truncated to 8 characters max. Any idea why or how to make maintain the whole name?string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data...
10 May 2013 by Andreas Gieriet
You may have a look at: social.msdn.microsoft.com: 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine[^].CheersAndi
16 May 2013 by kc004
I have resolved the issue by setting the configuration to target x86 platform since my application will run on a 64bit machine after publishing it. I followed following steps:On the Build menu, click Configuration Manager.In the Active solution platform box, select the platform 'x86',...
6 Aug 2013 by Maciej Los
In my opinion it's not possible because of the way in which Excel stores images in its files. Have a look here: http://stackoverflow.com/questions/2632715/retrieve-pictures-from-excel-file-using-oledb[^]
22 Aug 2013 by Trak4Net
You will need something like below. You can create a new datadapter and everything when you go to update the data (from my experience anyways). You will need the dataset and the row states for the dataset should be set to trigger updates for those modified rows. If you accept changes on your...
14 Sep 2013 by Mahesh Bailwal
You can not add new column/field to database table using dataset or datatable you might need to use "ALTER TABLE" with ADO.NET commands. Check below linksHow Can I Insert New Column Into A Database Table Using SqlDataAdapter and DataTable?[^]adding a column to a SQL table in VB using...
12 Nov 2013 by Sergey Alexandrovich Kryukov
Reading file via FTP is totally unrelated to OleDB. Instead, you can use the class System.Net.FtpWebRequest:http://msdn.microsoft.com/en-us/library/system.net.ftpwebrequest%28v=vs.110%29.aspx[^].—SA
17 Dec 2013 by Maciej Los
have a look here: http://www.connectionstrings.com/access/[^]OleDB Tutorial (C#)[^]
3 Mar 2014 by Krunal Rohit
Well, user is a keyword (If I'm not mistaken than it's a inbuilt table) in SQL, So you can't give a table name like that.But still if you want to, you can, but write the query this way,string query = "insert into [user] (username,password) values ('" + textBox1.Text + "','" + textBox2.Text...
27 May 2014 by Richard MacCutchan
According to my tests, it would appear that a filename for OLEDB is restricted to a total of 64 characters, this includes the .csv extension.
22 Aug 2014 by Slacker007
http://stackoverflow.com/quest...
9 Oct 2014 by Maciej Los
Have a look here:How to update an Excel worksheet using DataSet and the OleDbDataAdapter[^]How to update single cell of excel sheet using oledb connection,[^]I believe you'll find an answer there.For further information, please see:Accessing Microsoft Office Data from .NET...
7 Nov 2014 by hrdksanghavi12
Some drivers where installed by Tech Support Team. Which drivers I am not sure. But because of the patches I saw SQL Server Native Client 10 available in ODBC sources and my issue was resolved without any code change.Thanks all for your time.
24 Feb 2015 by Sergey Alexandrovich Kryukov
Bruno Sprecher is right: your approach is wrong from the very beginning. The query composed by concatenation with strings taken from UI. Not only repeated string concatenation is inefficient (because strings are immutable; do I have to explain why it makes repeated concatenation bad?), but there...
5 Mar 2015 by Afzaal Ahmad Zeeshan
That is because you, yourself, personally are throwing this exception in your code when there is no record found in the database. if (obj != null) return obj.ToString();else throw new Exception("No records");This line of code is intended to do what you're seeing. It...
14 Apr 2015 by Sascha Lefèvre
Maybe you know this, but as you speak of DataSets and tables in your question: DataSets are, simply put, a whole database in memory, with potentially multiple tables and possibly relations between those tables. To achieve what you're asking for, you only need two DataTables instead of...
15 May 2015 by Richard Deeming
There are several free and open-source components which will let you do this without needing to have Excel installed. For example:http://epplus.codeplex.com/[^]http://closedxml.codeplex.com/[^]https://github.com/tonyqus/npoi[^]The OpenXML SDK[^];
18 May 2015 by Sergey Alexandrovich Kryukov
Sure. The better alternative could be not using Excel at all. Instead, you can use Microsoft Open XML SDK. Please see my past answers:Microsot office Interop[^],How to add microsoft excel 15.0 object library from Add Reference in MS Visual Studio 2010[^].See also this CodeProject...
14 Oct 2015 by phil.o
Never, ever construct a SQL statement by concatenating strings obtained from user inputs. This leaves your code wide open to SQL injection attacks.Better user parameterized queries instead.Something like:string query = "UPDATE ClientMaster SET SubGroupName = @subGroupName, FirstName =...
14 Oct 2015 by F-ES Sitecore
Change"BranchName = '" + currentSelectedItem.BranchName + "' , " + "WHERE Id = " + currentSelectedItem.Client_Id;to"BranchName = '" + currentSelectedItem.BranchName + "' " + "WHERE Id = " + currentSelectedItem.Client_Id;However you'll also get this error if any of...
17 Jan 2016 by Mycroft Holmes
Bundle code in the where clause need to be surrounded with single quotes. The change from a number to text caused the type mismatch string where = " WHERE B.BundleCode = '" + BundleCode + "'"; string orderBy = " ORDER BY B.BundleOrder";
18 Jan 2016 by Dave Kreskowiak
On top of what Mycroft said, Google for "C# parameterized queries" and start reading. Using string concatenation to build your SQL queries like this opens your code up to SQL Injection Attacks and the possible destruction of your database.
23 Jan 2016 by OriginalGriff
Without your DB table definition we can't be sure, but I'd start by checking your spelling. Is MStaus really the column name, or should you have written:OleDbCommand cmd = new OleDbCommand("Select * from Loan where Plan_Id IS NOT NULL AND MStatus IS NULL ", con);
7 Feb 2016 by Richard MacCutchan
You have two different spellings for your connection object, which one is correct?OleDbConnection _Connection = new OleDbConnection(sConnection);_Connection.Open(); // ***** _Connectionstring cmd = string.Format("Update [{0}$A106880:A106880] set F1 = 12",...
29 May 2016 by Patrice T
Your code can be simplified by rewriting If ls_Site.Items.Count > 0 Then For i As Integer = 0 To ls_Site.Items.Count - 1 If i = 0 Then r = ls_Site.Items(0).ToString ElseIf i > 0 Then r &= ";" &...
4 Jun 2016 by OriginalGriff
If you have an SQL Server cluster set up, then it is very odd to want to use Access directly for anything, let alone for a large scale DB. Access is basically a single user, single access, small system database - and it isn't very good at all when you try to expand beyond that.If you have SQL...
17 Jun 2016 by OriginalGriff
The error is pretty clear:can't cast system.DBNull type to System.Byte[];The value returned from your database isn't data - it's a null. That means that either you didn;t insert an image in that column when you saved the row, or it's the wrong column.Given that you are using SELECT * FROM...
11 Jul 2016 by Ema112
How to export data table to excel in c# using Oledb?I want to transfer data in data table to excel in c# using Oledb provider. I am able to insert few cells using below code:try { string filelocation = @"E:\Alex\Arab_Test_Oledb.xls"; ...
11 Jul 2016 by Karthik_Mahalingam
refer this for exporting datatable to excelc# - Insert DataTable into Excel Using Microsoft Access Database Engine via OleDb - Stack Overflow[^]
7 Aug 2016 by Maciej Los
Connection string seems to be incomplete. Check this: Access connection strings - ConnectionStrings.com[^]For further details, please see:Data Access in Visual C++[^]OLE DB Programming[^]
22 Sep 2016 by Maciej Los
MS Access database engine doesn't know DateTime.Parse(dt)!Change command properties to:b.com.CommandText = "SELECT * FROM srvtrans WHERE dt=@a ORDER BY sno DESC";b.com.Parameters.Add("@a", dtp_srdmy.Value);and everything should be OK.
16 Oct 2016 by BrishPandey
You can use sub query that will return the list of id that satisfy the condition of your join. and in where clause of delete you should use 'in' keyword for filtering
16 Oct 2016 by Suvendu Shekhar Giri
If you want to remove records from both tables - InvoiceItems and TAXINVOICE then try using INNER JOIN, something like following-"DELETE InvoiceNumber,TAXINVOICE FROM InvoiceItems INNER JOIN TAXINVOICE WHERE InvoiceItems.InvoiceNumber=TAXINVOICE.INVOICENO and InvoiceNumber=" +...
17 Oct 2016 by #realJSOP
If you set the appropriate foreign keys, you could delete from one table, and the database will delete related rows in the other table, and you then you won't have to use overly complex queries.
17 Nov 2016 by Richard MacCutchan
See Passing Arguments by Value and by Reference (Visual Basic)[^].
17 Nov 2016 by Jochen Arndt
The passed argument is a "reference class". That means even when using ByVal, a reference is passed but you get a copy of the reference instead of the reference itself (you will not get a copy of the OleDBConnection instance).So the answer to your question is:The existing connection is...
31 Jan 2017 by Suvendu Shekhar Giri
You SQL statement is not correct as it seems.It should be in following syntax-UPDATE table_nameSET column1=value1,column2=value2,...WHERE some_column=some_value;Ref: SQL UPDATE Statement[^] Try something like-sql = "Update [AllPrinting$] SET UserName=@UserName,...
22 May 2017 by Maciej Los
To resolve your issue with Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine error, follow the instruction from: OLEDB Provider is Not Registered on the Local Machine[^]
7 Jul 2017 by RickZeeland
You can use virtual scrolling, see answer here: virtual scrolling in asp.net gridview[^]
7 Jul 2017 by Patrice T
Don't use Excel 2003 as it is limited to 65k rows. Excel 2007 is limited to 1M rows. Excel – a history of rows and columns - Office Watch[^]
19 Sep 2017 by Dave Kreskowiak
Another problem I see. You're repeating the same code over and over again. This is Clue #1 (tm) that you need to put that kind of code in it's own method and call it from where you need it.
27 Dec 2017 by BillWoodruff
To exclude the possibility that you are getting an object that can't be converted to a long, test with another function that uses Int64.TryGetValue, and break on error to examine the data. I would rather use hard-coded Type specific conversion methods, which throw useful errors. Use of...
8 Feb 2018 by OriginalGriff
I wouldn't do it like that. Instead don't use a DateReader, use a DataAdapter, and use the .NET built in code to access the data. This code uses SQL Server instead of OleDb, but it's the same for your DB - I happen to have SSMS open so it's easier for me to play with SQL Server at the moment: ...
10 Mar 2018 by InfinityJoe
Ok Finally I Figure it Out Myself!!, just like i thought before, this problem should be resolved with an simple way somehow :) For those who looking the same answers here's my Working Solutions Try dim UniqeID = 6 'Let's say this number as uniqe for now DB.OpenConnection() 'Open Connection...
25 Apr 2018 by Maciej Los
Using IMEX=1 in connection string - admittedly - avoids crashes during the process of retrieving data for mixed data columns, but it causes OledDb provider to treat data as a text. More details, you'll find here: Microsoft ACE OLEDB 12.0 Connection Strings - ConnectionStrings.com[^] I'd remove...
15 Aug 2018 by F-ES Sitecore
If you use reserved words for tables you put square brackets around them to let it be known you are not referring to the reserved word but a table called that word. OleDbCommand command = new OleDbCommand("SELECT * FROM [note]", con);
15 Aug 2018 by OriginalGriff
"Note" is an access keyword: Access 2007 reserved words and symbols - Access[^] - to use it as a table name it must be escaped: OleDbCommand command = new OleDbCommand("SELECT * FROM [note]", con);
12 Dec 2018 by Member 14087495
I'm trying to update a modified DataSet using OleDb in Vb.Net. I can get to the data and modify it, but I can't seem to be able to update the DateSet. Problem seems to be with CommandBuilder, but I can't find a solution. What I have tried: Dim i As Integer = 0 Dim strA As String = "" ...
27 Aug 2019 by OriginalGriff
It's your connection string, according to the error message. So use the debugger and find out exactly what string the code is using and go from there.
26 Nov 2019 by OriginalGriff
Well ... you read the same data from the DB each time that method is executed - so as long as the DB contains 30 or more items, you will print the first page, tell the system there are more pages to print, and exit. The system will then call you again to print the next page, you will read the...
12 Apr 2021 by Patrice T
Compare those 2 lines cmd = new OleDbCommand("select user from tbl_blogs where book_name='" + txt2_bnm.text + "' ,con); ` // here is missing a double quote ^ ... ...
30 May 2021 by KarstenK
Your starting point should be OLE DB Providers Overview from Microsoft. But I think that your efforts to "ride a dead horse" arent the best investment of time and money. Consider changing the data connection of VFP to the database. My best guess...
17 Aug 2021 by OriginalGriff
The error is pretty explicit and self explanatory: the ACE 12.0 database engine is not installed on the web server. Start here: Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center[^]
6 Oct 2022 by OriginalGriff
It's probably unrelated to the OleDbConnection itself, but we can't tell - none of that code would cause your form to close. And we can't test it, because we have no access to your sytem, data, or other code in your app. So, it's going to be up...
11 Jan 2023 by CHill60
There are several issues with your code, the connection string does not seem to be one of them. 1. You are opening a connection to your database and attempting execute some SQL - but you have not defined where the results should go 2. You are...
1 Nov 2023 by M Imran Ansari
The error message is clear that tha column name 'HOUR' is not being recognized in the table or not spelled correctly, you are trying to insert data into. The INSERT INTO statement contains the following unknown field name: 'HOUR'. Make sure you...
24 Aug 2012 by Wendelius
If I interpreted the question correctly, could it be possible that when you loop through the field names and the values, you're not getting the corresponding elements?So basically instead of using hash table, perhaps using sorted lists or a dictionary of strin, object (field, value) would...
24 Aug 2012 by Samoxin
OK, Mr. Mika, WE GOT IT!I was missing two points here.1. Order of sql statement fields and added parameter names ARE matter even though these two data set independently: e.g."INSERT INTO t1 (f1, f2, f3...) values (?, ?, ?...)" must match IDbCommand.Parameters.Add(param) order,...
24 Aug 2012 by Samoxin
Here are few methods from business class: Public Shared Function GetProperties(Of T)(_classObject As T) As Dictionary(Of String, Object) Dim cT As Type = GetType(T) Dim aL As Dictionary(Of String, String) = GetPropertyList(Of T)() Dim pL As New...
4 Sep 2012 by cell-in
I solved my problem. The problem is about my file name.My file name include a lot of "." character. When i choose the file, i change the file name.fileName.Replace(".", "_")
3 Oct 2012 by ggoutam7
Hello,I am trying to fix this bug. Please help.I am getting below error and no data inserted :"Must declare the scalar variable "@bytImage"." Public Sub InsertFile() Dim sMainFolder As String = "D:\Project" Dim conAccess As Data.OleDb.OleDbConnection ...
3 Oct 2012 by Santhosh Kumar Jayaraman
When using OleDb the parameters in the SQL are to be set to ? and not @bytImage.try thiscommSQL.CommandText = "INSERT INTO [PICS] ([IMAGE]) VALUES (?)"
17 Oct 2012 by thomas_wingfield
I have consumer(class) generated by ATL OLE DB Consumer.CProduct m_products;
25 Oct 2012 by thomas_wingfield
I got trouble when start creating accessor using attributes. I did like this class:[db_source("my connection string")][db_command(" \ SELECT \ ProductId, \ ProductName, \ Company, \ Code, \ Quantity, \ Price, \ Description...