| System.IO.FileNotFoundException in ODBC.NET (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am getting the unhandled exception of type 'System.IO.FileNotFoundException' occurred in system.windows.forms.dll while using ODBC.NET. Following is the source code: Imports System.Data Imports Microsoft.Data.ODBC Public Class OdbcDb Inherits System.Windows.Forms.Form .... Private Sub btnGetData Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetData.Click Dim cn As ... |
|
| SQL Anywhere 6 (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hey. I just started to learn about odbc with vb .net. I use also Sybase SQL Anywhere 6 i my work. But we use clarion to code in, but we shall move to vb .net. But we have to use Sybase SQL Anywhere 6 databas. Have any some sample that i can get to se how it would be?? Greetz Soren Forsdahl Analys Consult KB Sweden |
|
| MYSQL DataGrid (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have check out some of the examples and have not been successfull in implementing a datagrid with mysql. Has anyone got these two to work? |
|
| Binding DataGrid? (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Does anyone know if you can use odbc.net provider to bind to a DataGrid like you can with the SQLProvider and the OleDB provider? Does someone have an example of this that they could post? Thanks in advance. |
|
| generating PK's (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, According to everything I've read there is no locking rows available with C# and ADO.NET. OK so how does everyone deal with PK's? What I did in the past was use a table that had my PK field. I locked the table and then updated the field by one for my new PK. But locking is no longer supported. So how do I create and use PK's? John |
|
| Empty string and null value problem with PostgreSQL as well. (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I know similar posts have been made but not AFAIK concerning PostgreSQL. Using odbc.net with the PostgreSQL ODBC driver and database there seems to be both the problem concerning empty string values in table columns and the problem with null values. If a varchar or text type was inserted into a table with "" (the empty string) the runtime error is this: "Unhandled Exception: Microsoft.Data.Odb... |
|
| OdbcDataAdapter vs. OdbcDataReader? (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am fairly new to accessing databases and I am currently playing with the new ODBC.NET with C#. I am currently using a OdbcDataReader() to retrieve data, which works great. My question is about the OdbcDataAdapter(). Why would I use this instead of the OdbcDataReader()? What are the advantages? Thanks, Derek |
|
| FileNotFoundException when calling SqlDataAdapter.Fill() (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I used the designer to add a new connection, data, and dataset for a table that I have in my SQL server (running on W2kPro with SQL Server Enterprise 2k). When I call data.Fill(dataset) in my C# ASP.NET service I get the following: System.IO.FileNotFoundException: The specified module could not be found. at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen(ID... |
|
| connection to sql-server (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| How can I access an sql server with C .NET or C#.NET? Any help is appreciated! Randy |
|
| OdbcCommandbuilder : manipulating sql statements (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello. The OdbcCommandbuilder generates "where" clauses (in the update and delete sql) that contain pieces like "(? null and field x null)". Now my dbms (DB2) can't handle this "? null" structure, is there any way of manipulating how the CommandBuilder builds op sql statements? I've been searching for a while now but I couldn't find a way to accomplish that. Merci. |
|
| ODBC.NET with Adaptive Server Anywhere (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Help!!! I'm new with .NET and just trying to write a simple Web Form to read and write data stored in a Adaptive Server Anywhere 7.0 db. I can see my database via Server Explorer; well, a revised version of it; it rejected my real data complaining that the "data page size is too large" but this is another problem all together. I realized that I must write the code from scratch and not through the ... |
|
| datagrid in ODBC (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| After you make a change in a cell in a datagrid, how do you trigger a program to write it back to the database? If you use a second button do you have to create a new connection etc? Then how do you determine what and how to write back the changed cells? Can anyone point to me a real simple example? Thanks. |
|
| Update returning without actually doing work (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi everyone, Would someone be able to take a look at my code sample below and tell me what's off? I'm finding that I'm able to fill a dataset from an ODBC source with no trouble, and basic connectivity seems to be great. But, updates aren't working, and I'm not getting any sort of error or status message to troubleshoot. After running this sample, my C# code completes yet ODBC logging shows that t... |
|
