At the MSDN website it says, "Connecting to SQL Azure by using OLE DB is not supported." There are other places on the web where folks report that it works fine for them after tweaking the server name in the connection string, such as here and here. Even SQL Server's Analysis Services uses OLE DB to connect to SQL Azure! I develop a n...
Hi. We are running 64 bit windows 7 with 64 bit office 2010. We have a custom 32 bit OLEDB driver installed but it doesn't show up in the list of data providers when trying to import data into Excel. I've heard that 64 bit and 32 bit don't go well together and that you need to run 32 bit drivers inside the wow64 emulator but how can w...
I'm trying to search the Indexing Service of a remote Windows 2003 server from ASP.NET. There's sample code for this on the MS site, but only for local searches. Here's what I've got so far; the remote server in this example is called "indexserver", isn't on a domain, and has a index called "system": OleDbConnection conn = new OleDbCon...
I have a database in the same workspace, I've tried to connect to this DB using this codes : Dim CX As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & "./Learning.mdb") Dim CX As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & "~/Learning.mdb") Dim CX As O...
Hi, I need to perform a complex import in a Microsoft SQL Server 2000. Since doing it in a DTS is too complicated, I'm trying to do it with a little C# program, but I'm having problems when I need to import a CSV files: this file is using semicolons as field delimiters instead of commas and I can't get the .NET's OLE DB provider to reco...
Hey, I created a button (Next) to navigate in a Table called CHAPTERS; My problem is that the button work Two, and sometimes three times. After that I get [Not specified error]. This is my code : Dim S As Integer = Integer.Parse(Request.QueryString("id")) Dim RQ As String Dim DR As OleDbDataReader RQ = "SELECT ID_C FROM CHAPTRES" ...
This seems really ridiculous.. what am I missing? I have an access database with 5 tables. I want to fill a dataset with the entire contents of the database. Why can't it roughly look like this?: dim dConnection as new oleDbConnection(connection info) dim dAdapter as new oledbdataadapter(SelectCommand, dConnection) dim dSet as oleDb...
Does anyone know how to create an ODBC or OLE driver preferably in C#? What I want to do is creating a custom data source which I can use in Excel and Access. Or do think of another way how to do this? Thanks in advance for your responses! ...
It is possible to run multiple commands or sql script using OLE DB? For example to run sql script to create database and its structure (tables, indexes, stored procedures...). When I use CCommand class, I can run only one command. How can I run SQL script with multiple commands? Thanks, Martin ...
Hi, I want to ask how to select data from DB using OLE DB CRowSet in C++. How to access specific row, specific column etc. like in ADO .NET using DataTable. Can you give me some tutorial please? Thanks ...
I am looking for OLE DB driver to acces SQLite. Is there any? I need it to use under MFC, not .NET. I have found this but it is .NET driver: http://CherryCitySoftware.com/ccs/Home/Default.aspx and this but I have no references to this: http://www.newobjects.com/product.asp?Category=71 Thanks ...
I'm trying to write a simple website (ASP.NET v4), which will call Windows Search, find a specific file and return it to the user. I've put together the following as an example: it calls the Windows Search service on "remoteserver", and returns the path of "somefile.txt": OleDbConnection conn = new OleDbConnection(); conn.ConnectionStr...
I am using C# and .NET 2.0. I created an OleDbDataAdapter to import a tab delimited file and in the SQL for one of my commands, I am adding 'LIMIT 1' to the end of the query. string query = string.Format("SELECT DISTINCT * FROM {0} ORDER BY ZipCode ...
I have a C# program to write to Excel which is to support files without headers and files with. If I write where I want headers, this is fine, but in the case of reading a file without headers, I then want to write a table without headers. If I use the same headings to create a table, I still get F1, F2, F3 etc in the content. My conne...
How is possible to get rows count of rowset in OLE DB? I have filled RowSet using CCommand and CAccessor and now I dont know how to get rows count. I can go through all rows using MoveNext() but it does not seem efective. Thanks ...
OleDbCommand cmdpic = new OleDbCommand ("select * from sub_category where id_s=" + Request.QueryString["id_s"] +"or"+"order by sub_id desc", concars); it shows error what is the correct command ...
I am using OLEDB to Update data in .dbf database from c#. I get Error: System.Data.OleDb.OleDbException {"Undefined function 'replace' in expression."} on ExecuteNonQuery. How can I make this work with least changes, i need to replace double quotes with single quotes in many files, so i have to automate this process. Should I try ODBC...
Background Information: Visual Studio 2010 (.NET Framework 4.0) Informix Server 7.31 Informix ClientSDK 3.50 TC7 (Windows 32-bit) was installed as well. I have tried multiple ways suggested online to connect to the Informix server, but all of them do not work for me for whatever reason. I have looked at articles such as Connect Info...
I use OleDB to read an Excel file. One of the columns has a "Common" format and contains both strings with letters and values consisting of numbers only. String values are retrieved without problem, but pure numerical values are retrieved as DBNull. How to solve? I use the following connection string to open Excel 2003 file (xls): "Pr...
Hi Everyone, I'm writing a web app that will read data from an Excel file submitted by an authenticated user by opening an OLEDB connection to it. Can anyone tell me the security risks of opening up an Excel file this way? I know dangerous macros can be embedded in excel files, but is that still a risk when using a OLEDB connection? ...