Disk or network error

Hi

I have written an application in VB through which I can convert DBASE
IV database to MS SQL Server database. Also, the application provides
database manipulation features to the user like addition, deletion etc
of records.
I am using OPENROWSET for conversion purposes. Also the server is MS
SQL Server 2000.
Now this application workks fine when I have installed the instance of
MS SQL Server on my local machine. It converts the database and stores
it on the server perfectly and there are no isues.
However, when I try to use the application to connect with MS SQL
Server on another machine, there are a few problems. I connect to the
other MS SQL Server on other machine through named pipes. My
application successfully accesses the database and allows user to
modify it according to his needs.
For this I created the user account of that user on the machine.
But when I try to convert the database, I get the following error
message:

[Microsoft ODBC Dbase driver]Disk or Network Error

Here is the line in VB code which is causing all the trouble:

con.Execute "select * into " & UCase(X) & " from
OPENROWSET('MSDASQL','Driver={Microsoft dBASE Driver
(*.dbf)};DEFAULTDIR=" & BaseData & ";SourceType=DBF','select * from " &
UCase(X) & "')"

Here, X is the dbf file name, BaseData is the path name of file.
I gave the user full rights but i am still getting this error message.
Now, what am I doing wrong here?

Regards,
ShwetabhHi

You don't say of you can open the DBASE file from DBASE on the remote
machine? Are you using a mapped drive or UNC name? Have you checked that the
permissions are correct for the SQL Server service account?

John
"Shwetabh" <shwetabhgoel@.gmail.com> wrote in message
news:1144529567.672831.5960@.v46g2000cwv.googlegrou ps.com...
> Hi
> I have written an application in VB through which I can convert DBASE
> IV database to MS SQL Server database. Also, the application provides
> database manipulation features to the user like addition, deletion etc
> of records.
> I am using OPENROWSET for conversion purposes. Also the server is MS
> SQL Server 2000.
> Now this application workks fine when I have installed the instance of
> MS SQL Server on my local machine. It converts the database and stores
> it on the server perfectly and there are no isues.
> However, when I try to use the application to connect with MS SQL
> Server on another machine, there are a few problems. I connect to the
> other MS SQL Server on other machine through named pipes. My
> application successfully accesses the database and allows user to
> modify it according to his needs.
> For this I created the user account of that user on the machine.
> But when I try to convert the database, I get the following error
> message:
> [Microsoft ODBC Dbase driver]Disk or Network Error
> Here is the line in VB code which is causing all the trouble:
> con.Execute "select * into " & UCase(X) & " from
> OPENROWSET('MSDASQL','Driver={Microsoft dBASE Driver
> (*.dbf)};DEFAULTDIR=" & BaseData & ";SourceType=DBF','select * from " &
> UCase(X) & "')"
> Here, X is the dbf file name, BaseData is the path name of file.
> I gave the user full rights but i am still getting this error message.
> Now, what am I doing wrong here?
> Regards,
> Shwetabh|||Hi,

Actually, the DBASE files are stored in a seperate folder on the remote
machine (remote in the sense that though it is in the intranet, SQL
server 2000 isnt installed on it). I have made the drive shared. Also,
in my effort to get it to work, I gave the user all rights on the SQL
server. But it still doesnt work.
And yes, I am using UNC name.

Regards,
Shwetabh|||Hi Shwetabh

If you service account is a domain account then log onto the SQL Server
machine as this account and see if you can access the DBASE files.

John

Shwetabh wrote:
> Hi,
> Actually, the DBASE files are stored in a seperate folder on the remote
> machine (remote in the sense that though it is in the intranet, SQL
> server 2000 isnt installed on it). I have made the drive shared. Also,
> in my effort to get it to work, I gave the user all rights on the SQL
> server. But it still doesnt work.
> And yes, I am using UNC name.
> Regards,
> Shwetabh|||Hi,
Sorry for taking so long to reply.
Actually, I can access the database from my application.
But I am unable to import my DBASE database to sql server.
when I try to do so, using OPENROWSET I get the error message.
Also, since the end product will be used by many other people,
their individual accounts will be created, I dont think using domain
account will be a good idea.

Regards,
Shwetabh|||Hi

To access network resources you will need a domain account with the
appropriate privileges otherwise you will not be able to connect.

John
"Shwetabh" <shwetabhgoel@.gmail.com> wrote in message
news:1145602062.263512.306870@.e56g2000cwe.googlegr oups.com...
> Hi,
> Sorry for taking so long to reply.
> Actually, I can access the database from my application.
> But I am unable to import my DBASE database to sql server.
> when I try to do so, using OPENROWSET I get the error message.
> Also, since the end product will be used by many other people,
> their individual accounts will be created, I dont think using domain
> account will be a good idea.
> Regards,
> Shwetabh|||Hi,

Lets consider this,
I have the DBASE files on the local machine.
Now I want to convert them and store them in MS SQL
Server.
Now for doing this, I use OPENROWSET.
I can access the already converted database (which I converted
manually on the server for testing purpose). I can read, write, delete
that data. I get no errors when I do that.
Now when I try to convert database from DBF (stored on local disk)
to SQL using OPENROWSET, I get the error: Disk or Network Error.

How should I resolve this?

Shwetabh|||Shwetabh (shwetabhgoel@.gmail.com) writes:
> Sorry for taking so long to reply.
> Actually, I can access the database from my application.
> But I am unable to import my DBASE database to sql server.
> when I try to do so, using OPENROWSET I get the error message.
> Also, since the end product will be used by many other people,
> their individual accounts will be created, I dont think using domain
> account will be a good idea.

When John talked about domain account, he referred to the account
under which SQL Server itself is running. To access resources on
the network, the account should be a domain account. Running SQL
Server under a domain account is a very common thing to do, even
in multi-user enviroments.

To review the service accont for SQL Server, right-click My Computer
on the server, select Manage. Find Services, and in the list of
services, find MSSQL Server. Double-click, and go the log on tab.
Make sure that the user there has access to the remote drive
where the DBASE files are located.

Or move the DBASE files to a local disk on the server.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hi,

I tried to access the database stored on a machine running Windows 2000
+ MS SQL Server 2000 and it worked fine.
Infact, it worked fine when used by any machine which would connect to
Windows 2000 server.
I was easily able to import the data on servers running Windows 2k.
But I am getting this error by connecting onto the servers running
Windows 2003.

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC dBase Driver] The
Microsoft Jet database engine could not find the object 'ACE'. Make
sure the object exists and that you spell its name and the path name
correctly.]

How can I resolve this problem?

Regards,
Shwetabh|||Hi,

I tried to access the database stored on a machine running Windows 2000
+ MS SQL Server 2000 and it worked fine.
Infact, it worked fine when used by any machine which would connect to
Windows 2000 server.
I was easily able to import the data on servers running Windows 2k.
But I am getting this error by connecting onto the servers running
Windows 2003.

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC dBase Driver] The
Microsoft Jet database engine could not find the object 'ACE'. Make
sure the object exists and that you spell its name and the path name
correctly.]

Windows 2003 server is also running MS SQL Server 2000. But I cant get
it to work.
How can I resolve this problem?

Regards,
Shwetabh|||Shwetabh (shwetabhgoel@.gmail.com) writes:
> I tried to access the database stored on a machine running Windows 2000
> + MS SQL Server 2000 and it worked fine.
> Infact, it worked fine when used by any machine which would connect to
> Windows 2000 server.
> I was easily able to import the data on servers running Windows 2k.
> But I am getting this error by connecting onto the servers running
> Windows 2003.
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [Microsoft][ODBC dBase Driver] The
> Microsoft Jet database engine could not find the object 'ACE'. Make
> sure the object exists and that you spell its name and the path name
> correctly.]
> How can I resolve this problem?

Not that I am sure that I can help anyway, but it would definitely help if
you can give full details, both when it is working and when it is not.

1) Where is the dBase file located in relation to the SQL Server? Local
disk or an a network share?

2) Under what account is SQL Server running?

3) Do you get the error when you run under any account on SQL Server,
even as administrator?

In the end this may have more to do with Windows or Active Directory that
I know very little about.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

disk crash and dwh recover

