| ODBC .NET and other managed providers (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| The ODBC .NET provider must be downloaded and installed after the .NET framework is installed. I'm able to add a Data Connection to an ODBC source, and the database appears in Server Explorer. But, I'm not able to expand the Tables or Views node. Menu entries, such as "New Table" and "New View" do not appear when I right click on these nodes for the ODBC source. Also, the "Database Diagrams" node ... |
|
| HELP Connection string to access with c# (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| i need to know what is the way to connect to access database WITH DSN, for c# application. thank u |
|
| How can I send string with single quote in it to SQL Server? (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello! How's everybody??? I'm working with SQL server and I'm executing a stored procedure assigning the sql statement to the CommantText property and executing the ExecuteScalar method of the SqlCommand object My Sql statement looks like this sql "sp my storeprocedute '123','Margot O'hara'" The problem is that because SQL Server use the single quote (') to delimits the strings, my data can't have... |
|
| Creating typed datasets from an ODBC source (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I've done a search on Google, but I did not found an answer to my problem. Sorry if it has been asked before! We're using a database that doesn't support OLE DB (don't ask!), so I installed the Microsoft.Data.ODBC namespace to connect. This works fine! But I was used to working with SQL Server, where I could drag any table from the Server Explorer into my form. This would create the connection... |
|
| odbc.net using mysql and vb.net (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I am pulling my hair out with this one! As a novice I found a samplepage.aspx, I converted it to use odbc.net (since the database is mysql). I receive the following message. I would appreciate some help as I havent got a clue what I am doing wrong! Thanks in advance! [OdbcException: ERROR [S1000] [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO) ERROR [01000] [Microsof... |
|
| How to affect Automatically Generated Commands? (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Are there any posibilities to affect the commands builded by the OdbcCommandBuilder? I saw (ODBC Trace) that an UpdateCommand which was generated looked like this: UPDATE tblStoryPart SET strCustomColor1 ? , strCustomColor2 ? , strCustomColor3 ? , strCustomColor4 ? WHERE ( (lngStoryId ?) AND (intPartNo ?) AND ((? IS NULL AND mmWidth IS NULL) OR (mmWidth ?)) AND ((? IS NULL AND mmHeight IS NULL) OR... |
|
| OLEDB for ODBC via /NET Framework (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have download the add in for .NET Framework ODBC .NET Data Provider, but as it alwayas is, it won't work. Please anybody have some solution. Actually, I am trying to make some WebService (in Mannaged C ) for manipulating data, over older existing ODBC connection to the Access database, and I am always getting the same error, something like "MSDASQL.1 is not supportet with .NET OleDbConnection". ... |
|
| ERROR Connection is busy with results for another hstmt (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm developing a tool that copies data between two DSN. When copying from any database to a SQLServer2000 database sometimes I get this message: ERROR [HY000] [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt I've found an explanation from the MSDN that tells that's a problem with thread, but I'm not using threading. What I'm doing is something like this: Open a ... |
|
| ODBC.NET RETURNS 0 RECORDS (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| The table has 9 records(rows) and with oledb, returned all into datagrid. Now returns none. Thanks, Chris (single form with 1 datagrid.) Imports Microsoft.Data.Odbc Public Class Form1 Inherits System.Windows.Forms.Form Public DV As DataView Public DS As DataSet Public DT As DataTable Public CN As OdbcConnection Public DA As OdbcDataAdapter #Region " Windows Form Designer generated code " #End Regi... |
|
| guest book using odbc.net (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I have created a basic page that should write back to the database but it doesn't. I just cant understand why! can anyone help? Here's the code %@ Page Language "C#" Debug "true" % %@ Import namespace "System.Data"% %@ Import namespace "Microsoft.Data.Odbc"% %@ Assembly Name "Microsoft.Data.Odbc" % !DOCTYPE HTML PUBLIC " //W3C//DTD HTML 4.0 Transitional//EN" HTML script language "C#" runat "se... |
|
| Paradox 7 through Odbc.Net (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm accessing a Paradox 7 database through Odbc.Net. All my Delete, and Select commands are functioning properly. However, after inserting records and calling Odbc.DataAdapter.Update an Odbc.OdbcException is thrown containing the following message: Message: [Microsoft][ODBC Paradox Driver]Invalid string or buffer length Native: 84 Source: odbcjt32.dll SQL: HY090 I suspect the error might be in my ... |
|
| ODBC.NET and ADO.NET (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm trying to figure out the role of ODBC .NET data providers in relation to the ADO.NET architecture. Do you have to use ODBC.NET in conjunction with ADO.NET, that is, as a data provider to ADO.NET, or can you drop down to a lower level and use connections and recordsets directly, without using DataSets, DataAdapters, and DataTables? I'm also looking for online help for the ODBC.NET classes. Kevi... |
|
| Online Help (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Is there any online help/documentation on ODBC.NET, and if so where? Mostly I'm looking for reference materials, but tutorials are good too. Kevin |
|
