nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Advice on linking to data from Flex Viewer to SQL Server?

MelissaJohnson

I know using just Flex there is no way to link to SQL Server but I was hoping to get some dialog going from the experts out there on the best and easiest way to do this.
I have my Flex Viewer 2.1 and want to pass my parcel ID to SQL Server to return additional records.

Questions (Opinions):
Which is the easiest to learn for beginners?
Which method returns data fastest and taxes the server the least?

I am looking to take a class to learn how to do this (I wish ESRI had a class that explained connecting databases when building web mapping apps). I am not sure which service type I should use. In Flex you can use Blaze, Cold Fusion, HTTP, LCDS, PHP, Web Service or XML to connect to data services. Maybe there are others out there as well.

If anyone has experience with any of these good or bad some advice would be greatly appreciated.
Thanks in advance!
Melissa

Encontre mais publicações marcadas com

Accepted answers

All comments

NasifAlshaier

Thank you Carmen..

I am going to try and advise.

have a nice day

ctalleygreenville

Sorry - I have just stumbled on these requests. I don't think I received an email notification. Attached is a .zip file of the contents of the "GeoRSSSite" that we received from Jonathan Fisk when he was with ESRI-Charlotte. Also, there is a document that we made with notes on what had to be done. The notes are far from complete but maybe will get you started. It has been so long that I couldn't provide any more details - I just remember floundering around until it worked.

Let me know how it goes.

Carmen

GeorssSite.zip

GeoRSSCreation_HowTo.doc

Not responding.docx

Subdivisions.zip

MikeVolz

Carmen:

Can you provide the sample and details of the sample that you received from ESRI on the GeoRSSSite?

grahamcooke

Here is a link to a thread tha might help where I was trying to ascertain how to get the results back from a .net webservice.
http://forums.arcgis.com/threads/23798-calling-webservices-from-action-script-order-of-events?p=78120#post78120

Hope this helps.

MeghanMcGaffin

Melissa,

About a year ago, we got a "Web handler/service" from ESRI called "GeoRSSSite" that we used to access data from a SQL table (Fire Truck locations updated every minute).

We were able to alter their code to connect to our data. It was a bit of trial and error (as we had no clue what we were doing either), but we got it to work. We really just edited the files directly in a text editor vs having to use VStudio.

I have used it over an over for various things - some for creating the XML to generate auto-complete lists.

Maybe you can ask someone at ESRI if that is still available and if there are instructions???

Robert is the expert at this, but I can tell you that we got it to work without being an expert by any means. 😄

Carmen

I am definitely interested in learning more about how you did this.

NasifAlshaier

Melissa,

About a year ago, we got a "Web handler/service" from ESRI called "GeoRSSSite" that we used to access data from a SQL table (Fire Truck locations updated every minute).

We were able to alter their code to connect to our data. It was a bit of trial and error (as we had no clue what we were doing either), but we got it to work. We really just edited the files directly in a text editor vs having to use VStudio.

I have used it over an over for various things - some for creating the XML to generate auto-complete lists.

Maybe you can ask someone at ESRI if that is still available and if there are instructions???

Robert is the expert at this, but I can tell you that we got it to work without being an expert by any means. 😄

Carmen

Hi Carmen..

can you share the Web handler/service" from ESRI called "GeoRSSSite"?

Thanks
Nasif

LizDaRos

I've gone through a few tutorials of setting up a webservice and returning my sql data as xml and parsing into a flex application... and got it to work.
Now I'd like to show the data in my Sample Flex Viewer using the webservice. I've tried adding a few lines to my searchwidget to display the data but I'm not having much luck. Can anyone give me some help? Or is this NOT the way I should be doing this... should I be trying to �??Pass Search Parameters via URL in Sample Viewer�?�?
Ultimately I'd like to either search for a streetlight and get the sql data or possibly click on the streetlight and have this info appear.
Any help will greatly be appreciated.

RobertScheitlin__GISP

Emily,

There is no widget or anything built into FlexViewer 2.1 to allow connecting to a CF Web Service. Connecting to a CF Web service is definitely very custom and have to be coded by a developer that know what the web service is providing and what to do with it once it has it.

