Jump to content

Mike C

  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender
  • Location
    Cedar Rapids, IA

LabVIEW Information

  • Version
    LabVIEW 2009
  • Since

Mike C's Achievements


Newbie (1/14)



  1. You need to define the the fonts in the ini file of the specific application. In all my apps I add the following in the ini and it works just fine, regardless of the user OS or font/screen settings. appFont="Tahoma" 13 dialogFont="Tahoma" 13 systemFont="Tahoma" 13 I hope this helps Michael
  2. Could you convert it to a pdf before showing? Alternatively you can use an activex control called DSO Framer that will allow you to open an office document to display. I don't know if you can open it directly in preview mode though. I hope this helps Michael
  3. Osvald, I am sure there is a more elegant way than what I am about to suggest but it has worked for me for viewing PDF files. Just create a web browser activex container and load the file to preview there. Let the browser decide that the correct application is to view the file (acrobat, other pdf viewer, excel, etc). Michael
  4. Typically cellphone providers have email addresses associated with cellphone numbers. Maybe you can simply send an email to the phone. Here is a list of some examples I found with a quick search: Alltel [10-digit phone number]@message.alltel.com Example: 2125551212@message.alltel.com AT&T (formerly Cingular) [10-digit phone number]@txt.att.net Example: 2125551212@txt.att.net Boost Mobile [10-digit phone number]@myboostmobile.com Example: 2125551212@myboostmobile.com Nextel (now part of Sprint Nextel) [10-digit telephone number]@messaging.nextel.com Example: 7035551234@messaging.nextel.com Sprint PCS (now Sprint Nextel) [10-digit phone number]@messaging.sprintpcs.com Example: 2125551234@messaging.sprintpcs.com T-Mobile [10-digit phone number]@tmomail.net Example: 4251234567@tmomail.net Verizon [10-digit phone number]@vtext.com Example: 5552223333@vtext.com Virgin Mobile USA [10-digit phone number]@vmobl.com Example: 5551234567@vmobl.com
  5. QUOTE (alukindo @ Sep 27 2008, 07:18 PM) Anthony, Thanks very much for the reply. I'll give it a try once I get a chance (unfortunately something else came up that needs my attention). This is new programming territory for me and I needed some help. Your approach makes sense and I expect it would work for me. I am surprised to see that your vi does not use any of the database vi's. Thanks again for the help. Michael
  6. QUOTE (rbogomir @ Sep 26 2008, 01:57 PM) Rbogomir, I can get the same error message even if I point to a non existent sdf file. This makes me think that the service is not even running. Is there anything else you needed to do? How did you solve your problem? I have a suspicion that I need to have IIS running for this to work, is IIS running on your machine? Thanks again for taking the time to help me out.
  7. QUOTE (rbogomir @ Sep 26 2008, 05:21 AM) I have tried the same thing and it did not work. I am actually using the sql server compact not mobile so the string I tried was a bit different: Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=c:\mydb1.sdf On the up side I get a different error message now: Code: -2147467259, NI_Database_API.lvlib:DB Tools Open Connec (String).vi->test db.vi<ERR>Exception occured in Microsoft SQL Server Compact OLE DB Provider: in NI_Database_API.lvlib:DB Tools Open Connec (String).vi->test db.vi When you created the database did you give it a password? Is there anything else I should be aware of? QUOTE (Shaun Hayward @ Sep 26 2008, 08:09 AM) Jim, Thanks for the hint - I hadn't come across SQLite before - it looks like its doing much of the same kind of thing My only question is that the link you posted does not seem to have anywhere to actually download the toolkit - am I missing something? Shaun, I was just looking at that myself. I found the vi's here. I have not had a chance to try it but it looks interesting Michael QUOTE (jcarmody @ Sep 26 2008, 04:32 AM) Michael, I'm curious about why you're interested in this product. Do you have a specific need or is this an exercise to learn a new technology? I'm all for learning new things :thumbup: (except, perhaps MS isn't my favorite source :thumbdown: ) I'd recommend SQLite for a small database without onerous licensing that you can include with your application. There's a http://decibel.ni.com/content/docs/DOC-1254' target="_blank">toolkit on ni.com that I've had some success with. Anyway, good luck with your project. Please forgive me if I'm way off base. jm I writing an application that needs the database to be contained in a single file. My first choice was Access but I've recently heard of SQL Server Compact and I thought it may be a much better alternative. I have worked with SQL Server before so I figured it would be an easy transition. If I could only figure out how to connect to the database! I have no reason to want to use MS products. I will give SQLite a try, thanks for the suggestion.
  8. QUOTE (Yair @ Sep 25 2008, 01:04 PM) Yiar, thanks for the suggestions. I have been searching the web for a few days with no result. There is lots of examples on how to do it from within Visual Studio but that does not help. Creating my own udl had no result ( I get an error message:"NI_Database_API.lvlib:Conn getDataToModify.vi:1"<ERR>Object 0x000000 is not valid.) I tried a number of different combinations with the same error message. I have been using the normal SQL server for sometime now but this is very different. My guess is that I need to be calling some other dll before I can connect to the database file (the sql server compact database is contained in a single file) but I don't know how or which one. I was hoping someone else here may have used it and had some tips. Michael QUOTE (Shaun Hayward @ Sep 25 2008, 02:11 PM) I havent looked into it yet (due to time constraints) but SQL Compact Edition looks interesting. From what I have read so far (which isn't so much) it seems that it embeds a database within a particular applicatio. Therefore I would wonder whether you need to do some calls to its DLL / .Net trickery instead of a conventional UDL approach. The MSDN pages are suitably cryptic and basically talk you though using a Wizard in Visual Studio, which doesnt help so much. Shaun, thanks for the responce. That's exactly what I gathered by reading through various sites. I am afraid that you are probably correct in that I would need to make some dll calls. SQL server compact is a neat idea but it seems complicated to get working. Michael
  9. QUOTE (Yair @ Sep 25 2008, 12:53 PM) If it does I cannot figure out how to configure it. It does not behave like a normal SQL server or like an Access db. That's why I am having problems.
  10. Hi everyone. I was wondering if anyone has had any experience connecting to an SQL Server Compact 3.5 database using the LabVIEW database connectivity toolkits. I cannot figure out a way to created a valid connection string or if I let the "open connection to db" vi prompt me for connection info I cannot figure how to configure it. Thanks in advance for all the help. Michael
  11. Well, I figured out a way to do it. I had to create a stored procedure to do the insert and include the "select scope_identity()" as part of it. The funny part to this is that if you do execute the stored procedure from a query the insert happens correctly but the scope_identity is not returned. What does work is a parameterized query where you can set parameters (what you need to insert) as well as read parameters (the scope_identity). It took some looking around to find out the correct syntax to do this (the examples in LabVIEW do not explain this well). I am listing below the stored procedure and the code. This was just a test so please excuse any cosmetic sloppiness. Stored Procedure: CREATE PROCEDURE [dbo].[uSER_INS] (@userFullNM varchar(100),@username varchar(50),@adminpass varchar(50), @roleid int, @isactive int, @userid int output) AS BEGIN SET @USERID = NULL SELECT @USERID = [uSER_ID] FROM [uSER] WHERE USER_FULL_NM = @userFullNM IF @USERID IS NULL BEGIN INSERT INTO [user] (user_full_nm, username, admin_password, user_role_id, is_active, create_dtm, last_update_dtm) VALUES(@userFullNM, @username, @adminpass, @roleid, @isactive, GetDate(),GetDate()) SELECT @userid=SCOPE_IDENTITY() END ELSE BEGIN UPDATE [uSER] SET username = @username, admin_password = @adminpass, user_role_id=@roleid, is_active=@isactive, last_update_dtm = GetDate() WHERE [uSER_ID] = @USERID END END
  12. I have tried using a semicolon to indicate where each query ends but it did not work. I suppose the LabVIEW toolkit cannot execute more than one query per SQL statement. I did take a quick look at the blog and it seems that there is still a more than one query per SQL statement so it will probably not work. I'll give it a try though. QUOTE (orko @ Apr 25 2008, 04:06 PM)
  13. Thanks for the quick responses. I'll try and provide some answers to your questions: 1. There are no error messages 2. Using a termination character has no effect 3. The insert and select scope_identity() need to be in the same command. The scope_identity() is supposed to return the table primary key ID the insert had 4. Database: SQL Server 2005, ODBC connection
  14. Hello everyone. I am using the following SQL query to get the primary key ID following a record insert but nothing is returned: Insert into tblname (field_1, filed_2) Values ('value1', 'value2') select scope_identity() This query works as expected in the SQl server Management studio but not in LabVIEW. I am using the LabVIEW database connectivity kit with LabVIEW 8.5. Does anyone have a solution to this problem? Thanks, Michael
  15. QUOTE(rolfk @ Nov 27 2007, 04:41 PM) After Aristos' comment I started looking into the low level vis and found that there is a single vi (tcp read) in a loop that reads a specific amount of data (4kb by default) every iteration until the entire file is downloaded. I guess I need to do some rearraging in order to get the info I want. Thanks for all the help everyone. Mike C
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.