Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mentor1
Starting Member
2 Posts |
 Posted - 2011-04-14 : 23:51:04
|
| Hi,I am a beginner using ASP and PHP and need some help with a script to get data from a DB. A retired social worker, I create eLearning lessons. These are authored in software that has a pre-configured ASP page that saves the lesson data to an MS SQL DB on the web site where the lesson is uploaded to.For one lesson, I want to create a separate, external Flash SWF that can only be used by students who have registered for the main lesson: so, an ASP (or PHP) page needs to be set up, for the Flash SWF to link to on the web site. The ASP (or PHP) script page would connect with the lesson's MS SQL Server DB, get the registered users names (in an array), and check the name entered in the Flash SWF's input text box to see if it matches a name in the array of registered users from the main lesson's DB.I have been trying to find tutorials, scripts, learning materials to help figure out the ASP (or PHP) script and connection strings (the lesson sends its data to the SQL DB using an OLE DB string), but so far I can not figure out a working script and correct connections. I've tried to adapt sample scripts and test to get one data item (user name), but I must be doing something wrong.Any help would be appreciated.Kind Regards, |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-15 : 08:40:41
|
| Not to run off new talent, but your question is probably better asked in a forum for ASP or PHP. It sounds like you don't have much control over the SQL database. I would assume that the site that hosts would set up the connection strings for the database hooks.Hey, it compiles. |
 |
|
|
mentor1
Starting Member
2 Posts |
Posted - 2011-04-15 : 10:11:24
|
| Hi,I was hoping that someone with SQL Server experience could suggest a basic ASP or PHP script to get a single data item (as a test) from the DB. I've tried many different scripts, connection strings (including the one suggested in the web hosting help files), with no success.Any help appreciated.Kind Regards,mentor1 |
|
|
|
|
|
|
|
|
Get Data from MS SQL Server DB