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

java_roshan · Jul 7th, 2006, 10:24 AM

If you create a blank database, in MS-access, you can issue SQL commands to create tables. i.e.
1. Create a blank database with no tables

2. Create an ASP file, including the connection code, and write create table statements. Include a subroutine to check for errors, that might creep up, if any. (make use of err.Number, err.Description, to simplify your work)

3. Use Response.Write statements, if there are no errors, to display, "Successfully created a table"

and yes, use Mozilla Firefox

paulchwd · Sep 29th, 2006, 3:25 PM

thanks.. wil try

java_roshan · Oct 1st, 2006, 9:09 AM

Quote:

Originally Posted by paulchwd

thanks.. wil try

Almost two months later, this thread is evoked!
I hope, my reply helps.

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

Jul 7th, 2006, 10:24 AM	#2
java_roshan Professional Programmer Join Date: Mar 2005 Location: Student of University of Mumbai, Maharashtra State, India Posts: 344 Rep Power: 4	If you create a blank database, in MS-access, you can issue SQL commands to create tables. i.e. 1. Create a blank database with no tables 2. Create an ASP file, including the connection code, and write create table statements. Include a subroutine to check for errors, that might creep up, if any. (make use of err.Number, err.Description, to simplify your work) 3. Use Response.Write statements, if there are no errors, to display, "Successfully created a table" and yes, use Mozilla Firefox __________________ Visit: http://www.somaiya.edu

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

Sep 29th, 2006, 3:25 PM	#3
paulchwd Hobbyist Programmer Join Date: Mar 2005 Posts: 139 Rep Power: 4	thanks.. wil try

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

Programming Forums > Web Development and Design > ASP

SQL and ASP