SQL7 And SQL2000

I am currently using asp and sql 2000. I have moved my database to another server that supports only sql7. I only have simple tables. The issue is how different the two are and do I need to change the way I connect to the database in terms of syntax?

View Replies


ADVERTISEMENT

Sql2000 Connection

What is the best connection to make with an sql2000 server?

View Replies View Related

Securing SQL2000 Connection Strings

Looking for a way to secure string. Have connect.asp page as an include file, but want to still use dsn-less connection and not have this in an asp page. Though about putting this in the global.asa file. Don't want to create a DSN and give IUSR_ rights to SQL DB.

View Replies View Related

Trap Primary Key Error (ASP, SP And SQL2000)

I have a table in SQL 2000 with a composite Primary Key on coulumns Instrument_ID (int) and WeekOf (smalldatetime.) I am running asp on win 2003. Code:

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved