Search Results

Search found 1109 results on 45 pages for 'ado'.

Page 9/45 | < Previous Page | 5 6 7 8 9 10 11 12 13 14 15 16  | Next Page >

• Requested operation requires an OLE DB Session object... - Connecting Excel to SQL server via ADO

  - by Frank V

  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 (I've tried 2.8 to 2.0) but I'm getting an error while setting the ActiveConnection variable which is inside the ADODB.Connection object. I need to…

  Read the article

• Is ADO.NET Entity framework database schema update possible?

  - by fyasar

  I'm working on proof of concept application like crm and i need your some advice. My application's data layer completely dynamic and run onto EF 3.5. When the user update the entity, change relation or add new column to the database, first i'm planning make for these with custom classes. After I rebuild my database model layer with new…

  Read the article

• How do I authenticate an ADO.NET Data Service?

  - by lsb

  Hi! I've created an ADO.Net Data Service hosted in a Azure worker role. I want to pass credentials from a simple console client to the service then validate them using a QueryInterceptor. Unfortunately, the credentials don't seem to be making it over the wire. The following is a simplified version of the code I'm using, starting…

  Read the article

• Custom ADO.NET provider to intercept and modify sql queries.

  - by Faisal

  Our client has an application that stores blobs in database which has now grown enough to impact the performance of SQL Server. To overcome this issue, we are planning to offload all blobs to file system and leave the path of file in a new column in user table. Like if user has a table docs with columns id, name and content (blob);…

  Read the article

• Load a 6 MB binary file in a SQL Server 2005 VARBINARY(MAX) column using ADO/VC++?

  - by Feroz Khan

  How to load a binary file(.bin) of size 6 MB in a varbinary(MAX) column of SQL Server 2005 database using ADO in a VC++ application. This is the code I am using to load the file which I used to load a .bmp file: BOOL CSaveView::PutECGInDB(CString strFilePath, FieldPtr pFileData) { //Open File CFile fileImage; …

  Read the article

• ?Oracle Database 12c????Information Lifecycle Management ILM?Storage Enhancements

  - by Liu Maclean(???)

  Oracle Database 12c????Information Lifecycle Management ILM ?????????Storage Enhancements ???????? Lifecycle Management ILM ????????? Automatic Data Placement ??????, ??ADP? ?????? 12c???????Datafile??? Online Move Datafile, ????????????????datafile???????,??????????????? ????(12.1.0.1)Automatic Data…

  Read the article

• Ado.net Fill method not throwing error on running a Stored Procedure that does not exist.

  - by Mike

  I am using a combination of the Enterprise library and the original Fill method of ADO. This is because I need to open and close the command connection myself as I am capture the event Info Message Here is my code so far // Set Up Command SqlDatabase db = new…

  Read the article

• OData to the rescue. Exposing the eventlog as a data feed

  - by cibrax

  In one of the project where I was working one, we used the Microsoft Enterprise Library Exception Application Block integration with WCF for logging all the technical issues on the services/backend in Windows Event Log. This application block worked like a charm, all the errors…

  Read the article

• How do I use C# and ADO.NET to query an Oracle table with a spatial column of type SDO_GEOMETRY?

  - by John Donahue

  My development machine is running Windows 7 Enterprise, 64-bit version. I am using Visual Studio 2010 Release Candidate. I am connecting to an Oracle 11g Enterprise server version 11.1.0.7.0. I had a difficult time locating Oracle client software that is made for 64-bit Windows…

  Read the article

• ADO Entity Framework 4 to WPF Datagrid. DatagridComboBox nightmare.

  - by Jason

  The WPF datagrid -seems- like it's going to work, but the combobox implementation does not work straight from the designer. So I'm left wandering around in the XAML randomly changing things trying to get it to work. The problems are numerous. I want to display a foreign key…

  Read the article

• Using ADO.net Entity Framework 4 with Enumerations? How do I do it ?

  - by Perpetualcoder

  Question 1: I am playing around with EF4 and I have a model class like : public class Candidate { public int Id {get;set;} public string FullName {get;set;} public Gender Sex {get;set;} public EducationLevel HighestDegreeType {get;set;} } Here Gender and EducationLevel…

  Read the article

• why DbCommandBuilder (Oracle) produces weird WHERE-clause to UpdateCommand in C# / ADO.NET 2.0?

  - by matti

  I have a table HolidayHome in oracle db which has unique db index on Id (I haven't specified this in the code in any way for adapter/table/dataset, don't know if i should/can). DbDataAdapter.SelectCommand is like this: SELECT Id, ExtId, Label, Location1, Location2,…

  Read the article

• how can I add a custom non-DataTable column to my DataView, in a winforms ADO.net application?

  - by Greg

  Hi, How could I (/is it possible) to add a custom column to my DataView, and in this column display the result of a specific calculation. That is, I currently have a dataGridView which has a binding to a DataView, based on the DataTable from my database. I'd like to…

  Read the article

• ADO.NET Entity Framework: Can I have multiple entity types for the same row.

  - by black_nm

  Hi all, I have a base class Participants inherited by Artist, Author and TextWriter. I have only one table in the data store: Participants { ID, FirstName, LastName, IsArtist, IsAuthor, IsTextWriter, } The idea is to have a class for all the…

  Read the article

• is it possible to lock oracle 10g database table with ADO.NET?

  - by matti

  I have a table that contains a maximum value that needs to be get and set by multiple programs. How can I lock the table for a while when old value is got and new is updated in C#? In other words: string sql = "lock table MaxValueTable in exclusive mode"; using…

  Read the article

• [ADO.NET ERRROR]: CREATE DATABASE permission denied in database 'master'. An attempt to attach an au

  - by Mark Cidade

  Anyone seen this before? CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file C:\Documents and Settings\..\App_Data\HelloWorld.mdf failed. A database with the same name exists, or specified file…

  Read the article

• ADO.NET: Faster way to check if the database server is accessible?

  - by lotana

  At the moment I am using this code to check if the database is accessible: public bool IsDatabaseOnline(string con) { bool isConnected = false; SQLConnection connect = null; try { connect = new SQLConnection(con); connect.Open(); isConnected…

  Read the article

• Retrieve entities with children per one sql call. ADO.NET Entity framework

  - by Andrew Florko

  Hello everybody, I have two tables: A & B B { B1: Field1, B2: Field2, ... } A { Children: List of B, A1: Field1, A2: Field2, } I want to retrieve "A" entities with related "B" entities like this: DataContext.A.Select(…

  Read the article

• Is re-using a Command and Connection object in ado.net a legitimate way of reducing new object creat

  - by Neil Trodden

  The current way our application is written, involves creating a new connection and command object in every method that access our sqlite db. Considering we need it to run on a WM5 device, that is leading to hideous performance. Our plan is to use just one…

  Read the article

• Is there a way to add extra fields to an association in the ADO.NET Entity Framework?

  - by bigbird1040

  I would like to be able to model a many-to-many relationship that has extra details about the relationship. For example: Person: int id, String name Project: int id, String name ProjectPerson: Person.id, Project.id, String role Whenever I create the…

  Read the article

• When using Oracle load balancing and ADO.NET, how do you know which host the command executed on?

  - by Leeks and Leaks

  It's possible to use Microsoft's OracleClient assembly to connect to an Oracle database, and using Oracle's connection string format, set it up to use load balancing, provided your Oracle environment supports it. The question I have is how do you know…

  Read the article

• VB6 ADO Connection - How to Check if in Transaction?

  - by Tom Tresansky

  Is there any way to tell, using just the ADODB.Connection object, whether or not it is currently involved in a transaction? I'd love to be able to test this on the connect object itself, without relying on keeping a boolean next to it updated.

  Read the article

• Can the Sequence of RecordSets in a Multiple RecordSet ADO.Net resultset be determined, controlled?

  - by Shiva

  I am using code similar to this Support / KB article to return multiple recordsets to my C# program. But I don't want C# code to be dependant on the physical sequence of the recordsets returned, in order to do it's job. So my question is, "Is there…

  Read the article

• how to get rows created with DataTable.NewRow() in C# / ADO.NET 2.0?

  - by matti

  Now I use Select and use a criteria which select only new rows. But is there any kind of GetInsertedRows-method. If I remember correctly there is status for each row so naturally one can loop through them all but that's not elegant. -Cheers -Matti

  Read the article

• What would be the fastest way to insert 750 records using Ado.NET?

  - by Lieven Cardoen

  We have tried it using an orm mapper tool, but it opens en closes the connection 750 times. Then we tried to construct a bulk insert, but that goes even slower...

  Read the article

< Previous Page | 5 6 7 8 9 10 11 12 13 14 15 16  | Next Page >