hi everybody.
A customer of mine has had a disk "crash" few days ago.
I wrote for him a dwh application and
of course the backup was not working...
now some "hardware guys" said that it is possible to recover most of
the files.
what I need to restore would be:
1- the sql server db
2- the sql server dts and jobs
3- the analysis service cube and dimensions
to do so is it enough for me to have:
1- the .mdf and .ldf files
2- the master.mdl /.ldf file
3- the .odb file and .dim* and .role .map ... files
right?
is it enough to recover everything?
if it is so, what would be the right processes to recover everything?
any help greatly appreciated!No RAID and no backups? So this data warehouse is really just a bunch of
data dumped on someone's PC with a few reports tacked onto it? ;-)
Assuming the hardware gurus can actually recover the .mdb (data) files
intact, they can be reattached once the SQL Server box is re-installed. The
.ldf files are the transaction logs, and in a bulk loaded data warehouse,
restoring these may not be important.
http://msdn2.microsoft.com/en-us/library/ms190794.aspx
http://support.microsoft.com/defaul...kb;en-us;224071
What will be a pain is restoring or re-building the master database and how
this affects logins/users for the user database(s). However, unlike
operational databases, most data warehousing databases only have a limited
number of users or profiles (ex: Admin and Reporting), so perhaps this won't
be too much of a deal.
Rebuilding the master Database:
http://msdn.microsoft.com/library/d... />
t_0cvm.asp
User logons and permissions on a database may be incorrect after the
database is restored:
http://support.microsoft.com/defaul...kb;en-us;168001
As for restoring the Analysis Services cubes, I assume you at least have a
backup of the development system which can be restored to production. OLAP
data is typically just derived and aggregated, so once AS is re-installed
and the cube files restored, just re-process and they will be re-loaded from
the source data warehouse tables.
Microsoft SQL Server 2000 Analysis Services Operations Guide:
http://www.microsoft.com/technet/pr...n/anservog.mspx
"ilkaos" <c.caoduro@.gmail.com> wrote in message
news:1138637846.479954.273090@.f14g2000cwb.googlegroups.com...
> hi everybody.
> A customer of mine has had a disk "crash" few days ago.
> I wrote for him a dwh application and
> of course the backup was not working...
> now some "hardware guys" said that it is possible to recover most of
> the files.
> what I need to restore would be:
> 1- the sql server db
> 2- the sql server dts and jobs
> 3- the analysis service cube and dimensions
> to do so is it enough for me to have:
> 1- the .mdf and .ldf files
> 2- the master.mdl /.ldf file
> 3- the .odb file and .dim* and .role .map ... files
> right?
> is it enough to recover everything?
> if it is so, what would be the right processes to recover everything?
> any help greatly appreciated!
>|||
> No RAID and no backups? So this data warehouse is really just a bunch of
> data dumped on someone's PC with a few reports tacked onto it? ;-)
>
kind of...it was my first attempt with analysis service and it did a
"little but good" job..

> Assuming the hardware gurus can actually recover the .mdb (data) files
> intact, they can be reattached once the SQL Server box is re-installed.
The
> .ldf files are the transaction logs, and in a bulk loaded data warehouse,
> restoring these may not be important.
> http://msdn2.microsoft.com/en-us/library/ms190794.aspx
> http://support.microsoft.com/defaul...kb;en-us;224071
I thought so

> What will be a pain is restoring or re-building the master database and
how
> this affects logins/users for the user database(s). However, unlike
> operational databases, most data warehousing databases only have a limited
> number of users or profiles (ex: Admin and Reporting), so perhaps this
won't
> be too much of a deal.
> Rebuilding the master Database:
>
http://msdn.microsoft.com/library/d... />
t_0cvm.asp
in fact there are no particular users or profiles

> User logons and permissions on a database may be incorrect after the
> database is restored:
> http://support.microsoft.com/defaul...kb;en-us;168001
I see...

> As for restoring the Analysis Services cubes, I assume you at least have a
> backup of the development system which can be restored to production. OLAP
> data is typically just derived and aggregated, so once AS is re-installed
> and the cube files restored, just re-process and they will be re-loaded
from
> the source data warehouse tables.
> Microsoft SQL Server 2000 Analysis Services Operations Guide:
>
http://www.microsoft.com/technet/pr...n/anservog.mspx
>
sorry but I do not understand what you mean with a "backup of the
development system which can be restored to production".
As I wrote in my previous message I can have back the files tjat were in the
..\analysis service\* folder...
in any case thanks a lot for your answer, it is a great help!
ciao.sql

disconnection of web pages from SQL Server

We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
fusion application that is running against this database. We have 5 front end
(cold fusion) servers load balanced. We have a monitoring service that pings
our web application main pages (we have 2 main pages) and reports the
downtime. Once in a while the alert site reports that the site is down (tries
thru all the 5 cold fusion servers). On the DB side, I do not see any
messages for that time frame SQL server logs and or error logs. I was looking
at the stats... CPU usuage is around 55%, 8 minutes before the problem
oocured. It gradually went up and reached 65% 3 minutes before. Came
gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
available through out and number of cpu processes were constant at 45.
Are there any other ways to find out what happened (if any thing was really
wrong with SQL server) ?
Are there any other logs I could check (of course it is after the effect now)
Do you have scheduled virus scans that might be running at this time?
"RK73" wrote:

> We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
> fusion application that is running against this database. We have 5 front end
> (cold fusion) servers load balanced. We have a monitoring service that pings
> our web application main pages (we have 2 main pages) and reports the
> downtime. Once in a while the alert site reports that the site is down (tries
> thru all the 5 cold fusion servers). On the DB side, I do not see any
> messages for that time frame SQL server logs and or error logs. I was looking
> at the stats... CPU usuage is around 55%, 8 minutes before the problem
> oocured. It gradually went up and reached 65% 3 minutes before. Came
> gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
> available through out and number of cpu processes were constant at 45.
> Are there any other ways to find out what happened (if any thing was really
> wrong with SQL server) ?
> Are there any other logs I could check (of course it is after the effect now)
sql

disconnection of web pages from SQL Server

