| Compiler Error Message: BC30002: Type 'Microsoft.data.Odbc.OdbcConnection' is no (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I got this error code Compiler Error Message: BC30002: Type 'Microsoft.data.Odbc.OdbcConnection' is not defined. Using this asp.net code anyone who can tell me what s wrong %@ Page Language "VB" % %@ import Namespace "System.Data" % %@ import Namespace "Microsoft.Data.Odbc" % script runat "server" Sub Page Load(Sender As Object, E As EventArgs) ' TODO: Update the ConnectionString and CommandText v... |
|
| Mysql connection and usage question (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Ok, i've been looking all over the web for a way to connect through MySQL server so i create an offline application using my data from my Web Application based on MYSQL. I've looked at a lot of things this is my final try. I installed MDAC 7.0, The patch for ODBC.Net, and looked all over the place to find my odbc namespace or anything that looks like it. i can't find it... Can anyone refer me to a... |
|
| Updating SQL Server From a Dataset (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have a dataset that has the same columns as a DB table that I need to update. Is there an easy way to insert all the records of the dataset into the table without cycling through the recordset and creating INSERT statments? |
|
| Error Reading from a Postgres Database (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I run the following code and keep getting the following error: System.ArgumentNullException: Value cannot be null. Parameter name: dataTable I can connect to the database and step through records, but any effort to grab actual data results in this error. I have tried several methods, including DataReaders, DataTables, and DataGrids. Thanks, Steve Dim oConnection As Microsoft.Data.Odbc.OdbcConnecti... |
|
| Database - Please help me choose (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi. Thank you for anything you can help. I'm going to develop an application which has to access a database using VB.NET in a Windows enviroment. I'm new to DB development. What are the differences between the different types of databases and the different methods to access them? What I need to do is a form that searches through the database for a reference number or client name and displays the r... |
|
| ERROR Invalid value stored in pcbValue (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm trying to update a single record in an AS/400 database file using OdbcDataAdapter.Update. I'm able to create the record, using OdbcCommand.ExecuteScalar, but when try to update it, I get an OdbcError: "[IBM][Client Access Express ODBC Driver (32 bit)][DB2/400 SQL]Invalid value stored in pcbValue." The SQLState is HY090, and the Native Error is 10001. I'm not sure what the problem is, exactly. ... |
|
| ODBC Column Width (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I have a Select Statement ( "Select * from Customers" ). The execution works fine ( ODBCConnection, ODBCCommand, ODBCDataReader ). I get all Data, but not the size of the fields. MyReader.GetName(), MyReader.GetString(), MyReader.GetDataTypeName() How can I get an information, that field "A" is varchar (20) and not only varchar? Gero |
|
| ODBC .NET/Oracle DataSet Updates (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I display Oracle 8 data in an ASP.NET DataGrid server control, using the ODBC.NET Data Provider. I use a separate Web Form with a single direct OdbcCommand to insert new rows in my table successfully. However, whenever I make changes to the DataGrid (and the DataSet backing it), such as edit or delete a row, the DataSet changes are never reflected in the database. There are no exceptions thrown an... |
|
| What is wrong with this connectionstring? (6 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| This connectionstring works fine with ADO, but not with ADO.NET (ODBC.NET is installed) Provider MSDASQL.1;Persist Security Info False;Data Source JOF This is the .NET code: Private Sub Read() Dim objConn As OdbcConnection Dim objCMD As OdbcCommand Dim objDR As OdbcDataReader objConn New OdbcConnection("Provider MSDASQL.1;Persist Security Info False;Data Source JOF") objConn.Open() objCMD New Odbc... |
|
| Accessing a sybase anywhere 5.0 server (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am trying to write I web user interface that can make queries against a Sybase Anywhere 5.0 Database. On the test setup, the Database server will and IIS will be running on the same machine. My problem lies when I try to make I connection to the database. string strConnection "DSN USData"; string strSelect "SELECT * FROM bl"; OdbcConnection odbcConnection new OdbcConnection(strConnection); OdbcC... |
|
| ODBC & MSACCESS DSN (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am new to Visual Studio and ASP.NET development so I hope that someone can help here. We are redeveloping an application from ASP to ASP.NET and the application revolves around several MS Access databases. The Application uses a DSN connection to the database that are located across server server etc... I have read posts on this and when I try to access one of these DSN's with VS.NET I get this ... |
|
| Command Builder fails as missing owner/schema parameter (6 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Ran same OdbcCommandBuilder test against a SQLServer data source and against a Caché data source. The Caché test fails because of a call to SQLPrimaryKeysW with NO value specified for the 'Schema/Owner' input parameter. The SQLServer test succeeds because SQLPrimaryKeysW is NOT called!!! Example table was created in both databases using : create table user1.table1 (field1 varchar(10) primary key, ... |
|
| AS400 database (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| is it possible to access AS400 database using Visual Basic.NET or C#? |
|
| odbcdataadapter (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Can help me with this code what wrong ? Dim con As New Microsoft.Data.Odbc.OdbcConnection() Dim cmd As New Microsoft.Data.Odbc.OdbcCommand() con.ConnectionString "DSN mysqldsn" Strsql "Select * from user" Dim Ds As New DataSet() Dim objDA As New Microsoft.Data.Odbc.OdbcDataAdapter() objDA New Microsoft.Data.Odbc.OdbcDataAdapter(Strsql, con) objDA.Fill(Ds, "test") DataGrid1.DataSource Ds DataGrid1.... |
|
| Error updating paradox db (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello all I am writing a .NET application to transfer data from multiple Paradox DB sources to a SQL server for consolidated reporting. After transferring a record, I want to update a flag column so that I can transfer only unflagged (new) records from the file. I am using Microsoft.Data.Odbc classes to read data from the Paradox DB into .NET DataSet. The transfer from Paradox to SQL is working fi... |
|
