VB5 and SQLServer 1

[techshoot]

I have an app written in VB5 that uses Access 97 and would like to convert it to SQLServer. Are there any restrictions on SQLServer versions as there are in Access version? As far as I know, I cannot do Access XP with VB5 code.

Thanks
Dave Kaylor

http://www.ktech-usa.com

 

[Elysium]

Do you mean that you cannot get into an Access XP db with VB5?

 

[techshoot]

The original code was written for Access 97 back when VB5 was new. Company is changing to Access XP and the existing code doesn't interface to a native XP database. SQLServer is now available and due to the number of transactions the current database is up to, the decision was made to move it to the SQLServer. While there are currently only 5 users to the database, three are automated and we are seeing 500 transaction every 8 hours or 1,000 a day.

http://www.ktech-usa.com

 

[vb5prgrmr]

Best bet is to use SQL 7.0 or greater. If you are using DAO then you will have to adjust your code to use ADO or RDO. If you are using the DAO data control then the same will need to be done. Also if you have queries that use the "Like" in your Syntax then you will have to go through and change the "*" to "%" for accessing the data.

Good Luck

 

[vb5prgrmr]

That is from...

Select * from your_table where your_field like *your_expression*

To

Select * from your_table where your_field like %your_expression%

 

[techshoot]

It is written in DAO but I planned on changing it to ADO anyway. There are no "Like" statements, only general Select and som "Inner Join". There really isn't many statements that need to be changed so conversion to ADO should be fairly easy.

Thanks

http://www.ktech-usa.com