?
Solved

Update a .DBF from SQL trigger

Posted on 2003-03-10
14
Medium Priority
?
455 Views
Last Modified: 2008-02-01
Any ideas on how I could connect to a dbf and update a field from sql server?
0
Comment
Question by:criki
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
14 Comments
 
LVL 3

Expert Comment

by:htarlow
ID: 8104217
Add the dbf as a linked server.
lookuup linked servers in SQL Books Online.
If you need more details let me know.

-HT
0
 
LVL 33

Expert Comment

by:CarlWarner
ID: 8104728
HOWTO: Add a FoxPro Database to SQL Server as a Linked Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;199131
0
 

Author Comment

by:criki
ID: 8105884
OK, I've created a linked server but I can't seem to access it or see it anywhere.  
How can I check to see what I actually have?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:criki
ID: 8105897
OK, I've created a linked server but I can't seem to access it or see it anywhere.  
How can I check to see what I actually have?
0
 
LVL 33

Expert Comment

by:CarlWarner
ID: 8105935
HOWTO: Return Information About SQL Server Linked Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;203638

0
 

Author Comment

by:criki
ID: 8105946
Found it, but I get an error...
Could not intialize data source object of OLE DB provider 'Microsoft.jet.OLEDB.4.0'
0
 

Author Comment

by:criki
ID: 8105963
Found it, but I get an error...
Could not intialize data source object of OLE DB provider 'Microsoft.jet.OLEDB.4.0'
0
 
LVL 33

Expert Comment

by:CarlWarner
ID: 8105973
I don't know exactly if that OLE DB provider works with all dbf files.  The reason I say that is that in MS Visual FoxPro 7 (and 8), there is a specific OLE DB Provider for VFP included in those products which supports .dbf files.  However, I don't know the source of your .dbf file to comment on whether or not this is your problem.  But, it sure could be.

Assuming it is the correct connectivity driver, setup can be tricky and something may have been missed into how all that was configured.
0
 

Author Comment

by:criki
ID: 8106011
Found it, but I get an error...
Could not intialize data source object of OLE DB provider 'Microsoft.jet.OLEDB.4.0'
0
 

Author Comment

by:criki
ID: 8106115
Found it, but I get an error...
Could not intialize data source object of OLE DB provider 'Microsoft.jet.OLEDB.4.0'
0
 

Author Comment

by:criki
ID: 8106297
OK...
After playing with the sp_addlinkedserver, I did it the easy way and just created it by right clicking on the linked server in enterprise manager.
I actually got thru it once with no errors, but no tables showed.  
0
 

Author Comment

by:criki
ID: 8106416
OK...
After playing with the sp_addlinkedserver, I did it the easy way and just created it by right clicking on the linked server in enterprise manager.
I actually got thru it once with no errors, but no tables showed.  
0
 
LVL 17

Expert Comment

by:walterecook
ID: 10337159
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

PAQ with points refunded

Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

walterecook
EE Cleanup Volunteer
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 10364746
PAQed, with points refunded (500)

PashaMod
Community Support Moderator
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question