We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
fusion application that is running against this database. We have 5 front end
(cold fusion) servers load balanced. We have a monitoring service that pings
our web application main pages (we have 2 main pages) and reports the
downtime. Once in a while the alert site reports that the site is down (tries
thru all the 5 cold fusion servers). On the DB side, I do not see any
messages for that time frame SQL server logs and or error logs. I was looking
at the stats... CPU usuage is around 55%, 8 minutes before the problem
oocured. It gradually went up and reached 65% 3 minutes before. Came
gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
available through out and number of cpu processes were constant at 45.
Are there any other ways to find out what happened (if any thing was really
wrong with SQL server) ?
Are there any other logs I could check (of course it is after the effect now)Do you have scheduled virus scans that might be running at this time?
"RK73" wrote:
> We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
> fusion application that is running against this database. We have 5 front end
> (cold fusion) servers load balanced. We have a monitoring service that pings
> our web application main pages (we have 2 main pages) and reports the
> downtime. Once in a while the alert site reports that the site is down (tries
> thru all the 5 cold fusion servers). On the DB side, I do not see any
> messages for that time frame SQL server logs and or error logs. I was looking
> at the stats... CPU usuage is around 55%, 8 minutes before the problem
> oocured. It gradually went up and reached 65% 3 minutes before. Came
> gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
> available through out and number of cpu processes were constant at 45.
> Are there any other ways to find out what happened (if any thing was really
> wrong with SQL server) ?
> Are there any other logs I could check (of course it is after the effect now)

disconnection of web pages from SQL Server

We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
fusion application that is running against this database. We have 5 front en
d
(cold fusion) servers load balanced. We have a monitoring service that pings
our web application main pages (we have 2 main pages) and reports the
downtime. Once in a while the alert site reports that the site is down (trie
s
thru all the 5 cold fusion servers). On the DB side, I do not see any
messages for that time frame SQL server logs and or error logs. I was lookin
g
at the stats... CPU usuage is around 55%, 8 minutes before the problem
oocured. It gradually went up and reached 65% 3 minutes before. Came
gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
available through out and number of cpu processes were constant at 45.
Are there any other ways to find out what happened (if any thing was really
wrong with SQL server) ?
Are there any other logs I could check (of course it is after the effect now
)Do you have scheduled virus scans that might be running at this time?
"RK73" wrote:
[vbcol=seagreen]
> We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a col
d
> fusion application that is running against this database. We have 5 front
end
> (cold fusion) servers load balanced. We have a monitoring service that pin
gs
> our web application main pages (we have 2 main pages) and reports the
> downtime. Once in a while the alert site reports that the site is down (tr
ies
> thru all the 5 cold fusion servers). On the DB side, I do not see any
> messages for that time frame SQL server logs and or error logs. I was look
ing
> at the stats... CPU usuage is around 55%, 8 minutes before the problem
> oocured. It gradually went up and reached 65% 3 minutes before. Came
> gradually came down to 25% at 1 minute after the problem. 1.6 GB memory w
as
> available through out and number of cpu processes were constant at 45.
> Are there any other ways to find out what happened (if any thing was reall
y
> wrong with SQL server) ?
> Are there any other logs I could check (of course it is after the effect now)[/vbc
ol]

Disconnected application w/xml data source - how do I create strongly typed datasets?

I am sourcing my disconnected application with an xml data source but would
like to use strongly type datasets in my application using Visual Studio
2005. Is this possible?
JimOn Jul 21, 7:39 am, "Jim" <j...@.myemai.com> wrote:
> I am sourcing my disconnected application with an xml data source but woul
d
> like to use strongly type datasets in my application using Visual Studio
> 2005. Is this possible?
> Jim
VS comes with xsd.exe. You pass your xml to the tool and it will
create strongly typed dataset class for you.
Mike

Disconnected application w/xml data source - how do I create strongly typed datasets?

I am sourcing my disconnected application with an xml data source but would
like to use strongly type datasets in my application using Visual Studio
2005. Is this possible?
Jim
On Jul 21, 7:39 am, "Jim" <j...@.myemai.com> wrote:
> I am sourcing my disconnected application with an xml data source but would
> like to use strongly type datasets in my application using Visual Studio
> 2005. Is this possible?
> Jim
VS comes with xsd.exe. You pass your xml to the tool and it will
create strongly typed dataset class for you.
Mike

Disconnected application and replication

