Programming Forums > Web Development and Design > ASP

paulchwd · Jul 7th, 2006, 10:18 AM

Hi,

Question...in asp you have to (as far as I no) state the location of the database you are going to use...before you start running sql commands through it....

What if i want to use sql (**note i mean the language sql no tthe server**) to create the table (create table statments) how do i do that

(Toggle Plain Text)

path=server.mapPath("customer.mdb")

set adocon = server.createobject("ADODB.Connection")
adocon.Provider="Microsoft.Jet.OLEDB.4.0"
adocon.Open=  path

in short i do not want to create my tables physically in access, I want to use sql (the language not the server) to create my tables

thanks

Jul 7th, 2006, 10:18 AM	#1
paulchwd Hobbyist Programmer Join Date: Mar 2005 Posts: 139 Rep Power: 4	SQL and ASP Hi, Question...in asp you have to (as far as I no) state the location of the database you are going to use...before you start running sql commands through it.... What if i want to use sql (note i mean the language sql no tthe server) to create the table (create table statments) how do i do that (Toggle Plain Text) path=server.mapPath("customer.mdb") set adocon = server.createobject("ADODB.Connection") adocon.Provider="Microsoft.Jet.OLEDB.4.0" adocon.Open= path path=server.mapPath("customer.mdb") set adocon = server.createobject("ADODB.Connection") adocon.Provider="Microsoft.Jet.OLEDB.4.0" adocon.Open= path in short i do not want to create my tables physically in access, I want to use sql (the language not the server) to create my tables thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > ASP

SQL and ASP