Re: C# SharePoint Folder / Subfolder list collection [modified] - C# Discussion Boards

Retrieve data from AR REmedy ODBC server

Praveen Raghuvanshi12-Oct-09 4:13

12-Oct-09 4:13

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.

Re: Retrieve data from AR REmedy ODBC server

riced12-Oct-09 5:57

riced

12-Oct-09 5:57

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. Smile | :)

Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis

Re: Retrieve data from AR REmedy ODBC server

Praveen Raghuvanshi12-Oct-09 9:22

Praveen Raghuvanshi

12-Oct-09 9:22

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.

Re: Retrieve data from AR REmedy ODBC server

Dave Kreskowiak12-Oct-09 10:25

Dave Kreskowiak

12-Oct-09 10:25

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[^].

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: Retrieve data from AR REmedy ODBC server

Praveen Raghuvanshi12-Oct-09 20:39

Praveen Raghuvanshi

12-Oct-09 20:39

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.

Re: Retrieve data from AR REmedy ODBC server

Dave Kreskowiak13-Oct-09 2:48

Dave Kreskowiak

13-Oct-09 2:48

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.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

C# SharePoint Folder / Subfolder list collection

Wheels01212-Oct-09 4:08

Wheels012

12-Oct-09 4:08

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
    {

        //public static void Main()
        //{
        //}

        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

Re: C# SharePoint Folder / Subfolder list collection [modified]

Henry Minute12-Oct-09 4:40

Henry Minute

12-Oct-09 4:40

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

Re: C# SharePoint Folder / Subfolder list collection

Not Active12-Oct-09 4:49

Not Active

12-Oct-09 4:49

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

How to select map with opendialog

Aljaz11112-Oct-09 3:47

Aljaz111

12-Oct-09 3:47

Is there any option to select only path of map not files in it with open dialog?

Thanks,
Bye

Re: How to select map with opendialog

Luc Pattyn12-Oct-09 3:48

Luc Pattyn

12-Oct-09 3:48

No, however there is a FolderBrowserDialog Class

Smile | :)

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!

Re: How to select map with opendialog

Aljaz11112-Oct-09 4:43

Aljaz111

12-Oct-09 4:43

Thanks a lot;)

SNMP

deviao12-Oct-09 3:11

deviao

12-Oct-09 3:11

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,

Re: SNMP

harold aptroot12-Oct-09 3:31

harold aptroot

12-Oct-09 3:31

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..

Default file image

gwithey12-Oct-09 2:38

gwithey

12-Oct-09 2:38

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

Re: Default file image

Ian Shlasko12-Oct-09 2:50

Ian Shlasko

12-Oct-09 2:50

First google link: Get Registered File Types and Their Associated Icons in C#[^]

Proud to have finally moved to the A-Ark. Which one are you in?
Developer, Author (Guardians of Xen)

Re: Default file image

freakyit12-Oct-09 2:50

freakyit

12-Oct-09 2:50

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 Smile | :)

Re: Default file image

Luc Pattyn12-Oct-09 2:56

Luc Pattyn

12-Oct-09 2:56

I don't think so, the OP wants the icon associated with a file, not an icon from within the file.

Smile | :)

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!

Re: Default file image

gwithey12-Oct-09 3:34

gwithey

12-Oct-09 3:34

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.

Re: Default file image

Henry Minute12-Oct-09 4:44

Henry Minute

12-Oct-09 4:44

http://www.codeproject.com/KB/cs/GetFileTypeAndIcon.aspx[^]

Connect to a remote MySql DB

SummerBulb12-Oct-09 2:28

SummerBulb

12-Oct-09 2:28

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!

Re: Connect to a remote MySql DB

stancrm12-Oct-09 2:31

stancrm

12-Oct-09 2:31

http://www.connectionstrings.com/mysql[^]

Re: Connect to a remote MySql DB

SummerBulb12-Oct-09 2:38

SummerBulb

12-Oct-09 2:38

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.

Re: Connect to a remote MySql DB

stancrm12-Oct-09 2:46

stancrm

12-Oct-09 2:46

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.

thread problem

Member 59031012-Oct-09 2:06

Member 590310

12-Oct-09 2:06

hw can i suspend and resume thread.

Last Visit: 31-Dec-99 18:00 Last Update: 17-Apr-24 18:36

Refresh

ᐊ Prev 1...4217 4218 4219 422042214222 4223 4224 4225 4226 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.