Search results for query: *

to Mike and Chris Thank you for your replies. Though I did not give you enough info, your responses were helpful. I was wondering if there was any known problems with SQL 2019. Since neither of you mentioned it, I went to work again, trying to solve the problem. The good news is, the...

I program for my own small business use. I have a VFP 7 program that has been and is currently running for 15 years successfully with a SQL 2008 then 2016 backend. It has been on the same 8 PCs all this time. 1 pc as the sql server and the others as clients. I made a copy of the data and...

Thank you JRB-Bldr That solved my problem. Jim Rumbaugh

I am using FVP8 frontend SQL Express 2005 backend The program has run successfully for 5 years on many XP machines. I have installed it for the first time on a Windows 7 machine. The ODBC connection tests good through the Windows ODBC Open connection Manager, but when I launch my program I get...

I have found a solution, though I admit I did not find the problem. The clients on our LAN were connecting to the host via ODBC using TCP/IP. I changed the ODBC CLIENT CONFIGURATION from TCP/IP to OPEN PIPES. It now works as desired. I consider this question resolved.

@biglebowski Thanks you for your suggestion. With the old router that works, per your suggestion, I did 'telnet "SQL IP ADDRESS" 1433 ' I recieved the error message "could not open the connection to the host........" Should I expect something else with the router that does not work?

I have 8 computers on a LAN using XP home connecting to SQL EXPRESS 2005 on a machine using XP Pro. The setup has worked for over 5 years. A router plugs into the 24 port Dell switch. The router is to allow internet access. We need to set up a VPN and installed a new router. Once the router is...

Problem resolved. Quick to the point. After various attempts, I made a new subdirectory, copied over my MAIN.PRG and FIRST.FRM and started a new project. To my surprize, FoxPro then coppied 95% of the files I needed from my old project without asking me. I can compile again. This process...

@TamaraGranor Thank you for the suggestion. Under the CODE tab of the project manager, if I expand everything, I see nothing under APPLICATION nor API LIBRARIES, only under PROGRAMS. I will continue troubleshooting.

Sad report The program "whichone" was listing errors because DELETED was OFF. Once DELETED was set to ON, the report came back NO ERRORS. I will start looking for other answers.

Thanks again for all the quidance and education. The program "whichone" from Mike Lewis' website is now working after I corrected the project directory name and made a minor correction to the program ( the include file did not recognise a reserved word because a "(" was next to it)...

@DanFreeman Thank you for the insight @FatSlug I could not find "IIRC it ", but your link took me to a program called "whichone". The program crashed due to a bad directory name for the project, just as DanFreeman suggested above. I will research the bad directory name. It has a...

@DanFreeman thanks for the suggestions last succesfull compile 3-28-2011 opened debugger, ran build, same error, no info from debugger.(I am unfamiliar with running DEBUGER and BUILD at the same time) The app does run in development mode. Tried building EXE in a new subdirectory (so...

@DanFreeman To answer the question,"has it been compied during the 5 years?", I checked out the VERSION info under the BUILD OPTIONS. I'm on revision 264. In the past, VFP would tell me what's wrong, but now I'm not getting a specific error message, just the "compile error in...

@DanFreeman This is the software we use at our medical practice. I modify it as needed. After editing some accounting functions/procedures/forms (I forget which), it refused to compile. I have been going along with no updates for a few months, but it's time to get it fixed. Is there a way to...

@MikeLewis the "Display Errors" is marked @jrbbldr For my first time ever, I went to "Project - Errors... top-level menu pull-down ". The ERRORS option was grayed out and not available. I recomplied with a known error in place. An error box was displayed, as expected. I could then go to...

Olaf Your comment made me investigate further. I may have been working under the wrong assupmtions. I would have declared that changes to the back end tables made it impossible for me to access the remote view. But I was able to increase a field length and use the remote view editor. Then I...

Thank you Olaf and Tamar I now have a better understanding of WHY the past mods have been such a pain. I now understand the pitfalls of "SELECT *" in views. I think I can handle the field additions and modifications. I just hate it when I can no longer open the view for modification from the...

Olaf said,"you need some tool like SDT " Is that Stonefield Data Tool???

I am using FVP8 as front end SQL Express 2005 is back end. I have about 60 remote views. It is time to modify the Tables via SQL Express. In the past, if I change the tables, the remote views will no longer work, nor can I access the views to modify them via the IDE. Any suggestions on a good...