I had to create a 64-bit DSN and use the 64-bit driver 'Microsoft Access dBASE Driver' where I was trying to use a 32-bit driver 'Microsoft dBase Driver' with a 32-bit DSN which gave mismatch between Driver and Application error, this can be seen in. Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question.Provide details and share your research! Asking for help, clarification, or responding to other answers.
- Odbc Visual Foxpro Driver Download
- Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error Example
- Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error Key
- Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error Free
A while back, someone handed over some scheduling data in a somewhat clunky old application in desperate need of modernization. I looked under the hood and figured out that this thing uses a FoxPro database! Microsoft discontinued development of Visual FoxPro way back in 2007, and I hadn’t seen a working FoxPro database since the late 1990s…so I knew it might be tricky to get the data out.
TL;DR: I fired up Microsoft Access to see if I could link to the external data. This was harder than I expected because Windows 10 and Access 2016 no longer ship with a Visual FoxPro ODBC driver. Once I found one, I could easily link to all of the tables—except for the ones that included variable-width memo fields. I could use an OLE DB provider to get to tables with memo fields, but only via Excel or programmatically. Access apparently can’t create a linked table via OLE DB.
As I mentioned above, if you’re on Windows 10 and Microsoft Access 2016, chances are good that your machine doesn’t have an ODBC driver for Visual FoxPro installed like earlier versions. You can find a page on Microsoft’s website that used to have a link to download of the driver, but it’s been removed since they no longer support it. Thankfully, it seems you can reliably find a link to the old Microsoft VFPODBC.msi file at the Visual FoxPro Wiki.
I know Microsoft Access isn’t an ideal tool for creating applications, but I sure saw and wrote plenty of them back in the day. It’s still a great tool to quickly test stuff like this.
So I clicked over to the External Data ribbon, clicked New Data Source→From Other Sources→ODBC Database and configured a connection to the FoxPro data I wanted to get into. I easily pulled up a table listing and decided to select all the tables to start off. Several prompts came up to indicate a unique identifier. Being that my attention span for message and dialog boxes has shrunk to zero, I answered the first two or three, and then just clicked Cancel through the rest. Everything seemed all too easy!
Problems with Tables Having Memo Fields :-/
Odbc Visual Foxpro Driver Download
Now that I knew this was indeed a FoxPro database and that I could access its contents, I set my focus on analyzing the table structure to find the specific data I needed. At this point I hit a snag…
After much googling and digging, I concluded that the cause of these error messages was that the Microsoft Visual FoxPro ODBC driver was choking on the memo fields.
. Every other table I linked to via ODBC worked perfectly, but any table that included one or more memo fields bombed.
If you look at the file structure of a FoxPro database, you see that each data table has a corresponding .DBF and .CDX file. Using a text editor, I could infer that the .DBF file contains headings and data for the table’s fixed-width fields, and that the .CDX file contains indexes. Any table that included a variable-width memo field had a corresponding .FPT file containing that data.
So if you want a shortcut to determine whether ODBC will get you into all of your FoxPro tables, look for .FPT files. If you see them, you will have problems. If you don’t have problems, I hope you’ll tell me about it! The best solution I’ve found is only a workaround. I’d love to know if you’ve found a method to link directly.
In my quest to crack this open, I found others recommend OLE DB as a way to overcome the memo field problem. While an OLE DB driver for Visual FoxPro no longer ships with Windows 10 or Access 2016 of course, I easily tracked one down on Microsoft’s website here.
After I installed it, my next problem was how to use it in Microsoft Access to create a linked table. After again scouring the Internet, I found no way to do this. Access apparently only allows you to create linked tables to Access, SQL Server, and ODBC databases. I could however import the data into Excel, but that too was tricky.
Importing Visual FoxPro Data Into Excel via OLE DB
Getting to external data via OLE DB is pretty intuitive in Excel…up until you go to create the connection string. (Click Data→Get Data→From Other Sources→From OLE DB.) After I clicked Build, selected the Visual FoxPro driver, and clicked Next, Excel crashed…every single time…
Thankfully there’s more than one way to build an OLE DB connection string. For the most part, it’s pretty straightforward (so long as you don’t need any special options):
Once I had my connection string, I pasted it into Excel and it connected to every table in the FoxPro database. I could import all of the data I needed with no problems.
From here I could link to the data in Excel to use it in Access. I could also use some VBA code to directly import the data into Access. These are not simple ways to get to my data, but at least I know I can get it out when the time comes.
I have an application written in ASP Classic and connecting to a FoxPro database which intermittently throws this error message, found in the IIS log file:
14|80004005|[Microsoft][ODBC Visual FoxPro Driver]Unable to create temporary work files.
The line referenced is a SELECT statement against the FoxPro database. The error does not occur every time this particular SELECT statement is run.
The ever-helpful MSDN Article concerning this error suggests that the problem is either due to permissions or to disk space. Permissions are at least semi-functional because the problem doesn't always happen. Disk space is also not a problem as there is enough free space on the drive (8GB) proportional to the size of the database in question (about 500MB).
What else can I look for?
Is the FoxPro ODBC driver cleaning up after itself?
Look in your TEMP folder (defined by the %TEMP% environment variable, in my case), and you may see a large number of files matching the expression [A-Z0-9]{8}.TMP (e.g. LVAK00AQ.TMP).
Per this ancient tome, FIX: TMP File Errors If ALTER TABLE Runs Same Time As ODBC DLL:
Visual FoxPro and the VFP ODBC driver both use the same naming convention and algorithm for temporary (.tmp) file creation. If both programs run concurrently, there is a conflict in the processes attempting to access the same file or same file name. This conflict creates different error messages.
Visual FoxPro 5.0x uses a tempfile naming scheme based on the system clock. These names are generated for internal use and many times the filename is never actually created on the disk. However, there are many circumstances when FoxPro does create the temporary file on disk, so the name generation scheme could cause two processes or two instances of the run-time in the same process to generate the same temporary file name. If both processes try to create a temporary file on disk later, only the first one succeeds.
In my experience, the file naming pattern is based on a small unit of time, and with the alphanumeric scheme limited to 8 characters, it will start again from 0 within a short period of time (not sure if hours or days).
If the temp file needs to be written to disk, and the file already exists from a previous execution, then instead of overwriting the previous file, the driver will throw the error 'Unable to create temporary work files'.
ODBC php Excel Encoding Issues
php,excel,encoding,utf-8,odbc
Incase someone stumbles the same problem as I had, I solved it the following way: In the excel file change the Encoding to Western European (Windows-1252 to UTF-8); In PHP convert from Windows-1252 to UTF-8 -> $value = iconv('Windows-1252', 'UTF-8', $auxVar); Value has the correct encoding. For some reason the...
Asp classic 3.0 loop and movenext
loops,asp-classic
msg = msg & VBcrlf & 'ID record: ' & Rec('Id') & ' msg = ' This code doesn't make sense, msg = ' changes the value of msg to an empty string, and makes the previous line pointless. It would make more sense to have msg = ' before...
How can I correlate session.sessionid and IIS Log session cookie?
asp.net,session,iis,asp-classic,iis-6
According to this MSDN article (which is ancient, but certainly makes sense in my experience): Session ID values are 32-bit long integers. Each time the Web server is restarted, a random Session ID starting value is selected. For each ASP session that is created, this Session ID value is incremented....
New Datastax driver for Tableau is not working
cassandra,odbc,tableau,datastax
So I've resolved it. When you setup datasource it Tableau, you have to specify cluster, database and table (a.k.a. column family). I specified CF/table 'tablename_i_try_to_query' and dragged it to the pane on the right. Then I specified database. It didn't work. Tableau generated query without specifying database. Then I removed...
How to extract and store ODBC with driver pairs
c#,odbc
The code could be cleaned up a bit, but this worked for me: public List<Tuple<string, string>> ListODBCsources() { int envHandle = 0; const int SQL_FETCH_NEXT = 1; const int SQL_FETCH_FIRST_SYSTEM = 32; List<Tuple<string, string>> ODBCNameDriverList = new List<Tuple<string, string>>(); if (OdbcWrapper.SQLAllocEnv(ref envHandle) != -1) { int returnValue; StringBuilder serverName =...
Junk varchar entries in MSSQL database using ODBC
c++,sql-server,c++11,odbc
Thanks to @erg, here is the solution that worked for me: char mMessageText[100]; bool initConnection() { (...) // bind parameters SQLBindParameter(mSqlStatementHandle, 5, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_LONGVARCHAR, 100, 0, (SQLPOINTER)mMessageText, 100, NULL); (...) } bool fillDb() { (...) std::string lMessageText = 'This text is longer than 15'; strcpy(mMessageText, lMessageText.c_str()); mMessageText[sizeof(mMessageText) - 1]...
Java JDBC-ODBC cannot load driver for Excel
java,excel,jdbc,odbc
The JDBC-ODBC Bridge is obsolete and has been removed from Java 8. If you need to manipulate an Excel document and you are unable (or unwilling) to downgrade your environment to Java 7 then you might want to investigate Apache POI.
Malicious code hidden in image
image,iis,asp-classic,virus
OK, the file was malicious it contained encoded php, all of which im not sure of there were far too many encoded layers. It created a backdoor that fetched and executed remote code. This file was not detected by any of our antivirus software, what gave it away way was...
Print HTML with IF Statement
html,asp-classic
It's been a while... If I can remember, it should be this: <% If anyCondition = True Then %> <p>This is a HTML paragraph, it will be printed if <%=anyCondition%> will be true</p> <% Else %> <p>This is another HTML paragraph, it will be printed if <%=anyCondition%> will be false</p>...
Response.write in multiple place with same recordset
vb.net,vbscript,asp-classic
if its not working by do while loop, you may try using simple for loop For i as integer=0 to rs.rows.count Response.Write('<option>'+rs.rows(i).value+'</option>') Next ...
Database structure possibility
php,sql-server,database,codeigniter,odbc
After inserting to table B, use $user_id = $this->db->insert_id() to get the last insert ID (table B's ID) and then update table A. So your code looks like ... $this->db->insert('tableA',$data); $last_rowID = $this->db->insert_id(); $this->db->insert('tableB',$dataB); $user_id = $this->db->insert_id(); $this->db->where('tableA_ID',$last_rowID )->update('tableA',array('userID' => $user_id)); ...
Classic ASP Post to MS Access DB - Doesen't Work from Textarea Editor
ms-access,asp-classic,tinymce
Can you use String = Server.HTMLEncode(String) instead of Replace? Can you show your query with data? Just before you going to execute Conn.Execute ? You could do this by using following way Response.Write 'your query' Response.End few more suggestion in HTML control maximum size of text for input instead <input...
QODBCResult::exec: Unable to execute statement: '[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error
c++,sql-server,qt,tsql,odbc
The problem turned out to be the syntax, I changed it to query.prepare('{CALL add_syllabus_line (:teacher_name, :subject_name, :temporary_name, :type_name, :activity_name, :min_score, :max_score, :max_score_exists, :evaluation_by_exam)}'); QComboBox *combo = static_cast<QComboBox*>(table->cellWidget(i,0)); query.bindValue(':teacher_name', teacherName); query.bindValue(':subject_name', 'Физика'); query.bindValue(':temporary_name', ratingName); query.bindValue(':type_name', combo->currentText());...
Get special character from Query string in classic asp
url,asp-classic
I got where I am going wrong. while giving the redirection tag like <a href='ViewProfile.asp?mem_id=phani#1&page=1'> it should be like <a href='ViewProfile.asp?mem_id=Server.UrlEncode(phani#1)&page=1'> This solves the issue....
Classic ASP Response write statement
Use double double quotes if you need to escape them within a Response.Write statement, ie Response.Write '<divthe_div'border: 1px solid red'><iframe src='asp3.asp'> </iframe><br><br></div>' Response.Write '<a href='#'hide('the_div');return false;'>Hide the div until this link is click again.</a><br>' Response.Write '<a href='#'remove('the_div');return false;'>Remove the div until this link is click again.</a>'...
How can I find a node containing a sub-string?
xml,xpath,vbscript,asp-classic
You can use contains(): Set user = objXMLDoc.selectSingleNode('//user[contains(@id,' & id & ')]') or if spaces appear only at the end of string you can use starts-with(): Set user = objXMLDoc.selectSingleNode('//user[starts-with(@id,' & id & ')]') ...
SQL Server Native Client 11 ADO connection string for MS SQL Server 2014 with integrated login
sql-server,iis,asp-classic,database-connection,ado
Got the following connectionstring to work: strConn = 'Provider=SQLOLEDB;DataTypeCompatibility=80;Integrated Security=SSPI;MARS Connection=False;Initial Catalog=myDB;Data Source=myServer' ...
Microsoft.XMLDOM - Facebook Page RSS - System error: -2147012866
xml,facebook,asp-classic,rss
Try using the latest version of Microsoft's XML processor. Replace your third line of code with: Set objXML = Server.CreateObject('Msxml2.DomDocument.6.0') I notice you don't appear to be outputting your XML node values, your just writing them to variables. If you're looping through a set of elements then the values of...
ODBC ISAM_EOF without any reason
c#,database,odbc,cobol
It seems to be Windows UAC reliant. As our application run in compatibility mode, UAC visualization is active and causing may some problems. The reason for this is, that the COBOL databse is a file based database, and the client where are coding for uses these files in ODBC DSN...
Form Data Not Posting While Using URL Rewrite
asp.net,forms,url-rewriting,asp-classic,web-config
Your web.config contains action=redirect. A redirect always results redirect header being sent to the browser. This changes the URL in the browser address bar, and the browser then issues an HTTP GET for the new address. With an HTTP GET, no form/post data are ever sent; all arguments are assumed...
Calling Up A Correct, Individual, Modal Menu from a Classic .ASP Repeat Region
javascript,jquery,asp-classic
Part of the problem is that all of your FORMs have the same ID, so when the delete link is clicked it opens all objects with the same ID. It would be a good idea to give each a unique ID by changing this line from... <form ACTION='<%=MM_noteDeleteAction%>' METHOD='POST' name='Modal-Menu-DeleteNote-Form'...
Error when leaving input blank in ASP
asp-classic,active-directory
8007200b = LDAP_INVALID_SYNTAX (The attribute syntax specified to the directory service is invalid) I would say that you have worked out what the issue is. LDAP attributes cannot be NULL. You probably don't even need to have spaces, an empty string might work as well. e.g. if (IsNull(firstname)) Then firstname...
LIKE operator in SQL for my Access Database returns no values in ASP CLASSIC while it does if the query gets copied directly in Access
sql,ms-access,asp-classic,sql-like
Figured it out myself. Seems that I only had to replace the * wildcards with the % wildcard. This did the trick..
Error Type: Microsoft VBScript runtime (0x800A01A8) Object required in asp
vbscript,asp-classic
There are two sure ways to get an 'Object required' error: Trying to use Set when assigning a non-object: >> Set x = 'non-object/string' >> Error Number: 424 Error Description: Object required Trying to call a method on a non-object: >> WScript.Echo TypeName(x) >> If x.eof Then x = 'whatever'...
Publish will not push adovbs.inc to target File System destination (classic asp and IIS 7.5)
iis,asp-classic,iis-7.5,publish,server-side-includes
Don't use VS Publish website option for a classic asp site because there is nothing to compile, use the Copy website option instead, you can find it in the Website menu or right-click on the website in the solution explorer.
Search returns line number
You need to have the loop contain the readline, so that it fetches the next row, otherwise it goes into an infinite loop, and that is why it times out, not because you are using InStr You also only fire the InStr once, before the loop, so it would only...
Insert Server Date to DB ODBC Error
This issue ended up being resloved, ended up being an issue with my text area that was gathering the data. Closing thread, thank you all for your help and advice.
Connecting to ODBC using pyODBC
python,ms-access,odbc,pyodbc,dsn
I managed to solve my issue. My code did not really change. cnxn = pyodbc.connect('DSN=BCTHEAT') cursor = cnxn.cursor() cursor.execute('select * from acr.Table_one_hh') row = cursor.fetchall() then I wrote the results into a csv file....
More precision needed from SQL Server Money data type
sql,sql-server,asp-classic,sqldatatypes,money
you should define the type as decimal(25,10) which could hold the federal deficit up to an accuracy of 10 digits. (25 digits with ten after the decimal place).
How to execute POST using CURL
post,curl,asp-classic
from a basic search i found how to do this: $curl --data 'responseCode=jorgesys&publication_id=magaz234rewK&version=1.0' http://mywebsite.com/appiphone/android/newsstand/psv/curl/posted.asp then i have as a result: { 'responseCode': jorgesys, 'publication_id': magaz234rewK, 'version': 1.0 } ...
Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error Example
Read POSTed Binary File And Write To a New Binary File
excel,vbscript,asp-classic
I don't see how your code would work. Classic ASP has no way accessing uploaded files like ASP.NET (Request.UploadedFiles) so if you don't use a a COM component then you need to read Request.BinaryStream and parse out the contents, which isn't so easy. There are several Classic ASP scripts that...
VBScript Redirect to Network Folder
vbscript,asp-classic
The Request.ServerVariables collection is available on the server side , you will have to get that value into the client side script : window.location = 'path to user folders<%=Right(Request.ServerVariables('LOGON_USER'),6)%>' ...
what is the SQL prepared stament for lo_import in postgreSQL
c++,sql,database,postgresql,odbc
The query to prepare should be insert into test values(?,lo_import(?)); You proposal insert into test values(?,?) can't work because you can't submit a SQL function call (lo_import) as the value for a placeholder (?). Placeholders only fit where a literal value would fit. When you're asking what's the prepared statement...
Convert XML tag to specific format
vbscript,asp-classic
Assuming that all your files have the XML en bloc with each line starting and ending with a tag (i.e. an angular bracket) and no blank lines between them you could do something like this (using a replacement function): foldername = '...' Function MakeXmlVar(m, sm, pos, src) s = Replace(sm,...
Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error Key
What is the '<>' asp operator?
So, the below expression would be false if x is null or an empty string, and true otherwise? Not exactly. There are few function to verify value: IsNull(expression) IsNull returns True if expression is Null, that is, it contains no valid data; otherwise, IsNull returns False. If expression consists...
How do I take values entered on one html page's form, and enter them on another html page as variables
javascript,html,asp-classic
In process.asp, you can print out the variable from the form, right into your javascript. <script> var betweenDivs = (<% response.write(request.form('secondsBetween')) %> * 1000), numSlides = <% response.write(request.form('numberOf')) %>; </script> ...
How to implement Google Recaptcha 2.0 in ASP Classic?
I don't see how you send request. Anyway, below is working sample with my site key for test web site. Of course, you should provide your own 'secret key' and 'data-sitekey' Live sample: http://1click.lv/googlecaptcha.asp File name: GoogleCaptcha.asp <%@LANGUAGE=VBSCRIPT%> <% Option Explicit %> <html> <head> <script src='https://www.google.com/recaptcha/api.js' async defer></script> </head> <body>...
Classic ASP Adding sort function by TD column
javascript,asp-classic
The way to do this purely in classic asp would be to modify the end of your sql query from ORDER BY filmoccurence desc to ORDER BY ' & Request.Querystring('sortparameter') & ' desc, and then turn your table column headers into links which can pass the relevant field name to...
Edit fields in local table linked to PassThrough Query
sql-server,ms-access,odbc
Yes, you can achieve this with a local table as you have already mentioned. However to add a 'Note' to your local table, you either have to have a form, or both queries linked as (master > child) Your local table's design will look like this: Warehouse_record_id > Int or...
Classic ASP and JQuery reloads default.asp page on redirect
javascript,jquery,vbscript,asp-classic
If in a frameset, consider using JavaScript to change window.top.location.href to your redirect URL instead.
Error connecting to MSSQL using PHP
php,sql-server,pdo,odbc,sqlsrv
Change it to: $this->link = new PDO( 'sqlsrv:Server={$this->serverName},{$this->port};Database={$this->db};', $this->uid, $this->pwd ); The default SQL Server port is 1433. Note the curly brackets, they allow for class variables....
How to convert an integer to a string in ASP Classic
cookies,asp-classic,session-variables
You can use method cstr() to transform INT variable in STRING.
Classic ASP & Access DB - FROM Clause Error
ms-access,vbscript,asp-classic
You have used a lot of reserved words of access to the field names. If you make a query inside access the system run at the same, but if you pass the query using asp will be in error. You should either change the names of the tables fields. Es.:...
Best way to deploy classic asp webapp with sqlite database?
sqlite,asp-classic,hosting
Ok, I came up with a good solution: I imported my database into MS Access (from Access -> external data -> ODBC database -> follow the steps to choose your database). It works well with my ASP front-end after a few minor modifications. I can now use any ASP hosting...
Can't open Saleslogix SLX connection
Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error Free
vbscript,asp-classic,saleslogix
Well, I managed to find the solution: In IIS, in my site, feature name: IIS/Authentication: Anonymous Authentication, I change the Application user identity to Application pool identity. Full configuration to make it work: Application Pool: Identity->Network Service, Load User Profile->True, Enable 32-Bit Applications: True Site: Authentication: Anonymous Authentication->Application pool identity...
Regex to strip span inside a tag using classic ASP
regex,asp-classic
I whipped this out pretty quick, so it may have some issues, but it worked. You will need to update it for double quotes. <% text = '<h2><span>{text to remain}</span></h2>' dim objRegExp : set objRegExp = new RegExp objRegExp.Pattern = '</?span()?>' objRegExp.IgnoreCase = True objRegExp.Global = True...
C++ [ODBC]-MSSQLExpress 2008 SQLSTATE: 28000 || 42000
c++,sql,windows,sql-server-2008,odbc
Solution I solved this problem by modifying the connection string to: 'DRIVER={SQL Server};SERVER=TOWER-PC;DATABASE=tfe;UID=adminA;[email protected];' Helpful link...
Prevent Caching of PDFs in ASP Classic
pdf,caching,asp-classic
The code below generates a link with the current time converted to a Double so it produces a random link each time the page is loaded to trick the browser into thinking it is a new pdf. <a href='yourpdffile.pdf?<%= CStr(CDbl(Now)) %>'>Link to the PDF</a> Now is the current time CDbl(Now)...
FormatCurrency giving different results on different pages in different browsers?
vbscript,asp-classic
A cow-orker pointed this out to me, after having a similar issue: Make sure your file is saved in the proper encoding! My file was saved in UTF-8 and needed to be encoded in ANSI (it's an old system)....
Javascript Ajax Call always returns readyState=1 and status=0 error
javascript,html,ajax,asp-classic
xmlhttp.onreadystatechange=stateChanged(); does not do what you think it does - it will invoke stateChanged, evaluate it to undefined, then assign that undefined to .onreadystatechange, which tells the xmlhttp that it doesn't have to care about ready state changes. You want to assign your function to the .onreadystatechange, not its result:...