Programming Forums - View Single Post

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