| Use OleDB DB2 provider type without extra software? |
|
 |
Index ‹ DotNet ‹ ADO
|
- Previous
- 1
- Dotnet >> Desktop will not display shortcutsI down loaded and installed iTunes update. Noted that it took a long time to
"finalize". When finished iTunes shortcut had disapeared. When I restarted
computer all shortcuts were gone from desktop.
Restore function will not restore to any point prior to install.
Shortcuts sent to desktop do not appear.
Any ideas?
--
RFP
- 2
- Visual C#.Net >> advice for simple scenariohey all,
i have a gridview inside my web user control that's inside my .aspx page. i
have the CRUD(create,read,update,delete) buttons on my .aspx page but outside
the user control.
the rule is i have to select a row in the gridview in order for the edit
link to be enabled. and if the new button is pushed i have to disable the
other links appropriately (Cancel is enabled, Edit is disabled, Delete would
be disabled, etc)
i guess what i'm asking what's the best way to keep the CRUD buttons sync
when my gridview is inside a user control but the CRUD buttons have to reside
outside that user control?
thanks,
rodchar
- 3
- Visual C#.Net >> simulate copy commandHow do I run following from csharp from "server"?
copy file.txt \\server\printer1
Also how can I submit a text file print job to local print queue "printer1"?
Assuming I run copy command from server.
TIA!
- 4
- 5
- Visual C#.Net >> hiding a rows in DataGridViewComboBoxColumnAfter a value from the combobox has been selected in a previous row of the
DataGridView, I would like to hide that value from being selectable in the
combobox in a new row of the DataGridView.
Here is a visual sample of what I'm trying to do:
http://oha.nu/accepted_creditcards.gif
I've found code to hide rows from DataGridView, but not from the
DataGridViewComboBoxColumn.
Any help much appreciated.
thanks,
Nik Edmiidz
- 6
- ADO >> ADO.NET 2.0 - Simple question for you...I have an ASP.NET 2.0 website. I want to write a function in ADO.NET 2.0
(VB.NET) that does the following:
1. Opens up a connection to my SqlExpress db. (The connectionstring is in
the <connectionStrings> section of my web.config)
2. Runs a query, storing results in a datatable.
3. Closes connection
Can anyone assist?
Thanks!
- 7
- Visual C#.Net >> adding icons to controlsHi!
I have made a few custom controls. E.g. I have a ColorTextBox which inherits
the TextBox class...
When I build the project and add it to the toolbar (through Add/Remove
Items) the control has
the default icon next to it...
Is there a way I can change the icon displayed in the toolbar? Through some
attribute perhaps?
Thanks...
Saso
- 8
- Dotnet >> Application FailIf I put my .exe file on my Local Network (in a Folder of course) and try to
run from my Pc which would be the causes ? such application don't Run.
I make the Wrap a COM component for Export data to MS-Excel:
Interop.Excel.dll
Interop.VBIDE.dll
Note: Only Run in my local PC
Best Regard
Mario
- 9
- Winforms >> tabPage.Focus() doesn't work?Hi,
I have a TabControl in a WinForm witn two tabs.
At some point I want to switch focus from the first TabPage to the second
TabPage.
The documentation says that any control (which seems to be the case for the
TabControl) that derives from Panel aren't selectable.
Since I think this is a simple wish I can't imagine that there shouldn't be
a workaround for that. Do you have helping ideas?
Thank you very much.
Torben
- 10
- ADO >> SPs/ADO.NET/DataSets/DataTables/DataAdapters/TableMappingHi all,
I posted this in the EnterpriseDevelopment.SQLServer.Programming group and
got a reccomendation that I post it here too.
This is probably a no-brainer, but I'm having a heck of a time trying to
form my question the right way for the search engines to return anything
meaningful.
I'm working with SQL Server 2000 and C# on .NET 1.1.
Letâ??s say that I have a stored procedure which looks like this
CREATE PROCEDURE [Get_Configuration]
AS
SELECT * FROM Table1
SELECT * FROM Table2
SELECT * FROM Table3
Now letâ??s also say that I have some .net code that looks like
System.Data.SqlClient.SqlCommand MyCommand = new
System.Data.SqlClient.SqlCommand("Get_Configuration",this.sqlConnection1);
MyCommand.CommandType = System.Data.CommandType.StoredProcedure;
System.Data.DataSet MyDs = new DataSet();
System.Data.SqlClient.SqlDataAdapter MyAdapter = new
System.Data.SqlClient.SqlDataAdapter(MyCommand);
MyAdapter.Fill(MyDs);
What I get back is a DataSet containing the 3 DataTables I want, however all
of the DataTables are named ("Table", "Table1" and "Table2")
I want to know how I can name those tables in T-SQL so that when DataAdapter
fills the DataSet with the DataTables I can program against the table names
instead of relying on the table position indexes.
This is because I know this stored procedure will change over time and I
would rather not have to keep going back to the code to modify the table
indexes.
I have tried making in memory tables and performing an SELECT INTO, but in
that in doing that I donâ??t get any DataTables back.
I did some research on the topic and understand that this is due to the way
the DataAdapter performs the Fill method and that it makes new table Objects
for each result set that the SP provides. I also understand how TableMapping
plays into the issue. But I have a genuine situation where I don't always
know the names of the tables before hand.
I have a statistical Stored Procedure library which is broken into smaller
pieces, but are called in succession from a master statistical SP. As time
goes on I'm always adding new dimensions to the report and allowing for new
tables of data to be returned. The problem I'm having is in the fact that I
don't want to have to constantly have to keep updating my front end
application each time a place a new table in the middle of the SP.
I think I have found a work around that I can use for now, which involves
creating an extra table at either the beginning or end of the SP which
returns specific meta-data about the tables being returned, which I can read
at the beginning of my Front End's execution.....I'm just hoping that there
is someone out there who has come up with a solution to this issue.
Thanks to anyone who can help,
John Rossitter
- 11
- 12
- ADO >> How do you use OleDbLiteral?I had already posted this message in the framework group when I spotted that
this group might be more apt.
I am completely baffled by the OleDbLiteral enumeration.
How do you get from the enumerated values to the things that they
represent?
I can't see any calls or methods that do this. ToString just returns the
name of the enumerated value.
This must be a really stupid question but I can't find a single worked
example that uses this class. either through google or in the 2 ADO.NET
books that I have bought.
You need this information to generate safe SQL that will run against a
variety of back-ends.
Tom
- 13
- Microsoft Project >> After Timesheet Update Project no longer displays in Timesheet VieWe are using Project Server 2003.
We have a regular project plan (not an administrative plan) to track
miscellaneous administrative activities. The plan contains approximately 6
Summary Tasks. Team members use the plan via the 'Create A New Task'
function when they need to record time against this plan. The plan will
display in their Task Page and they are able to enter time for the newly
created task. However, when they do an update all the project plan no longer
is displayed in their Task Page. Changing the option on the Task Page to
display All Activities doesn't have any affect. The acutal time is captured
and reported to the project manager, but the project plan no longer remains
on their Task Page. Why? This plan was also added in our Project 2003
development environment and it remains on the Task Page after an update; it
doesn't behave the same as the version in production. Why is it disappearing
in our production environment?
Also, we have another plan that is similar where by team members record
non-project related support for existing applications. The plan is the same
concept as the plan to track miscellaneous administrative activities, except
we have a Summary Task for each application that our area supports. Team
members use again use the 'Create a New Task' feature to update this plan.
This plan doesn't disappear from their Task Page in the Development or
Production environment after doing an update.
So I do know that the behavior that I am seeing with the miscellaneous
administrative activities is unique to our production environment and only to
this one plan. Help!
--
Thanks,
Kelly
- 14
- Net Framework >> Class not registeredHi Every one,
I am developing web application using c# in Visual Studio 2005 Beta 1. When
I try to connect my SQL database, I am getting error
"System.Data.OleDb.OleDbException: Class not registered". My database is in
Sql Server 2000. I am using OLEDB namespace. For some specific business need
I am using oledb namespace instead of sql name space of system.data. Can any
body help me in resolving this.
Thanks in advance.
Shailesh.
- 15
|
| Author |
Message |
Kleev
|
 Posted: Wed Dec 20 18:37:00 CST 2006 |
