Hi. I have an application running on local machines at different geographic locations, that need to update data (and pick some info back) to a central server at the end of the day (receiving data from all locations).
Data volume can be 500 records / day, nearly 2 MB.
I am not sure if this can be called distributed database.
I plan to use SQL Server on the central server and am undecided on whether to use MS Access / SQL server. I will be using VB for the application.
What application technology and database technology (and data transfer) would be ideal?
Thanks.I would think that SQL Server would be the most ideal. You could set up separate ACCESS DSN (for your various clients to upload their MS Access database updates to), then use DTS within SQL Server to pull data from these various datasources.
What I would recommend is the following (in terms of the DTS structure, easiest, not the most jazzy or seamless approach, but it may work, of course, the other option is writing a stored procedure to either UPDATE or INSERT data into your centralized database):
1) Delete all data from central database.
2) Append data from client#1
3) Append data from client#2
4) Append data from client#3
etc...
Showing posts with label locations. Show all posts
Showing posts with label locations. Show all posts
Friday, February 24, 2012
Tuesday, February 14, 2012
Database create error
I have a strange error occuring on one of my sql servers.
When I execute a CREATE DATABASE statement without
specifying any file locations, e.g. "CREATE DATABASE
fred", I get the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Device
activation error. The physical file name '\fred.mdf' may
be incorrect.
[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
DATABASE failed. Some file names listed could not be
created. Check previous errors.
If I specify a location for the data file the but not the
log file it works ok. I set the default database
locations in the server properties and this then allowed
the original statement to work.
However, I would like to know where the error is coming
from. I assume that the default locations where
calculated based on either master of model, but where is
the file name error being generated?
Any pointers would be great.
Thanks,
Phil.
> However, I would like to know where the error is coming
> from. I assume that the default locations where
> calculated based on either master of model, but where is
> the file name error being generated?
The default database file locations are stored in the registry and are not
related to the location of the master or model databases. When you set the
default locations using EM, this updates the registry entries that SQL
Server uses for CREATE DATABASE.
Hope this helps.
Dan Guzman
SQL Server MVP
"Phil" <philip@.intex.co.uk> wrote in message
news:4f2901c48067$e34c6d00$a601280a@.phx.gbl...
> I have a strange error occuring on one of my sql servers.
> When I execute a CREATE DATABASE statement without
> specifying any file locations, e.g. "CREATE DATABASE
> fred", I get the following error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Device
> activation error. The physical file name '\fred.mdf' may
> be incorrect.
> [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
> DATABASE failed. Some file names listed could not be
> created. Check previous errors.
> If I specify a location for the data file the but not the
> log file it works ok. I set the default database
> locations in the server properties and this then allowed
> the original statement to work.
> However, I would like to know where the error is coming
> from. I assume that the default locations where
> calculated based on either master of model, but where is
> the file name error being generated?
> Any pointers would be great.
> Thanks,
> Phil.
When I execute a CREATE DATABASE statement without
specifying any file locations, e.g. "CREATE DATABASE
fred", I get the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Device
activation error. The physical file name '\fred.mdf' may
be incorrect.
[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
DATABASE failed. Some file names listed could not be
created. Check previous errors.
If I specify a location for the data file the but not the
log file it works ok. I set the default database
locations in the server properties and this then allowed
the original statement to work.
However, I would like to know where the error is coming
from. I assume that the default locations where
calculated based on either master of model, but where is
the file name error being generated?
Any pointers would be great.
Thanks,
Phil.
> However, I would like to know where the error is coming
> from. I assume that the default locations where
> calculated based on either master of model, but where is
> the file name error being generated?
The default database file locations are stored in the registry and are not
related to the location of the master or model databases. When you set the
default locations using EM, this updates the registry entries that SQL
Server uses for CREATE DATABASE.
Hope this helps.
Dan Guzman
SQL Server MVP
"Phil" <philip@.intex.co.uk> wrote in message
news:4f2901c48067$e34c6d00$a601280a@.phx.gbl...
> I have a strange error occuring on one of my sql servers.
> When I execute a CREATE DATABASE statement without
> specifying any file locations, e.g. "CREATE DATABASE
> fred", I get the following error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Device
> activation error. The physical file name '\fred.mdf' may
> be incorrect.
> [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
> DATABASE failed. Some file names listed could not be
> created. Check previous errors.
> If I specify a location for the data file the but not the
> log file it works ok. I set the default database
> locations in the server properties and this then allowed
> the original statement to work.
> However, I would like to know where the error is coming
> from. I assume that the default locations where
> calculated based on either master of model, but where is
> the file name error being generated?
> Any pointers would be great.
> Thanks,
> Phil.
Database create error
I have a strange error occuring on one of my sql servers.
When I execute a CREATE DATABASE statement without
specifying any file locations, e.g. "CREATE DATABASE
fred", I get the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Device
activation error. The physical file name '\fred.mdf' may
be incorrect.
[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
DATABASE failed. Some file names listed could not be
created. Check previous errors.
If I specify a location for the data file the but not the
log file it works ok. I set the default database
locations in the server properties and this then allowed
the original statement to work.
However, I would like to know where the error is coming
from. I assume that the default locations where
calculated based on either master of model, but where is
the file name error being generated?
Any pointers would be great.
Thanks,
Phil.> However, I would like to know where the error is coming
> from. I assume that the default locations where
> calculated based on either master of model, but where is
> the file name error being generated?
The default database file locations are stored in the registry and are not
related to the location of the master or model databases. When you set the
default locations using EM, this updates the registry entries that SQL
Server uses for CREATE DATABASE.
Hope this helps.
Dan Guzman
SQL Server MVP
"Phil" <philip@.intex.co.uk> wrote in message
news:4f2901c48067$e34c6d00$a601280a@.phx.gbl...
> I have a strange error occuring on one of my sql servers.
> When I execute a CREATE DATABASE statement without
> specifying any file locations, e.g. "CREATE DATABASE
> fred", I get the following error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Device
> activation error. The physical file name '\fred.mdf' may
> be incorrect.
> [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
> DATABASE failed. Some file names listed could not be
> created. Check previous errors.
> If I specify a location for the data file the but not the
> log file it works ok. I set the default database
> locations in the server properties and this then allowed
> the original statement to work.
> However, I would like to know where the error is coming
> from. I assume that the default locations where
> calculated based on either master of model, but where is
> the file name error being generated?
> Any pointers would be great.
> Thanks,
> Phil.
When I execute a CREATE DATABASE statement without
specifying any file locations, e.g. "CREATE DATABASE
fred", I get the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Device
activation error. The physical file name '\fred.mdf' may
be incorrect.
[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
DATABASE failed. Some file names listed could not be
created. Check previous errors.
If I specify a location for the data file the but not the
log file it works ok. I set the default database
locations in the server properties and this then allowed
the original statement to work.
However, I would like to know where the error is coming
from. I assume that the default locations where
calculated based on either master of model, but where is
the file name error being generated?
Any pointers would be great.
Thanks,
Phil.> However, I would like to know where the error is coming
> from. I assume that the default locations where
> calculated based on either master of model, but where is
> the file name error being generated?
The default database file locations are stored in the registry and are not
related to the location of the master or model databases. When you set the
default locations using EM, this updates the registry entries that SQL
Server uses for CREATE DATABASE.
Hope this helps.
Dan Guzman
SQL Server MVP
"Phil" <philip@.intex.co.uk> wrote in message
news:4f2901c48067$e34c6d00$a601280a@.phx.gbl...
> I have a strange error occuring on one of my sql servers.
> When I execute a CREATE DATABASE statement without
> specifying any file locations, e.g. "CREATE DATABASE
> fred", I get the following error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Device
> activation error. The physical file name '\fred.mdf' may
> be incorrect.
> [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
> DATABASE failed. Some file names listed could not be
> created. Check previous errors.
> If I specify a location for the data file the but not the
> log file it works ok. I set the default database
> locations in the server properties and this then allowed
> the original statement to work.
> However, I would like to know where the error is coming
> from. I assume that the default locations where
> calculated based on either master of model, but where is
> the file name error being generated?
> Any pointers would be great.
> Thanks,
> Phil.
Database create error
I have a strange error occuring on one of my sql servers.
When I execute a CREATE DATABASE statement without
specifying any file locations, e.g. "CREATE DATABASE
fred", I get the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Device
activation error. The physical file name '\fred.mdf' may
be incorrect.
[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
DATABASE failed. Some file names listed could not be
created. Check previous errors.
If I specify a location for the data file the but not the
log file it works ok. I set the default database
locations in the server properties and this then allowed
the original statement to work.
However, I would like to know where the error is coming
from. I assume that the default locations where
calculated based on either master of model, but where is
the file name error being generated?
Any pointers would be great.
Thanks,
Phil.Instead of putting '\fred.mdf' you will need to put (as an
example) C:\fred.mdf.
If you like to know more I would sugest you script a
database by going into EA and
1. Right Click on the DB -> All Tasks -> Generate SQL
Script.
2. Go the options tab and select script database
3. Press ok and choose a location to save the file.
After you have done this load the file in QA and have a
look at it - note - Do not run it.
Peter
>--Original Message--
>I have a strange error occuring on one of my sql servers.
>When I execute a CREATE DATABASE statement without
>specifying any file locations, e.g. "CREATE DATABASE
>fred", I get the following error:
>[Microsoft][ODBC SQL Server Driver][SQL Server]Device
>activation error. The physical file name '\fred.mdf' may
>be incorrect.
>[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
>DATABASE failed. Some file names listed could not be
>created. Check previous errors.
>If I specify a location for the data file the but not the
>log file it works ok. I set the default database
>locations in the server properties and this then allowed
>the original statement to work.
>However, I would like to know where the error is coming
>from. I assume that the default locations where
>calculated based on either master of model, but where is
>the file name error being generated?
>Any pointers would be great.
>Thanks,
>Phil.
>.
>|||> However, I would like to know where the error is coming
> from. I assume that the default locations where
> calculated based on either master of model, but where is
> the file name error being generated?
The default database file locations are stored in the registry and are not
related to the location of the master or model databases. When you set the
default locations using EM, this updates the registry entries that SQL
Server uses for CREATE DATABASE.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Phil" <philip@.intex.co.uk> wrote in message
news:4f2901c48067$e34c6d00$a601280a@.phx.gbl...
> I have a strange error occuring on one of my sql servers.
> When I execute a CREATE DATABASE statement without
> specifying any file locations, e.g. "CREATE DATABASE
> fred", I get the following error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Device
> activation error. The physical file name '\fred.mdf' may
> be incorrect.
> [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
> DATABASE failed. Some file names listed could not be
> created. Check previous errors.
> If I specify a location for the data file the but not the
> log file it works ok. I set the default database
> locations in the server properties and this then allowed
> the original statement to work.
> However, I would like to know where the error is coming
> from. I assume that the default locations where
> calculated based on either master of model, but where is
> the file name error being generated?
> Any pointers would be great.
> Thanks,
> Phil.
When I execute a CREATE DATABASE statement without
specifying any file locations, e.g. "CREATE DATABASE
fred", I get the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Device
activation error. The physical file name '\fred.mdf' may
be incorrect.
[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
DATABASE failed. Some file names listed could not be
created. Check previous errors.
If I specify a location for the data file the but not the
log file it works ok. I set the default database
locations in the server properties and this then allowed
the original statement to work.
However, I would like to know where the error is coming
from. I assume that the default locations where
calculated based on either master of model, but where is
the file name error being generated?
Any pointers would be great.
Thanks,
Phil.Instead of putting '\fred.mdf' you will need to put (as an
example) C:\fred.mdf.
If you like to know more I would sugest you script a
database by going into EA and
1. Right Click on the DB -> All Tasks -> Generate SQL
Script.
2. Go the options tab and select script database
3. Press ok and choose a location to save the file.
After you have done this load the file in QA and have a
look at it - note - Do not run it.
Peter
>--Original Message--
>I have a strange error occuring on one of my sql servers.
>When I execute a CREATE DATABASE statement without
>specifying any file locations, e.g. "CREATE DATABASE
>fred", I get the following error:
>[Microsoft][ODBC SQL Server Driver][SQL Server]Device
>activation error. The physical file name '\fred.mdf' may
>be incorrect.
>[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
>DATABASE failed. Some file names listed could not be
>created. Check previous errors.
>If I specify a location for the data file the but not the
>log file it works ok. I set the default database
>locations in the server properties and this then allowed
>the original statement to work.
>However, I would like to know where the error is coming
>from. I assume that the default locations where
>calculated based on either master of model, but where is
>the file name error being generated?
>Any pointers would be great.
>Thanks,
>Phil.
>.
>|||> However, I would like to know where the error is coming
> from. I assume that the default locations where
> calculated based on either master of model, but where is
> the file name error being generated?
The default database file locations are stored in the registry and are not
related to the location of the master or model databases. When you set the
default locations using EM, this updates the registry entries that SQL
Server uses for CREATE DATABASE.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Phil" <philip@.intex.co.uk> wrote in message
news:4f2901c48067$e34c6d00$a601280a@.phx.gbl...
> I have a strange error occuring on one of my sql servers.
> When I execute a CREATE DATABASE statement without
> specifying any file locations, e.g. "CREATE DATABASE
> fred", I get the following error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Device
> activation error. The physical file name '\fred.mdf' may
> be incorrect.
> [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
> DATABASE failed. Some file names listed could not be
> created. Check previous errors.
> If I specify a location for the data file the but not the
> log file it works ok. I set the default database
> locations in the server properties and this then allowed
> the original statement to work.
> However, I would like to know where the error is coming
> from. I assume that the default locations where
> calculated based on either master of model, but where is
> the file name error being generated?
> Any pointers would be great.
> Thanks,
> Phil.
Subscribe to:
Posts (Atom)