I really want to complete lesson 3 of UD Training From The Source, but I am on a mac. Being a newbie at this I think I am running into problems because I can't insert the DSN drop down menu. It mentions to type the exact name of the DSN as it was originally created on the Windows server, that name is
"andescoffe". In Appendix B in the back of the book it mentions how to set up the server, it also mentions how to set it up in the beginning of the book as well. But being that the server is remote
I don't have a clue on how to set up the DNS.

I believe my remote server is Windows 2000 plus IIS. I am trying to define a site using ASP which the server is compatable with. Then I am to define a databse connection using ASP. I go to "Modify" then "Connections" The connections dialog box appears,I click new and select "Data Source Name" from the drop down list. In the book, it also mentions that i am to have the product_details.asp web page open.

The Data Source name dialog box appears. I type in connAndes in the connection name text field. Then the book mentions that I will see all the DNS's on my system which I don't because I am on a mac. There is a TIP at bottom of the picture of all the DNS names and it states:
"On the mac, you cannot use the DSN drop down menu. Instead, type into the text field the exact name of the DSN as originally created on the Windows server". So I typed in (on my mac) "andescoffee". I click "Test" and that didn't work.

Then on Page 33, it mentions that I should of made a "data connection".
Then "Add A Recordset To A Page", I do that and then I click on the "Advanced tab" I give the recordset a name, I select connAndes and then <b>I am supposed to CLICK THE TABLES FOLDER IN THE DATABASE ITEMS LIST. I AM SUPPOSED TO HIGHLIGHT THE PRODUCTS DATA TABLE, BUT THERE ARN'T ANY ITEMS IN THE FOLDERS OF "TABLES", "VIEWS" AND "STORED PROCEDURES", (YOU CAN SPOT THESE FOLDERS WITH THE STUFF THAT SHOULD BE THERE ON PAGE 36 OF MACROMEDIA ULTRA DEV 4 TRAINING FROM THE SOURCE). BUT ON MY MAC THESE FOLDER JUST HAVE THE WORD "NONE" UNDER "TABLES", "VIEWS" AND "STORED PRCEDURES".</b>

So I really can't go on with the lesson.
If any of you Ultra Dev 4 guru's would give me some pointers I sure would appreciated it.

thanks for any help

/tiles

I am not entierly familiar with Ultradev on a Mac but I'll have a stab at solving it from what I know.

The reason why you can't see the database tables when you click the + sign is because these tables are dependant on a live DNS connection that Ultradev stores in the Connections folder. For you to see that you need to have a dsn connection to your database. I would really think it would be stupid of Macromedia not to allow a connection across a network for the dsn - for this exact problem.

So, if you are connected to a network/web server - get onto a windows machine and set up your dsn on it. I haven't tried this before but set up your testing server as an FTP server on the windows server. Upload all your files to it. Then try again.

I am not sure so maybe someone else can through a bit of light on this - but maybe you can use the testing server to connect to your database while you work locally.

Have a search on macromedia website or in the help for connecting to database using dsn and a mac. Maybe something will come up.

Sorry I can't be of more help.

Regards

_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2

Thanks much for the post. I have posted to various another group as well but you are the first to reply.
I hardly know much about DNS, but from reading your post I have to set up a DNS connection on the remote server were my web pages are stored. I have two free hosting services which say they are asp compatable, and they are I believe Windows 2000 server with IIS.
But I am really stumped on how to set up a DNS connections. On my end I think I have to go to the Modify menu then go to connections and set up the DNS there. But I havn't a clue on how to set it up on the remote server.

Thanks

/tiles

UD requires its own connection string made by the program to function properly. You can set up a DSN-Less connection using the script below. This allows you to connect to the database without using dsn so to speak. You would need to include this file in every asp page that connects to the database if you take the dsn-less approach.

If you are looking for windows hosting to get you started check out our website. We start at €99 for windows hosting. I'll get a hold of one our designers mac laptop and install UD on it. If I come up with anything else or a proper solution, I will give you a shout.

www.site-manager.com/af.asp?a=11&l=1tds9p6x2&r=windowshosting

I am so proud... this is my 100th post on UDzone.

best of luck

