Mike C

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

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

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

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

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

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.

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.

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

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.

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

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

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)

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

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

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

Thanks for the suggestion everyone. I am planning on using the Labview internet toolkit VIs for this project but was unable to find any output indicating how much data was received at any point in time. Justin's suggestion of polling the file size of the downloded file might work but I agree that it's not very elegant. How do other programs (FTP clients, browsers, download utilities, etc) know how much data was received? MikeC

Hello all. I am using FTP to tranfer a file from a remote server. I want to be able to monitor the download progress but I don't know how to do that. Getting the file size is not a problem, but how can I find out how much data has been trasferred at a given point during the download? Thanks in advance for all the help. MikeC

Hello all. I am using FTP to tranfer a file from a remote server. I want to be able to monitor the download progress but I don't know how to do that. Getting the file size is not a problem, but how can I find out how much data has been trasferred at a given point during the download? Thanks in advance for all the help. MikeC

Eerc, I am not sure how one would use an SMS gateway to sent an sms to a cell phone. From what I have seen you would need to subscribe to some kind of service that allows you to do that. In searching for an answer to your question (I've been wondering myself how to do this), I have found that you may be able to send an sms to a phone by simply sending an email to the phone. In my case my mobile provider (US Cellular) allows an email to be sent to a phone. I can send an email to 'myphonenumber@email.uscc.net' and it will show up as a text message on my phone. Other providers may allow this or provide it as a service (maybe for free). Check with your mobile provider if you can do this. I hope this helps Michael

Hugo, I was looking to do the same thing some time ago but I had to postpone that project. I did find some information on the NI Knowledge base that may give you some direction: "Problem: Can LabVIEW send a text message to my mobile phone email address? Solution: LabVIEW can indirectly send text messages to a cellular phone with the SMTP E-Mail VI

I have used LabSQL (open source) in the past and it works great. You can get it from http://www.jeffreytravis.com/lost/labsql.html. A number of examples are also included with LabSQL to get you started. Good luck

If anyone is interested here is the 7.0 version Download File:post-283-1123870541.vi

I talked with NI about this and it turns out that LabView executables do not have a version resource area for any version information to be stored in. NI may implement this in a future version of LabView.

Hello everybody. I have an interesting problem. The company I work for requires that all programs released have a version number associated with them that can be read by the GetFileVersionInfo function. None of my LabView programs return a version number, they actually return 0.0.0.0. Is there a way to provide version information that will eventually be stored in the final executable? Thanks java script:emoticon(':headbang:') smilie

Does anyone know of a way to programmatically get the application data folder path (i.e. C:\Documents and Settings\username\Application Data) Thanks