Go Daddy Access or MSSQL Connection Strings

[Guest]

I've created many many connection strings over the past 10 years, all different platforms and databases. But I'm stumped.

How the heck do you create a connection string for ASP in a GoDaddy account. I've tried both Access and MSSQL. I've create the DSN entries in the GoDaddy admin tool.

I can't get it to work. I've tried, Server Maps, DSN entries, etc. I've look at their help. I just can't get it to work. No way, no how.

If anyone can paste an example of their connection string, it would be very helpful. Thanks.

Below are two examples of what I've tried recently.

"Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath ("/access_db/XYZ.mdb")

"Driver={SQL Server};SERVER=" & p3swhsql-v16.shr.phx3.secureserver.net & ";DATABASE=" &
XYZ & ";UID=" & XYZ & ";PWD=" XYZ

[Newsgroup_User]

> If anyone can paste an example of their connection string, it would be
> very
> helpful. Thanks.
>
> Below are two examples of what I've tried recently.
>
> "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath
> ("/access_db/XYZ.mdb")
>
> "Driver={SQL Server};SERVER=" & p3swhsql-v16.shr.phx3.secureserver.net &
> ";DATABASE=" &
> XYZ & ";UID=" & XYZ & ";PWD=" XYZ



ODBC is deprecated. Try a OLEDB connection instead:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\path\to\database.mdb;

Or for SQL:
Provider=sqloledb;Data Source=server_address;Initial
Catalog=database_Name;UID=?;PWD=?

[Newsgroup_User]

Here is mine

MM_cs_demos_STRING = "Driver={SQL
Server};Server=whsql-v16.prod.mesa1.secureserver.net;Database=DB_Deni;Ui
d=Demoeddb;Pwd=mypsswrd;"

You need the server name, db name, user name, and password

> ODBC is deprecated. Try a OLEDB connection instead:
> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\path\to\database.mdb;
>
> Or for SQL:
> Provider=sqloledb;Data Source=server_address;Initial
> Catalog=database_Name;UID=?;PWD=?



--