DSN Connection with Go Daddy Account

[Brachole]

Can anyone help me with creating a DSN in Dreamweaver for a Go Daddy Account? The DSN is already created on Go Daddy, which is named access_DataSource.dsn and is located in a folder called _dsn.

I also have an Access DB named DataSource.mdb located in a folder called access_db. These 2 locations are required by Go Daddy.

I have always created DSN before with other hosting companies, but Go Daddy is different I guess...

Here's my connection.asp page:

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_ESDCheckDatasource_STRING
MM_ESDCheckDatasource_STRING = "dsn=access_DataSource;"
%>

It used to work with a different hosting company, but now I'm not sure what to do different here...

Thank you!

[bregent]

What are the symptoms when you try to connect?

[Brachole]

I've always used Web.com for my hosting provider. They let me choose my DSN name and select a database, which makes it easy. But Go Daddy, as soon as you upload your Access DB to they server, they create the DSN for you.

When I go in Dreamweaver to create my Database > Data Source Name (DSN), I select the option to Use DSN on testing server. When I click on the "DSN" button, it doesn't find anything...

I read some other posts online and looks like Go Daddy uses an unusual way of creating DSN...

[David_Powers]

Thread moved to the Dreamweaver Application Development forum.

[bregent]

Can you try with a dsn-less connection to make sure that it is not a database problem?

[davo33]

I'm having the very same problem, except using javascript and ASP.
My program works on my own server, but then when I try to use DW to create a connection using my GoDaddy DSN, it does not work. I've tried various permuatations of string.What is the secret to using a GoDaddy DSN to work in ASP, especially Javascript?