We don't use a connection to a SQL Server, and therefore when I try paging, the simple way to do it using a SQL DataAdapter does not work. Is there an alternative for this, such as for an ODBCDatatAdapter? I looked through the available Objects and could not find anything similar for and ODBC Connection (we connect to a DB2 database using RPC's written in COBOl and create Class modules to connect to the CICS region...it is not pretty) Does anyone have any suggestions for a replacement for the DataAdapter? TIA...
Coleen
---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community Website: http://www.dotnetjunkies.com/newsgroups/ 12  1799 
What server are you using?
<coleenholley> wrote in message
news:uF**************@TK2MSFTNGP12.phx.gbl... We don't use a connection to a SQL Server, and therefore when I try
paging, the simple way to do it using a SQL DataAdapter does not work. Is
there an alternative for this, such as for an ODBCDatatAdapter? I looked
through the available Objects and could not find anything similar for and
ODBC Connection (we connect to a DB2 database using RPC's written in COBOl
and create Class modules to connect to the CICS region...it is not pretty)
Does anyone have any suggestions for a replacement for the DataAdapter?
TIA...
Coleen
---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest
Community Website: http://www.dotnetjunkies.com/newsgroups/
We connect to a Mainframe not a particular server. We use CICS to establish the connection. Unfortunately, I don't know that much about the connection process, except that the code in the Class Modules to connect is UGLY! I didn't write it, and I don't understand most of what was written, so it's really a difficult process to try and troubleshoot the paging errors. Basically, the If Not Page.IsPostBack doesn't seem to work for us...the same set of data is returned each time you select a page number, then after switching through the pages, everything disappears - no datagrid, no labels, nothing...weird! Any help is appreciated :-) Coleen
---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community Website: http://www.dotnetjunkies.com/newsgroups/
If you are not connecting to SQL Server, then you should not be using any of
the classes in the SQLClient namespace, instead use the classes in the OLEDB
namespace. You could then use the OLEDB.DataAdapter.
<coleenholley> wrote in message
news:uF**************@TK2MSFTNGP12.phx.gbl... We don't use a connection to a SQL Server, and therefore when I try
paging, the simple way to do it using a SQL DataAdapter does not work. Is
there an alternative for this, such as for an ODBCDatatAdapter? I looked
through the available Objects and could not find anything similar for and
ODBC Connection (we connect to a DB2 database using RPC's written in COBOl
and create Class modules to connect to the CICS region...it is not pretty)
Does anyone have any suggestions for a replacement for the DataAdapter?
TIA...
Coleen
---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest
Community Website: http://www.dotnetjunkies.com/newsgroups/
I'll try that...hope it works with our configuration :-) Thanks.
---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community Website: http://www.dotnetjunkies.com/newsgroups/
Do you at least know what kind of database you are using? When you say
"mainframe" are you referring to UNIX or AIX or something else?
"coleenholley" <coleenholley@-NOSPAM-dmv.state.nv.us> wrote in message
news:uj**************@TK2MSFTNGP09.phx.gbl... We connect to a Mainframe not a particular server. We use CICS to
establish the connection. Unfortunately, I don't know that much about the
connection process, except that the code in the Class Modules to connect is
UGLY! I didn't write it, and I don't understand most of what was written, so
it's really a difficult process to try and troubleshoot the paging errors.
Basically, the If Not Page.IsPostBack doesn't seem to work for us...the same
set of data is returned each time you select a page number, then after
switching through the pages, everything disappears - no datagrid, no labels,
nothing...weird! Any help is appreciated :-) Coleen
---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest
Community Website: http://www.dotnetjunkies.com/newsgroups/
if this doesn't work there is an odbc.net assembly for download from
microsoft. i believe it comes standard in the framework v1.1 as the
system.data.odbc namespace, but you'll have to download it separately if you
are using v1.0.
you can find it here... http://tinyurl.com/3c3dh
we've used it to connect to a btrieve backend and it's relatively reliable.
there are problems though mostly associated with provider compatibility, not
the classes themselves...
hope this helps,
jim
<coleenholley> wrote in message
news:uC**************@TK2MSFTNGP10.phx.gbl... I'll try that...hope it works with our configuration :-) Thanks.
---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest
Community Website: http://www.dotnetjunkies.com/newsgroups/
* coleenholley <coleenholley@-NOSPAM-dmv.state.nv.us> scripsit: We connect to a Mainframe not a particular server. We use CICS to
establish the connection. Unfortunately, I don't know that much about
the connection process, except that the code in the Class Modules to
connect is UGLY! I didn't write it, and I don't understand most of what
was written, so it's really a difficult process to try and troubleshoot
the paging errors. Basically, the If Not Page.IsPostBack doesn't seem
to work for us...the same set of data is returned each time you select a
page number, then after switching through the pages, everything
disappears - no datagrid, no labels, nothing...weird! Any help is
appreciated :-) Coleen
Would be great if you break lines after 76 chacters.
Posted using Wimdows.net NntpNews Component - Posted from .NET's
Largest Community Website: http://www.dotnetjunkies.com/newsgroups/
Dumb web interface.
--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
Hi Coleen,
Why do you not look what webservice can do for you.
That is as far as I know one of the few places this two worlds reach each
other very close.
(The only thing I did not see in your message was if the Mainframewas using
EBCDIC or ASCII)
Cor We don't use a connection to a SQL Server, and therefore when I try
paging, the simple way to do it using a SQL DataAdapter does not work. Is
there an alternative for this, such as for an ODBCDatatAdapter? I looked
through the available Objects and could not find anything similar for and
ODBC Connection (we connect to a DB2 database using RPC's written in COBOl
and create Class modules to connect to the CICS region...it is not pretty)
Does anyone have any suggestions for a replacement for the DataAdapter?
TIA...
Coleen
Thanks for your help :-)
I'm not sure if this will help with my paging problem or not, but at this point anything is worth a try!
---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community Website: http://www.dotnetjunkies.com/newsgroups/
We connect to a DB2 database that resides on the Mainframe - we use CICS to get the connection, and our other main application (PowerBuilder) uses middleware - "Interspace" to convert to the COBOL code for datatypes and field sizes. Since we don't have "Interspace" when using .Net, we have created a long, ugly routine to get the datatypes and filed sizes from/to COBOL. It is definately not my favorite way of connecting, but we don't have a choice...Thanks for the help, it is much appreciated :-)
---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community Website: http://www.dotnetjunkies.com/newsgroups/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: chris |
last post by:
Hi,
I have a table in the database. I have a method which will
return a table with the same structure as the DB one and
with all data I need.
What I want to do is to remove all data in the DB...
|
by: Lasse Edsvik |
last post by:
Hello
I'm trying to build a simple COM+ app in vs.net using C# and i cant register
it in component manager.....
what more is needed than this:
using System;
using...
|
by: W Akthar |
last post by:
I am trying to use SqlDataAdapter to execute a Stored
Procedure.
The Stored Procedure is as follows
CREATE Procedure SP_GetAddressesFromContactID
@ID int
AS
SELECT
b.StreetAddress1,
|
by: Bill |
last post by:
Got a form that pulls data and allows for the user to enter a
response in a textbox and I have a button that is supposed to push this
reponse text back to the database for that record when clicked....
|
by: Jerry Higgins |
last post by:
I added a SqlDataAdapter to a web form, created a data
connection, and generated a dataset. I then connected it
to a DataGrid control. When I do this using the
SqlServer database on my machine...
|
by: Victor |
last post by:
Hello there,
I have a module in VB.NET (ASP.NET) and on top I declare the
SqlConnection and the SqlDataAdapter.
Like:
Module AccessDB
Dim sqlCmd As New SqlCommand
Dim conAanvraag As New
|
by: Matt Jensen |
last post by:
Howdy
Fairly simple question I think, I presume the answer is no it can't be
reused for 2 *SELECT* statements, but just hoping for clarification. Just
asking in the interests of trying to minimise...
|
by: Roy |
last post by:
Hey all,
Here's a small VB codeblock that connects to a database and uses 2 SQL
queries then forms a relation for a master/detail view on the aspx side:
Private Sub Binddata(ByVal name As...
|
by: languy |
last post by:
Hi there
I'm having a problem when using the SqlDataAdapter. When calling the
Update(DataSet, string) method I get the following error message "String or
binary data would be truncated". The...
|
by: kempshall |
last post by:
When I use an SqlDataAdapter to fill a DataSet from a database, do I
need to explicitly open and close the SqlConnection that I'm using? For
example, I have code that looks like this:
...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
