| Author |
Topic |
|
aeckdahl
Starting Member
2 Posts |
 Posted - 2006-07-12 : 11:17:55
|
| I hope I am posting this question to the right place. I am working with an old product that was built back in the Borland days, and has been upgraded to Visual Studio C++ 6.0. I am currently using mySQL as our database, but we need to change over to SQL Express 2005. Has anyone ever used SQL Express with VS 6.0? If you knew of any documentation I could read that woudl be helpful as well.Thanks! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-07-12 : 12:45:27
|
i guess you can access the db same as with the sql 2000. but don't hold me to it.But bare in mind that VC++ 6.0 is an old programming language that will only complacate things.If you're going with SQL express 2005 then also go with C# 2.0.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-07-12 : 12:49:48
|
| aeckdahl,You can use SQL Server Express fine using VC++ 6 via ADO.spirit1,Going with C# 2.0 only makes sense if two conditions apply:1) You intend to completely rewrite your application.2) You have a business reason to move to .NET.Otherwise, it makes no sense.Ken |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-07-12 : 12:59:13
|
| KenW:i agree complety with that.but then i guess you could use MSDE too...i guess he'd have to tell us what does "upgraded" mean in his case? a rewrite or a "upgrade me wizard."A rewrite in VC++ 6.0 seems unreasonable.Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
aeckdahl
Starting Member
2 Posts |
Posted - 2006-07-12 : 13:11:12
|
| Thanks for the responses. I only recently took over this product, so a rewrite in c# is not an option. As for what I mean by upgraded - all I know is that the product was converted from a borland project to a Visual C++ 6.0 project, and whatever means it took to do that is unkown to me. I was under the impression that SQL Server Express 2005 was an upgrade of MSDE - is it not? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-07-12 : 13:19:57
|
| yes it is, but new functionality can be only used in .netGo with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-07-13 : 01:53:40
|
quote:
Originally posted by spirit1
yes it is, but new functionality can be only used in .net
That is not correct.You can with no problem use VC++ 6 with SQL Express, just as easely as with any previous version of SQL Server. You can take full advantage of all the new T-SQL language features, and be happy that the gorvenor of MSDE is dead.There may or may not be some of the new client features that you can't take advantage of, but that is nothitng to worry about.-- This one's tricky. You have to use calculus and imaginary numbers for this. You know, eleventeen, thirty-twelve and all those. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-07-13 : 06:16:35
|
| my bad.Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
SQL Express in VC++ 6.0?