|
 |
asp_databases thread: Access 97 vs 2000 for a DSN
Message #1 by shrij@v... on Tue, 28 Nov 2000 16:40:42 -0500 (GMT)
|
|
Hi
I am using DSN to connect to the database
On my test server I m using Access 97
On my deployment server I want to use Access 2000
will it be a problem ?
DSN will be configured properly
Secondly, can I use Connection String in place of DSNs with sole purpose of avoiding DSN setup charges, in short, does using
connection strings require some additional charges ? (a bit off topic but of some interest :))
Thanks in advance
Regds
Shree
Message #2 by Stephane_Dattenny@D... on Tue, 28 Nov 2000 06:38:17 -0600
|
|
Hi
For the second question...
If you are using ADO for data access, instead of using ODBC DSN, you could
use OLEDB for Microsoft Jet 4.0 (MS Access 2000 only)
The connection string is like this:
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<path to .mdb
file>;User ID=" & chr(34) & strUserName & chr(34) & ";Password=" & chr(34) &
strPassword & chr(34)
Best regards / Cordialement
Stephane Dattenny
Dell Computers - EMEA IT - VB and Web developer
Phone: +33 (0)4 99 75 49 88
-----Original Message-----
From: shrij@v... [mailto:shrij@v...]
Sent: Tuesday, November 28, 2000 10:41 PM
To: ASP Databases
Subject: [asp_databases] Access 97 vs 2000 for a DSN
Hi
I am using DSN to connect to the database
On my test server I m using Access 97
On my deployment server I want to use Access 2000
will it be a problem ?
DSN will be configured properly
Secondly, can I use Connection String in place of DSNs with sole purpose of
avoiding DSN setup charges, in short, does using connection strings require
some additional charges ? (a bit off topic but of some interest :))
Thanks in advance
Regds
Shree
Message #3 by "Ken Schaefer" <ken@a...> on Wed, 29 Nov 2000 12:03:51 +1100
|
|
Or just:
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\db1.mdb;" & _
"User ID=Username;" & _
"Password=Whatever"
No need for Chr(34)
Cheers
Ken
----- Original Message -----
From: <Stephane_Dattenny@D...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, November 28, 2000 11:38 PM
Subject: [asp_databases] RE: Access 97 vs 2000 for a DSN
> Hi
>
> For the second question...
>
> If you are using ADO for data access, instead of using ODBC DSN, you could
> use OLEDB for Microsoft Jet 4.0 (MS Access 2000 only)
>
> The connection string is like this:
> strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<path to .mdb
> file>;User ID=" & chr(34) & strUserName & chr(34) & ";Password=" & chr(34)
&
> strPassword & chr(34)
>
>
> Best regards / Cordialement
>
> Stephane Dattenny
> Dell Computers - EMEA IT - VB and Web developer
> Phone: +33 (0)4 99 75 49 88
|
|
|
View Cart
