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 |
|
NiallC
Starting Member
2 Posts |
 Posted - 2014-01-16 : 11:40:39
|
| Hi all, this is my first time posting.We have an old application which populates a SQL server 6.5 database. I need to access this database from another computer. I am trying to create an ODBC connection to the instance of SQL 6.5. The computer 6.5 is on is Windows 2000 professional and is not a member of the domain.I have tried to make ODBC connection from window 7, XP and server 2003 computers.I had limited success by mapping a drive to the target machine and entering login details. Then creating the ODBC. On the first attempt I could create the OBDC and see the databases. After a short time the connection failed. This happened on a 2003 server also.Since then I have not been able to create the ODBC connection.I can ping the computer by hostname and IP address. The computer is also in the same IP range as the other computers.I have searched for the last two weeks for an answer and I have got nowhere. Any advise would be welcome.RegardsNiall |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-01-16 : 12:52:37
|
| This is a database driver issue. You are going to need to use an old driver as the newer drivers almost certainly do not support SQL Server 6.5. I haven't touched 6.5 in about 14 years!Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
NiallC
Starting Member
2 Posts |
Posted - 2014-01-17 : 05:54:11
|
| Hi TaraThank you for your reply.I though as much regarding drivers.Does anyone have a link from where I can download a compatible driver.I know how old Sql server 6.5 is but I still need to connect to it. RegardsNiall |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Creating ODBC to Slq Server 6.5