SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Creating ODBC to Slq Server 6.5
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

NiallC
Starting Member

Ireland
2 Posts

Posted - 01/16/2014 :  11:40:39  Show Profile  Reply with Quote
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.

Regards
Niall

tkizer
Almighty SQL Goddess

USA
36625 Posts

Posted - 01/16/2014 :  12:52:37  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

NiallC
Starting Member

Ireland
2 Posts

Posted - 01/17/2014 :  05:54:11  Show Profile  Reply with Quote
Hi Tara

Thank 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.

Regards
Niall
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36625 Posts

Posted - 01/17/2014 :  12:55:45  Show Profile  Visit tkizer's Homepage  Reply with Quote
Try JDBC 3.0 or ODBC 2.5.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000