Hi
We have a situation where the sql server backend is on the server but
several laptop users need to disconnect and still be able to use the data.
Can we have copies of say sql express on each laptop which can replicate
data with the sql server when connected and still make the data available
while disconnected from the server? Will this work, specially when the app
front end will be in vb.net?
Thanks
RegardsJohn,
yes - this can work. You'd have a merge publication and pull subscriptions,
activated by your vb.net application.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||Or you could have the sync managed by Windows Synchronization Manager or
task scheduler. SQL Server Express does not ship with a scheduler. I would
also have a look at SQL Server Everywhere edition - due out this summer.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||Ok, but is it the best/recommended way? I mean what do other people do in
this situation?
Thanks
Regards
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||It depends on your requirements. The question is do you want the app to
manage the sync, or do you want it done externally.
If you want the app to manage the sync use the activeX merge control. If you
do not use WSM or task scheduler. WSM has a rich set of functionality for
controlling the sync. If you choose to use task scheduler you will have to
have it instantiate the activeX control to do the sync.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uGU3ovHZGHA.4944@.TK2MSFTNGP02.phx.gbl...
> Ok, but is it the best/recommended way? I mean what do other people do in
> this situation?
> Thanks
> Regards
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
>

Disconnected application and replication

Hi
We have a situation where the sql server backend is on the server but
several laptop users need to disconnect and still be able to use the data.
Can we have copies of say sql express on each laptop which can replicate
data with the sql server when connected and still make the data available
while disconnected from the server? Will this work, specially when the app
front end will be in vb.net?
Thanks
RegardsJohn,
yes - this can work. You'd have a merge publication and pull subscriptions,
activated by your vb.net application.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||Or you could have the sync managed by Windows Synchronization Manager or
task scheduler. SQL Server Express does not ship with a scheduler. I would
also have a look at SQL Server Everywhere edition - due out this summer.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||Ok, but is it the best/recommended way? I mean what do other people do in
this situation?
Thanks
Regards
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||It depends on your requirements. The question is do you want the app to
manage the sync, or do you want it done externally.
If you want the app to manage the sync use the activeX merge control. If you
do not use WSM or task scheduler. WSM has a rich set of functionality for
controlling the sync. If you choose to use task scheduler you will have to
have it instantiate the activeX control to do the sync.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uGU3ovHZGHA.4944@.TK2MSFTNGP02.phx.gbl...
> Ok, but is it the best/recommended way? I mean what do other people do in
> this situation?
> Thanks
> Regards
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
>> John,
>> yes - this can work. You'd have a merge publication and pull
>> subscriptions, activated by your vb.net application.
>> Cheers,
>> Paul Ibison SQL Server MVP, www.replicationanswers.com
>> (recommended sql server 2000 replication book:
>> http://www.nwsu.com/0974973602p.html)
>

Disconnect from sql server database

Hi
I have c# application that uses SQL SERVER databases.
The problem is that after I close all connections to a database in order to
make actions (detach, copy or delete) on the current database I get a
message saying that the database still has connections.
At the Enterprise manager I can see that the current database still has 2
connections although I closed them in my application.
I would like to disconnect from the database through the application and
make the actions that were mentioned above, how can I do that?
Thanks,
Eyal
On SQL SERVER 2000, you can disconnect all the current connections with:
ALTER DATABASE your_database SET SINGLE_USER WITH ROLLBACK IMMEDIATE
USE master
DROP DATABASE your_database etc..
You need USE master, otherwise you're still connected yourself.
Jacco Schalkwijk
SQL Server MVP
"Eyal" <eg@.margan.com> wrote in message
news:eYltEA3BFHA.3592@.TK2MSFTNGP09.phx.gbl...
> Hi
>
> I have c# application that uses SQL SERVER databases.
> The problem is that after I close all connections to a database in order
> to
> make actions (detach, copy or delete) on the current database I get a
> message saying that the database still has connections.
>
> At the Enterprise manager I can see that the current database still has 2
> connections although I closed them in my application.
>
> I would like to disconnect from the database through the application and
> make the actions that were mentioned above, how can I do that?
>
> Thanks,
> Eyal
>

Disconnect from sql server database

Hi
I have c# application that uses SQL SERVER databases.
The problem is that after I close all connections to a database in order to
make actions (detach, copy or delete) on the current database I get a
message saying that the database still has connections.
At the Enterprise manager I can see that the current database still has 2
connections although I closed them in my application.
I would like to disconnect from the database through the application and
make the actions that were mentioned above, how can I do that?
Thanks,
Eyal
My guess is that you are using connection pooling. This is the default
setting for SqlClient. Do please check about connection pooling in .Net
documentation if this is your problem.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Eyal" <eg@.margan.com> wrote in message
news:eAAkq$2BFHA.3236@.TK2MSFTNGP15.phx.gbl...
> Hi
>
> I have c# application that uses SQL SERVER databases.
> The problem is that after I close all connections to a database in order
to
> make actions (detach, copy or delete) on the current database I get a
> message saying that the database still has connections.
>
> At the Enterprise manager I can see that the current database still has 2
> connections although I closed them in my application.
>
> I would like to disconnect from the database through the application and
> make the actions that were mentioned above, how can I do that?
>
> Thanks,
> Eyal
>

Disconnect from sql server database

Hi
I have c# application that uses SQL SERVER databases.
The problem is that after I close all connections to a database in order to
make actions (detach, copy or delete) on the current database I get a
message saying that the database still has connections.
At the Enterprise manager I can see that the current database still has 2
connections although I closed them in my application.
I would like to disconnect from the database through the application and
make the actions that were mentioned above, how can I do that?
Thanks,
EyalMy guess is that you are using connection pooling. This is the default
setting for SqlClient. Do please check about connection pooling in .Net
documentation if this is your problem.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Eyal" <eg@.margan.com> wrote in message
news:eAAkq$2BFHA.3236@.TK2MSFTNGP15.phx.gbl...
> Hi
>
> I have c# application that uses SQL SERVER databases.
> The problem is that after I close all connections to a database in order
to
> make actions (detach, copy or delete) on the current database I get a
> message saying that the database still has connections.
>
> At the Enterprise manager I can see that the current database still has 2
> connections although I closed them in my application.
>
> I would like to disconnect from the database through the application and
> make the actions that were mentioned above, how can I do that?
>
> Thanks,
> Eyal
>

Disappearing parameter values

I have an ASP.NET application with a page which has a Reportviewer control
linked to a Reporting Services report on a Remote Server. I pass parameters
into it OK including the name of the database which is then referenced by a
dynamic connection string. The database is the first parameter. Other
parameters have dropdown lists based on datasets using the dynamic connection
string.
All of this works fine, but...
When I hide some of the parameters, because I know what value is required,
the value is not acceoted, nor does the report use the default value. It is
as though hiding the parameter prevents the list of available values being
requeried; consequently the passed in value is ignored as it does not match
an available value!
Can anyone help please?
Thanks
GeorgeGeorge,
I assume you are setting the Visible property of some web control that
holds the value of your report parameter. You should set the Visibility
Style of the control to 'hidden' so that it still gets rendered into the web
form but is not 'seen' in the web browser. This way the controls value is
still within the form and viewstate when the form is posted back.
Hope I made the correct assumption and this helps.
thx
-jsh
"George Davies" wrote:
> I have an ASP.NET application with a page which has a Reportviewer control
> linked to a Reporting Services report on a Remote Server. I pass parameters
> into it OK including the name of the database which is then referenced by a
> dynamic connection string. The database is the first parameter. Other
> parameters have dropdown lists based on datasets using the dynamic connection
> string.
> All of this works fine, but...
> When I hide some of the parameters, because I know what value is required,
> the value is not acceoted, nor does the report use the default value. It is
> as though hiding the parameter prevents the list of available values being
> requeried; consequently the passed in value is ignored as it does not match
> an available value!
> Can anyone help please?
> Thanks
> George|||Thanks jsh for replying so promptly
I'm not sure I've explained the problem correctly, as I could not find the
Visibility Style for the control as you suggested. I am using RS2005 and
ASP.NET 1.1 with a ReportViewer control linked to a deployed remote report.
But I think you may be on to something as the problem does not arise when
designing the report, nor in Report Manager, only when I run it from within
the ASP ReportViewer control as a Remote Report.
The parameter is passed into the Reporting Services report OK, but when the
Report Server processes the parameters it first takes the name of the
database as the first parameter, then it recognises that there are cascading
parameters because the dropdown lists require data from tables which have
been queried using the dynamic connection string. At this point it seems to
assume that because it is going to refresh the dropdown lists that it can no
longer rely on the selections supplied in the other parameters and scrubs
them i.e. it insists that the user rekey each of the parameter values
wherever the dropdown lists use the dynamic connection string.
This causes two problems:
1 When I want a parameter value hidden, it is impossible to set it and the
report fails with e.g. "Parameter zzz does not have a value". I could get
round this by using two parameters for each value, one for when I want to
force the parameter to be a certain value and hide it with no associated
dropdown list, and one for when I want to show it and ask the user to pick
from a list. Messy, but I could get the report SQL to test for either of the
values in the two parameters. But this still leaves problem number 2...
2 When cascading parameters are used, each time the user picks a value, it
postbacks to the server. This is not very clever of Reporting Services. It
should post back when the value for a parameter is changed where that
parameter is used by other parameters, not when a parameter changes which
uses the value from another parameter.
The long and short of it is that with eight parameters, the selection of
report options is excruciatingly slow and won't be acceptable to my users.
If you or anyone else can shed any light on this problem, I would be really
grateful.
Thanks again and best wishes
George
"jsh02_nova@.hotmail.com" wrote:
> George,
> I assume you are setting the Visible property of some web control that
> holds the value of your report parameter. You should set the Visibility
> Style of the control to 'hidden' so that it still gets rendered into the web
> form but is not 'seen' in the web browser. This way the controls value is
> still within the form and viewstate when the form is posted back.
> Hope I made the correct assumption and this helps.
> thx
> -jsh
> "George Davies" wrote:
> > I have an ASP.NET application with a page which has a Reportviewer control
> > linked to a Reporting Services report on a Remote Server. I pass parameters
> > into it OK including the name of the database which is then referenced by a
> > dynamic connection string. The database is the first parameter. Other
> > parameters have dropdown lists based on datasets using the dynamic connection
> > string.
> >
> > All of this works fine, but...
> >
> > When I hide some of the parameters, because I know what value is required,
> > the value is not acceoted, nor does the report use the default value. It is
> > as though hiding the parameter prevents the list of available values being
> > requeried; consequently the passed in value is ignored as it does not match
> > an available value!
> >
> > Can anyone help please?
> >
> > Thanks
> >
> > George

Disabled the automatic round of SQL SERVER 2000 on the float data type

Hello,

I have a problem with the round of SQL Server 2K on the float data type.

In my application I do a SQL request for find a row in a table of SQL Server 2K.

This is the request :

SELECT DISTINCT N_ROW_ID FROM COMM WHERE N_ARTICLE_ID=79510 AND N_DATASOURCE_ID=1 AND N_SOURCE_ID=-102 AND N_PROVIDER_ID=-100
AND N_LEAD_TIME IS NULL AND N_UNIT_PRICE = 329.78 AND N_UNIT_PRICE_CURRENCY_ID=1

N_UNIT_PRICE is a float data type.

In the line need, the field N_UNIT_PRICE has 329.78 but with the round of SQL Server 2K I have 329.779999999999997.

So I never find the row

Do you have a solution for comparate a float flied with SQL Server round and a float send in a request as my 329.78?

I can't transform the column in decimal or numeric data type.

Is it possible to Disable the function?

Regards

Floats are known as inexact or approximate datatypes. Due to the 'fuzzy' rounding, the same value may display slightly different every time you look at it.

Floats are not appropriate for any situation where you will have to search or index the value.

If your N_UNIT_PRICE is a float, you 'could' convert it to a decimal in the query. For example, this may work:

Code Snippet

SELECT DISTINCT
N_ROW_ID
FROM COMM
WHERE ( N_ARTICLE_ID = 79510
AND N_DATASOURCE_ID = 1
AND N_SOURCE_ID = -102
AND N_PROVIDER_ID = -100
AND N_LEAD_TIME IS NULL
AND cast( N_UNIT_PRICE AS decimal(10,2)) = 329.78
AND N_UNIT_PRICE_CURRENCY_ID = 1
)

|||As Arnie described this is no "function" as you mentioned, float datatypes only provide exact precision as you defined it on the column. The precision "floats" on the size of the value.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Disable the use of Enterprise Manager

I have created a new DB user, ABC, for using ASP.NET application to
connecting to SQL Server. Does it means this ABC user can logon in the
Enterprise Manager to view the data without using the web application' if
so, is there any way to block this ABC user from viewing data in Enterprise
Manager?> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application'
Yes.
> if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
No. I suggest you use stored procedures and only allow your users to execute the stored procedures.
You might also want to read about application roles...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Grey" <erickwyum@.i-cable.com> wrote in message news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application' if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
>|||TO add to Tibor's comments, if you really, really want that capability, use
Application roles. They allow you to give permission when access is via the
application, but the end user does NOT have a permissions, so he can not go
through SEM or query analyzer and see anything.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Grey" <erickwyum@.i-cable.com> wrote in message
news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application' if
> so, is there any way to block this ABC user from viewing data in
Enterprise
> Manager?
>

Disable the use of Enterprise Manager

I have created a new DB user, ABC, for using ASP.NET application to
connecting to SQL Server. Does it means this ABC user can logon in the
Enterprise Manager to view the data without using the web application? if
so, is there any way to block this ABC user from viewing data in Enterprise
Manager?
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application?
Yes.

> if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
No. I suggest you use stored procedures and only allow your users to execute the stored procedures.
You might also want to read about application roles...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Grey" <erickwyum@.i-cable.com> wrote in message news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application? if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
>
|||TO add to Tibor's comments, if you really, really want that capability, use
Application roles. They allow you to give permission when access is via the
application, but the end user does NOT have a permissions, so he can not go
through SEM or query analyzer and see anything.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Grey" <erickwyum@.i-cable.com> wrote in message
news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application? if
> so, is there any way to block this ABC user from viewing data in
Enterprise
> Manager?
>

disable log on user login events

my server is have user login (by services) 5~8 times per second, and all these events are logged in sql log and system application events log.
will this cause problem to the server? as each entry will cause a open/close action.
if yes, how can i disable them?Originally posted by timothymo
my server is have user login (by services) 5~8 times per second, and all these events are logged in sql log and system application events log.

will this cause problem to the server? as each entry will cause a open/close action.

if yes, how can i disable them?

Hi.... :)

