sivakugan
asked on
Dreamweaver and DSN
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.h tm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_conn_ecom_STRING
MM_conn_ecom_STRING = "dsn=access_ecom;"
%>
-------------------------- ---------- ---------- ---------- ---------- ----------
Thanks
Regards
Kugan
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_
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_conn_ecom_STRING
MM_conn_ecom_STRING = "dsn=access_ecom;"
%>
--------------------------
Thanks
Regards
Kugan
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
but the problem is still here. I'll try my level best now. Hope u will continue to support my question- dodge20.
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
If you have found a good way to fix this, please post comment on my question page.
Thank you
https://www.experts-exchange.com/questions/22996486/DSN-and-Dreamweaver.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.