Top |
ADO >> Use OleDB DB2 provider type without extra software?
I recently realized that I need IBM's iSeries Access installed to use
Provider=IBMDA400.DataSource.1 in an OleDB connection string.
Is there any .NET 2.0 class or dll that provides DB2 data access
without any other software installs besides the .NET 2.0 Framework? Or,
alternatively, can I pack whichever specific class/dll provides
IBMDA400.DataSource.1 into the project itself (and not as a reference
to it externally)?
DotNet275
|
| |
|
| |
|
KerryMoorman
|
| Posted: Wed Dec 20 18:37:00 CST 2006 |
Top |
ADO >> Use OleDB DB2 provider type without extra software?
ajmastrean,
I believe that you can use Microsoft's OleDb provider:
Provider=DB2OLEDB
See www.ConnectionStrings.com for an example.
Kerry Moorman
"ajmastrean" wrote:
> I recently realized that I need IBM's iSeries Access installed to use
> Provider=IBMDA400.DataSource.1 in an OleDB connection string.
>
> Is there any .NET 2.0 class or dll that provides DB2 data access
> without any other software installs besides the .NET 2.0 Framework? Or,
> alternatively, can I pack whichever specific class/dll provides
> IBMDA400.DataSource.1 into the project itself (and not as a reference
> to it externally)?
>
>
|
| |
|
| |
|
ajmastrean
|
| Posted: Thu Dec 21 07:25:17 CST 2006 |
Top |
ADO >> Use OleDB DB2 provider type without extra software?
I am actually being told that that provider is not registered on my
machine. I have done some searching (in the groups and other forums)
and it seems a separate client needs to be installed to use that
provider as well.
|
| |
|
| |
|
Paul
|
| Posted: Thu Dec 21 09:32:38 CST 2006 |
Top |
ADO >> Use OleDB DB2 provider type without extra software?
On 21 Dec 2006 05:25:17 -0800, "ajmastrean" <EMail@HideDomain.com> wrote:
¤ I am actually being told that that provider is not registered on my
¤ machine. I have done some searching (in the groups and other forums)
¤ and it seems a separate client needs to be installed to use that
¤ provider as well.
Correct. There is no DB2 provider (or client software) that is installed by Microsoft.
Paul
~~~~
Microsoft MVP (Visual Basic)
|
| |
|
| |
|
Kevin
|
| Posted: Thu Dec 28 14:45:32 CST 2006 |
Top |
ADO >> Use OleDB DB2 provider type without extra software?
To use the IBM native ADO.NET provider you need to install it from Client
Access which I believe is a free download. Add the reference in
IBM.Data.DB2.iSeries.dll followed by [Imports IBM.Data.DB2.iSeries]
"ajmastrean" <EMail@HideDomain.com> wrote in message
news:EMail@HideDomain.com...
>I recently realized that I need IBM's iSeries Access installed to use
> Provider=IBMDA400.DataSource.1 in an OleDB connection string.
>
> Is there any .NET 2.0 class or dll that provides DB2 data access
> without any other software installs besides the .NET 2.0 Framework? Or,
> alternatively, can I pack whichever specific class/dll provides
> IBMDA400.DataSource.1 into the project itself (and not as a reference
> to it externally)?
>
|
| |
|
| |
|
| |
|
Index ‹ DotNet ‹ ADO |
- Next
- 1
- Visual C#.Net >> C# vs Java SerializationHello,
I have two Java applications that exchange serialized
objects. Although I would like to ultimately convert both
to C# it's a pretty monumental task, especially for
someone just learning both langauges. I thought it might
be more reasonable to start with simply converting the
simpler one of the two and getting it to work. I have
used Microsoft's free Java to C# converter to convert most
of the code, but of course I must complete some of the
conversions manually. I have this basic concern,
however: Will the serialization done in C# be the same as
that done in Java? Also, do all Java compilers serialize
the same way for the same source code? How do I determine
exactly what the serialized data looks like, both
theoretically and emperically? I'd like to be able to
view it at the byte level just for general debugging
purposes. (Of course I could use a packet sniffer, but
that's a little too gross even for a hardware person like
me!)
Thanks,
Ray Mitchell
- 2
- Dotnet >> Subclassing the PropertyGridFolks -
I've done some searching on the 'net, and I think I know the answer to my
question, but I wanted to pose it anyway, just in case.
I'm embarking on a new project, and we're investigating the use of the
PropertyGrid. I've used it in a couple of places before, but never in an
application that goes out to my general user base. We really like the
functionality and capabilities it provides, but some of the display choices
are not exactly what we want.
Some initial tests of creating an inherited control (and my above-mentioned
searching) seemed to show that I'm SOL if I want to override the drawing of
the control elements. I really do not want to go through the effort of
re-creating the majority of this control just so we can draw a couple of
things differently.
Any ideas?
TIA
- Scott
- 3
- Visual C#.Net >> Equals and "==" operatorHi,
What is the difference between Object.Equals and "==" operator ?
When we use CollectionBase.List.Remove(object), which methods is used to
compare objects ?
Thanks
- 4
- Net Framework >> Restart with ClickOnceIs it possible to require a reboot with a clickonce deployment - IE:
show a window that says: You need to reboot your computer (or similar)
with buttons: "reboot now" and "reboot later" or similar, after
installing?
- 5
- Winforms >> Why events are behaving differently for controls in 1.0 and 1.1 of .NET?Hi all,
I have observed that some of the controls in 1.0 .NET framework behave
differently in 1.1 .NET framework.
For example - the ComboBox control:
The combo box is in DropDown mode. Consider the behavior of KeyPress event.
In 1.0 framework, the combobox Text property contains the modified value
during KeyPress event handling.
For eample, if the text in the combobox is "test" initially and I modified
it to "test1" then in key press event the Text property is "test1".
But this is not the case in 1.1 framework. The Text property is old value
i,e., in this case "test" but not "test1".
private void testComboBox_KeyPress(object sender,
System.Windows.Forms.KeyPressEventArgs e)
{
System.Diagnostics.Debug.WriteLine("Text Value in KeyPress :" +
testComboBox.Text);
}
run this in both 1.0 and 1.1 framework.
Due to this my applications are not working properly when I port them from
1.0 to 1.1 .NET framework.
My main concern is: Is this behavior is a bug or intentionally done ?
Because this is causing problems: Help!!!!
Thanks,
Anil.
- 6
- ADO >> Crystal Report - Page break after Report header !Hi all,
I'm actually encountering the following problem. I've got a report
with standard report header, page header and detail sections. But on
viewing mode, CR generates everytime a page break right after the
report header section, so the data start to be displayed only on the
second page. When all data could fit on only one page, it worked good.
The problem came when i added more fields, to report, needing 3 pages
at least. I don't know why, CR does this, where is it told to generate
this page break, cause the options "New page after, before" are not
checked.
Any help apreciated,
Thanks,
Mike.
- 7
- Net Framework >> Looking for a book on writing ASP.NET Controls with VB.NETI am an ASP.NET developer who would like to start learning about writing
ASP.NET custom controls using VB.NET. I already have a reasonable amount of
knowledge with making ASP.NET pages, and am looking for a book specifically
on writing controls. Here are some things I would like the book to talk
about and my preferences as to how I would like it to be shown/explained:
1. I want it to use VB.NET for the examples, since that is what I write all
my sites using and have experience with.
2. I would prefer that the book use many examples, because I feel I learn
better when I see examples.
3. I want to know how to make the different properties be either displayed
or not displayed in the Visual Studio .NET Properties Palette, as well as
other things that affect the appearance in Visual Studio .NET.
4. I want it to concentrate only on ASP.NET Custom Controls.
Thank you in advance to anyone that can help me find a book on this topic.
--
Nathan Sokalski
njsokalski@hotmail.com
http://www.nathansokalski.com/
- 8
- Net Framework >> how can i manipulate a check box in another processi want to manipulate a check box in another process,how can i get it
the check box in the process A,developed by C#
now i want to manipulate the check box in other application developed by MFC
as the usually,i sendmessage BM_SETCHECK from the MFC application to the checkbox of a C#
application,but it respond nothing
but i send message from MFC application to another MFC application ,it work right
what can i do
thanks very much.
- 9
- Dotnet >> .NET control event with java script handlerHi all,
I have created a .NET Windows control with c#.
I have placed the control on a HTML page within the OBJECT element.
Everything works fine up to now.
Now, I wanna implement the following stuff that the control must support.
The control must provide a method called InvokeJavaScriptFunction
The prototype of this method is:
InvokeJavaScriptFunction(<point to java script function>)
where <point to java script function> is a pointer to an existing java
script function in the HTML page.
The InvokeJavaScriptFunction method of the control is invoked within the
HTML page when the page is loading
<head>
<script language="javascript">
function MyJScriptFunction()
{
....
}
</script>
<OBJECT id="MyControl" .....>
</OBJECT>
</head>
<body onLoad="MyControl.InvokeJavaScriptFunction(MyJScriptFunction)">
.....
</body>
Inside the control.... the InvokeJavaScriptFunction is performing some stuff
and after that it should invoke the java script function on the page.
In other words, the InvokeJavaScriptFunction takes some actions and then it
must turn back the control on the page invoking the script function.
You can think at this like to an event.. the InvokeJavaScriptFunction is
doing its job and then fires an event on the page, where the handler of the
event is the provided java script function.
Do you have any idea how to implement this must have functionality of my
control?
Thanks,
Mircea
- 10
- 11
- Dotnet >> ASP.NET Integrated AuthenticationI'm developing a web application for our local intranet that will allow users
to pull up a webpage and update or deleted or insert records into a database
as well as run reports etc...
Our DB server is on a Win2k3 OS using SQL Server 2000
Our Web server is on a separate Win2kr OS using IIS 6
Both the servers and the clients are part of the same domain.
We've turned anonymous access off on the web and are passing the integrated
authentication from the client's machine (through their domain login). The
user has been granted all the correct permission to the database server and
the database that will be updated. However it seems like the authentication
is being passed to the web server and then the web server is passing a
different set of authentication on to the database server? The
authentication it is passing on to the database server is DOMAIN\MACHINENAME$.
If we add that machine name to the SQL Server as having permission to do the
update/delete/select we can get the app to work just fine. However, what we
want to do is to pass the clients authentication on to the database server...
not the web serverâ??s authentication.
Any help I could get would be much appreciated..... this is driving me nuts
and seems like a pretty common practice (having the db and the web on two
separate machines).
Thanks in advance.
Josh
- 12
- 13
- Net Framework >> Profiling/Debugging Real Time Security ChecksI have a medium sized application (say 50k lines) that occasionally will
spike the % of time in RT security checks performance counter between 50 and
95%.
It can perform hundreds of thousands of code access security permission
checks in a few seconds in some cases.
I know that I can set a permission set on a higher level method and demand
then assert to help allieviate some of these checks, but how do I go about
determining what method to assert the permissions and which permissions to
assert?
I guess what I'd really like is to get a list of methods with the number of
calls and the number of code access security permission checks performed
(inclusive and exclusive).
Any ideas of how I can go about profiling/debugging this issue?
- 14
- ADO >> Getting Data from a DataSetHello,
I have a DataSet that was returned from a QueryMethod ( ).
Using the following code, I drilled down to the column level but am unsure
how to get at the data:
Dim ds As System.Data.DataSet
Dim dt As System.Data.DataTable
Dim dr As System.Data.DataRow
Dim dc As System.Data.DataColumn
ds = QueryMethod()
For Each dt In ds.Tables
For Each dr In dt.Rows
For Each dc In dt.Columns
if dr(dc) = "owner" then
' GET DATA VALUE IN THE TABLE IN THE ROW OF THE COLUMN
end if
Next dc
Next dr
Next dt
Thanks for any help.
glenn
- 15
- Net Framework >> Framework 2.0 not showing up in IISWindows Server 2003, all sp's.
Installed Framework 2.0 on this box, and it says that it installed, but
the tab for ASP.NET on the properties doesn't show up. We've removed &
reinstalled, but that hasn't helped.
Does anyone have any ideas as to what's happening to this?
The only option I can think of that we already have not tried is to just
uninstall Framework & then IIS then reinstall both of them.
Help!!
BC
|
|
|