Hi
Please give some help on this

I have created a virtual dir in IIS win 2000
 From a visual basic application on another machine
I am trying to retrieve data from a database in this directory.
Using access database is terribly slow
Using SQL server database is flying.

What is going on with access
is the whole database getting downloaded?
Is there anything I can do to make access work fast?

Please suggestions on that would be greatly appreciated

The connection string I use:

CONNECTSTRING = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\\servers IP\my-virtualdir\databasename.mdb;Persist Security 
Info=False"
or
"Driver={Microsoft Access Driver (*.mdb)};" & _
"Data Source=\\servers IP\my-virtualdir\databasename.mdb;Persist Security 
Info=False"

Thanks in advance
Best regards
Nikos

SQL Server is a proper database server.

Access is just a file-based database that is designed to be used locally by
a single user. Whilst you may not be pulling the entire database across the
wire, you're certainly pulling large portions of it.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Nikos" <pappas@c...>
Subject: [asp_databases] remote server


: Please give some help on this
:
: I have created a virtual dir in IIS win 2000
:  From a visual basic application on another machine
: I am trying to retrieve data from a database in this directory.
: Using access database is terribly slow
: Using SQL server database is flying.
:
: What is going on with access
: is the whole database getting downloaded?
: Is there anything I can do to make access work fast?
:
: Please suggestions on that would be greatly appreciated
:
: The connection string I use:
:
: CONNECTSTRING = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
: "Data Source=\\servers IP\my-virtualdir\databasename.mdb;Persist Security
: Info=False"
: or
: "Driver={Microsoft Access Driver (*.mdb)};" & _
: "Data Source=\\servers IP\my-virtualdir\databasename.mdb;Persist Security
: Info=False"
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Great
Many thanks for your help Ken

Please send another answer to the following:
If I design a database in SQL server and export it to MSDE
using the wizard is everything like constraints indexes etc will be
transferred as well
or I got to do something else to transfer it properly?
The customer cannot spend to have SQL server

Thanks again
Best regards
Nikos

At 02:18 =F0=EC 5/12/2002, you wrote:
>SQL Server is a proper database server.
>
>Access is just a file-based database that is designed to be used locally by
>a single user. Whilst you may not be pulling the entire database across the
>wire, you're certainly pulling large portions of it.
>
>Cheers
>Ken
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: "Nikos" <pappas@c...>
>Subject: [asp_databases] remote server
>
>
>: Please give some help on this
>:
>: I have created a virtual dir in IIS win 2000
>:  From a visual basic application on another machine
>: I am trying to retrieve data from a database in this directory.
>: Using access database is terribly slow
>: Using SQL server database is flying.
>:
>: What is going on with access
>: is the whole database getting downloaded?
>: Is there anything I can do to make access work fast?
>:
>: Please suggestions on that would be greatly appreciated
>:
>: The connection string I use:
>:
>: CONNECTSTRING =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0;" & _
>: "Data Source=3D\\servers IP\my-virtualdir\databasename.mdb;Persist
 Security
>: Info=3DFalse"
>: or
>: "Driver=3D{Microsoft Access Driver (*.mdb)};" & _
>: "Data Source=3D\\servers IP\my-virtualdir\databasename.mdb;Persist
 Security
>: Info=3DFalse"
>:
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>

MSDE is SQL Server.

Just be aware of the MSDE licencing conditions:
http://www.microsoft.com/sql/howtobuy/msdeuse.asp

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Nikos" <pappas@c...>
Subject: [asp_databases] Re: remote server


Great
Many thanks for your help Ken

Please send another answer to the following:
If I design a database in SQL server and export it to MSDE
using the wizard is everything like constraints indexes etc will be 
transferred as well
or I got to do something else to transfer it properly?
The customer cannot spend to have SQL server

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Thanks a lot Ken

I thought MSDE was free.
I never used it so far anyway.
Thanks for the link as well
Microsoft has to do something with the Java scripts
the page keeps raising an error as the mouse moves
but managed to see it.

All the best

Nikos

At 03:36 =F0=EC 5/12/2002, you wrote:
>MSDE is SQL Server.
>
>Just be aware of the MSDE licencing conditions:
>http://www.microsoft.com/sql/howtobuy/msdeuse.asp
>
>Cheers
>Ken
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: "Nikos" <pappas@c...>
>Subject: [asp_databases] Re: remote server
>
>
>Great
>Many thanks for your help Ken
>
>Please send another answer to the following:
>If I design a database in SQL server and export it to MSDE
>using the wizard is everything like constraints indexes etc will be
>transferred as well
>or I got to do something else to transfer it properly?
>The customer cannot spend to have SQL server
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>