| Prb faced when Executing SQL Statements containing INNER Join with Microsoft .NET Oracle Client. (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I'm using Microsoft .NET Oracle Client to communicate with my Oracle DB, my sql statement uses INNER JOIN , WITH (NO LOCK) which is passed to OracleCommandBuilder. I know that Oracle doesn't support them but i cannot change my sql format as its being prepared within my COM component. Can someone please tell me how to solve this problem so that my SQL works for both SQL Server and Oracle DB? Re... |
|
| Trouble connection using OBDC (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I cannot connect to a SQL Server using a DSN.Can anyone tell me what is wrong. I have included the code below: Friend Function GetConnection(ByVal strDSN As String) As Microsoft.Data.Odbc.OdbcConnection If strDSN Is Nothing Then Return Nothing If strDSN "" Then Return Nothing Dim strConnectionString As String "dsn " & strDSN Dim oConn As OdbcConnection Try oConn New OdbcConnection(strConnectionStr... |
|
| odbc.net not working with asp.net (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Has anyone has problems or success with using ODBC.NET with ASP.NET? I successfully installed ODBC.NET, and checked that the namespace "Microsoft.Data.Odbc" did indeed make its way into the global assembly cache (by using the Visual Studio.NET gacutil.exe at the command prompt). When I run the aspx file below from Internet Explorer, I get the error message that "OdbcConnection type is not defined"... |
|
| Updates to DB2/AS400 (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have a good connection to the AS400 using the ODBC.NET adapters. I can get whatever records I want. However, In the example below, I can't figure out how to write the Insert String, so that it will work for multiple records and the general "Update" method of the data adapter will work. My tables have primary keys, but that information doesn't seem to come across with the ODBC .NET classes. The O... |
|
| Database table schema (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Does anyone know how to get the schema for a database table without using a data reader. I want to read the complete schema for each table in a database the first time each table is accessed irrespective of the columns referenced in that first access. |
|
| Detect if ODBC is installed? (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'd like to do this: Dim Conn as IDBConnection If usermachine has ODBC installed then Conn New Microsoft.Data.Odbc.OdbcConnection() else Conn New OleDb.OleDbConnection() However, references to ODBC generate compiler errors if the user's machine does not have the classes in the ODBC namespace installed. Is there a way to include/exclude source lines conditionally in order to prevent such errors? Th... |
|
| ASP.NET or ASP (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Is it a good idea to use ASP.NET or ASP at the moment? Which one is more compatible with browser at the moment? |
|
| Use DELETE + INSERT for UPDATE (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, The DB we're using for our .NET application doesn't support the UPDATE statement when the key column was changed. We need to call a DELETE statement first, followed by an INSERT statement. In PowerBuilder, it was possible to specify this, so we didn't have to worry about it. Is there something like this in ADO.NET ? Steven |
|
| Ingres Record Lock (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi Everyone, I m doing the coding first time with the Ingres database in Asp.net. I need to lock the record thile reading thorough the asp.net. Now pls tell me how can achive this so that other user at the same time cannot update this record which already locked by one user. The another thing is I want to decrease the timeout with the record lock, i tried to lock the record explicitly but the reco... |
|
| Storing BLOB's with OdbcCommand (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi How can I store a BLOB (adLongVarBinary) with the OdbcCommand Object? I have to use an SQL Statment like "insert into mytable(description, binary) values(?,?)" The source is from a dataset like: Dim byteBLOB() as Byte byteBLOB MyDataSet.Tables(0).Rows(0)("BLOBField") Thanks markus |
|
| Please help, having trouble accessing Sybase Anywhere 5.5 database from ASP.Net application. (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have previously posted this message a few months ago. The response I got was to do something with the security permissions. I think there was also something done with the .net console, but I cant remember. The odd thing is that I have no problems creating a connection to the database through the server explorer in visual studio.net, but when it comes down to creating a connection in code, I fail... |
|
| IsDBNull does not work from ODBC (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am using MICROSOFT.DATA.ODBC The line with Getdouble is working. I get the value from the datareader The next line is NOT working: OBJECT REFERENCE NOT SET TO AN INSTANCE OF AN OBJECT dd is from type double lboolean is fom type boolean Which object is not set to an instance ?? The datareader is OK, because in the line before i can read the correct value What is wrong in my brain ?? Thanks for an... |
|
| Sybase and DataReader (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I'm using the OdbcDataReader to access Sybase 11.9. I'm running into an unexpected behavior. The reader is giving me data in bursts of 50 records then stops for quite sometime then another burst of 50 records. Is this normal? Thanks, Paul |
|
| Memo size BUG (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm inserting rows in a MS Access database into the following table using parameters: CREATE TABLE MODEL ( F MODEL ID LONG NOT NULL, F MODEL MEMO NOT NULL, CONSTRAINT PK MODEL PRIMARY KEY (F MODEL ID) ); I can only insert into "F MODEL" strings with a length between 1 255 or 2000 and up. Any string with a length between 256 and 1999 throws the following error: "ERROR [HY104] [Microsoft][ODBC Micro... |
|
| Assembly name comparison mismatch: Build Number (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I am using System.Data.OracleClient to connect to Oracle. I have problem while running the application. I get this error : f:\mycsharp\Oracle OracleClientTest.exe Unhandled Exception: System.IO.FileNotFoundException: File or assembly name System, or one of its dependencies, was not found. File name: "System" at mycon.Main() Fusion log follows: LOG: Post policy reference: System, Version 1.0.33... |
|
| DataAdapter.UpdateCommand (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello, I've been struggling for a while with a small problem, which has to do with updating a data source table, while working with a dataset. I have a database table with product information that I want to display one by one and allow the user to update, delete or insert a new row into. The problem comes in when I try to do that from a SQL View object. The view formats the necessary values, which... |
|
| Database DSN question (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello friends. I am a newcomer to asp.net. I have an access database on my web server(at an isp) and I have configured the DSN as "northwind" and the path is wwwroot/data/northwind.mdb. Now I wish to access the data using asp.net. I have found many books which give the code for sql and oldb connecvtion. But I cannot find any code on how I can connect to this database dsn. Can someone guide me to s... |
|
| AS400 and apostrophes (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have a description that has an apostrophe in it. ("D'Huez"). I'm using an insert statement for an AS400 ODBC connection like this: dim sA7ITEMDES as string "D'Huez" dim sInsertString as string "INSERT INTO myPartition.Mytable( A7ITEMDES ) VALUES ('" & sA7ITEMDES & "')" MyConnection.connectionstring sMyConnectionString MyCommand.connection myconnection MyCommand.commandtext sInsertSTring MyConnec... |
|
| Datareader not returning recordset (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi guys, I'm using VB.NET with ODBC to access a DB2 database running on an AS400. I have a system DSN set up through the control panel using a DB2 provider from IBM. Setting up DB2 through the Server Explorer option, I can right click the table and choose "Retrieve Data from Table" successfully. However, if I use code then no dataset is returned. Peforming the ODBCDataReader.Read() function to ret... |
|
| MAXIMUM CURSORS EXCEEDED in Oracle 8.7.1 (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have a form that allows the user to execute ad hoc type queries on a specific table in an oracle 8.7.1 database. After executing 2 or three queries, I get an exception from the database reading MAXIMUM NUMBER OF CURSORS EXCEEDED. I am using the oracle client downloaded from the Microsoft web site and I'm using the Oracle Data Adapter to execute a stored proc and retrieve a ref cursor which I the... |
|
| Exception when executing a stored procedure (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| First some facts about I want to do: Declaration of SP: CREATE PROCEDURE dbo.sp WnGetMasterIds input params @strTableName varchar(50), @intNbIds int, output params @strOut varchar(8000) OUT 8000 is the maximum for varchar AS ... To execute the SP, I create a command an add the parameters to the OdbcParameterCollection. I've set then CommandText as {? call sp WnGetMasterIds (?,?,?)} and tried to ex... |
|
| HI How to Convert Text file to table? (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| HI Can any one send a query string to covert text file to Table? (And i want to fill this table into dataset ) Love Murali |
|
| Can't read BLOB fields from MySQL using ODBC.NET (7 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| This is in fact terrible. As it has stalled me completely.. :o\ I've tried both OdbcDataAdapter and OdbcDataReader. Every other type can be read except BLOBs.. Is that really too much to ask? ;o) What I want is just to be able to have text fields longer than 255 chars.. There really must be a way to fix this problem or ODBC.NET would be completely useless.. :o\ And I have to use ODBC.NET with MySQ... |
|
| Bug in Jet 4.0 OLEDB Driver? (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I think I have found a reproducible bug in the OLEDB Jet 4.0 driver. The attached zip file has a VB.NET sample that demonstrates the problem. Program Steps 1) Create a dataset, populate it with more than 1 row and display in 1st datagrid (click on Populate button) 2) Create a data adapter with stored procedures for insert statement (click on Save button) 3) Execute data adapter Update 4) Retrieve ... |
|
| References in VS .Net (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| What are the References in VS . Net useful for? I followed an example with adding the microsoft.data.odbc.dll to this, but I still had to use a %@ CompilerOptions '/R:"C:\Program Files\Microsoft.NET\Odbc.Net\Microsoft.data.odbc.dll"' % directive in order for VS .Net to build my application successfully. Shouldn't the Reference taken care of this? Regards, Jonathan Scott Web Architect Miniature Pre... |
|
