| View previous topic :: View next topic |
| Author |
Message |
Marina Davydova
Guest
|
 Posted: Thu Apr 01, 2004 8:29 pm Post subject: Can Delphi 5.0 connect to MS SQL 2000 |
 |
|
Hello,
we have Delphi 5 application that connects to MS SQL 6.5 by BDE.
The plan is to upgrade DB to MS SQL 2000.
Do you know if Delphi 5 will handle it?
If yes - what areas will require attention
Thank you very much in advance
|
|
| Back to top |
|
 |
Aage Johansen
Guest
|
| Posted: Thu Apr 01, 2004 8:50 pm Post subject: Re: Can Delphi 5.0 connect to MS SQL 2000 |
|
|
On 1 Apr 2004 12:29:27 -0800, Marina Davydova wrote:
| Quote: | Hello, we have Delphi 5 application that connects to MS SQL 6.5 by BDE.
The plan is to upgrade DB to MS SQL 2000.
Do you know if Delphi 5 will handle it?
If yes - what areas will require attention
|
I think Delphi/5 will. However, the BDE will eventually cause grief as new
functionality in MSSQL2k isn't suported.
--
Aage J.
|
|
| Back to top |
|
|
Del Murray
Guest
|
| Posted: Thu Apr 01, 2004 9:19 pm Post subject: Re: Can Delphi 5.0 connect to MS SQL 2000 |
|
|
If possible, switch everything to use ADO. If you have D5Enterrpise you own
it, else you will have to get a copy for your version.
|
|
| Back to top |
|
|
J. M. De Moor
Guest
|
| Posted: Fri Apr 02, 2004 8:44 pm Post subject: Re: Can Delphi 5.0 connect to MS SQL 2000 |
|
|
| Quote: |
I think Delphi/5 will. However, the BDE will eventually cause grief as
new
functionality in MSSQL2k isn't suported.
|
Yup. If you can afford to get off of BDE, do it. I have one remaining BDE
app and the reason it works well with MS SQL2K is that almost all the SQL is
in stored procedures and views. So the engine handles everything before BDE
gets a chance to mangle it.
Anyway, the main thing you have to watch out for when upgrading is that the
";1" in TStoredProc.StoredProcName property does not work when you move out
of version 6.5. So you will have to remove them if you use them.
Joe
|
|
| Back to top |
|
|
Andrey Zubik
Guest
|
| Posted: Fri May 28, 2004 5:46 pm Post subject: Re: Can Delphi 5.0 connect to MS SQL 2000 |
|
|
| Quote: | Hello,
we have Delphi 5 application that connects to MS SQL 6.5 by BDE.
The plan is to upgrade DB to MS SQL 2000.
Do you know if Delphi 5 will handle it?
If yes - what areas will require attention
Thank you very much in advance
|
Hello,
you can try to use ODBC DAC v.1.3.0 from http://softvector.com
--
Best wishes,
Andrey Zubik
e-mail: [email]andrey.zubik (AT) softvector (DOT) com[/email]
http://www.softvector.com
|
|
| Back to top |
|
|
Craig Stuntz [TeamB]
Guest
|
| Posted: Fri May 28, 2004 6:57 pm Post subject: Re: Can Delphi 5.0 connect to MS SQL 2000 |
|
|
Andrey Zubik wrote:
| Quote: | you can try to use ODBC DAC v.1.3.0
|
I cancelled five messages like this. This is spamming, and it's
against the rules, which you should read here:
http://info.borland.com/newsgroups/guide.html
Please note that the thirdparty groups are the *only* place where you
can advertise your products.
-Craig
--
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Performance Monitor -- Analyze and control your IB7
server: http://delphi.weblogs.com/IBPerformanceMonitor
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
