Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Dreamweaver and DSN

Posted on 2007-12-05
5
Medium Priority
?
816 Views
Last Modified: 2012-05-05
Hi,

Can someone help me?..I'm dying with this problem for a week?

I've got a shared hosting account, which creates a file DSN automatically to access the database.
The problem is, They don't allow to remotely set up the connection. So in the case of Dreamweaver , I can't  remotely connect and select the file DSN to create the connection string file.

so what I've done is , I've created the DSN file locally in same name which my hosting account has and then selected that DSN file to create the connection string file but my asp files are not running with that connection.

I think I need to change path of the DSN file, that causing for the problem.

These are the links about the DSN file. please have a look on it, if it doesn't make sense.

http://help.godaddy.com/article.php?article_id=40&topic_id=

http://help.godaddy.com/article.php?article_id=259&topic_id=

What can I do further?...

This is the connection file the Dreamweaver has created
--------------------------------------------------------------------------
 <%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_conn_ecom_STRING
MM_conn_ecom_STRING = "dsn=access_ecom;"
%>
----------------------------------------------------------------------------



Thanks
Regards
Kugan

Open in new window

0
Comment
Question by:sivakugan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 11

Expert Comment

by:dodge20
ID: 20415386
There wasn't a need to open another question. Just respond to your previous question
http://www.experts-exchange.com/Web_Development/Software/Macromedia_Dreamweaver/Q_22996486.html

Have you tried a dsnless connection? I would suggest using that if you can't get the dsn to work properly.

Here is a tutorial on how to do that
http://www.geekpedia.com/tutorial141_How-to-setup-DSN-Less-Connection-in-Dreamweaver-MX.html

I also posted how to find the path of your mdb in your other post.
0
 

Author Comment

by:sivakugan
ID: 20415563
I can try dsnless connection but I need to make sure that, Is it suitable for E-commerce site?...

Also I've seen ur answer earlier. but it doesn't match to my question.
I've already knew my database path. My actual question is, How do I intergrate the DSN connection in connection string file?.....Because I've use Dreamweaver to generate connection file.
So I need to manually edit the connection file to reference the DSN file, which is in my hosting account.
Does it make sense?....

Thanks
Regards
Kugan
0
 
LVL 11

Accepted Solution

by:
dodge20 earned 1500 total points
ID: 20415721
Did you create a DSN Connection on your local machine? (Sorry, I am still having a hard time understanding what exactly you are asking). Are you trying to access your website database from your local machine?

I would really suggest creating the dsnless connection - It is more reliable, faster, and less confusing.

Also check this link out - it is about godaddy dsn and dreamweaver
http://www.dmxzone.com/forum/topic.asp?topic_id=37048

0
 

Author Comment

by:sivakugan
ID: 20416177
ohhh. Jesus...I'm having the same problem they had.  Thanks for the link dodge..
but the problem is still here. I'll try my level best now. Hope u will continue to support my question- dodge20.
0
 

Expert Comment

by:jtuttle99
ID: 20864940
Have you solved this problem? I have exactly same problem, and can't seem to find right answer.
If you have found a good way to fix this, please post comment on my question page.
Thank you
0

Featured Post

Plesk WordPress Toolkit

Plesk's WordPress Toolkit allows server administrators, resellers and customers to manage their WordPress instances, enabling a variety of development workflows for WordPress admins of all skill levels, from beginners to pros.

See why 2/3 of Plesk servers use it.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question