Open / Close of DB file is not an issue its an configuration setting in Select DB Right click /Property / Options tab - Auto Close on-Off. This is to release the resource while DB is not in use. When any user use this DB the DB file will be opened.

If you don't want to use the login to be logged disable Server property / Security - Audit level (None or failure)

Cheers ,

Shaji

Disable Event Logging to Windows Application Log?

Hi,

We are starting to work with SSIS in our production environment & due to support issues; we are trying to get rid of the "Package xxx started" log entries inside of the Windows Application Event Log...

So far, I have tried many different things, including setting the LoggingMode to "Disabled", as well as adding a new logging reference with a different destination... All of which still do not get rid of the extra log entries...

Is this possible? & does anyone know how to get this done?

Thanks!

I am having this same problem. Have you had any luck with this?

I have LoggingMode disabled in the properties of the package, I don't have anything checked on the Configure SSIS Logs screen in the Containers list nor on the Providers and Logs tab and the Details tab. The packages are being run from a SQL Server Agent job.

Thanks.

Bobette

|||

I move the thread to SQL Server Tools general because this looks like and SQL Agent problem

Thanks,
Ovidiu

|||

Hi,

Unfortunately I still haven't found a way to get this accomplished... At least I'm not the only one with the same problem.. . :) Thanks Bobette..

