|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
An unidentifed error has occurred- trying to connect to SQL sever
Hi
I’m following this tutorial that shows how to build a poll using PHP and MySQL but the database application I’m using is SQL server 2005. I’ve created the DB and the tables and everything, so basically the SQL part is done. Now comes the connection between Dreamweaver and SQL server and what the tutorial says: - connect to database: The database panel click ‘+’ and select ‘MySQL’ in dialog box that opens complete the connection information for database server and the database connection for your website. - create the recordset: to create the recordset click on the ‘+’ in the ‘Bindings’ panel and select ‘Recordset’ dialog will open. The recordset that we need to create will cross two tables however, so we will need to switch to the ‘Advanced Recordset’ dialog to do so. - getting advanced: type the following into the SQL box: SELECT tblQuestions.questionID, questionText, answerID, answerText FROM tblQuestions, tblAnswers WHERE tblQuestions.questionID = tblAnswers.answerID AND tblQuestions.questionID = 1 You will see the answers within questionID and questionText - use recordset: your recordset should now appear in the ‘Bindings’ panel, expand it to see the fields. We can now place the question onto the page by dragging ‘ questionText’ from the ‘Bindings’ panel to the location on the page where we want to display it. A placeholder ‘rsPoll.questionText’ displays in the location. I’ve followed al the steps but when I click in the ‘Bindings’ panel to expand it to see the fields of the tables it generates an error: DataSources An unidentifed error has occurred. What’s the error how I can solve this problem? |
|
#2
|
||||
|
||||
|
you might benefit more by visiting php.net, finding info on connecting to mssql databases, and just writing/copying the code yourself. Dreamweaver uses about 1200% more code than is needed to accomplish a simple task. Making changes to the code created in dreamweaver is nearly impossible.
__________________
If you found a post of mine helpful, please click on the on my post to add to my reputation.
|
|
#3
|
|||
|
|||
|
Try www.w3schools.com .
__________________
[Video] 7 Devastating Effects of Oil Depletion Why Beautiful Young Women Can't Marry Rich and Powerful Men Your Birthday Cake Sucks! For more interesting reads, visit IcyBlog. |
![]() |
| Viewing: ASP Free Forums > Other > Programming Help > An unidentifed error has occurred- trying to connect to SQL sever |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|