Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 470
  • Last Modified:

Update a .DBF from SQL trigger

Any ideas on how I could connect to a dbf and update a field from sql server?
0
criki
Asked:
criki
1 Solution
 
htarlowCommented:
Add the dbf as a linked server.
lookuup linked servers in SQL Books Online.
If you need more details let me know.

-HT
0
 
CarlWarnerCommented:
HOWTO: Add a FoxPro Database to SQL Server as a Linked Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;199131
0
 
crikiAuthor Commented:
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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
crikiAuthor Commented:
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
 
CarlWarnerCommented:
HOWTO: Return Information About SQL Server Linked Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;203638

0
 
crikiAuthor Commented:
Found it, but I get an error...
Could not intialize data source object of OLE DB provider 'Microsoft.jet.OLEDB.4.0'
0
 
crikiAuthor Commented:
Found it, but I get an error...
Could not intialize data source object of OLE DB provider 'Microsoft.jet.OLEDB.4.0'
0
 
CarlWarnerCommented:
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
 
crikiAuthor Commented:
Found it, but I get an error...
Could not intialize data source object of OLE DB provider 'Microsoft.jet.OLEDB.4.0'
0
 
crikiAuthor Commented:
Found it, but I get an error...
Could not intialize data source object of OLE DB provider 'Microsoft.jet.OLEDB.4.0'
0
 
crikiAuthor Commented:
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
 
crikiAuthor Commented:
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
 
walterecookCommented:
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
 
PashaModCommented:
PAQed, with points refunded (500)

PashaMod
Community Support Moderator
0

Featured Post

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now