| FLEXQUARTERS (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Has anybody on here successfully got ODBC.NET to work with the FlexQuarters ODBC driver to access dataflex data files? I get an error saying: Microsoft.Data.Odbc.OdbcException: ERROR [S1000] [Flex/ODBC][FLEXERR] Required file COLLATE.CFG missing from DFPATH Cant Open filelist.cfg I get this even though I have put COLLATE.CFG in the same directory as filelist.cfg. Which I have read (somewhere) it's... |
|
| Bug in ODBC.NET after compacting Access Database? (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Ok, after 2 days of racking my brains on why this is happening, I am positive that there is a bug in the ODBC.NET driver and am wondering if anyone can confirm this, or is this a known issue. This is related to the post titled "Connection Error" by me. I have Access 2000 installed on my machine (W2k Professional) which is the database for my web app. I installed it from the MSDN CD's (Office 2000 ... |
|
| Inserting data in non-standerd way (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I currently have an application in C that will insert data using the following query. if exists(select 1 from rtocsvBidsMarket where DateTime ?) update rtocsvBidsMarket set MW1 ?, Bid1 ?, SLP1 ? where DateTime ? else insert rtocsvBidsMarket (DateTime, MW1, Bid1, SLP1) values (?, ?, ?, ?) To perform the query I first have to populate data structure with all of the data and I tell the application ho... |
|
| An unhandled exception of type 'Microsoft.Data.Odbc.OdbcException' occurred in m (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello, Every time I run this piece of code. I get the following error "An unhandled exception of type 'Microsoft.Data.Odbc.OdbcException' occurred in microsoft.data.odbc.dll" I get this error on the DataConn.Open() line. Can anyone help me. Here is my Code Below Dim DataReader As OdbcDataReader Dim DataConn As OdbcConnection Dim DataCmd As OdbcCommand Dim DataAdapter As OdbcDataAdapter Dim strConn... |
|
| Setting up Access ODBC connection (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello all. I am new to Access and .NET, and have limited experience with ODBC in general, but find myself needing to write a .NET app which connects to an Access Database via ODBC. So far, I have been unable to establish a working connection. I believe my connection string is incorrect in some way, but perhaps someone with more experience can steer me in the right direction. Thus far I: Set up the... |
|
| Is OdbcDataReader.IsDBNull working? (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi all. I've run into a small problem and I'm wondering if it's a bug in the OdbcDataReader class. I've executed a select statement which returns a number of rows with 6 columns. For each column I do a if(!reader.IsDBNull(i)) { value reader.GetString(i); } The problem is that for columns with null db values my program throws an exception at the reader.IsDBNULL call, giving the message: NO DATA no ... |
|
| Connection Error (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I get the following error when I try to run my webpage. The webpage was working fine until I compacted the database. The error is ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's... |
|
| SQL Stored Procedure value disappears (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, Thanks in advance for any help with this. I have a function calling the code below. The code runs fine and returns no errors or exceptions but it doesn't always properly insert the value @Message into the database. The problem seems to be with the length of the string. I have a string that has a length of 420 and that is inserted fine but a string with a length of 8076 gets inserted as "". I'v... |
|
| Connecting to remove data sources (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I have developed my new ASP.NET app, and all works fine except for one catch. Everything is working when the databse the app is connecting to is on the local machine. When I move the code to the live servers, the database of course is on different clustered servers. Security to these is tight, and only one port is open for use, so this connection is defined in the web.config (as per example be... |
|
| DataReader error using .Net ODBC (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I am trying to use .Net ODBC to read data from a legacy ODBC data store. The legacy ODBC driver works OK when I access it using classic ASP. When I use ..Net, the connection and dataReader are opened, but I got the following error at the line when the data is read An unhandled exception of type 'System.IndexOutOfRangeException' occurred in microsoft.data.odbc.dll Additional information: NAME T... |
|
| OdbcException on Client (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I urgently need some help in finding out why my deployed project is throwing ODBC Exceptions. The attached screenshot of the caught exception gives no indication of the error itself: Microsoft.Data.Odbc.OdbcException: NO DATA no error information available at... I have installed the (Postgres) ODBC drivers, set up the DSNs, installed the ..NET redistributable framework, updated MDAC on THREE targe... |
|
| Adding reference manually to microsoft.data.odbc (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm attempting to use the odbc .net provider in a class file that is not compiled before calling it from an ASPX page. When I put the line "Imports Microsoft.Data.odbc" at the top of my .vb file and then run the .ASPX page I get the error "Namespace or type 'odbc' for the Imports 'Microsoft.Data.odbc' cannot be found." I hook my .vb class file to my .ASPX page by including the following line at th... |
|
| Odbc Connection Error (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I've got a problem. I am trying to connect to a DBF file using the following code. It worked on a test DBF file, but not this particular one. I get an error at the dbReader dbCommand.ExecuteReader() line and it says: "ERROR [HY000] [Microsoft][ODBC dBase Driver] Unexpected error from external database driver [10023]. Can anybody give me any clues as to why this would happen. The using another clie... |
|
| Simple task with C# and AccessDB - newbie questions (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi there Please help me figure this out! I've recently started to learn C# and have decided to write a database app with winforms to help me along. I'm having an amazing amount of difficulty trying to do what I think is a simple task: update the database with changed data that I entered into my winform. Here's an explanation, along with all the code. It's long, but pretty simple code. I have two t... |
|
