|
and your question makes no sense what-so-ever.
|
|
|
|
|
Hi,
I am using BMC AR remedy client 7.1. I have deloped an application in C# to fetch data from some tables of this database. The problem is that I am not getting the data for some rows for which value is a large string.
I tried using OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0) API's to fetch data. Both of them fails if the value is a large string. Also, it doesn't timeout and the execution stays at this call only and application used to hang.
There is a inconsistency in the output of the query for different records. For some records, it works fine and for some data is missing and for some the same query hangs.
Eveything was working fine for the AR REmedy client 6.20. Only after upgrading it, I started getiing this problem.
- Is there a better way to fetch data from a ODBC database through C#?
- How to set a timeout value for the query execution so that the application dowe not hang?
Thanks in advance.
- Praveen
P.S
Connection string: "Driver={AR System ODBC Driver}; arserver=**********; arserverport=*******; uid=******; aruseunderscores=*******; server=******";
Query: SELECT cloumn1 FROM tablename WHERE column1.value='00000';
Praveen Raghuvanshi
Software Engineer,
India.
|
|
|
|
|
Rags1512 wrote: Eveything was working fine for the AR REmedy client 6.20. Only after upgrading it, I started getiing this problem.
Then the best course is probably to get in touch with the supplier - not likely that anyone here would be able to help.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
I contacted the supplier and was told that earlier they were using SQL server and they have moved to Oracle.
Will this make a change.
Also, my 2 questions remain unaswered
- Is there a better way to fetch data from a ODBC database through C#?
- How to set a timeout value for the query execution so that the application does not hang? i.e how to avoid execution of OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0) API's infinitely?
Thanks,
Praveen
Praveen Raghuvanshi
Software Engineer,
India.
|
|
|
|
|
Yeah, use the provider for the database engine you're connceting to. ODBC is the "generic" provider and it's data types may not match up to nor work 100% with the database engines native data types.
If your connecting to an Oracle database, look into reading this[^].
|
|
|
|
|
Thanks, still I have some query.
I tried to fetch data from the database using MS Excel and it worked fine. Also, tried with VB, the results are as expected. It fails/retrieves less no of records with the queries using OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0).
- How to set a timeout value for the query execution so that the application does not hang? i.e how to avoid execution of OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0)?
- Is there a manual way to fetch data in C# rather than using the APS's?
Thanks,
Praveen
Praveen Raghuvanshi
Software Engineer,
India.
|
|
|
|
|
Rags1512 wrote: I tried to fetch data from the database using MS Excel and it worked fine. Also, tried with VB, the results are as expected. It fails/retrieves less no of records with the queries using OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0).
Like I already said, don't use ODBC.
Rags1512 wrote: - How to set a timeout value for the query execution so that the application does not hang? i.e how to avoid execution of OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0)?
I hate repeating myself.
Rags1512 wrote: - Is there a manual way to fetch data in C# rather than using the APS's?
Whatever you mean by "APS", no.
|
|
|
|
|
Good morning.
I was wondering if there was an easy way to access the list of folders and subfolders from a SharePoint site.
I have the following so far:
namespace SharePoint_Tree
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
teamspace.Lists tsl = new teamspace.Lists();
tsl.Credentials = CredentialCache.DefaultCredentials;
XmlNode resp = tsl.GetList("Content and Structure Reports");
this.Response.Write(resp.OuterXml);
}
}
}
Thank you, WHEELS
|
|
|
|
|
You might get more response if you post this in the SharePoint forum. here[^].
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
modified on Monday, October 12, 2009 10:46 AM
|
|
|
|
|
Wheels012 wrote: an easy way to access the list of folders and subfolders from a SharePoint site.
Yes there is, ask in the correct forum and you might get an answer, or be told it's so simple it should take about 30 seconds to Google it.
only two letters away from being an asset
|
|
|
|
|
Is there any option to select only path of map not files in it with open dialog?
Thanks,
Bye
|
|
|
|
|
No, however there is a FolderBrowserDialog Class
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
|
Hi there,
I am looking to create an application that uses SNMP to map a basic network, however i have never used SNMP and am struggling to implement it - i am not quite sure where to start.
I have read numerous articles about SNMP on the web ranging from the basics to the defined RFC's as well as example code and i am still completely in the dark. I get the idea of how SNMP works using managers and clients, OIDs, Mibs etc but have no idea how to go about it with C# code.
Could someone please assist me!
Kind Regards,
|
|
|
|
|
Well it "runs" over UDP right, so I guess you could just use an UDP socket?
I've never used SNMP though so maybe I'm completely missing the point..
|
|
|
|
|
Does anyone know if there is a way of getting the default image of a file to show in a file browser.
ie .txt image will be notepad etc.
Is there a way of finding this from "System.io.DirectoryInfo" or is there some other way i could retrieve this name.
I can then display the correct type of image for the file in my browser
)
UI.Entry(Image.FromFile("FolderFull_125x125.png"
Thanx George
|
|
|
|
|
|
hi,
try to extract the icon from the file with
System.Drawing.Icon.ExtractAssociatedIcon("log.txt").ToBitmap()
you can save the image to file with bitmap.Save("log.txt.png")..
hope i could help
|
|
|
|
|
I don't think so, the OP wants the icon associated with a file, not an icon from within the file.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
bm = System.Drawing.Icon.ExtractAssociatedIcon("@C:\WINDOWS\system32\notepad.exe").ToBitmap();
This line does get the correct image thank you just dont know how to find all the others as the focused file is changed.
|
|
|
|
|
|
Hi,
i have a c# application that connects to a remote MySql database.
The application is meant for a windows 2003 server.
I have a refference to mySql.Data in my app.
What do i need in order to get the application to connect to the database?
Thanks!
|
|
|
|
|
|
I don't know why, but copying the dll (MySql.Data.dll) to the location of the application did the trick.
I'll apreciate an explaination...
Thanks again.
|
|
|
|
|
If you just want to use MySql.Data.dll, you can set "CopyLocal = true" in reference property. Then the MySql.Data.dll will be copied automatically to Debug or Release directory. You can distribute it. To connect to remote DB, then what you need is connectionstrings.
|
|
|
|