Jump to content

Basic Sql Connection


Recommended Posts

I'm pulling information out from Exchange using powershell and posting this information to HTML pages with CSS. Now csv'ing the data out and BULK INSERTING into SQL tables (not access) Next, figuring out how to1. connect a basic web page using (?ADO?) to these tables2. query data out of the tables to the web page3. create basic forms to pull decision based queries out I'm stuck on just basically connecting to a SQL db from a web page. ADO on w3schools shows how to connect to an odbc source/access, but how can I do this for SQL please? <%set conn=Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open "c:/webdata/northwind.mdb"%> TIA

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...