-
Posts
683 -
Joined
-
Last visited
-
Days Won
2
Content Type
Profiles
Forums
Downloads
Gallery
Everything posted by i2dx
-
Database Connectivity Toolkit MYSQL BLOB Type
i2dx replied to Michele's topic in Database and File IO
QUOTE (James Beleau @ May 29 2009, 09:21 PM) Although I never have tried this with mySQL I think it should work, if you pass the data as plain string (use the flatten to string primitive e.g.). You should read the mySQL documentation and find out what the "special characters" of the DB-Server are, which need to be "escaped" in the SQL-Statement. I assume that you need to insert a large amount of data, because you use a BLOB field? If not, and the data size is about "a few kilobytes" you could use a trick and convert the binary data to a string, then to an u8 array and the u8 array to a hex-string, which can be inserted into a text field without any hassle but almost doubles the size of the data. If you need an example you could download the http://www.ib-berger.com/index.php?action=adotool_en' rel='nofollow' target="_blank">ADO Toolkit, there is a function which exactly does this .. -
This wish has beend posted several times before, and the answer was always: we can't do this, because there is no way to connect controls to a wire at runtime (e.g. because there is no block diagram at runtime ...). My assumption is: even with the newly released scripting there is no way because scripting will not work at runtime, just at development time. Unless this task is easy to do in other programming languages, it will be hard to archive in LV, because IMHO this would require something like Objects by reference (in the C++ or C# sense of Object)
-
a big "Thank You" to NI and AQ! ... this makes me really happy
-
QUOTE (fuzzycontrolfreak @ Mar 17 2008, 01:41 PM) if you are searching for a ready to run datalogging application based on LabVIEW / NI-USB-6008 / Access Database http://www.ib-berger.com/index.php?action=ibblogger' rel='nofollow' target="_blank">you should check this one
-
Best way to interface LabVIEW to SQL Server
i2dx replied to John Lokanis's topic in Database and File IO
QUOTE (jlokanis @ Mar 14 2008, 01:33 AM) maybe you want to try out my ADO-Toolkit? (the link is in my signature ...) cheers, CB -
QUOTE (Klaus Petersen @ Mar 4 2008, 10:06 PM) that's wrong. the ADO-Toolkit does not need Access to work properly QUOTE (rolfk @ Mar 10 2008, 09:52 PM) If you install MDAC (already installed on recent Windows OSes like XP) you should be able to read Acess database files *.mdb) using a properly formatted DSN/UDN. that's right. You have to install MDAC to use the ADO-Toolkit. MDAC is allready pre-installed on Windows 2k or higher, so you have to install it on Windows 98 or if you want to update your MDAC installation
-
QUOTE(PeterB @ Mar 10 2008, 10:27 AM) pah, that's marketing mumbojumbo. If this should "work" there has to either be ONE complete architecture from the bottom of all software to the top for ALL the software which is written in the future or the superduperueberversatileerrorcompensationg virtual standardized interface - and that's absolutely unrealistic. If software is no longer programmed, but constructed, this implies, that the framework you compose your software with is able to solve all software problem, now and forever. Just to go a little bit further: If all software could be *just* composed, that would mean: 1. mankind has reached the point where creativity and genius is obsolete 2. you could automate the software creation process ==> which means, if software can create all the software, it has it's own consciousness and you know what that means ... (I hope you saw Terminator 3 ...)
-
sad but true: lava.org isn't the one and only really hot thing on the planet any more ;(
-
QUOTE(Aristos Queue @ Feb 15 2008, 10:29 PM) this explains a LOT
-
QUOTE(PJM_labview @ Feb 15 2008, 12:39 AM) hardware whishlist? here comes my favorite: a NI Atmel AVR Device plus the LabVIEW AVR Module! that should not be that difficult, because there is an Atmel AVR working inside the LEGO brick and there is already a toolset for it. Those devices should be able to commuicate through RS232 or TCP-IP or CAN or SPI, to allow the development of "deeply" distributed systems. And hey, that rides directly on the multiprocessing wave
-
QUOTE(tcplomp @ Feb 14 2008, 09:37 PM) hmm ... I dunno ... maybe I look like THAT when I'm dancing? (And I swear I don't do this often!)
-
QUOTE(Anders Björk @ Feb 14 2008, 09:21 AM) yes, that's cRIO: http://zone.ni.com/devzone/cda/tut/p/id/6265 just forget about the high volume
-
QUOTE(Aristos Queue @ Feb 13 2008, 11:28 PM) QUOTE(Aristos Queue @ Feb 14 2008, 06:29 PM) Usually these examples are intended for intra-machine communication of some sort. I don't know the particular one to which you refer, but it would be my guess that it was written for one machine to publish and the other machine to subscribe. Over a TCP/IP or Datasocket link (or your favorite protocol) the data sent is just strings which the other side interprets. Thanks a LOT for pointing that out. Why? ... that statment saves me a lot of time for benchmarking my data transfer mechanisms in my distributed systems
-
QUOTE(Gabi1 @ Feb 12 2008, 09:53 PM) WHOW, thanks a LOT! maybe I could offer you a job, but it's a long way until then. First I have to write my business plan and so on and so on ... --> 7.) yes, I am a LabVIEW guy, and more severly: I know allmost nothing about how to build a circuit. Ok, it's still enough to impress my little sister, but I'm an absolute no0b compared to an "interested amateur". If there is allready any finished solution which can act as a frequency converter circuit (20 kHz base frequency, 1-35V, 0-150A, 0-240 Hz) and create a 3 Phase rotary field for AC motors, and HAS DIRECT ACCESS to the MOSFETS/IGBTS through digital inputs, please let me know. This solution has not to be able to convert the Voltage, I just want to switch the current. All finished solutions I could find so far are "ready to run" frequency converters with it's own µC, but I want to control the frequency by myself (in my FPGA VI)
-
QUOTE(snooper @ Feb 14 2008, 04:03 PM) hmm ... maybe the response to your solution is so small, because there are already 2 (or more?) established free Database toolkits for LabVIEW. The first I know is http://jeffreytravis.com/lost/labsql.html' target="_blank">LabSQL from Jeffrey Travis the second one is the one I wrote: ADO-Toolkit (the link is in my signature) which supports (for free) and is tested with: Access, Excel, MSSQL, mySQL and should support (but not yet tested) Oracle and any other Database which can be connected through ODBC. Last but not least, if you need support (and want to pay for the product): The Database Connectivity Toolset from NI. I can only speak for myself:I have about 400 - 500 Downloads per month since 2006, the ADO-Toolkit exists since 2005. So I'd consider my toolkit as a renowned LV-Database Toolkit => I think it would be really hard to establish a paid / free but limited alternative to this 3 products ...
-
QUOTE(AnalogKid2DigitalMan @ Feb 11 2008, 05:44 PM) Pah, isolation is for cowards That 9401 Module does not cost that much anyway and NI will love me, if I order them in dozens seroius again: yepp, sounds like a good idea!
-
QUOTE(Gabi1 @ Feb 8 2008, 10:42 PM) sounds like you have some experience with such circuits? I'm still searching for someone who could give me a little input about how to build a frequency converter circuit (20 kHz base frequency, 1-35V, 0-150A, 0-240 Hz) which is directly connected to a cRIO 9401 DIO Module (which generates the PWM) ...
-
QUOTE(rtn1 @ Feb 8 2008, 09:31 AM) that depends of the base frequency of your generated PWM signal and the switching time of your relays. If your signal is very slow (e.g. 10 Hz) a solid state relay may be fast enough. If you use e.g. 20 kHz (which is a common base frequency of frequency-converters ...) a relay will not be fast enough. In that case you should think about useing MOSFETs or IGBTs, but that is a science of its own.
-
The ADO Toolkit makes usage of the local computers time format, determined by '%c'. There are 2 polymorphic Conversion VIs in the ADO-Tool Subpalette, which help you to do the correct conversion. BTW: AFAIK it's the best solution to use always a dot as the decimal separator, because SQL separates the columns by a comma. Use the "Data to SQL String" VI to convert Data into an SQL string and "Variant to Data" to convert the data from the result into LabVIEW Data types. Both VIs are polymorphic. You have to select the instance manually at the "Variant to Data" vi, because a Variant can be any type.
-
QUOTE(sara @ Jan 27 2008, 01:18 PM) use the "format Date/Time String" primitive and display the date in a string control. http://lavag.org/old_files/monthly_01_2008/post-885-1201502731.png' target="_blank"> Use Ctrl+H to see how to build the format string ....
-
QUOTE(CHRLAB47 @ Jan 24 2008, 11:46 PM) in doubt I'd take a look at the function description at the MSDN (http://msdn.microsoft.com). Hint: type e.g. _workbook.open into the search window and the Object definition should be among the first 10 search results. Warning: if that input is a nested Variant, e.g. a string array, it is likely that you have no chance in LV to build that specific data type.
-
QUOTE(Kun @ Jan 24 2008, 10:52 PM) Kun, you should take a look at the "event structure" tutorial in the example finder and at the "state machine" tutorial. You'll need that to solve your problem: 1. catch the "button pressed" event with the event structure 2. change the state of your state machine from "running" to "idle" when the event occurs ...
-
QUOTE(beckerg @ Oct 28 2007, 10:25 AM) greetings to munic from an "exile bavarian*" in Duesseldorf *but as long as I can get "Erdinger" here I can hold out
-
QUOTE(neB @ Jan 18 2008, 02:34 PM) gratulations is there any difference between the first certification exam and the recertification exam?
-
QUOTE(crelf @ Jan 11 2008, 11:11 PM) Ah, thanks! Nope CTA is definitvely not on my list. I don't even have Testatand installed. CPI is not on my list, too, because I have no ambition to lead courses.