| Author |
 Topic  |
|
|
Justntyme
Starting Member
USA
5 Posts |
 Posted - 04 July 2001 : 16:20:11
|
Is this forum designed for DSN or DSNLess? If is it designed for DSN, how can I change it to DSNLess?
Many thanks.
|
|
|
RDoGG™
Junior Member
USA
329 Posts |
Posted - 04 July 2001 : 16:25:20
|
quote:
Is this forum designed for DSN or DSNLess? If is it designed for DSN, how can I change it to DSNLess?
Many thanks.
this forum is designed for non-dsn
snitz forums supports access, mysql, and sql server
RDoGG™ |
 |
|
|
Justntyme
Starting Member
USA
5 Posts |
Posted - 04 July 2001 : 16:53:26
|
My thanks RDoGG
|
|
|
|
RDoGG™
Junior Member
USA
329 Posts |
Posted - 04 July 2001 : 16:56:01
|
quote:
My thanks RDoGG
no problem and you're welcome.
RDoGG™ |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 04 July 2001 : 23:05:44
|
quote:
this forum is designed for non-dsn
Actually, the forum code doesn't care if you use a DSN or DSNless connection. The examples in the config.asp file show DSNless strings, but you can set your connection string to sConn = "DSN=name" or just sConn = "name" where name is the system DSN name.
======
Doug G
====== |
|
|
|
bjlt
Senior Member
1144 Posts |
Posted - 04 July 2001 : 23:53:24
|
if we can use both, which is better? I heard dnsless is more efficient, is it right?
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 05 July 2001 : 00:11:05
|
It's faster than a DSN connection, yes.
- David |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 05 July 2001 : 11:33:46
|
DSNless offers somewhat increased performance, and you can set it up yourself without needing access to the host. DSN's provide additional security, in that none of the connection details like username or password are visible in your asp code.
I don't have any hard numbers on performance differences, I suspect performance gains with DSNless are incremental, not substantial.
======
Doug G
====== |
|
|
|
tomw
Starting Member
USA
20 Posts |
Posted - 05 July 2001 : 15:24:40
|
Just to add my two cents and give back a little, I understand that using the: "OLEDB" connect string "strConnString= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=?:????????? "
is best for speed and reliablity. It is one of the defaults in the base code.
Regards
Tom |
|
|
| |
Topic |
|
Topic Locked