Dave

_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2

To: beano

Thanks for the response. I thought the book would be very clear on how to complete the tutorial. Then as I went to Amazon.com and read so many comments by reviewers that said to stay away from " UD Training From The Source" book because it was not written the way it should. It seems like Ultra Dev 4 "The Complete Reference might be better. It had the best reviews at Amazon.com for UD as far as I've seen
.
I've come to realize that there are very few good books for newbies on web design-development software. One that thrilled me was Lynda.com's Flash 5. I was stunned that her book was so well thought out. It was truly a great step by step aproach leaving no stone unturned.

It would be great to see a well writen book for UD for the Mac. Maybe there is none out there.

As far as getting a new host, I am going to see how far I can go with the free host right now. If they don't have good tec support, maybe I should consider a new host. But I might just buy a better book, one that is written well. Which I realize there are so few of.

I can see how it would be difficult to wirte a good UD book, beacause there are so many options: JSP, ASP, Cold Fusion, whether your dealing with a mac or windows.

The writer just can't cover it all. But being a mac head, I long for the day that more books would be written just for the Mac, plus leaving no stone unturned, a great step by step approach book.
It is very needed in an industry were pub lishers just want to get something out the door in a hurry. I guess the figure if they take too much time on it, by the time the author is finished, a new updated software is out and ready for a new book.

/tiles



Edited by - tiles on 28 May 2002 02:06:45

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
To: beano

Thanks for the response. I thought the book would be very clear on how to complete the tutorial. Then as I went to Amazon.com and read so many comments by reviewers that said to stay away from " UD Training From The Source" book because it was not written the way it should. It seems like Ultra Dev 4 "The Complete Reference might be better. It had the best reviews at Amazon.com for UD as far as I've seen
.
I've come to realize that there are very few good books for newbies on web design-development software. One that thrilled me was Lynda.com's Flash 5. I was stunned that her book was so well thought out. It was truly a great step by step aproach leaving no stone unturned.

It would be great to see a well writen book for UD for the Mac. Maybe there is none out there.

As far as getting a new host, I am going to see how far I can go with the free host right now. If they don't have good tec support, maybe I should consider a new host. But I might just buy a better book, one that is written well. Which I realize there are so few of.

I can see how it would be difficult to wirte a good UD book, beacause there are so many options: JSP, ASP, Cold Fusion, whether your dealing with a mac or windows.

The writer just can't cover it all. But being a mac head, I long for the day that more books would be written just for the Mac, plus leaving no stone unturned, a great step by step approach book.

It is very needed in an industry were pub lishers just want to get something out the door in a hurry. I guess they figure if they take too much time on it, by the time the author is finished, a new updated software is out and ready for a new book.

/tiles



Edited by - tiles on 28 May 2002 02:06:45
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
To: beano

Thanks for the response. I thought the book would be very clear on how to complete the tutorial. Then as I went to Amazon.com and read so many comments by reviewers that said to stay away from " UD Training From The Source" book because it was not written the way it should. It seems like Ultra Dev 4 "The Complete Reference might be better. It had the best reviews at Amazon.com for UD as far as I've seen
.
I've come to realize that there are very few good books for newbies on web design-development software. One that thrilled me was Lynda.com's Flash 5. I was stunned that her book was so well thought out. It was truly a great step by step aproach leaving no stone unturned.

It would be great to see a well writen book for UD for the Mac. Maybe there is none out there.

As far as getting a new host, I am going to see how far I can go with the free host right now. If they don't have good tec support, maybe I should consider a new host. But I might just buy a better book, one that is written well. Which I realize there are so few of.

I can see how it would be difficult to write a good UD book, beacause there are so many options: JSP, ASP, Cold Fusion, whether your dealing with a mac or windows, is it for a newbie or a tec pro.

The writer just can't cover it all. But being a mac head, I long for the day that more books would be written just for the Mac, plus leaving no stone unturned, a great step by step approach book.

It is very needed in an industry were publishers just want to get something out the door in a hurry. I guess they figure if they take too much time on it, by the time the author is finished, a new updated software is out and ready for a new book.

/tiles



Edited by - tiles on 28 May 2002 02:06:45
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>