Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jvrzhao
Starting Member
3 Posts |
 Posted - 2008-06-04 : 03:26:35
|
| Ive got sql server 2005 WG edition running and have an access adp application which connects to it. However since upgrading to sql server 2005 from 2000 the adp project runs a lot slower. However when I install express on a machine and connect the adp project to it which sits on the same machine it runs just fine. We have also rebuild all the indexes for the database but that doesnt fix the problem. Could someone please help... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-04 : 03:44:27
|
| what's adp application? what's it doing? |
 |
|
|
jvrzhao
Starting Member
3 Posts |
Posted - 2008-06-04 : 03:52:27
|
| And adp project is an Access project that provides access to a Microsoft Sql Server database. So all my reports and forms is in Access but my database is on sql server. |
|
|
|
jvrzhao
Starting Member
3 Posts |
Posted - 2008-06-04 : 10:07:02
|
| Some more information, one possible solution that I found on the net is to ensure that I connect to sql native client. I try to do this programatically but it fails to connect to the native client. What could be the reason for this? How can I test my connection to sql native client? Please help... |
|
|
|
|
|
|
performance issues with sql server 2005 and adp