Online Calendar

Networking/Security Forums -> Databases

Author: NETworkER PostPosted: Mon Apr 02, 2007 8:11 pm    Post subject: Online Calendar
    ----
I've had some experience building an online calendar w/ Myphp writing to a MySQL database displaying on a website. The php scripts were placed obviously in the html code, with login and username capabilities writing to a prepared MySQL dbase. All changes/updates made online by a user were saved and it was fairly useful.

My question, because I haven't found anything similar, is how do I go about creating a calendar to use with MS SQL, what script is recommended, because I don't, or can't use Myphp or is there any freeware available someone could recommend?

Thanks.

Author: GroovicusLocation: Centerville, South Dakota PostPosted: Mon Apr 02, 2007 9:56 pm    Post subject:
    ----
Are you trying to create another web based calendar for "production" use, or just create something for yourself ( a free standing application)? Interacting with MySql is not terribly difficult. But when you are talking about scripts, are you talking about .sql scripts, or something else?

Author: carlokie PostPosted: Wed Apr 04, 2007 10:39 am    Post subject:
    ----
Are you asking how to connect to a MSSQL?

Try using ADO connection string (example taken from ASP):

( This uses integrated NT security though - you will need SQL security)

set myconn = server.createobject("adodb.connection")

connection = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=@DATABASENAME;Data Source=@SOURCESERVER"

myconn.open (connection)

sql = "select * from table"

set result = myconn.execute(sql)

while not result.EOF

response.write(result(col_name) )

result.movenext()
wend

Something like the above mentioned .....



Networking/Security Forums -> Databases


output generated using printer-friendly topic mod, All times are GMT + 2 Hours

Page 1 of 1

Powered by phpBB 2.0.x © 2001 phpBB Group