| odbc.net not working?!? (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have installed the .netframework OK I have installed MDAC 2.7 I think OK no errors I have installed .net ODBC provider OK no errors Yet when I have the follwong aspnet code i get compilation errors ...data type not defined? Please tell me what I am leaving out %@ Import Namespace "System.Data" % %@ Import Namespace "Microsoft.Data.Odbc" % % Dim myConnection As OdbcConnection errors from here Dim... |
|
| HOW TO: Fill a DataSet from an Stored Procedure Using the ODBC .NET (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| . |
|
| Question about using database (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| How can I determine the number of results by select statement of OdbcDataAdapter? Without to fill the DataSet or DataTable with all results. I don't want to retrive all the results at once to my computer localy. It could be more results, then I have memory. |
|
| Cannot open Csv file uisng ODBC.Net (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have no luck in trying to test the opening of a Csv file using the short example in the ODBC driver documentation. Any ideas ? Dim myConnString As String "Driver {Microsoft Text Driver (*.txt; *.csv)}; DBQ c:\inetpub\wwrwroor\aspx" Dim myConnection As New OdbcConnection(myConnString) myConnection.Open() myConnection.ChangeDatabase("sales1.csv") CTX.Response.Write("Database: " myConnection.Databa... |
|
| Database metadata? (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Is there any way to get the whole database metadata? For example, To get the list of all Stored Procedure of Database. And get info about them. |
|
| Oracle OdbcCommandBuilder problems, guidance requested (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am attempting to import table data from an XML file into an Oracle 9i database table Oracle's ODBC driver (V9.00.11.00). The table name and its respective columns are all in mixed case. Using the recently released RTM ODBC.NET provider with RTM Visual Studio.NET, I either get "Invalid table name" or "invalid column name" when I attempt to update the Oracle table using the code below. Here is the... |
|
| Newbie; please help! (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi all, I've installed the ODBC.NET download, added a reference to it in the following trivial console app: dim x as new odbcconnection("data source test") x.open() When I execute this, an exception of type 'System.IO.FileNotFoundException' occurs in 'Unknown Module'. When I hit the Break button, I'm told that 'There is no source code available for the current location'. I've tried copying Microso... |
|
| Best way to convert ODBC 2 XML? (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have just been thrown back into the development side after a few years off. Can someone point me in the right direction? I need to open an odbc.net source (got that far). I need to then provide the dataset as an XML string. Is there an easy route or do I have to construct it manually. Would be happy with a url to a how to article Thanks Geoff |
|
| System namespace problem after installing ODBC.Net (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I get the following error even before I get to the ODBC code in a web application (no compilation errors). I'm pretty bewildered about what this means. Any help appreciated: Server Error in '/MDMLoadingWebAppl' Application. File or assembly name System, or one of its dependencies, was not found. Description: An unhandled exception occurred during the execution of the current web request. Please re... |
|
| ODBC connection pooling (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have downloaded the ODBC.NET which I use with VS.NET RC1. The documentation refers to ODBC documentation for activating connection pooling. I find some references to SQLSetEnvAttr in this documentation, but how do I use it from .NET (C#)? I understand it uses an attribute named SQL ATTR CONNECTION POOLING and I find an enumaration named ODBC32.SQL ATTR containing the value CONNECTION POOLING in ... |
|
| Sybase SQL Anywhere database connections (12 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| In the Server Explorer I have a Sybase SQL Anywhere database. It shows in the Data Connectuions tree. I can click on the TABLES tree item. It shows me all the tables. I can double click a table, see all the data. I can add, insert and update data from the server explorer. The problem is when I create a web form page and use the OLEDBDataAdapter to get data. I configure a connection...... Microsoft... |
|
| VB.net to link to ADO.Net & ODBC that will be supported on diffrent db platform (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| What I am trying to do is to get my VB.Net program to connect to diffrent db platform through ODBC, and ADO.NET. The DB platforms would be Access 2000, SQL 2000, and Oracle. I am trying with no success to read a UDL file and pass the paramters to connect to the database. And once I can connect to a database I would need to know how to read each record, Passing each feild within the record to the t... |
|
| Retrieve DSN List (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Is there a way to retrive list of ODBC DSN's throught the .Net framework (without having to make api calls)? |
|
| Connecting to Pervasive DB through ODBC (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi I'm new in ADO.NET & ASP.NET. I have some trouble with connection through ODBC Data Provider to Pervasive DB. I make small asp page which have only one DataGrid and it is a body of Page Load function: Microsoft.Data.Odbc.OdbcConnection myNurConn new Microsoft.Data.Odbc.OdbcConnection( "DSN Nurses"); Microsoft.Data.Odbc.OdbcDataAdapter myNurCmd new Microsoft.Data.Odbc.OdbcDataAdapter( "SELECT In... |
|
| Trouble using Microsoft.data.odbc dll (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I try to have a database connection using a DSN. I add a function in my "webForm1.aspx.vb" file and when i try to run my wheb application the following declaration raise errors. I already add reference to Microsoft.Data.Odbc.dll in my project. Dim CnODBC As New Microsoft.Data.Odbc.OdbcConnection (MyCnString) Thanks for any help. Errors : Server Error in '/sitepape/WebAppTest2' Application. File or... |
|
| Dataset and ODBC provider (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Tell me please, why can't .Net Studio use OLE DB provider for ODBC drivers in Data Set? When I try to drag some table of ODBC data base from Server Explorer, I receive the following message: "You cannot use an OLE DB provider for ODBC drivers." How to fix this? Or tell me (give URL) then how I can bind ODBC dataset to DataGrid (and other controls). Thanks! |
|
| Invalid Cast exception (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| A puzzler : I'm getting an invalid cast exception when accessing records using SqlDataReader call to an ST proc as in the following code : SqlDatareader result command.ExecuteReader (); while (result.Read ()) { string s (string) result ["somefield']; ... } The "somefield" is an nvarchar in the db and can be NULL. The odd thing is that the same code runs against the same db image on a different ser... |
|
| how to create a new database from c# (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi! I want to write a program that creates an .jet database with c#, but I can't find how to create a database, only how to open it. OleDbConnection MyConnection new OleDbConnection( "Provider Microsoft.Jet.OLEDB.4.0; Data Source MyDb.mdb"); MyConnection.Open( ); just throws an exception because MyDb.mdb does not exist. But I need a call to create MyDb.mdb has anybody out there an idea how to crea... |
|
| ODBC.NET analog for SQLTables (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| ODBC SQLTables returns the list of table, catalog, or schema names, and table types, stored in a specific data source. What is its analog in ODBC.NET or ADO.NET? |
|
| PRINT Results Truncated? (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| It appears that not all PRINT results are being returned from an ODBC.Net command execution. I am executing a command using the "SQL Server" driver and the ODBC.Net components (version 1.0.3300.0) for VS.Net RTM version. I'm executing the tests on my development workstation, which has MDAC 2.7 loaded. The CommandText is: PRINT 'Line 1' PRINT 'Line 2' PRINT 'Line 3' PRINT 'Line 4' PRINT 'Line 5' PR... |
|
| ODBC Exceptions (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I've been trying to get the ODBC Data Provider to work with my ODBC Driver, but I have run into a problem that is not consistent. Using the ODBC Data Provider I create a connection to the DSN and open it. I then create a new DataSet and ODBCDataAdapter. The query I issue is a simple "select * from table". I use the ODBCDataAdapter to fill my DataSet with the query results. And it works just fine. ... |
|
