| Author |
 Topic  |
|
|
alex042
Average Member
USA
631 Posts |
 Posted - 20 May 2002 : 13:01:46
|
Is there a preferred connection type? I've assumed the preferred method is through a DSN based on what my hosting provider has stated, but have heard otherwise from posts from other Snitz members. My hosting reseller states the following in their FAQs:
quote:
Can I use a DSN-less connection?
Yes you can, however we do not provide support for DSN-less connections and highly recommend using a DSN for added security and stability. if you chose a DSN-less connection, you will severely limit the number of concurrent users your database can handle and it will affect the overall performance. If you have problems with your DSN-less connection, we will not be able to assist you.
What exactly are the pros and con's of the various connection methods? i.e. OLE path vs Virtual path (MapPath) vs DSN .. Access vs MS SQL, etc. I have some ideas, but would like clarification and opinions.
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 May 2002 : 13:26:31
|
Just a quick answer:
For what I've seen here and know about the nature of drivers, that statement by your provider does not make sense (at least now).
I could say OLEDB providers are faster and more robust than ODBC drivers (and DSNs use ODBC drivers). I've also verified that OLEDB providers can actually handle more users than ODBC ones.
The reasoning that DSN connections are more secure can only apply to Access DB's, since without a DSN you need to specificy the path to the database. Well that can be easily overcome if you place the DB in a folder that cannot be reached from the Web (which is what I would strongly recommend). And even if you don't do that the only way someone would get to your ASP script source to get the path to your DB would be a server hack, since IIS won't allow the download of an ASP script. But, hey, if your server got hacked I don't think the DSN would help that much in protecting your DB.
I think there was a time when OLEDB drivers were more unstable than ODBC ones. I don't think that's the case anymore. I would always favor OLEDB versus ODBC (and thus DSN).
This applies to Access and SQL Server.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
| |
Topic |
|
|
|
Topic Locked
