January 8, 2007 at 9:02 am
I have VB app which is on a machine running SQL Server 7.0. This VB App is not able to make a connection to another server which is running SQL Server 2000. Can anyone please help me with this issue and guide me.
Thanks
January 9, 2007 at 12:27 am
update your MDAC to at least 2.6. Best is to use the latest version.
http://msdn.microsoft.com/data/Default.aspx
http://msdn.microsoft.com/data/ref/mdac/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 9, 2007 at 5:40 am
As stated, you can update the MDAC on your SQL 7.0 machine to MDAC 2.6 or you could create an alias for your SQL 2000 instance on your SQL 7.0 machine. For more information about aliases, refer to this KB article: http://support.microsoft.com/kb/265808/en-us
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply