• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • Last Modified:

ASP.net site without DSN

Hi
I have been given a new piece of work by a client who stated:
"Our host only supports DSN-less OBDC connections, so we need to get the site converted to a DSN-less connection"
Is the foolowing connection string in line with this
   <add name="MyCon" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|GC.accdb;"  />
0
Murray Brown
Asked:
Murray Brown
1 Solution
 
pritamduttCommented:
Yeah that would qualify to be DSN Less Connection String.

More samples of DSN Less Connection String for access database

Standard security
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;

Open in new window


With database password
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;

Open in new window


Incase you wish to use ODBC Driver but not create a ODBC DSN following is an example

Microsoft Access accdb ODBC Driver
Standard Security
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;Uid=Admin;Pwd=;

Open in new window


Workgroup
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;SystemDB=C:\mydatabase.mdw;

Open in new window


Exclusive
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;Exclusive=1;Uid=admin;Pwd=;

Open in new window


Enable admin statements
To enable certain programatically admin functions such as CREATE USER, CREATE GROUP, ADD USER, GRANT, REVOKE and DEFAULTS (when making CREATE TABLE statements) use this connection string.
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;Uid=Admin;Pwd=;ExtendedAnsiSQL=1;

Open in new window


Read more @ http://www.connectionstrings.com/access-2007
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now