• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Search | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

Online Calendar

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases

View previous topic :: View next topic  
Author Message
NETworkER
Just Arrived
Just Arrived


Joined: 07 Feb 2007
Posts: 0


Offline

PostPosted: Mon Apr 02, 2007 8:11 pm    Post subject: Online Calendar Reply with quote

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.
Back to top
View user's profile Send private message
Groovicus
Trusted SF Member
Trusted SF Member


Joined: 19 May 2004
Posts: 9
Location: Centerville, South Dakota

Offline

PostPosted: Mon Apr 02, 2007 9:56 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message Visit poster's website
carlokie
Just Arrived
Just Arrived


Joined: 27 Mar 2007
Posts: 0


Offline

PostPosted: Wed Apr 04, 2007 10:39 am    Post subject: Reply with quote

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 .....
Back to top
View user's profile Send private message
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases All times are GMT + 2 Hours
Page 1 of 1


 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Community Area

Log in | Register