For now, we are simply living with the problem & have built a custom app that queries the event log for error's only... But this isn't a solution, just a band-aid...

~James

|||

Hopefully someone that knows will find our posting here. Thanks for the quick reply!

bobette

|||

After I read your poost twice I realized this is a SSIS thing.

The current implementation will always post the "Package xxx started" event and there is no way to disable this message

Thanks,
Ovidiu Burlacu

|||

Thanks! At least I know to quit trying to figure it out.

Bobette

Disable Event Logging to Windows Application Log?

Hi,

We are starting to work with SSIS in our production environment & due to support issues; we are trying to get rid of the "Package xxx started" log entries inside of the Windows Application Event Log...

So far, I have tried many different things, including setting the LoggingMode to "Disabled", as well as adding a new logging reference with a different destination... All of which still do not get rid of the extra log entries...

Is this possible? & does anyone know how to get this done?

Thanks!

I am having this same problem. Have you had any luck with this?

I have LoggingMode disabled in the properties of the package, I don't have anything checked on the Configure SSIS Logs screen in the Containers list nor on the Providers and Logs tab and the Details tab. The packages are being run from a SQL Server Agent job.

Thanks.

Bobette

|||

I move the thread to SQL Server Tools general because this looks like and SQL Agent problem

Thanks,
Ovidiu

