Delphi MSSQL Problem

Please discuss general Delphi programming topics here.

Delphi MSSQL Problem

Postby wpsd.forum » September 2nd, 2010, 3:24 am

Hi all I'm new here

Is there a difference in Delphi programming to connect MSSQL 2000 and MSSQL 2005
My software using a register settings ( connection string element such as user pass and sql server "dsn" ), and I have two mssql server in two server
one is already working the other one is for upgrade.

I 100% backup the one in 2000 and restore it to 2005 checking all the table and function and trigger is all working in the new 2005

But when i change the register settings to point to the new mssql 2005 it can't connect. why ?
I check using the "udl" method it can connect flawlessly without problem, then i create a small program to connect ( not in delphi though ) to both of the database no problem at all.

Is there a difference ?
wpsd.forum
Member
Member
 
Posts: 1
Joined: September 2nd, 2010, 3:17 am

Re: Delphi MSSQL Problem

Postby Kambiz » September 18th, 2010, 4:04 pm

MS SQL 2000 is not forward compatible with MS SQL 2005. I think you need the proper SQL Native Client for each version of MS SQL Server.
Kambiz
User avatar
Kambiz
Administrator
Administrator
 
Posts: 2421
Joined: March 7th, 2003, 7:10 pm


Return to Delphi Programming

Who is online

Users browsing this forum: No registered users and 1 guest

cron