| syntax problem? (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Trying to use ODBC .NET data provider, I succeed in connecting to my DBMS, but am failing to execute a data reader. Can someone help with syntax? Thanks. My stored procedure GET PERSON has four parameters: status is an output integer, somid is the only input and is integer, lname is varchar(35) output, fname is varchar (35) output. Private Sub Button3 Click(ByVal sender As System.Object, ByVal e A... |
|
| Connect to Paradox Database (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello nG! There s a way to connect to Paradox with C#? I tried to make an ODBC connection but appears one message tell me about the incompatible of OleDbDataAdapter. Any idea, please! Thanks. Fernando Lopes |
|
| Stored Procedure does not return multiple tables. (9 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am passing a single parameter to a stored procedure that returns two or more tables. The first table is created in the dataset with no problem but I get a NullReferenceException error. Here is the code. Dim oConn As New OdbcConnection() Dim oCom As New OdbcCommand() Dim da As New OdbcDataAdapter() Dim ds As New DataSet() oConn.ConnectionString "DSN " & ServerName & ";UID user;PWD pwd;" oConn.Ope... |
|
| update a table? (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello, I don't know which group to send this one so I picked the ones I think someone might hear some bells ringin'...(ODBC newsgroup seems abandoned windmills and all), here goes: This is to try and update a table with ODBC connectivity to an Informix SE database. The compiler doesnt complain, and it kinda looks like what they tell us to do in the (most useless when it comes to ODBCing) .NET book... |
|
| OdbcDataReader Getters Bug or limitation? (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have an integer datatype defined in my odbc datasource, when I attempt to do a GetString() from the OdbcDataReader, it throws an InvalidCastException, why can't the .NET ODBC data provider convert it to a string for me? Is this a limitation or is it a "strong type" feature? |
|
| ODBC DSN (7 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am trying to connect to a System DSN using the ODBC .NET provider. When I set the connection string to "DSN xxx"; I get a data source not found error. I do not want to use a Driver keyword, but when I do use one like "Driver {SQL Server};DSN Info;" I get a SQL Driver error that DSN was not specified. Is there some problem with the DSN keyword? Thanks, Jeff |
|
| dsn (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| i have an odbc driver for both clarion, and dataflex. i have my datasources set up and they work great with crystal and other apps. how do i connect to them using ado.net? hq |
|
| Update real type field with a null? (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| How can I update/insert a nullable real type field with a null value. My situation is that I already have a value in the real field which is nullable and I need to update it to nothing which is null. No other value is acceptable. |
|
| excel - unknown worksheet name - no automation (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I am using odbc.net to read in data from several different external file types, including Excel (2000). When I try to load excel data I supply the name of the worksheet as the table name, and fill the dataset based on that worksheet. (See the code snippet below.) If I know that name of the worksheet say "Sheet1" then I affix a "$" to signify that it's a worksheet and everything works well. However... |
|
| ODBC connection for Oracle 8i (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Can any one tell me for syntax on connect Oracle8 with ODBC connection strings? using oledbconnection. TIA, Peter C. |
|
| Oracle database (8 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, Does anybody know how to use an Oracle database in VB.NET? Where can I start looking on the internet for information about the standard operations (query, insert, update etc) Julian |
|
| Looking for a user Login example using mysql and odbc.net (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I have an example login page from asp.net unleashed, but unfortunately it does not cover either odbc.net or mysql.The other problem is that it uses a stored procedure which I dont believe mysql supports? I was wondering someone could either provide a sample or help me out with converting this one: %@ Import Namespace "System.Data" % %@ Import Namespace "System.Data.SqlClient" % Script Runat "S... |
|
| ODBC.Net & SQLBase (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi Is there anyone how has already used the Microsoft ODBC .Net Provider to access SQLBase? I'm using it and it works quiet fine. But when I try to use parameters in my SQL statements, errors appear.. Anyone who knows how to make that run?? This is my code: parameterName ":1" strSql "SELECT * FROM table1 WHERE begindate :1 AND (enddate :1)" Dim dataCommand As Microsoft.Data.Odbc.OdbcParameter data... |
|
| Sybase ODBC connection problems in dotnet (8 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I've created an ODBC connection using the Sybase System 11 driver. Within dotnet, I'm able to create an SqlConnection object using this ODBC connection. Clicking on the "Test Connection" button also succeeds. However, once I try to add an SqlCommand, I receive the following error: "Server does not exist or access denied." I receive the same error when I create the connection string programatic... |
|
| Connecting to Faircom Db using ODBC.net (6 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| My application uses an OdbcDataAdapter to access Faircom c tree db files. I succesfully carry out simple selects, inserts, deletes and updates using OdbcDataAdapter (SQLText, Connection) then fill a Dataset. But when I have finished the updates and then open a new dialog form (i.e. new myForm()) an Exception is thrown (ArithmeticException in System.Drawing.dll). I created an Access Db with the sam... |
|
