| DSN Connection using MS Access (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I am trying to do a DSN connection using MS Access. I downloaded the ODBC .NET Provider and installed MDAC 2.7 RTM Refresh. I created a project(using VS.NET) and added reference to Microsoft.Data.ODBC.dll. I have imported these two namespaces also: Imports System.Data Imports Microsoft.Data.ODBC When ever I run the application it is giving the following error: ERROR [IM002] [Microsoft][ODBC Dr... |
|
| How do you implement a client-side cursor? (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm converting an old Powerbuilder client/server app to C# using an ODBC.NET driver to an ASA database. The select statements for the new C# program are executing extremely slow over the network, about 35 seconds for 300 rows. The old Powerbuilder app took about a second (using ODBC as well). I enabled ODBC tracing and found that my C# program invoked a server side cursor on the database. The trac... |
|
| There can be only one 'page' directive (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, i would like to know how i should combine without creating any problems. %@ Page Language "vb" AutoEventWireup "false" Codebehind "WebForm1.aspx.vb" Inherits "Main.WebForm1"% %@ CompilerOptions '/R:"C:\Program Files\Microsoft.NET\OracleClient.Net\System.Data.OracleClient.dll"' % I do want to use the aspx.vb page. If i was to remove the first line, and include the VB code in the 'Script' Tag, i... |
|
| Web Form postback overwriting data in textboxes/dataset (6 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| This simple app shows database field contents in textboxes, and is supposed to allow the user to modify the contents of the textbox and write those changes to the database bhy clicking a button that invokes a subroutine for updating the database. A Page Load sub fills the textboxes with database data for display. The button on my Web Form seems to automatically trigger a Page Load event, repopulat... |
|
| HTML TO SQL (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| anyone knows how to transfer the source code from a html file to a sql server database? |
|
| Problem with ODBC accesing a DBase table (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello I'm using this code to access a Dbase III dbf file, the problem is with the logical values, it give me error when I try to insert a logical value Any advice will be greatly appreciated Thanks, Ignacio Machin. OdbcConnection conn new OdbcConnection("DSN MAQ ODBC"); conn.Open(); string sqlQuery "insert into somast01 values( ' 413697' , '2104 ' , '04/23/2003' , '04/23/2003' , ' ' , 'origin' , '... |
|
| Merging Two FoxPro Databases (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello All, I have an application that uses a FoxPro database. Two separate copies run on two distinct computers. Assuming that the starting point for each FoxPro database is the same, I need to merge the changes each day. Specifically, what I want to do is use C# and ADO.NET to connect to the two different FoxPro database instances and merge the changes into one FoxPro database that is redeployed ... |
|
| Problems with Connection Pooling and odbc.net (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I seem to have a problem that is similiar to MS Knowledge Base Article 319345. When I have connection pooling enabled and kill (for testing purposes) the connection from Sybase I can no longer connect to Sybase from my service and the only way out is to stop and restart the service. When I have connection pooling disabled I am able to recover from the error. Following is the stack trace I receive:... |
|
| unable to open a Ole Db connection (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I try to connect on a Access 2000 database, using the code given in the .NET framework documentation: OleDbConnection dbBaseAgenda new OleDbConnection("Provider SQLOLEDB;DataSource localhost; IntegratedSecurity SSPI;InitialCatalog BaseAgenda"); dbBaseAgenda.Open(); Very simple code, but unfortunatly it doesn't work : the Open method times out. As a newbie in the .NET world, I can't make it wor... |
|
| ODBC won't connet using framework 1.1 (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi. I've just upgraded to vs.net 2003, and now the ODBCConnection dosen't work any more. I have a native ODBC driver to MBS's (old Navision) Concorde XAL, which still works fine with MS Query and even within VS.NET server explorer, but not in the VS.NET (windows forms) applikation The followering code snippet will fail: System.Data.Odbc.OdbcConnection cn; cn new System.Data.Odbc.OdbcConnection() c... |
|
| ERROR Operation must use an updateable query. (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi all, I have a very simple Excel 2002 file called "Target.xls". The file has just 1 worksheet called "Target". Inside the worksheet, I have defined 3 columns whose headers are in turn called "TargetId, "TargetName" and "TargetPhone". I am just trying to insert one row into the Excel file using Odbc.Net Driver. BTW, I am using .NET Framework 1.0, but I don't think it matters. Below is my attempte... |
|
| Update Data in DataGrid via DataTable, DataSet, ODBCDataAdapter, ODBCCommand ODBCConnection. (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm trying to write a simple app to change a Boolean colum in a FoxPro DB. I'm able to get the Data into a Grid and I can see the Boolean Field and I can Check/UnCheck it. Now I want to save that change. Seems like you should just be able to do a ..Update on the DataSet and it knows how to update the table. I've added a seperate ODBCCommand for the Update and have assigned it to the OdbcDataAdapte... |
|
| vb.net ODBC to dbase (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I'm trying to read a dbase file with the odbcreader and seem to be just going in circles. Here is the code I was trying to use with no luck. Also where do I find info on the use of odbc from a programming view, I can't seem to find much in the VS help files. Thanks Joe Dim oODBCConnection As OdbcConnection Dim sConnString As String "Dsn EIS Dbase Files;Uid ;Pwd " Dim mystring As String "Select * f... |
|
| unable to open a Ole Db connection (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I try to connect on a Access 2000 database, using the code given in the .NET framework documentation: OleDbConnection dbBaseAgenda new OleDbConnection("Provider SQLOLEDB;Data Source localhost;" "Integrated Security SSPI;Initial Catalog BaseAgenda"); dbBaseAgenda.Open(); Very simple code, but unfortunatly it doesn't work. As a newbie in the .NET world, I can't make it work. Do you hav any idea?... |
|
| MS Access database on Windows 2003 Web Server (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi Kevin, Thanks for getting back to me. I am using C# with asp.net to access the database. Below is the code that I am using to access the two tables. string DataBaseName; string SelectCommand; NameValueCollection coll; coll Request.ServerVariables; DataBaseName coll.Get("APPL PHYSICAL PATH"); DataBaseName "Databases\\db.mdb"; OleDbConnection CustomerConnection new OleDbConnection( @"Provider Mic... |
|
| INSERT fails in OdbcConnection (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| the following code throws an exception when run under .net 1.1. the entire exception message is the ever helpful "Additional information: System error." (nothing else). the database, table and column all exist. the connection gets created ok. any ideas? thanks, dave OdbcCommand odbccmdTest m odbcconn.CreateCommand(); string strSqlInsert String.Format( "INSERT INTO {0} ({1}) VALUES{2});", "Test", "... |
|
| an encrypted connection string in the registry (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| hello, this is in reference to the article using encrypted connection string in the registry. http://msdn.microsoft.com/library/default.asp?url /library/en us/dnnetsec/ht ml/SecNetHT11.asp what i would like to know is, after the connection string has been encrypted, how does one call that particular connection string, in the ASP.NET page. I am using VB as the language. Thank you |
|
| Problem with an "System.Data.SqlClient.SqlException" (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I've got a problem and I hope if anyone could advice or help me on this issue?... Thanks Nuno Event Type: Error Event Source: Utilities Event Category: None Event ID: 0 Date: 18 06 2003 Time: 10:13:33 User: N/A Computer: DGRNFMKQITIJ01 Description: DBHelper.ExecuteDBNonQuery(), Erro: System.Data.SqlClient.SqlException: Invalid column name 'codAreaFunc'. Invalid column name 'codPedido'. Invalid col... |
|
| Data source name not found and no default driver specified (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I keep getting the following error message: .... Data source name not found and no default driver specified .... When I try to connect to an Access database through ODBC. My code is as follows: .... OdbcConnection Conn new OdbcConnection "DSN test,UID ;PWD "); Conn.Open(); .... There was another thread in this newsgroup that talked about permissions to the registry hive. I have added the deafult w... |
|
| OdbcDataAdapter - SQL Anywhere 5.0 - Select statement with parameter problem (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I am trying to configure an OdbcDataAdapter using SQL statements using the "Query Builder". I want to create a criteria based on a parameter value. Normally, with a SQLdataadapter, I would just drop @OrderNumber in the criteria field for the OrderNumber column. This would generate the correct parameter for the select statement etc. When I run the query inside of the "Query Builder" it works ju... |
|
| Betreive ODBC (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| OdbcDataAdapter adapter new OdbcDataAdapter("Select * Form MyTable", this. connectionStringODBC); adapter.Fill(ds, tableName); I get the following error where I run this code, it's having problems with one of the dates. how can I force it to read the data or ignore the error, I can read the data with Access even when the data is bad: System.ArgumentOutOfRangeException: Specified argument was out o... |
|
| ODBC connection to AS400 Stored Procedure (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have created a Stored Procedure on an AS400 system and I am trying to call it from VS.Net (ODBC.NET). I am using a DNS less connection and the connection itself is fine. I can open it and close it. The problem is the call of the Stored procedure. I have two input variables and I have set them to OdbcType.Char and size 10. I have one output variable that is OdbcType Char also size 10. After the a... |
|
| Help with API SQLDescribeCol (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am trying to call the SQLDescribeCol API from inside a .net project. Here is my declaration and the function where it is called. I am getting a retcode 0, which is good, but .net gets a err#91 "Object reference not set to an instance of an object." I cannot figure out what could be causing this Any ideas????? Private Declare Function SQLDescribeCol Lib "odbc32.dll" (ByVal hstmt As Integer, ByVal... |
|
| Sage Line 100 ODBC Connection Error (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I am trying to connect to the Sage Line 100 accounting system database via their ODBC driver (v2.00.00.75) and the .NET ODBC Managed Provider, but receive the following error: Unhandled Exception: System.NullReferenceException: Object reference not set to an instance of an object. at System.Data.Common.Odbc32.SQLFetch(IntPtr StatementHandle) at Microsoft.Data.Odbc.OdbcDataReader.Read() at Syst... |
|
| Running stored procedures through Microsoft.Data.ODBC (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I have an app that is using the ODBC assembly. I am wanting to return a DataRow from a call to a stored procedure that exists on a Sybase server. The stored procedure takes one parameter called @name that is a varchar 32. code: OdbcParameter[] parameters {new OdbcParameter("@name", OdbcType.VarChar, 32)}; parameters[0].Value paramName; When the app tries to call the stored procedure, an error ... |
|