|||

Hi,

Unfortunately I still haven't found a way to get this accomplished... At least I'm not the only one with the same problem.. . :) Thanks Bobette..

For now, we are simply living with the problem & have built a custom app that queries the event log for error's only... But this isn't a solution, just a band-aid...

~James

|||

Hopefully someone that knows will find our posting here. Thanks for the quick reply!

bobette

|||

After I read your poost twice I realized this is a SSIS thing.

The current implementation will always post the "Package xxx started" event and there is no way to disable this message

Thanks,
Ovidiu Burlacu

|||

Thanks! At least I know to quit trying to figure it out.

Bobette

Disable Event Logging to Windows Application Log?

Hi,

We are starting to work with SSIS in our production environment & due to support issues; we are trying to get rid of the "Package xxx started" log entries inside of the Windows Application Event Log...

So far, I have tried many different things, including setting the LoggingMode to "Disabled", as well as adding a new logging reference with a different destination... All of which still do not get rid of the extra log entries...

Is this possible? & does anyone know how to get this done?

Thanks!

I am having this same problem. Have you had any luck with this?

I have LoggingMode disabled in the properties of the package, I don't have anything checked on the Configure SSIS Logs screen in the Containers list nor on the Providers and Logs tab and the Details tab. The packages are being run from a SQL Server Agent job.

Thanks.

Bobette

|||

I move the thread to SQL Server Tools general because this looks like and SQL Agent problem

Thanks,
Ovidiu

|||

Hi,

Unfortunately I still haven't found a way to get this accomplished... At least I'm not the only one with the same problem.. . :) Thanks Bobette..

For now, we are simply living with the problem & have built a custom app that queries the event log for error's only... But this isn't a solution, just a band-aid...

~James

|||

Hopefully someone that knows will find our posting here. Thanks for the quick reply!

bobette

|||

After I read your poost twice I realized this is a SSIS thing.

The current implementation will always post the "Package xxx started" event and there is no way to disable this message

Thanks,
Ovidiu Burlacu

|||

Thanks! At least I know to quit trying to figure it out.

Bobette