ASP link to sql database
Posted on 2013-07-01
I'm new at ASP and just trying to hack at making some changes out of curiosity.
I have a ASP website that is referencing an access database. I converted the access database to a SQL database. I am trying to change my the link in my config page to connect to the SQL database. The SQL database is local.
AT the moment I have the following in my config.asp:
const DATABASE_FILE_PATH = "./db/NFL.mdb"
How can I change it so it points to my SQL database? The SQL database is called MyNFLPicks.
Any help would be appreciated.