We are getting the following ODBC timeout errors when executing sql code against a SQL Server database. "Connectivity error: [Microsoft][ODBC SQL Server Driver]Timeout expired" "S1T00" The confusing thing here is that our stack dump says that the SQL code it is executing when the timeout occurrs - is very simple: SELECT @@TRANCOUNT AS...
Hi! I need some help with the ADS OleDB Provider for Visual FoxPro. I'm trying to insert data from an 64-Bit .net-Application into a FoxPro Database. The table in which the data will be inserted has about 130'000 records, 139 fields and 11 indexes. Every time I run my sample application i get an error which says that the indexes are co...
I couldn't quickly find a google answer, and I don't have the help in front of me (long story), so - any easy way to URL-encode a string in MS Visual FoxPro 8 ...
I have a visual foxpro 6 application which is hanging (100% CPU). Process explorer etc don't indicate any activity, so it is obviously in some kind of loop. For a .net or C app I would take a dump of the process when it is hung, and identify which method is causing the problem. Can a similar technique be done using foxpro, or any advi...
I have the following dilema: My clients (mom-n-pop pawnshops) have been using my mgmt. system, developed with ISQL, for over 20 years. Throughout these two decades, I have customized the app to each clients desire, or when changes in Laws/Regulations have required it. Most clients are single-user sites. Some have multiple stores, but hav...
I want to know is there any way to know which font a foxpro application using for printing. This foxpro application is around 8-10 yrs old. and when I print bill it produces same font style in (XP, Win7 os). I want to this font because it produces good result than what i experimented with different font available on Win 7 OS. Thank you....
I have legacy application that checks to see if the version of SQL Server is 6.5, 7 or 2000. If not, it returns a database not supported error. I would like this application to use the database on SQL Server 2008. Is there a way to fake the version so that the application check for SQL Server version passes. My legacy application code is...
I have foxpro app which uses .dbf as database and generate a .txt file for report printing. is there any way to know what query foxpro app is using for report preparation. I have .prg, .idx, .dbf, .fxp and some other files. ...
I have a database with 1,000,000 records and a query like this: select count(code) from table1 It works well on the local system but becomes very slow on the network. Other queries like select * from table execute quickly, but select count(code) from table1 is very slow. I can't change the database's structure. My database is Foxpro a...
How can i write this query with LINQ to a FoxPro database? SELECT count(*) FROM Table group by item1 I wrote it as below, but it doesn't work Dim Query Dim dt As New DataTable Dim da = New Odbc.OdbcDataAdapter("SELECT * FROM table1",connection) da.Fill(dt) Query = (From row In dt.AsEnumerable Select row_ Group By item1 ...
I have a ton Visual FoxPro db files that I am trying to import into an empty SQL 2008 Express database. When I run through the SQL Import and Export Wizard everything seems to communicate fine. When I get to the mappings section I can click on preview and see the data in the selected FP table. When I click on Edit Mappings or Next I g...
There is one software application in which foxpro is used as back-end. Now this application is need to change. And want to develop same new application in .net. But now database will be sql. And I don't want to let user make all data entry again. Is this possible to use data of foxpro in new application with .net? EDIT: I have not codin...
I access data in .dbf files via System.Data.OleDb (vfpoledb.dll). How can I find out whether table exists via SQL command? Something similar to the following on SQL server: IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TheTable')) BEGIN --Do Stuff END ...
In FoxPro 2.6 for MS-DOS is there a way to use a variable in a SELECT command? For example, how can I write the following query: SELECT * FROM DBFILE WHERE Ord_no = temp_no Given that temp_no is a previously defined variable. I tried using "&temp_no" but this does not appear to be the correct syntax. ...
Which software can you recommend to sync data from a FoxPro source to a SQL Server destination? ...
OleDB always add one more digit to DBF numeric fields when we create them. A command like this: CREATE TABLE [file1.DBF] ( [MY_FIELD] NUMERIC(1,0) NULL) will create a field that can contains 2 digits (or one digit and a minus sign). What's funny is that I can ask for a length of zero like this NUMERIC(0,0) and it's going to create a fiel...
LANGUAGE: C#, System: Windows7, Excel 2007 I want to create a .DBF from some data, and i want to open it from Excel 2007. It can be either dBase or foxpro. I am currently doing in FoxPro9 (btw this code is from the internet): OleDbConnection con = new OleDbConnection("Provider=VFPOLEDB.1;Data Source=C:\\Temp\\;"); con.Open...
I need to transfer a lot of foxpro files over the internet and then import the data into an access database. In some cases the .fpt file is several times bigger than the .dbf file of the same name. From what I have been reading it seems that the .dbf file might hold everything and that I can ignore the .cdx and .fpt files. is this correc...
In Foxpro how to get Call stack info for logging.(not using the debugger ui, but in code at runtime) ...
My DBA's are saying my foxpro application or .DBC (Database container) are hitting SQL server but searching all the code can't find the SQL call (FMTONLY ON/OFF). This is the SQL command being sent: FMTONLY ON/OFF Getting called 16260 times every few minuets? Any ideas how to find this or what could be causing it, maybe my DBC file? ...