April 4, 2009 at 10:19 pm
I had created a software made of visual basic 6 and i use sql2000. Now i have bought a license sql2008. Is my software still runs on the sql2008? If possible, are there any changes that i should make, please inform me if any. thanks...:-)
April 4, 2009 at 11:59 pm
Hello,
It is quite possible that your VB Application will work with SQL 2008 just as well as it did with 2000. Particularly if you were just using SQL Server for data storage i.e. are the SQL Statements only DML ones (Select, Insert, Update, etc).
May be take a look at this MSDN article:
http://msdn.microsoft.com/en-us/library/ms143532.aspx
Regardless, you will still want to test the Application with SQL 2008 before putting it into production.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
April 5, 2009 at 4:09 pm
of course. depends on what your using to connect to SQL server with though. Im assuming its ado.
http://www.connectionstrings.com
is your friend.
in your vb IDE, you should chose Microsoft Data Access 2.8
But odly lately, i have seen Microsoft Data Access 6.0 Anyone know what thats all about? Thats a big jump
Either way, its best to install the native SQL server 2008 native provider from. http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
I think there is some hotfixes to that link above too =]
April 6, 2009 at 4:38 am
thanx for that idea, do i have to change any of my codes to do that?
April 6, 2009 at 9:32 am
ray_brp (4/6/2009)
thanx for that idea, do i have to change any of my codes to do that?
u will just have to change your connection string to Provider=SQLCLNT10...... bla bla
and in your project references point to the highest version of MDAC
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply