ASP Classic Lessons #6 - Creating Connection to a SQL Server Database
6,704 views (571 Site Views) ~ Last Updated on June 14, 2014
In this lesson, we are going to look at creating the connection string within ASP Classic, to connection to, two SQL Servers.
One SQL Server is our inhouse server, and the other, is our Hosting Providers Server.
However, some of the details are blanked out, everything is detailed and expained so that anyone can follow along.
We will also write code that is needed to check to make sure that a connection with the database was indeed made.
Thank You
Wayne Barron
Dark Effects Production
https://www.facebook.com/darkeffectstv ( Like Us On Facebook )
Spotlight on Dark Effects
http://www.youtube.com/DESpotlight
Follow us on Twitter
https://twitter.com/DarkEffectsTV
http://www.darkeffects.net
http://www.darkeffects.com
http://www.enterview.org/Dark_Effects_Production
Tags
Microsoft SQL Server (Database Management System),Database (File Format Genre),Active Server Pages (Software),SQL (Programming Language),Hypertext Transfer Protocol (Internet Protocol),SQL Server,SQL Server 2005,ASP Classic and SQL Server,Create a Connection string to SQL Server,Create A connection string to SQL Server with ASP Classic,Create for connection string to SQL Server with ASP Classic,asp classic check if connection is made to sql server
6,704 views (571 Site Views) ~ Last Updated on June 14, 2014
In this lesson, we are going to look at creating the connection string within ASP Classic, to connection to, two SQL Servers.
One SQL Server is our inhouse server, and the other, is our Hosting Providers Server.
However, some of the details are blanked out, everything is detailed and expained so that anyone can follow along.
We will also write code that is needed to check to make sure that a connection with the database was indeed made.
Thank You
Wayne Barron
Dark Effects Production
https://www.facebook.com/darkeffectstv ( Like Us On Facebook )
Spotlight on Dark Effects
http://www.youtube.com/DESpotlight
Follow us on Twitter
https://twitter.com/DarkEffectsTV
http://www.darkeffects.net
http://www.darkeffects.com
http://www.enterview.org/Dark_Effects_Production
Tags
Microsoft SQL Server (Database Management System),Database (File Format Genre),Active Server Pages (Software),SQL (Programming Language),Hypertext Transfer Protocol (Internet Protocol),SQL Server,SQL Server 2005,ASP Classic and SQL Server,Create a Connection string to SQL Server,Create A connection string to SQL Server with ASP Classic,Create for connection string to SQL Server with ASP Classic,asp classic check if connection is made to sql server
-
Intro to ASP Classic Website Development Lessons
2,646 views
514 Site Views -
Introduction to ASP Classic Lessons
4,244 views
466 Site Views -
Lesson 1 - ASP Classic - Learning how to Create Variables and doing Response.write
1,289 views
475 Site Views -
Lesson 2 - ASP Classic - Submitting Form and Process it
702 views
584 Site Views -
Lesson 3 - ASP Classic - Submitting multiple Form fields and see if they contain content
923 views
502 Site Views -
ASP Classic Lessons #4 - Ad Rotation System (Part 1)
552 views
471 Site Views -
ASP Classic Lessons #5 - Ad Rotation System (Part 2)
348 views
489 Site Views -
ASP Classic Lessons #6 - Creating Connection to a SQL Server Database
6,704 views
571 Site Views -
ASP Classic Lessons #7 - Error 800a0bcd BOF or EOF
1,640 views
479 Site Views -
ASP Classic Lessons #8 - Error 800a0409 Unterminated string constant
1,220 views
682 Site Views -
ASP Classic Lessons #9 - Troubleshooting Techniques (#1)
2,427 views
554 Site Views -
ASP Classic Lessons #10 - Troubleshooting #2 (Invalid Object Name)
1,801 views
506 Site Views -
ASP Classic Lesson #1 (Creating Forms and Submission page)
12,700 views
472 Site Views -
ASP Classic Lesson #2 (Creating Access And SQL Server Database)
9,246 views
694 Site Views -
ASP Classic Lesson #3 (Updating record, selecting records)
3,919 views
464 Site Views -
ASP Classic Lesson #4 (Admin Users, Delete Records)
2,285 views
515 Site Views