| Closing an OdbcDataReader causes an exception (3 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I am writing a little utility to transfer data from a unix based database into sql server. I have an ODBC driver installed, and it seems to work just fine. But if I call the Close() method on my OdbcDataReader object, I get the following exception. System.Data.Odbc.OdbcException: ERROR [IM001] [Microsof t][ODBC Driver Manager] Driver does not support this function at System.Data.Odbc.OdbcConnectio... |
|
| Can ADO.NET create a table in the database programmatically without executing CREATE TABLE sql statement? (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| There're all the good stuffs in ADO.NET classes, like you can create a new DataTable and add columns/constraints to it. But everything is in memory. Is there a way to save this nicely and freshly coded in memory DataTable back to the database as a table without executing CREATE TABLE sql statement? Thanks. From: Jeff Lee Posted by a user from .Net Guru (http://www.dot-net-guru.com/) Id X2JGSD S90e7bQ7... |
|
| Oracle vs. OleDb? (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| (Type your message here) Oracle parameters have a type 'cursor'. There is an equivalent type for OleDb? From: Ana Popescu Posted by a user from .Net Guru (http://www.dot-net-guru.com/) Id TbmUbMDTRk2JX44KiRF8pQ /Id |
|
| Intermittent Exception from System.Data (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I have a number of functions which read 1000 rows from AS400/DB2 tables through ODBC using ODBCDataReaders. Intermittently an error is written to the Windows Application Event Log with the source marked as System.Data and the message Invalid Handle! There is no other information. Immediately before this error is recorded an exception is encountered within one of my functions with the following inf... |
|
| ado.net to Outlook (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| (Type your message here) How to connect ADO.NET to outlook ? (VB.Net code) From: yogesh lokhande Posted by a user from .Net Guru (http://www.dot-net-guru.com/) Id au9p8Yue4Umqt6mts/GC1w /Id |
|
| ODBC Driver for Pervasive (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Does anyone know if a ODBC driver for Pervasive SQL is available for .NET? Thanks |
|
| ACT! (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Has anyone successfuly read the ACT! Datafile? We are replacing ACT with an on house program and would like to migrate the data. |
|
| Problem in connecting to FoxPro DB (3 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| (Type your message here) Hi I am trying to connect to a FoxPro db. My application is built as a C# user control in .NET. The DB is a free table directory. I created a DSN (Microsoft Visual Foxpro Driver type) on the server and linked to the folder. It created fine. But when I run my code, it gives me a 'file sample.dbf does not exist'. The file is present under the folder. I also tried a DSNLess c... |
|
| MySql (5 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I was wondering if Microsoft will have any classes available to connect to MySQL databases instead of just SQL. I know being Microsoft, they wouldn't want to do that, but a lot of the servers out there use MySql because it's more affordable than regular SQL server. Any comments or answers reguarding this? Also if so, when? Thanks a bunch. |
|
| SQL Validation (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I am using the Microsoft.Data.Odbc class to submit an SQL to TeraData using the commandText property (SQL is stored in a string locally). Is there a way to perform validation on the SQL syntax prior to submission to the DB? In our environment, we submit dozens of SQL statements sequentially and I am trying to eliminate bad SQL syntax from bombing the execution. Any help is appreciated! |
|
| Creating a scaled down CRM (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello, I am creating an Outlook 2003 based CRM for my organization and would like to model the approach after Outlook BCM. Unlike BCM, this CRM will be accessible throughout my company (20 users). First, I'll be creating a MSDE SQL Database on my SBS 2003 server and then I'd like to customize an Exchange Public Folder (containing Contacts) to pull extra data from the MSDE. I will create custom for... |
|
| ADOX and C# problems (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| The following code: ADOX.Catalog mdb new ADOX.CatalogClass(); try { mdb.Create("Provider Microsoft.Jet.OLEDB.4.0;" "Data Source " mdbPath @"\" mdbName ";" "Jet OLEDB:Engine Type 5"); ADOX.Table mdbTbl new ADOX.TableClass(); mdbTbl.Name "Receivers"; mdbTbl.Columns.Append("AddressBookID", ADOX.DataTypeEnum.adDecimal,9); mdb.Tables.Append(mdbTbl); } catch(Exception ex) { Trace.WriteLine(ex.Source); T... |
|
| ERROR Procedure 'ABC' expects parameter '@abc', which was not supplied. (7 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Greetings, I am getting this error when I try to populate a DataTable by executing a stored procedure on a SQL Server 2000 database through an ODBC in a VB.NET application: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'ABC' expects parameter @abc, which was not supplied. 'cmd is passed into a helper function that excutes this code conn New System.Data.Odbc.OdbcConnection(... |
|
| Use of SqlConnection with an ODBC datasource (3 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi everyone, Is it possible to use an ODBC datasource with a SqlConnection object? If we use SQL Server, we can create a SqlConnection, then drag it onto our form for use. But if we instead use an ODBC datasource, when we drag the connection onto our form, we get the following error: You cannot use an OLE DB provider for ODBC drivers. Thanks a lot, Mike |
|
| Reading FoxPro Date field frpm ODBC (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Ok, what is the trick!!! I am using C# to read a FoxPro DBF file. I do the following: Private DataSet getDBFData(string dbfFile) { DataSet ds new DataSet(); string Sql; int dbfNameStart dbfFile.LastIndexOf(@"\"); string dbfTableName dbfFile.Substring(dbfNameStart 1); //Define a connection string with file path as parameter string Connection "Provider MSDASQL/SQLServer ODBC;Driver {Microsoft Visual... |
|
| SCO Vision ODBC (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have a .NET client application which is trying to connect to an Informix database via SQL Retriever 4.17 I am experiencing an error message which was supposed to have been corrected in v4.17 of the ODBC driver: 'ERROR [IM003] Specified driver could not be loaded due to system error 1114 (SCO Vision ODBC).' Does anyone have an idea of how I can overcome this issue. Thanks in advance, Chris |
|
| reading dbf tables (6 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I have an interesting problem reading data from a dbf table I can create a dbf table in excel, save it then use odbc in .net to read it ok. I can read the same table in another (3rd party) app ok. If I change data in the table using the 3rd party app the table structure changes. Excel reads the modified table ok, the 3rd party app reads it ok but .net returns enpty objects. The problem appears to ... |
|
| Why MySql isn't as good as MSDE (2 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I've been trying to migrate away from SqlServer2000 a bit because even thou I love it, and I own it from a developers point of view, it just isn't light weight enough for me. Solution: I thought, MySql, i'll give that a shot with C# see how it goes. Now MySql is great dont get me wrong, but from a Engineers point of view, it isn't full database. Its a toy database for hacking away at. Stored Proce... |
|
| Connecting to an Excel File (3 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi Anyone who can explain me how to load and edit an Excel file in a DataGrid via an odbcConnection? Thanks Frans Vander Meiren |
|
| ODBC Connectivity Issues with .NET (7 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hey, I'm moving a VB application to C# and the VB program accessed a datasource through ADO using the OLE DB provider for ODBC drivers. I'm able to access the datasource through the .NET IDE because it is also using OLE DB, but .NET forces me to use the ODBC driver directly with the OdbcConnection object and it just won't work. I've tried every possible connection string I can think of from readin... |
|
| Connecting with FoxPro DBF (4 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| Heya, I'm trying to connect to a FoxPro DBF database using a system DSN and the .NET ODBC drivers. It works well on two of my WindowsXP machines, but will not work on the bosses machine, even though the environments *look* identical. Has anyone had any trouble with ODBC and FoxPro from .NET? When I connect from his machine it says the database connection is Closed. Any help anyone can give me woul... |
|
| ODBC connection to AS400, (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, 1 I have IBM Client Access installed on Server 2 I have created a system ODBC on the machine I'm trying to connect to AS400 data but the following code MyConnection New OdbcConnection(MysConnectonStringIsHere) MyConnection.open() hangs for long meaning it cannot open the connection.I do not get any error messages... Any ideas folks? |
|
| odbc database schema (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi everybody, I'm trying to use an odbc connection to get the list of the available tabls in my database. But I cant't find the right way to do this. Can you help me ?? |
|
| C# ODBC.Net and MySQL error (19 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Guys Ive copied code "exactly" from the ODBC.Net samples. The connection is made, because if I change the pwd, I get an error. But I cannot get the ExecuteNonQuery(); to work. I get this error: Error: System.NullReferenceException: Object reference not set to an instance of an object. at System.Data.Common.Odbc32.SQLExecDirectW(IntPtr StatementHandle, String StatementText, Int32 TextLength) at Mic... |
|
| ERROR Specified driver could not be loaded due to system error 5 (Oracle in OraHome92). (11 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi , I use ODBC DSN to connect Oracle. string newConnString "DSN OracleTest;UID tt;PWD pp"; OdbcConnection m connection new OdbcConnection(newConnString); m connection.Open(); when I setup the DSN in windows ODBC Datasource manager, the test connection successfully, but when use in asp.net code, I got the following errors: 'ERROR [IM003] Specified driver could not be loaded due to system error 5 (... |
|
| Add a new column to dBase (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have a database in data.dbf Now, I want to add a new column to this datebase. I write it in C#. My code is: string nazwa "dsn baza dbf"; OdbcConnection cn new OdbcConnection(nazwa); cn.Open(); OdbcCommand cmd new OdbcCommand(); cmd.CommandText "??????????????????????????????????????"; cmd.Connection cn; cmd.ExecuteNonQuery(); cn.Close(); What should I write in cmd.CommandText ... Please help |
|
| Reopenning ADODB Connection (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm trying to reuse an ADO connection in a loop. The connection string is different each time I go through the loop. My code is basically the following: Dim conn as ADODB.Connection Do loop conn new ADODB.Connection I use a case statement to set connection string conn.open() do stuff to database conn.close loop Whenever I run the code however, I get the message "Data source rejected establishment ... |
|
| Getting a list of Tables in MS access database (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have a need to list all the tables in a MS access database using ODBC. How can this be acheieved ? |
|
| System.Data.Odbc.OdbcException: ERROR Data source name not (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, All I have a Problem when I'm working with Informix Dynamic Server DataBase, and VB.NET as tools Developmen, the problem is when a Run my WebAplication have this message. "System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" Can yours help me. Thanks..! *** Sent via Developersdex http://www.developersdex.com ... |
|
| Jet Won't Open (5 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I get the following error when I write any code against a connection that is hooked to an Access database: The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\TimeTracker\Data\TimeTracker.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Does anyone have any idea what to do about this? |
|
| CurrentUser function from access doesn't work in VB (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am trying to access an Access query that uses the CurrentUser function from VB. The query runs fine in Access but gives me a Undefined Function error in VB. Anybody struck this before? Steve |
|
| How to get tables and index information from an Odbc provider (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I need to retrieve schema information from an Odbc provider basically I need to know which tables are available and what the indexes are on those tables. I need a method that works across SQL Server, Oracle, Text, etc. I'm converting C code that uses the native Odbc libraries but I can't figure out how to do the same thing via .NET's Odbc driver. The only thing I can think of to do at this point i... |
|
| Driver's SQLSetConnectAttr failed ERROR (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi all, I try to migrate an application ASP to ASP.NET(C#). This application get data from a SAGE database located on a server. I test my ODBC connection everything work fine, and in ASP no problem. But in ASP.NET I've got the following error : ERROR [S1000] [Simba][Simba ODBC Driver][CBase]Erreur inconnue ! ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01... |
|
| Using Access with C#.NET (4 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm tyring to use MS Access with .NET, but I'm having some problems. Here's the code: string sSQL "SELECT Statement Id,Statement In Brief FROM Statements"; OleDbDataAdapter thisAdapter new OleDbDataAdapter(sSQL,oleDbConnection1); DataSet thisDataset new DataSet(); thisAdapter.Fill(thisDataset,"Statements"); It bombs on the 4th line. I get the error message, " The Microsoft Jet database engine cann... |
|
| ODBC DataReader - dBase IV (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hey, I've been working for the last few days on changing over a system from SQL Server to dBase IV (don't ask :0) ). Everything seems to be going well, except whenever I use the ODBCDataReader, specifically use the ODBCDataReader.Item( fieldName ) overload, I get an OutOfRangeException. I tried using the .Item(int) overload, and I get the fields, but of course, they are in the order they exist in ... |
|
| Too Few Parameters Error calling query stored in Access Database (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am calling a query stored in Access that requires a parameter. But the parameter that I am passing in as part of the command does not seem to be being recognized. I have two queries in an Access database. They are: SELECT [tblEventParticipants].[EventID], [tblEventParticipants].[MemberID], [tblEventParticipants].[InterestLevelID] FROM tblEventParticipants WHERE ((([tblEventParticipants].[MemberI... |
|
| UniData & ODBC & VB (.net or VB6) (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Has anyone had any experience with the UniData ODBC Client? I'm just getting started and having trouble calling a UniData Basic program from VB. I'm getting the following error: "ERROR [42000] [Ardent][UniData ODBC Driver][Informix][SQL Client][UNIDATA] MY.PROGRAM.NAME; Syntax error" Any ideas??? TIA! Bryan Dickerson |
|
| data types not supported (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm trying to get data from an NCR Teradata Database but OdbcDataReader won't accept columns that are of INTERVAL data type. I get an "Unknown SQL Type 101" error when trying to read INTERVAL values. Does anyone know of a way to read non CLR data types using the OdbcDataReader? Can the DataReader be forced to read a value as a string for example? |
|
| ODBC Text Driver question (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I found a doc saying that the ODBC text driver doesn't support insert/update/delete, etc. Is this accurate for the latest version of the ..NET framework? The text driver is basically a read only implementation then? http://support.microsoft.com/default.aspx?scid http://support.microsoft.com:80/support/kb/articles/Q178/7/17.ASP&NoWebContent 1 Thanks in advance! Derrick |
|
| Updating Access table through OleDb works but Odbc give Concurrency Violation error?! (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I developed a web site using the OleDb namespace, but I need to use an DSN on the production web server and thus must convert the app to use Odbc namespace. I have done this and all works find except for updating one table. The following code example demonstrates the situation exactly. In the code below example setting iTestCase to 0 results in "Success" being outputted. Setting it to non zero res... |
|
| Oracle using ASP.NET (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi All Can anyone help me with the following problem: I am trying to log onto an Oracle 8.0.5 database using ASP.NET running Oracle 8.1.7 Client. The application don't seem to find the created System DNS. Can anyone please HELP. I can connect to the DB using the Client with no problems. Thanks |
|
| Using the Desktop Engine (4 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm attempting to use MS Access with .NET but am not having much luck, so I've decided maybe I should just use the SQL Server Desktop Engine. Is there any way to import my tables from Access into the Desktop Engine? |
|
| Solutions Won't Load (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I've been using Visual Studio .NET for several weeks now. I've finished some example solutions as well as started others. Now when I open the environment, very few of them will load properly. Usually, I get no listing of files in the properties window to the right or anything like that. Does anyone have any idea what might cause this and how I can fix it? |
|
| Rollback transaction doesnt work when DataAdapter.Update() throws exception caused by RAISEERROR in a trigger (6 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I have a trigger like this (simplified to illustrate the problem): CREATE TRIGGER Test ON [dbo].[TestTable] FOR INSERT, UPDATE, DELETE AS RAISERROR( 'test trigger error !', 16, 1) And a C# code portion: (new record inserted in dsFormTest.TestTable) OdbcTransaction odbcTrans null; try { if ( odbcConn.State ! ConnectionState.Open ) odbcConn.Open(); odbcTrans odbcConn.BeginTransaction(); odaTest.... |
|
| Error when connecting to a Foxpro database from a .NET web app (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello all Here's the situation. I have a web server, and I'm developing a web application using VB.NET that will run on this server. I also have another server, which runs a third party Human Resources application, written in Visual Foxpro. Its databases are standard .dbf files. I want to be able to connect to the .dbf files on the HR server directly from my web app on the web server. I have not b... |
|
| OLE DB provider for reading DBF files using ASP.NET (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am trying to read a DBF file using ASP.NET, I have spent hours trying to get the correct connection string. Is there anyone out there that has successfully connected a dbase III file with a ASP.NET page?? If ( readDBFFile TRUE ) then read on; else dont worry; This is the code that I have been using but the compiler seems to complain on the line ..... [ reader command.ExecuteReader() ] the error ... |
|
| Query is too complex error (3 replies, VIP) |
| microsoft.public.dotnet.framework.odbcnet |
| I am updating Access database using System.Data.Odbc I am using the following code: //////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////// foreach(DataColumn cl in dsNew.Tables[0].Columns) { dataRowDest[cl.ColumnName] dataRowOrigin[cl.ColumnName]; } adapter.Update(ds, tableName); ///////////////////////////////... |
|
| NotesSql & .Net connection problem (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I'm trying to connect to a Notes database using .Net, Odbc & NotesSql, but I keep getting the following error on opening the connection: System.Data.Odbc.OdbcException: ERROR [IM003] Specified driver could not be loaded due to system error 1114 (Lotus NotesSQL Driver (*.nsf)). I can open the connection ok using .asp, with the same connection string. I assume it's some kind of permissions issue... |
|
| ODBC Connection Pooling with ADO.NET and Oracle RDB (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi! I believe I am not getting ODBC connection pooling in ADO.NET to work correctly. I am connecting to an Oracle RDB database with Oracle RDB ODBC driver 3.1.0.0. With a test project in VB6 I start out with this call to enable pooling on the ODBC level. SQLSetEnvAttr(0&,SQL ATTR CONNECTION POOLING,SQL CP ONE PER DRIVER,SQL IS IN TEGER) This enables connection pooling at driver level (one pool per... |
|
| System.Data.OracleClient Problem: Not closing open connection (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, Could any one tell me what is the latest version of System.Data.OracleClient? Currently I'm using version 1.0.1012.0 in my project which is giving problem of not closing connection eventough I'm issuing connection Close() statement.I am trying to connect Oracle 8i from ASP.NET framwork 1.1 in my application. Initially I tried to put Connection Lifetime property to 60 seconds, when the applicat... |
|