Differences in ASP code between and Access and SQL Server database

[Scorez2000]

I'm currently upsizing all my access applications onto SQL Server. I was expecting this to be very easy. I thought I could upload my database into SQL Server, change the ODBC and robert's your father's brother.

NOPE!!! There seems to be a fair few errors in my ASP page. I had a quick google but wasn't only able to find a great deal.

Does anyone have any good material on the differences between ASP coding ontop of Access and SQL Server.

Thanks in advance peeps.

 

[onpnt]

Connection Strings and JetSQL convert to T-SQL is the only differences. although there may be unforseen things as vbscript functions for data type conversions that are "If inThere == True" then you need to work with them to suit the data type differences from Jet to T

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think. faq333-3811
Join the Northern Illinois/Southern Wisconsin members in Forum1064