473,703 Members | 3,336 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

FoxPro ODBC Link Servers and the Dreaded 7399 Error

(SQL 2K SP3a on W2K. VFP 6 data lives on W2K. GIGABIT BACKBONE, gig
cards on the data servers)

I'm sure anyone who attempts to retrieve or alter FP/VFP data through
a SQL link server will commiserate.

I'm getting sick of restarting my instance after attempting a simple
OPENQUERY statement on a VFP 6.0 DBC link server:

select * from openquery(ofsdb c,'select onestinkinfield from mytable
where onestinkinfield = whatever')

and being rewarded with

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager]
Driver's SQLSetConnectAt tr failed]
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager]
Driver's SQLSetConnectAt tr failed]
[OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro
Driver]Cannot open file \\mydevbox\mydb path\myvfpdata. dbc.]
OLE DB error trace [OLE/DB Provider 'MSDASQL'
IDBInitialize:: Initialize returned 0x80004005: ].

The only remedy is to restart the SQL services. The link server then
behaves for a variable number of queries, and then we do the dance
again.

Come on, MS, this is unacceptable. VFP is your own technology and you
can't make SQL play nice with it? Pshaw. This gets old when you're
five or six layers into a BizTalk process trace. ("When you're up to
your arse in alligators, it's tough to remember that the objective was
to drain the swamp.")

I RDP to the SQL box and can ping the datasource server all day long.
I can open the folder in which the DBC and data live all day long. I
can run the DBC in VFP, FROM THE SQL BOX, all day long. I just can't
get a link server to live more than one or two days, or sometimes more
than one or two queries.

NB I've already been through PSS for this garbage, and was essentially
told that MS no longer supports ODBC connections to VFP data from SQL
link servers. Furthermore, they don't support inserts, updates or
deletes through same with the VFP OLEDB provider.

Any and all war stories, tonics, suggestions, rants, corrections,
upbraids, horse laughs, and snickers appreciated in reply.
Jul 20 '05 #1
0 2034

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2754
by: Colin Colin | last post by:
We migrated our intranet site from IIS4 NT4 (\\GHCNT8) to a Windows 2003 server with IIS6 (\\NT58) using the IIS Migration Tools. I have a few ASP pages that access Foxpro data on a different server. I downloaded the Visual Foxpro ODBC Driver from MSDN. I exported (from the registry) the ODBC entries from the old server and imported them onto the newserver. I setup the Internet user guest account with rights where the Foxpro data is...
2
6600
by: Salad | last post by:
OS = WinXP & Win98. Access = A97 & AXP Q1) Where can I find the VFP ODBC driver at Microsoft. I have been working developing an app in Access that will link to some DOS FoxPro tables. I have been doing my development work in A97 but the folks have AXP at their site. As near as I can tell, the FoxPro driver has been discarded from A97 and replaced with ODBC in A2K onward
0
1776
by: Salad | last post by:
My operating system is WinXP Pro. I have 1 gig of memory and the chip is an Intel Pentium 4. I am using Access97. A table has been supplied to me from an external source createdc from Visual FoxPro file, version 6.0. If I connect to it using File/GetExternalData/Link and select FoxPro as the file type and it links OK. I press Open and the table opens just like an Access table...quickly. There are 557 records. The problem is that...
2
22113
by: Maverick | last post by:
If i try to create foxpro table by the following "sql" statment, the C# compiler will only return an error "xxxx not support in non-dbc version". The "index on" command statement return some kind of syntex error too. How can i create a DBF table with proper indexing ability ?? The "UNIQUE" keyword has already been proved to be failed to perform normally. Please help string sql = "CREATE TABLE datafile (field1 C(10) PRIMARY KEY, field2...
1
3931
by: GPBSOFT | last post by:
I am Italian developer, escuse me for my bad English I have a problem with ODBC. I must link to a database from Visual FoxPro, I have installed Windows XP Professional with service pack 2. When I try to install driver for Visual FoxPro i see the message: “Error 1918. Error installing ODBC driver: Microsoft Visual FoxPro Driver, ODBC error 13: : Impossibile caricare la libreria di impostazione o del convertitore. Verify that the file...
4
8449
by: Robert Hooker | last post by:
I have installed our .NET application on a system running Microsoft Windows Vista operating system. When I run our application, I receive the following error message whenever it tries to create a DBF file using VFPODBC: "ERROR Driver does not support this function" I am using a connection string that I have used for many years with no problems, here is some sample C# code:
1
1259
by: ilanwajsman | last post by:
I'm linking a DB2 database running on Linux to SQL Server 2000, in Enterprise Manager. I've done this successfully on several servers, but on some servers I'm getting the following error when I try to access the DB2 tables: Error 7399: OLDE DB provider 'UNKNOWN' reported an error. SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553 ]
7
5490
by: z71mdridin | last post by:
I have an asp.net website that uses Form authentication to authenticate users. I need to provide users with a report based on FoxPro data that resides on a remote server. When I attempt to connect to the Foxpro directory by using the ODBC DSN that we currently use in ColdFusion, I get the following message: ERROR File 'table.dbf' does not exist. I know this is probably a permissions issue because asp.net is being
3
5174
by: HistoricVFP | last post by:
Hello, I’ve been given the task of importing .dbf files from a very old version of Visual FoxPro (version 2.1) into Access (2003). When I import the data straight to Access it errors with: External table is not in the expected format. (Error 3274) I’ve tried the following but it did not work: “To import data from a FoxPro database, use the Microsoft Visual FoxPro ODBC driver. To do so, follow these steps: 1. Click Start, and then...
0
8662
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9243
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9109
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8956
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7853
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6585
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
1
3113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2434
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2057
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.