MelissaJohnson

Maybe someone else can answer your question. I am really new to Flex. I just knew that Cold Fusion was one of the options.

EmilyLaMunyon

Thanks Melissa!

I have been successful connecting to a CF webservice in Flash. Maybe this is not possible, but I was wondering if I could connect/use a coldfusion webservice in the Flex Viewer 2.1 without Flash.

Emily

MelissaJohnson

One of the options under Connect to Data/Service is Connect to Cold Fusion.

EmilyLaMunyon

Hello,
Can the Flex Viewer connect to the webservice of your choice, such as a ColdFusion webservice?

Thanks!

RickBaker

Nadeem,

Not much more I can elaborate on the development of a .Net webservice is completely specific to your data and as I said there are many examples out there, but you will have to have a fairly decent .Net programming ability to get started. Once you have the web service returning your data as xml than parsing it in flex is pretty easy. I don't think I can dumb this down with a generic example.

I have a .net webservice where some of the functions return a single table (which works fine in FB4) but there are some that return an array of tables. This is causing me some grief in drilling in to the individual tables to get the data. Do you have any experience with this. Any suggestion is appreciated.

ctalleygreenville

Melissa,

About a year ago, we got a "Web handler/service" from ESRI called "GeoRSSSite" that we used to access data from a SQL table (Fire Truck locations updated every minute).

We were able to alter their code to connect to our data. It was a bit of trial and error (as we had no clue what we were doing either), but we got it to work. We really just edited the files directly in a text editor vs having to use VStudio.

I have used it over an over for various things - some for creating the XML to generate auto-complete lists.

Maybe you can ask someone at ESRI if that is still available and if there are instructions???

Robert is the expert at this, but I can tell you that we got it to work without being an expert by any means. 😄

Carmen

RobertScheitlin__GISP

Melissa,

Good luck in the class. Let us know how it goes.

RobertScheitlin__GISP

Nadeem,

Not much more I can elaborate on the development of a .Net webservice is completely specific to your data and as I said there are many examples out there, but you will have to have a fairly decent .Net programming ability to get started. Once you have the web service returning your data as xml than parsing it in flex is pretty easy. I don't think I can dumb this down with a generic example.

MelissaJohnson

I am taking an ASP.net class next week so I can learn more about coding a webservice to access my SQL server data. I searched through the web and found some helpful links, but they just didn't quite take me where I need to be in the details of coding the webservice for my purposes. Hopefully things will be clearer for me after the class!

NadeemShaukat

Melissa,

I am not sure about the other ways out there but I use ASP.Net Webservice to do that on my site. I can't really talk about the ease of creating this service as I have been a .Net Developer for many years, so it came naturally to me. I do know there are many examples that you can Google of how to create a web service in dot net. My querying of my SQL Server 2005 is very responsive and the data is just returned as XML so Flex has not issue traversing it. You will want to keep your queried data to exactly what you need and try to limit the amount returned. I pass a Parcel ID Number to my web service and that will ensure I only get one record returned.

Robert,

I am also in a situation where I have to pass user input and access data from SQL Server database to be presented in a data grid. Could you elaborate on the steps that you have taken in your project to facilitate this.

Thanks

Nshaukat

MelissaJohnson

Thanks Robert! I have Googled the asp.net webservices for tutorials and had problems with them. I am using the Visual Studio express 10 and haven't been successful following the instructions in them without getting errors. I will keep looking.
thanks again.
Melissa

RobertScheitlin__GISP

Melissa,

I am not sure about the other ways out there but I use ASP.Net Webservice to do that on my site. I can't really talk about the ease of creating this service as I have been a .Net Developer for many years, so it came naturally to me. I do know there are many examples that you can Google of how to create a web service in dot net. My querying of my SQL Server 2005 is very responsive and the data is just returned as XML so Flex has not issue traversing it. You will want to keep your queried data to exactly what you need and try to limit the amount returned. I pass a Parcel ID Number to my web service and that will ensure I only get one record returned.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.