Connect to sql db vbscript in ASP

ismailc2 · #1 (**permalink**) 04-16-09, 11:18

Good day,

Need to connect & retrieve from SQL DB in aspx page using vbscript server side

I have an html page which I want to edit by adding information from a SQL database & display results on and in the html page (code below).

Any code would be great that works in the aspx page where i can just insert the DB connection details & sql statement & display the result on page.

Please Assist

myle · #2 (**permalink**) 04-16-09, 20:52

it can't be done in HTML
HTML is DUM all it does to format and display the DATA

Code:

Dim connstring   'conection string
Dim rs   'recordset name
Dim SQL   'sql
Dim my_Conn
set my_Conn = Server.CreateObject("ADODB.Connection")
set connstring = Server.CreateObject("ADODB.Connection")

connstring.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = #####;User Id =####; Password=######"

if you save as a inc file

at the top of the ASP pages



mine is called opendb.inc and its in the inc folder.

now get the DATA

1st create a record object
Set Rs = Server.CreateObject("ADODB.Recordset")
2 create the SQL
SSQL = ""
SSQL = SSQL & "SELECT [Note to PDF Sum].* FROM [Note to PDF Sum]"
3 open the SQL or table must be sql statment
Rs.Open SSQL, connstring, adOpenKeyset, adLockPessimistic, adCmdText
4 now we can do some thing

do until rs.eof
...
..
..
rs.movenext
loop
rs.close
set rs = nothing

ismailc2 · #3 (**permalink**) 04-18-09, 10:51

Thanks a million for the help, really apprecaite it.

I have been struggling for a while, the ascs page displays the as text but not the results from the query, i thought of a workaround creating a report - with a iframe in the header with not borders & the page look's like one.

Thank You

myle · #4 (**permalink**) 04-19-09, 06:57

yeap that can be done but you must walk before u run
iframe will do the job but that hard once you under stand part1 then play around with part 2 ok.

Internet Services

Web Development

Digital Marketing

Consumer Tech