DSN creation

• • Reply

  14 years ago

  by Dragono

  stephen olsen

  , United Kingdom

  Joined 14 years ago

  I am using Dreamweaver MX 2004 to create ASP web pages that communicate with a database.

  All I want to do is save names etc and create a search page.

  I need to get a system DSN set up pointing to my database to utilise MX2004 to it's full.

  I am currently with 1 & 1 and having so success with them.

  Can anyone recommend another host or a solution.

  Report abuse
• • Reply

  14 years ago

  by brin351

  brin351

  , Australia

  Joined 15 years ago

  You can use a "DSN Less" connection - it is simply a "connection string" to the database that goes in your code, no need to set up DSN on the server, dreamweaver also allows you to do this. Depending on what database your using they vary - being for asp I presume sqlServer or Access - I've put a sample below.

  Regards

  Brin

  Access
  Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\someFolder\THE Full Path TO myDB.mdb file"
  
  sqlServer
  
  Server=yourSQLserverName;Database=yourDBname;Uid=yourUsername;Pwd=yourPassword;
  
  
  

  Report abuse
• • Reply

  14 years ago

  by Kassem

  Kassem Baalbaki

  Riyadh, Saudi Arabia

  Joined 14 years ago

  Hi,

  To create a DSN check my post http://www.developerfusion.co.uk/forums/thread/148678/.

  Hope this works for you.

  Report abuse