Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Problem viewing via ODBC link

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 23-12-2009
Member
 
Join Date: May 2008
Posts: 248
Problem viewing via ODBC link
  

Hi
This is after several searches on the net without success I decided to post here. My problem is rather "odd":
I work in an Access database SQLServer 2000 (sp3). It has been several times that happens, the data displayed on the tables via Access are redundant. Let me explain: when viewing the data (without complaint, just by opening the table), if for example I must display 100 lines, those 100 lines will be absolutely identical in Access but in reality under SQLserver they are completely different. Good data are clearly those of SQLserver. I have to redo the links, but sometimes without success. Thank you for your help.

Reply With Quote
  #2  
Old 23-12-2009
Member
 
Join Date: May 2008
Posts: 4,565
Re: Problem viewing via ODBC link

Hello
I think there are several ways out there. Have you tried to delete outright, the Access table (linked) and recreate it?
The ODBC driver is this the latest version?
It seems there is a SP3a, which contains an ODBC driver:
Tell us what happens and good luck.
Reply With Quote
  #3  
Old 23-12-2009
Member
 
Join Date: May 2008
Posts: 248
Re: Problem viewing via ODBC link

Hi
Thank you for your answer. I already delete the Access table, redo the links, recreated a low Access , occasionally it works but I think it's random. What scares me is that users have this bug and make some cuts in the tables because of that there is a wholesale disaster!
Quote:
The ODBC driver is this the latest version?
Also I installed the SP3a. Any more suggestions on this. Any help please.
Reply With Quote
  #4  
Old 23-12-2009
Member
 
Join Date: May 2008
Posts: 4,565
Re: Problem viewing via ODBC link

Hi
Just go through this -
In "Tools" / "Options" tab "Advanced", tried to "play" with the "ODBC Refresh Interval (sec)": enter "1" for an instant update forced then modify the value if performance is too corrupted. In all cases, look, first, if your problem is solved.
Hope this helps you and your problem is solved. I repeat after every attempt please check it the problem is solved.
Reply With Quote
  #5  
Old 23-12-2009
Member
 
Join Date: May 2008
Posts: 248
Re: Problem viewing via ODBC link

Hey
Quote:
Have you tried to delete outright, the Access table (linked) and recreate it?
All the above was done by me, but still I was with the same problem.
Quote:
The ODBC driver is this the latest version?
After reinstall SP3a is not the problem resurfaced , I hope that the problem was much of the installation. Thanks for your help.
Reply With Quote
  #6  
Old 23-12-2009
Member
 
Join Date: May 2008
Posts: 4,565
Re: Problem viewing via ODBC link

Hello
Quote:
After reinstall SP3a is not the problem resurfaced , I hope that the problem was much of the installation.
Mostly in such cases it is the drivers of the hardware that given the problem. I am happy that you have solved your problem very soon with wasting the time. Best of luck.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Problem viewing via ODBC link"
Thread Thread Starter Forum Replies Last Post
x200t multitouch screen viewing angles and portrait viewing Mycenaen Portable Devices 6 17-09-2010 06:34 AM
satellite tv viewing problem anilpanchal India BroadBand 2 01-09-2010 12:01 AM
Problem viewing TV channels on PC Antrix Monitor & Video Cards 5 10-04-2009 11:11 AM
Problem while viewing DVD Asuman Hardware Peripherals 3 03-03-2009 11:28 AM
problem with viewing Flash videos Derwin Customize Desktop 3 13-01-2009 02:40 PM


All times are GMT +5.5. The time now is 02:25 AM.