who knows's the cause of error: 'Caller of lock manager is trying to
unlock an unlocked object' . This error appears 200 time per second.
configuration: SQL 6.5 SP 5 / NT 4 SP6Check the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;175887, I think it
can help you.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"marijn" <mklijs@.ons.nl> wrote in message
news:d35da914.0307280159.7819b3a7@.posting.google.com...
> who knows's the cause of error: 'Caller of lock manager is trying to
> unlock an unlocked object' . This error appears 200 time per second.
> configuration: SQL 6.5 SP 5 / NT 4 SP6
Showing posts with label object. Show all posts
Showing posts with label object. Show all posts
Monday, March 19, 2012
Sunday, March 11, 2012
Error 1105
Following is the error message that we get when we try to
do some process:
Error No:1105
==========
Could not allocate space for object '(System table id:3)'
in database 'database name' because primary filegroup is
full.
sometimes we do get error like the one following:
Could not allocate new page for database 'database
name'.There are no more pages available in filegroup
Primary.
Space can be created by dropping objects,adding additional
files , or allowing filegrowth.
How do I handle this programatically.
I'm not sure exactly what you mean by 'handle programmatically' but, as the
error message states, you can set your data file to autogrow. This will
automatically expand the data file as needed, assuming you have available
disk space. However, for performance reasons, it is better to anticipate
space requirements and size the file accordingly.
Hope this helps.
Dan Guzman
SQL Server MVP
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========
> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>
|||We are using JDBC to connect SQL server.
JDBC driver provided in SQL server.
We create database from JDBC and specify initial size
while creating database.
Using JDBC driver autogrow option fails. All transaction
fails with auto grow option.
This is the reason we specify initial value.
When the more record are added to tables and grows to
size specified it works fine. After exceeding the
specified size or just before that
it gives Error 1105
Thanks in advance
Lakshmi.
>--Original Message--
>I'm not sure exactly what you mean by 'handle
programmatically' but, as the
>error message states, you can set your data file to
autogrow. This will
>automatically expand the data file as needed, assuming
you have available
>disk space. However, for performance reasons, it is
better to anticipate
>space requirements and size the file accordingly.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
to
id:3)'
additional
>
>.
>
|||You might try to use the
alter database alte file
command... It allows you to change file growth paramters for the database
programmatically.
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========
> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>
|||In addition to the initial size, you can specify the growth increment and
max size so that the file can grow automatically if needed. You can specify
this in your CREATE DATABASE statement or after database creation with ALTER
DATABASE as Wayne suggested.
Hope this helps.
Dan Guzman
SQL Server MVP
"lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:1882f01c42095$f8e54f10$a601280a@.phx.gbl...[color=darkblue]
> We are using JDBC to connect SQL server.
> JDBC driver provided in SQL server.
> We create database from JDBC and specify initial size
> while creating database.
> Using JDBC driver autogrow option fails. All transaction
> fails with auto grow option.
> This is the reason we specify initial value.
> When the more record are added to tables and grows to
> size specified it works fine. After exceeding the
> specified size or just before that
> it gives Error 1105
> Thanks in advance
> Lakshmi.
> programmatically' but, as the
> autogrow. This will
> you have available
> better to anticipate
> message
> to
> id:3)'
> additional
do some process:
Error No:1105
==========
Could not allocate space for object '(System table id:3)'
in database 'database name' because primary filegroup is
full.
sometimes we do get error like the one following:
Could not allocate new page for database 'database
name'.There are no more pages available in filegroup
Primary.
Space can be created by dropping objects,adding additional
files , or allowing filegrowth.
How do I handle this programatically.
I'm not sure exactly what you mean by 'handle programmatically' but, as the
error message states, you can set your data file to autogrow. This will
automatically expand the data file as needed, assuming you have available
disk space. However, for performance reasons, it is better to anticipate
space requirements and size the file accordingly.
Hope this helps.
Dan Guzman
SQL Server MVP
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========
> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>
|||We are using JDBC to connect SQL server.
JDBC driver provided in SQL server.
We create database from JDBC and specify initial size
while creating database.
Using JDBC driver autogrow option fails. All transaction
fails with auto grow option.
This is the reason we specify initial value.
When the more record are added to tables and grows to
size specified it works fine. After exceeding the
specified size or just before that
it gives Error 1105
Thanks in advance
Lakshmi.
>--Original Message--
>I'm not sure exactly what you mean by 'handle
programmatically' but, as the
>error message states, you can set your data file to
autogrow. This will
>automatically expand the data file as needed, assuming
you have available
>disk space. However, for performance reasons, it is
better to anticipate
>space requirements and size the file accordingly.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
to
id:3)'
additional
>
>.
>
|||You might try to use the
alter database alte file
command... It allows you to change file growth paramters for the database
programmatically.
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========
> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>
|||In addition to the initial size, you can specify the growth increment and
max size so that the file can grow automatically if needed. You can specify
this in your CREATE DATABASE statement or after database creation with ALTER
DATABASE as Wayne suggested.
Hope this helps.
Dan Guzman
SQL Server MVP
"lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:1882f01c42095$f8e54f10$a601280a@.phx.gbl...[color=darkblue]
> We are using JDBC to connect SQL server.
> JDBC driver provided in SQL server.
> We create database from JDBC and specify initial size
> while creating database.
> Using JDBC driver autogrow option fails. All transaction
> fails with auto grow option.
> This is the reason we specify initial value.
> When the more record are added to tables and grows to
> size specified it works fine. After exceeding the
> specified size or just before that
> it gives Error 1105
> Thanks in advance
> Lakshmi.
> programmatically' but, as the
> autogrow. This will
> you have available
> better to anticipate
> message
> to
> id:3)'
> additional
Error 1105
Following is the error message that we get when we try to
do some process:
Error No:1105
========== Could not allocate space for object '(System table id:3)'
in database 'database name' because primary filegroup is
full.
sometimes we do get error like the one following:
Could not allocate new page for database 'database
name'.There are no more pages available in filegroup
Primary.
Space can be created by dropping objects,adding additional
files , or allowing filegrowth.
How do I handle this programatically.I'm not sure exactly what you mean by 'handle programmatically' but, as the
error message states, you can set your data file to autogrow. This will
automatically expand the data file as needed, assuming you have available
disk space. However, for performance reasons, it is better to anticipate
space requirements and size the file accordingly.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||We are using JDBC to connect SQL server.
JDBC driver provided in SQL server.
We create database from JDBC and specify initial size
while creating database.
Using JDBC driver autogrow option fails. All transaction
fails with auto grow option.
This is the reason we specify initial value.
When the more record are added to tables and grows to
size specified it works fine. After exceeding the
specified size or just before that
it gives Error 1105
Thanks in advance
Lakshmi.
>--Original Message--
>I'm not sure exactly what you mean by 'handle
programmatically' but, as the
>error message states, you can set your data file to
autogrow. This will
>automatically expand the data file as needed, assuming
you have available
>disk space. However, for performance reasons, it is
better to anticipate
>space requirements and size the file accordingly.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
>> Following is the error message that we get when we try
to
>> do some process:
>> Error No:1105
>> ==========>> Could not allocate space for object '(System table
id:3)'
>> in database 'database name' because primary filegroup is
>> full.
>> sometimes we do get error like the one following:
>> Could not allocate new page for database 'database
>> name'.There are no more pages available in filegroup
>> Primary.
>> Space can be created by dropping objects,adding
additional
>> files , or allowing filegrowth.
>> How do I handle this programatically.
>
>.
>|||You might try to use the
alter database alte file
command... It allows you to change file growth paramters for the database
programmatically.
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||In addition to the initial size, you can specify the growth increment and
max size so that the file can grow automatically if needed. You can specify
this in your CREATE DATABASE statement or after database creation with ALTER
DATABASE as Wayne suggested.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:1882f01c42095$f8e54f10$a601280a@.phx.gbl...
> We are using JDBC to connect SQL server.
> JDBC driver provided in SQL server.
> We create database from JDBC and specify initial size
> while creating database.
> Using JDBC driver autogrow option fails. All transaction
> fails with auto grow option.
> This is the reason we specify initial value.
> When the more record are added to tables and grows to
> size specified it works fine. After exceeding the
> specified size or just before that
> it gives Error 1105
> Thanks in advance
> Lakshmi.
> >--Original Message--
> >I'm not sure exactly what you mean by 'handle
> programmatically' but, as the
> >error message states, you can set your data file to
> autogrow. This will
> >automatically expand the data file as needed, assuming
> you have available
> >disk space. However, for performance reasons, it is
> better to anticipate
> >space requirements and size the file accordingly.
> >
> >--
> >Hope this helps.
> >
> >Dan Guzman
> >SQL Server MVP
> >
> >"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> >> Following is the error message that we get when we try
> to
> >> do some process:
> >>
> >> Error No:1105
> >> ==========> >> Could not allocate space for object '(System table
> id:3)'
> >> in database 'database name' because primary filegroup is
> >> full.
> >> sometimes we do get error like the one following:
> >> Could not allocate new page for database 'database
> >> name'.There are no more pages available in filegroup
> >> Primary.
> >> Space can be created by dropping objects,adding
> additional
> >> files , or allowing filegrowth.
> >>
> >> How do I handle this programatically.
> >>
> >
> >
> >.
> >
do some process:
Error No:1105
========== Could not allocate space for object '(System table id:3)'
in database 'database name' because primary filegroup is
full.
sometimes we do get error like the one following:
Could not allocate new page for database 'database
name'.There are no more pages available in filegroup
Primary.
Space can be created by dropping objects,adding additional
files , or allowing filegrowth.
How do I handle this programatically.I'm not sure exactly what you mean by 'handle programmatically' but, as the
error message states, you can set your data file to autogrow. This will
automatically expand the data file as needed, assuming you have available
disk space. However, for performance reasons, it is better to anticipate
space requirements and size the file accordingly.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||We are using JDBC to connect SQL server.
JDBC driver provided in SQL server.
We create database from JDBC and specify initial size
while creating database.
Using JDBC driver autogrow option fails. All transaction
fails with auto grow option.
This is the reason we specify initial value.
When the more record are added to tables and grows to
size specified it works fine. After exceeding the
specified size or just before that
it gives Error 1105
Thanks in advance
Lakshmi.
>--Original Message--
>I'm not sure exactly what you mean by 'handle
programmatically' but, as the
>error message states, you can set your data file to
autogrow. This will
>automatically expand the data file as needed, assuming
you have available
>disk space. However, for performance reasons, it is
better to anticipate
>space requirements and size the file accordingly.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
>> Following is the error message that we get when we try
to
>> do some process:
>> Error No:1105
>> ==========>> Could not allocate space for object '(System table
id:3)'
>> in database 'database name' because primary filegroup is
>> full.
>> sometimes we do get error like the one following:
>> Could not allocate new page for database 'database
>> name'.There are no more pages available in filegroup
>> Primary.
>> Space can be created by dropping objects,adding
additional
>> files , or allowing filegrowth.
>> How do I handle this programatically.
>
>.
>|||You might try to use the
alter database alte file
command... It allows you to change file growth paramters for the database
programmatically.
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||In addition to the initial size, you can specify the growth increment and
max size so that the file can grow automatically if needed. You can specify
this in your CREATE DATABASE statement or after database creation with ALTER
DATABASE as Wayne suggested.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:1882f01c42095$f8e54f10$a601280a@.phx.gbl...
> We are using JDBC to connect SQL server.
> JDBC driver provided in SQL server.
> We create database from JDBC and specify initial size
> while creating database.
> Using JDBC driver autogrow option fails. All transaction
> fails with auto grow option.
> This is the reason we specify initial value.
> When the more record are added to tables and grows to
> size specified it works fine. After exceeding the
> specified size or just before that
> it gives Error 1105
> Thanks in advance
> Lakshmi.
> >--Original Message--
> >I'm not sure exactly what you mean by 'handle
> programmatically' but, as the
> >error message states, you can set your data file to
> autogrow. This will
> >automatically expand the data file as needed, assuming
> you have available
> >disk space. However, for performance reasons, it is
> better to anticipate
> >space requirements and size the file accordingly.
> >
> >--
> >Hope this helps.
> >
> >Dan Guzman
> >SQL Server MVP
> >
> >"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> >> Following is the error message that we get when we try
> to
> >> do some process:
> >>
> >> Error No:1105
> >> ==========> >> Could not allocate space for object '(System table
> id:3)'
> >> in database 'database name' because primary filegroup is
> >> full.
> >> sometimes we do get error like the one following:
> >> Could not allocate new page for database 'database
> >> name'.There are no more pages available in filegroup
> >> Primary.
> >> Space can be created by dropping objects,adding
> additional
> >> files , or allowing filegrowth.
> >>
> >> How do I handle this programatically.
> >>
> >
> >
> >.
> >
Error 1105
Following is the error message that we get when we try to
do some process:
Error No:1105
==========
Could not allocate space for object '(System table id:3)'
in database 'database name' because primary filegroup is
full.
sometimes we do get error like the one following:
Could not allocate new page for database 'database
name'.There are no more pages available in filegroup
Primary.
Space can be created by dropping objects,adding additional
files , or allowing filegrowth.
How do I handle this programatically.I'm not sure exactly what you mean by 'handle programmatically' but, as the
error message states, you can set your data file to autogrow. This will
automatically expand the data file as needed, assuming you have available
disk space. However, for performance reasons, it is better to anticipate
space requirements and size the file accordingly.
Hope this helps.
Dan Guzman
SQL Server MVP
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx
.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========
> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||We are using JDBC to connect SQL server.
JDBC driver provided in SQL server.
We create database from JDBC and specify initial size
while creating database.
Using JDBC driver autogrow option fails. All transaction
fails with auto grow option.
This is the reason we specify initial value.
When the more record are added to tables and grows to
size specified it works fine. After exceeding the
specified size or just before that
it gives Error 1105
Thanks in advance
Lakshmi.
>--Original Message--
>I'm not sure exactly what you mean by 'handle
programmatically' but, as the
>error message states, you can set your data file to
autogrow. This will
>automatically expand the data file as needed, assuming
you have available
>disk space. However, for performance reasons, it is
better to anticipate
>space requirements and size the file accordingly.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
message
> news:16c9101c4208d$d56c5220$a001280a@.phx
.gbl...
to
id:3)'
additional
>
>.
>|||You might try to use the
alter database alte file
command... It allows you to change file growth paramters for the database
programmatically.
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx
.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========
> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||In addition to the initial size, you can specify the growth increment and
max size so that the file can grow automatically if needed. You can specify
this in your CREATE DATABASE statement or after database creation with ALTER
DATABASE as Wayne suggested.
Hope this helps.
Dan Guzman
SQL Server MVP
"lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:1882f01c42095$f8e54f10$a601280a@.phx
.gbl...
> We are using JDBC to connect SQL server.
> JDBC driver provided in SQL server.
> We create database from JDBC and specify initial size
> while creating database.
> Using JDBC driver autogrow option fails. All transaction
> fails with auto grow option.
> This is the reason we specify initial value.
> When the more record are added to tables and grows to
> size specified it works fine. After exceeding the
> specified size or just before that
> it gives Error 1105
> Thanks in advance
> Lakshmi.
> programmatically' but, as the
> autogrow. This will
> you have available
> better to anticipate
> message
> to
> id:3)'
> additional
do some process:
Error No:1105
==========
Could not allocate space for object '(System table id:3)'
in database 'database name' because primary filegroup is
full.
sometimes we do get error like the one following:
Could not allocate new page for database 'database
name'.There are no more pages available in filegroup
Primary.
Space can be created by dropping objects,adding additional
files , or allowing filegrowth.
How do I handle this programatically.I'm not sure exactly what you mean by 'handle programmatically' but, as the
error message states, you can set your data file to autogrow. This will
automatically expand the data file as needed, assuming you have available
disk space. However, for performance reasons, it is better to anticipate
space requirements and size the file accordingly.
Hope this helps.
Dan Guzman
SQL Server MVP
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx
.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========
> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||We are using JDBC to connect SQL server.
JDBC driver provided in SQL server.
We create database from JDBC and specify initial size
while creating database.
Using JDBC driver autogrow option fails. All transaction
fails with auto grow option.
This is the reason we specify initial value.
When the more record are added to tables and grows to
size specified it works fine. After exceeding the
specified size or just before that
it gives Error 1105
Thanks in advance
Lakshmi.
>--Original Message--
>I'm not sure exactly what you mean by 'handle
programmatically' but, as the
>error message states, you can set your data file to
autogrow. This will
>automatically expand the data file as needed, assuming
you have available
>disk space. However, for performance reasons, it is
better to anticipate
>space requirements and size the file accordingly.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
message
> news:16c9101c4208d$d56c5220$a001280a@.phx
.gbl...
to
id:3)'
additional
>
>.
>|||You might try to use the
alter database alte file
command... It allows you to change file growth paramters for the database
programmatically.
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx
.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========
> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||In addition to the initial size, you can specify the growth increment and
max size so that the file can grow automatically if needed. You can specify
this in your CREATE DATABASE statement or after database creation with ALTER
DATABASE as Wayne suggested.
Hope this helps.
Dan Guzman
SQL Server MVP
"lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:1882f01c42095$f8e54f10$a601280a@.phx
.gbl...
> We are using JDBC to connect SQL server.
> JDBC driver provided in SQL server.
> We create database from JDBC and specify initial size
> while creating database.
> Using JDBC driver autogrow option fails. All transaction
> fails with auto grow option.
> This is the reason we specify initial value.
> When the more record are added to tables and grows to
> size specified it works fine. After exceeding the
> specified size or just before that
> it gives Error 1105
> Thanks in advance
> Lakshmi.
> programmatically' but, as the
> autogrow. This will
> you have available
> better to anticipate
> message
> to
> id:3)'
> additional
Friday, March 9, 2012
Error 1038: Cannot use empty object or coymn names.Use a single sp
hi,
in SQL server, when list down the databases, there is a database without any
name.
also, when i click on the properties option of any other databases, i get
the following error : "Error 1038: Cannot use empty object or coymn names.
Use a single space if necessary".
I am not able to delete the unnamed database.
can any body suggest what to do in this case.
thanks and Regards
Jagminder
just try this in the Query Analyser
sp_renamedb '', 'new_name'
drop database new_name
please let me know, if it worked.
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
"Jagminder Chugh" wrote:
> hi,
> in SQL server, when list down the databases, there is a database without any
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder
|||Hi,
Try issuing the below command:-
DROP DATABASE []
or
DROP DATABASE [ ]
Thanks
Hari
SQL Server MVP
"Jagminder Chugh" <JagminderChugh@.discussions.microsoft.com> wrote in
message news:AB972FBE-58DF-4473-8807-497DB9F7A45B@.microsoft.com...
> hi,
> in SQL server, when list down the databases, there is a database without
> any
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder
in SQL server, when list down the databases, there is a database without any
name.
also, when i click on the properties option of any other databases, i get
the following error : "Error 1038: Cannot use empty object or coymn names.
Use a single space if necessary".
I am not able to delete the unnamed database.
can any body suggest what to do in this case.
thanks and Regards
Jagminder
just try this in the Query Analyser
sp_renamedb '', 'new_name'
drop database new_name
please let me know, if it worked.
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
"Jagminder Chugh" wrote:
> hi,
> in SQL server, when list down the databases, there is a database without any
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder
|||Hi,
Try issuing the below command:-
DROP DATABASE []
or
DROP DATABASE [ ]
Thanks
Hari
SQL Server MVP
"Jagminder Chugh" <JagminderChugh@.discussions.microsoft.com> wrote in
message news:AB972FBE-58DF-4473-8807-497DB9F7A45B@.microsoft.com...
> hi,
> in SQL server, when list down the databases, there is a database without
> any
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder
Error 1038: Cannot use empty object or coymn names.Use a single sp
hi,
in SQL server, when list down the databases, there is a database without any
name.
also, when i click on the properties option of any other databases, i get
the following error : "Error 1038: Cannot use empty object or coymn names.
Use a single space if necessary".
I am not able to delete the unnamed database.
can any body suggest what to do in this case.
thanks and Regards
Jagminderjust try this in the Query Analyser
sp_renamedb '', 'new_name'
drop database new_name
please let me know, if it worked.
--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Jagminder Chugh" wrote:
> hi,
> in SQL server, when list down the databases, there is a database without any
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder|||Hi,
Try issuing the below command:-
DROP DATABASE []
or
DROP DATABASE [ ]
Thanks
Hari
SQL Server MVP
"Jagminder Chugh" <JagminderChugh@.discussions.microsoft.com> wrote in
message news:AB972FBE-58DF-4473-8807-497DB9F7A45B@.microsoft.com...
> hi,
> in SQL server, when list down the databases, there is a database without
> any
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder|||hi
thanks for your reply
i tried it but did not work...its giving the same error.
can you suggest some other alternative
Jagminder
"Chandra" wrote:
> just try this in the Query Analyser
> sp_renamedb '', 'new_name'
> drop database new_name
> please let me know, if it worked.
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://groups.msn.com/SQLResource/
> ---
>
> "Jagminder Chugh" wrote:
> > hi,
> >
> > in SQL server, when list down the databases, there is a database without any
> > name.
> > also, when i click on the properties option of any other databases, i get
> > the following error : "Error 1038: Cannot use empty object or coymn names.
> > Use a single space if necessary".
> >
> > I am not able to delete the unnamed database.
> >
> > can any body suggest what to do in this case.
> >
> > thanks and Regards
> >
> > Jagminder|||hi
i tried
dropdatabase [ ] and it worked.
thanks for the reply
regards
Jagminder Chugh
IT Consultant
"Chandra" wrote:
> just try this in the Query Analyser
> sp_renamedb '', 'new_name'
> drop database new_name
> please let me know, if it worked.
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://groups.msn.com/SQLResource/
> ---
>
> "Jagminder Chugh" wrote:
> > hi,
> >
> > in SQL server, when list down the databases, there is a database without any
> > name.
> > also, when i click on the properties option of any other databases, i get
> > the following error : "Error 1038: Cannot use empty object or coymn names.
> > Use a single space if necessary".
> >
> > I am not able to delete the unnamed database.
> >
> > can any body suggest what to do in this case.
> >
> > thanks and Regards
> >
> > Jagminder
in SQL server, when list down the databases, there is a database without any
name.
also, when i click on the properties option of any other databases, i get
the following error : "Error 1038: Cannot use empty object or coymn names.
Use a single space if necessary".
I am not able to delete the unnamed database.
can any body suggest what to do in this case.
thanks and Regards
Jagminderjust try this in the Query Analyser
sp_renamedb '', 'new_name'
drop database new_name
please let me know, if it worked.
--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Jagminder Chugh" wrote:
> hi,
> in SQL server, when list down the databases, there is a database without any
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder|||Hi,
Try issuing the below command:-
DROP DATABASE []
or
DROP DATABASE [ ]
Thanks
Hari
SQL Server MVP
"Jagminder Chugh" <JagminderChugh@.discussions.microsoft.com> wrote in
message news:AB972FBE-58DF-4473-8807-497DB9F7A45B@.microsoft.com...
> hi,
> in SQL server, when list down the databases, there is a database without
> any
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder|||hi
thanks for your reply
i tried it but did not work...its giving the same error.
can you suggest some other alternative
Jagminder
"Chandra" wrote:
> just try this in the Query Analyser
> sp_renamedb '', 'new_name'
> drop database new_name
> please let me know, if it worked.
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://groups.msn.com/SQLResource/
> ---
>
> "Jagminder Chugh" wrote:
> > hi,
> >
> > in SQL server, when list down the databases, there is a database without any
> > name.
> > also, when i click on the properties option of any other databases, i get
> > the following error : "Error 1038: Cannot use empty object or coymn names.
> > Use a single space if necessary".
> >
> > I am not able to delete the unnamed database.
> >
> > can any body suggest what to do in this case.
> >
> > thanks and Regards
> >
> > Jagminder|||hi
i tried
dropdatabase [ ] and it worked.
thanks for the reply
regards
Jagminder Chugh
IT Consultant
"Chandra" wrote:
> just try this in the Query Analyser
> sp_renamedb '', 'new_name'
> drop database new_name
> please let me know, if it worked.
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://groups.msn.com/SQLResource/
> ---
>
> "Jagminder Chugh" wrote:
> > hi,
> >
> > in SQL server, when list down the databases, there is a database without any
> > name.
> > also, when i click on the properties option of any other databases, i get
> > the following error : "Error 1038: Cannot use empty object or coymn names.
> > Use a single space if necessary".
> >
> > I am not able to delete the unnamed database.
> >
> > can any body suggest what to do in this case.
> >
> > thanks and Regards
> >
> > Jagminder
Error 1038: Cannot use empty object or coymn names.Use a single sp
hi,
in SQL server, when list down the databases, there is a database without any
name.
also, when i click on the properties option of any other databases, i get
the following error : "Error 1038: Cannot use empty object or coymn names.
Use a single space if necessary".
I am not able to delete the unnamed database.
can any body suggest what to do in this case.
thanks and Regards
Jagminderjust try this in the Query Analyser
sp_renamedb '', 'new_name'
drop database new_name
please let me know, if it worked.
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Jagminder Chugh" wrote:
> hi,
> in SQL server, when list down the databases, there is a database without a
ny
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder|||Hi,
Try issuing the below command:-
DROP DATABASE []
or
DROP DATABASE [ ]
Thanks
Hari
SQL Server MVP
"Jagminder Chugh" <JagminderChugh@.discussions.microsoft.com> wrote in
message news:AB972FBE-58DF-4473-8807-497DB9F7A45B@.microsoft.com...
> hi,
> in SQL server, when list down the databases, there is a database without
> any
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder
in SQL server, when list down the databases, there is a database without any
name.
also, when i click on the properties option of any other databases, i get
the following error : "Error 1038: Cannot use empty object or coymn names.
Use a single space if necessary".
I am not able to delete the unnamed database.
can any body suggest what to do in this case.
thanks and Regards
Jagminderjust try this in the Query Analyser
sp_renamedb '', 'new_name'
drop database new_name
please let me know, if it worked.
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Jagminder Chugh" wrote:
> hi,
> in SQL server, when list down the databases, there is a database without a
ny
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder|||Hi,
Try issuing the below command:-
DROP DATABASE []
or
DROP DATABASE [ ]
Thanks
Hari
SQL Server MVP
"Jagminder Chugh" <JagminderChugh@.discussions.microsoft.com> wrote in
message news:AB972FBE-58DF-4473-8807-497DB9F7A45B@.microsoft.com...
> hi,
> in SQL server, when list down the databases, there is a database without
> any
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder
Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect
Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the Account property cannot be empty. 0 0
I am getting the above error when I am trying to deploy my objects.
I am trying to deploy this on a named sql 2005 server. The host also have named sql 2000 instance.Search "Impersonation Information" in the Help.
I suggest use "Defualt" for quick fix.
Quoted from the help:
Use the Impersonation Information dialog box to provide information about the security credentials used by the Analysis Services object. You can display the Impersonation Information dialog box by:
Clicking the ellipsis (...) of the Data Source Impersonation Info property in the Database Properties dialog box of SQL Server Management Studio.Clicking the ellipsis (...) of the Impersonation Info property in the Assembly Properties dialog box of SQL Server Management Studio.|||Hi,
In your project when you double click the Data Source object, you will see Data Source Designer screen.
Open Impersonation tab and check the user name and the password fields.
After corrections on this screen, you will probably deploy your project successfully.
Eralper
http://www.kodyaz.com|||
Hi,
thanks a lot for the suggession. This is working perfectly.
good show.
Swami.
|||Thanks a lot, your help is very usefull.
I want to add that in the spanish version of sql server anylisis services the translation for Impersonation is "Suplantacion", what is not very proper. Anyway for spanish version of sql you have to look for "Informacion de Suplantacion" in "Origenes de Datos" properties.
Espero que ayude.
Saludos
Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect
Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the Account property cannot be empty. 0 0
I am getting the above error when I am trying to deploy my objects.
I am trying to deploy this on a named sql 2005 server. The host also have named sql 2000 instance.Search "Impersonation Information" in the Help.
I suggest use "Defualt" for quick fix.
Quoted from the help:
Use the Impersonation Information dialog box to provide information about the security credentials used by the Analysis Services object. You can display the Impersonation Information dialog box by:
Clicking the ellipsis (...) of the Data Source Impersonation Info property in the Database Properties dialog box of SQL Server Management Studio.Clicking the ellipsis (...) of the Impersonation Info property in the Assembly Properties dialog box of SQL Server Management Studio.|||Hi,
In your project when you double click the Data Source object, you will see Data Source Designer screen.
Open Impersonation tab and check the user name and the password fields.
After corrections on this screen, you will probably deploy your project successfully.
Eralper
http://www.kodyaz.com|||
Hi,
thanks a lot for the suggession. This is working perfectly.
good show.
Swami.
|||Thanks a lot, your help is very usefull.
I want to add that in the spanish version of sql server anylisis services the translation for Impersonation is "Suplantacion", what is not very proper. Anyway for spanish version of sql you have to look for "Informacion de Suplantacion" in "Origenes de Datos" properties.
Espero que ayude.
Saludos
Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect
Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the Account property cannot be empty. 0 0
I am getting the above error when I am trying to deploy my objects.
I am trying to deploy this on a named sql 2005 server. The host also have named sql 2000 instance.
Search "Impersonation Information" in the Help.
I suggest use "Defualt" for quick fix.
Quoted from the help:
Use the Impersonation Information dialog box to provide information about the security credentials used by the Analysis Services object. You can display the Impersonation Information dialog box by:
Clicking the ellipsis (...) of the Data Source Impersonation Info property in the Database Properties dialog box of SQL Server Management Studio.Clicking the ellipsis (...) of the Impersonation Info property in the Assembly Properties dialog box of SQL Server Management Studio.|||Hi,
In your project when you double click the Data Source object, you will see Data Source Designer screen.
Open Impersonation tab and check the user name and the password fields.
After corrections on this screen, you will probably deploy your project successfully.
Eralper
http://www.kodyaz.com|||
Hi,
thanks a lot for the suggession. This is working perfectly.
good show.
Swami.
|||Thanks a lot, your help is very usefull.
I want to add that in the spanish version of sql server anylisis services the translation for Impersonation is "Suplantacion", what is not very proper. Anyway for spanish version of sql you have to look for "Informacion de Suplantacion" in "Origenes de Datos" properties.
Espero que ayude.
Saludos
Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect
Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the Account property cannot be empty. 0 0
I am getting the above error when I am trying to deploy my objects.
I am trying to deploy this on a named sql 2005 server. The host also have named sql 2000 instance.
Search "Impersonation Information" in the Help.
I suggest use "Defualt" for quick fix.
Quoted from the help:
Use the Impersonation Information dialog box to provide information about the security credentials used by the Analysis Services object. You can display the Impersonation Information dialog box by:
Clicking the ellipsis (...) of the Data Source Impersonation Info property in the Database Properties dialog box of SQL Server Management Studio.Clicking the ellipsis (...) of the Impersonation Info property in the Assembly Properties dialog box of SQL Server Management Studio.|||Hi,
In your project when you double click the Data Source object, you will see Data Source Designer screen.
Open Impersonation tab and check the user name and the password fields.
After corrections on this screen, you will probably deploy your project successfully.
Eralper
http://www.kodyaz.com|||
Hi,
thanks a lot for the suggession. This is working perfectly.
good show.
Swami.
|||Thanks a lot, your help is very usefull.
I want to add that in the spanish version of sql server anylisis services the translation for Impersonation is "Suplantacion", what is not very proper. Anyway for spanish version of sql you have to look for "Informacion de Suplantacion" in "Origenes de Datos" properties.
Espero que ayude.
Saludos
Friday, February 24, 2012
Error "System.NullReferenceException" on Update
Hello Everyone,
I am getting this error "System.NullReferenceException: Object reference not set to an instance of an object." when i try to run the update query as in my following code.
When the new record condition is true then the code runs absolutely fine and inserts a new record to the database. However, when it goes in the edit mode to update the record it gives an error at '## ERROR POINT FOR THE UPDATE QUERY'. Why is this happening. i have attached the portion of my code below for refernce. Can someone please help me with this? Where am i going wrong. Seems like update query has a problem.
'-------------------------------
If mode = "edit" Then
insertSql = "update [Customer Info] set [Company Name]=@.CompanyName, [Business Type]=@.BusinessSector, [Address Line 1]=@.AddressLine1, [Address Line 2]=@.AddressLine2, [Address Line 3] = @.AddressLine3, [Town] = @.Town, [County]= @.County, [Post Code]=@.PostCode, [Country]=@.Country, [Telephone]=@.Telephone, [Fax]=@.Fax, [Email Address]=@.Email, [Contact Person]=@.ContactPerson, [Job Title]=@.JobTitle, [Website Address]=@.WebsiteAddress Where [Customer ID] = " & Request.QueryString("custid")
else
insertSql = "insert into [Customer Info] ([Customer ID], [Company Name], [Business Type], [Address Line 1], [Address Line 2], [Address Line 3], [Town], [County], [Post Code], [Country], [Telephone], [Fax], [Email Address], [Contact Person], [Job Title],[Website Address])"
insertSql = insertSql & " values (@.CustomerIDSq, @.CompanyName, @.BusinessSector, @.AddressLine1, @.AddressLine2, @.AddressLine3, @.Town, @.County, @.PostCode, @.Country, @.Telephone, @.Fax, @.Email, @.ContactPerson, @.JobTitle, @.WebsiteAddress)"
end if
objConn.open()
objCommand.CommandText = insertSql '## ERROR POINT FOR THE UPDATE QUERY
objCommand.Connection = objConn
objCommand.Parameters.Add("@.CustomerIDSq", SqlDbType.Int).Value = CustomerID
objCommand.Parameters.Add("@.CompanyName", SqlDbType.VarChar).Value = Trim(txtCompanyName.Text)
objCommand.Parameters.Add("@.BusinessSector", SqlDbType.Int).Value = BusinessSector
objCommand.Parameters.Add("@.AddressLine1", SqlDbType.VarChar).Value = Trim(txtAddressLine1.Text)
objCommand.Parameters.Add("@.AddressLine2", SqlDbType.VarChar).Value = Trim(txtAddressLine2.Text)
objCommand.Parameters.Add("@.AddressLine3", SqlDbType.VarChar).Value = Trim(txtAddressLine3.Text)
objCommand.Parameters.Add("@.Town", SqlDbType.VarChar).Value = Trim(txtTown.Text)
objCommand.Parameters.Add("@.County", SqlDbType.VarChar).Value = Trim(txtCounty.Text)
objCommand.Parameters.Add("@.PostCode", SqlDbType.VarChar).Value = Trim(txtPostCode.Text)
objCommand.Parameters.Add("@.Country", SqlDbType.VarChar).Value = Trim(txtCountry.Text)
objCommand.Parameters.Add("@.Telephone", SqlDbType.VarChar).Value = Trim(txtTelephone.Text)
objCommand.Parameters.Add("@.Fax", SqlDbType.VarChar).Value = Trim(txtFax.Text)
objCommand.Parameters.Add("@.Email", SqlDbType.VarChar).Value = Trim(txtEmail.Text)
objCommand.Parameters.Add("@.ContactPerson", SqlDbType.VarChar).Value = Trim(txtContactPerson.Text)
objCommand.Parameters.Add("@.JobTitle", SqlDbType.VarChar).Value = Trim(txtJobTitle.Text)
objCommand.Parameters.Add("@.WebsiteAddress", SqlDbType.VarChar).Value = Trim(txtWebsiteAddress.Text)
objCommand.executeNonQuery()
objConn.close()
'-------------------------------
Thanks,
SimShow us where you instantiate (new) the objCommand. That is likely the problem.|||Yea, that was the problem. i was not instantiating the command object. Now i did it and it is running very fine.
Thanks You very much, how these small things gets me.. i dunno.. :o.
Sim
Error "-2147168246 (8004d00a)" Failed to Enlist on Calling Object'
I checked what suggested with
http://support.microsoft.com/default.aspx?scid=kb;en-us;191168.
The pingtest results are OK.
Is there any other check to do in order to solve this problem?
Thanks,
LucaHi
What about the other suggestions in the 191168 or
http://support.microsoft.com/kb/193893/EN-US/
Which version of MDAC are you using?
Are you using Oracle?
John
"lalberti" <lalberti@.discussions.microsoft.com> wrote in message
news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
>I checked what suggested with
> http://support.microsoft.com/default.aspx?scid=kb;en-us;191168.
> The pingtest results are OK.
> Is there any other check to do in order to solve this problem?
> Thanks,
> Luca|||At the moment I'm out of office and I don't know exactly which MDAC version
I'm using on client & server side.
Anyway I'm not using ORACLE...my problem is with SQLServer...
Luca
"John Bell" wrote:
> Hi
> What about the other suggestions in the 191168 or
> http://support.microsoft.com/kb/193893/EN-US/
> Which version of MDAC are you using?
> Are you using Oracle?
> John
> "lalberti" <lalberti@.discussions.microsoft.com> wrote in message
> news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
> >I checked what suggested with
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;191168.
> > The pingtest results are OK.
> > Is there any other check to do in order to solve this problem?
> > Thanks,
> > Luca
>
>|||I get the exact same error, only after applying SP1 to the Windows 2003
Server running our SQL Server 2000 SP3 database server. Transactions from
our Windows 2000 Server SP4 application server give the same exact error. It
is basically a VB application trying to connect to the application database.
Ping tests work fine. DTC tests fail with same error.
"John Bell" wrote:
> Hi
> What about the other suggestions in the 191168 or
> http://support.microsoft.com/kb/193893/EN-US/
> Which version of MDAC are you using?
> Are you using Oracle?
> John
> "lalberti" <lalberti@.discussions.microsoft.com> wrote in message
> news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
> >I checked what suggested with
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;191168.
> > The pingtest results are OK.
> > Is there any other check to do in order to solve this problem?
> > Thanks,
> > Luca
>
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;191168.
The pingtest results are OK.
Is there any other check to do in order to solve this problem?
Thanks,
LucaHi
What about the other suggestions in the 191168 or
http://support.microsoft.com/kb/193893/EN-US/
Which version of MDAC are you using?
Are you using Oracle?
John
"lalberti" <lalberti@.discussions.microsoft.com> wrote in message
news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
>I checked what suggested with
> http://support.microsoft.com/default.aspx?scid=kb;en-us;191168.
> The pingtest results are OK.
> Is there any other check to do in order to solve this problem?
> Thanks,
> Luca|||At the moment I'm out of office and I don't know exactly which MDAC version
I'm using on client & server side.
Anyway I'm not using ORACLE...my problem is with SQLServer...
Luca
"John Bell" wrote:
> Hi
> What about the other suggestions in the 191168 or
> http://support.microsoft.com/kb/193893/EN-US/
> Which version of MDAC are you using?
> Are you using Oracle?
> John
> "lalberti" <lalberti@.discussions.microsoft.com> wrote in message
> news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
> >I checked what suggested with
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;191168.
> > The pingtest results are OK.
> > Is there any other check to do in order to solve this problem?
> > Thanks,
> > Luca
>
>|||I get the exact same error, only after applying SP1 to the Windows 2003
Server running our SQL Server 2000 SP3 database server. Transactions from
our Windows 2000 Server SP4 application server give the same exact error. It
is basically a VB application trying to connect to the application database.
Ping tests work fine. DTC tests fail with same error.
"John Bell" wrote:
> Hi
> What about the other suggestions in the 191168 or
> http://support.microsoft.com/kb/193893/EN-US/
> Which version of MDAC are you using?
> Are you using Oracle?
> John
> "lalberti" <lalberti@.discussions.microsoft.com> wrote in message
> news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
> >I checked what suggested with
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;191168.
> > The pingtest results are OK.
> > Is there any other check to do in order to solve this problem?
> > Thanks,
> > Luca
>
>
Error "-2147168246 (8004d00a)" Failed to Enlist on Calling Object'
I checked what suggested with
http://support.microsoft.com/defaul...b;en-us;191168.
The pingtest results are OK.
Is there any other check to do in order to solve this problem?
Thanks,
LucaHi
What about the other suggestions in the 191168 or
http://support.microsoft.com/kb/193893/EN-US/
Which version of MDAC are you using?
Are you using Oracle?
John
"lalberti" <lalberti@.discussions.microsoft.com> wrote in message
news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
>I checked what suggested with
> http://support.microsoft.com/defaul...b;en-us;191168.
> The pingtest results are OK.
> Is there any other check to do in order to solve this problem?
> Thanks,
> Luca
http://support.microsoft.com/defaul...b;en-us;191168.
The pingtest results are OK.
Is there any other check to do in order to solve this problem?
Thanks,
LucaHi
What about the other suggestions in the 191168 or
http://support.microsoft.com/kb/193893/EN-US/
Which version of MDAC are you using?
Are you using Oracle?
John
"lalberti" <lalberti@.discussions.microsoft.com> wrote in message
news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
>I checked what suggested with
> http://support.microsoft.com/defaul...b;en-us;191168.
> The pingtest results are OK.
> Is there any other check to do in order to solve this problem?
> Thanks,
> Luca
Error "-2147168246 (8004d00a)" Failed to Enlist on Calling Object'
I checked what suggested with
http://support.microsoft.com/default...;en-us;191168.
The pingtest results are OK.
Is there any other check to do in order to solve this problem?
Thanks,
Luca
Hi
What about the other suggestions in the 191168 or
http://support.microsoft.com/kb/193893/EN-US/
Which version of MDAC are you using?
Are you using Oracle?
John
"lalberti" <lalberti@.discussions.microsoft.com> wrote in message
news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
>I checked what suggested with
> http://support.microsoft.com/default...;en-us;191168.
> The pingtest results are OK.
> Is there any other check to do in order to solve this problem?
> Thanks,
> Luca
http://support.microsoft.com/default...;en-us;191168.
The pingtest results are OK.
Is there any other check to do in order to solve this problem?
Thanks,
Luca
Hi
What about the other suggestions in the 191168 or
http://support.microsoft.com/kb/193893/EN-US/
Which version of MDAC are you using?
Are you using Oracle?
John
"lalberti" <lalberti@.discussions.microsoft.com> wrote in message
news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
>I checked what suggested with
> http://support.microsoft.com/default...;en-us;191168.
> The pingtest results are OK.
> Is there any other check to do in order to solve this problem?
> Thanks,
> Luca
Error ! SQL XML Bulkload Please help
Hi guys
I am running COM component from SQL server jobs.
The COM component uses SQLXML bulk object to copy the data to SQL server.
I do get following error. The error comes some times only some. It is not consistant
can anyone tell me why it is happening some times only and how to resolve it
thanks in advance
error :-
Executed as user: myserver\Administrator. Error Code: 0 Error Source= Microsoft XML Bulkload for SQL Server Error Description: The error log file could not be created. Make sure you have the appropriate permissions and that the ErrorLogFilePath is valid
. Error on Line 1. The step failed.
Did you check the obvious permission and size issues for the log file
location?
Thanks
Michael
"Nitin" <Nitin@.discussions.microsoft.com> wrote in message
news:D780E0E2-3FA2-4F6B-BFFD-987E528682C8@.microsoft.com...
> Hi guys
> I am running COM component from SQL server jobs.
> The COM component uses SQLXML bulk object to copy the data to SQL server.
> I do get following error. The error comes some times only some. It is not
> consistant
> can anyone tell me why it is happening some times only and how to resolve
> it
> thanks in advance
> error :-
> Executed as user: myserver\Administrator. Error Code: 0 Error Source=
> Microsoft XML Bulkload for SQL Server Error Description: The error log
> file could not be created. Make sure you have the appropriate permissions
> and that the ErrorLogFilePath is valid. Error on Line 1. The step
> failed.
|||Yes
I did check the permission and size thats not the problem
funny thing is that if i run the job explicitly it does runs properly but if i schedule it to run automatically it gives me this error
thanks
Nitin
"Michael Rys [MSFT]" wrote:
> Did you check the obvious permission and size issues for the log file
> location?
> Thanks
> Michael
> "Nitin" <Nitin@.discussions.microsoft.com> wrote in message
> news:D780E0E2-3FA2-4F6B-BFFD-987E528682C8@.microsoft.com...
>
>
|||This sounds like you run the scheduled job with less permissions than when
you do. Is the scheduled job running as a different user?
Michael
"Nitin" <Nitin@.discussions.microsoft.com> wrote in message
news:C6033E80-4C72-44D5-B59C-3B750EE27C23@.microsoft.com...[vbcol=seagreen]
> Yes
> I did check the permission and size thats not the problem
> funny thing is that if i run the job explicitly it does runs properly but
> if i schedule it to run automatically it gives me this error
> thanks
> Nitin
> "Michael Rys [MSFT]" wrote:
|||Hi Michael
The schedule job gets run by SQL server Agent and the SQL server agent is running under administrator user. The SQL server job is calling is COM+ (in which i am using SQLXML bulkupload) and it runs under seperate user which has also got the administrator
permission. I dont know this happens some times only.
thanks for your kind support
Nitin
"Michael Rys [MSFT]" wrote:
> This sounds like you run the scheduled job with less permissions than when
> you do. Is the scheduled job running as a different user?
> Michael
> "Nitin" <Nitin@.discussions.microsoft.com> wrote in message
> news:C6033E80-4C72-44D5-B59C-3B750EE27C23@.microsoft.com...
>
>
|||Hi Michael
The schedule job gets run by SQL server Agent and the SQL server agent is running under administrator user. The SQL server job is calling is COM+ (in which i am using SQLXML bulkupload) and it runs under seperate user which has also got the administrator
permission. I dont know this happens some times only.
thanks for your kind support
Nitin
"Michael Rys [MSFT]" wrote:
> This sounds like you run the scheduled job with less permissions than when
> you do. Is the scheduled job running as a different user?
> Michael
> "Nitin" <Nitin@.discussions.microsoft.com> wrote in message
> news:C6033E80-4C72-44D5-B59C-3B750EE27C23@.microsoft.com...
>
>
|||Hi Michael
The schedule job gets run by SQL server Agent and the SQL server agent is running under administrator user. The SQL server job is calling is COM+ (in which i am using SQLXML bulkupload) and it runs under seperate user which has also got the administrator
permission. I dont know this happens some times only.
thanks for your kind support
Nitin
"Michael Rys [MSFT]" wrote:
> This sounds like you run the scheduled job with less permissions than when
> you do. Is the scheduled job running as a different user?
> Michael
> "Nitin" <Nitin@.discussions.microsoft.com> wrote in message
> news:C6033E80-4C72-44D5-B59C-3B750EE27C23@.microsoft.com...
>
>
|||Hi Michael
The schedule job gets run by SQL server Agent and the SQL server agent is running under administrator user. The SQL server job is calling is COM+ (in which i am using SQLXML bulkupload) and it runs under seperate user which has also got the administrator
permission. I dont know this happens some times only.
thanks for your kind support
Nitin
"Michael Rys [MSFT]" wrote:
> This sounds like you run the scheduled job with less permissions than when
> you do. Is the scheduled job running as a different user?
> Michael
> "Nitin" <Nitin@.discussions.microsoft.com> wrote in message
> news:C6033E80-4C72-44D5-B59C-3B750EE27C23@.microsoft.com...
>
>
|||Are you possibly running two jobs at once and one can not access the file
because the other still has it open?
Irwin
Irwin Dolobowsky
Program Manager - SqlXml
http://blogs.msdn.com/irwando
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nitin" <Nitin@.discussions.microsoft.com> wrote in message
news:75EB6BBE-9E47-4279-9D89-D2D5BC418B59@.microsoft.com...[vbcol=seagreen]
> Hi Michael
> The schedule job gets run by SQL server Agent and the SQL server agent is
> running under administrator user. The SQL server job is calling is COM+
> (in which i am using SQLXML bulkupload) and it runs under seperate user
> which has also got the administrator permission. I dont know this happens
> some times only.
> thanks for your kind support
> Nitin
>
> "Michael Rys [MSFT]" wrote:
|||Irwin
Possibly this could be the cause , I will keep different file name and try to run the jobs so that it wont use same file name
will let you know whats the outcome
thanks for your help
Nitin
"Irwin Dolobowsky [MS]" wrote:
> Are you possibly running two jobs at once and one can not access the file
> because the other still has it open?
> Irwin
> --
> Irwin Dolobowsky
> Program Manager - SqlXml
> http://blogs.msdn.com/irwando
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Nitin" <Nitin@.discussions.microsoft.com> wrote in message
> news:75EB6BBE-9E47-4279-9D89-D2D5BC418B59@.microsoft.com...
>
>
I am running COM component from SQL server jobs.
The COM component uses SQLXML bulk object to copy the data to SQL server.
I do get following error. The error comes some times only some. It is not consistant
can anyone tell me why it is happening some times only and how to resolve it
thanks in advance
error :-
Executed as user: myserver\Administrator. Error Code: 0 Error Source= Microsoft XML Bulkload for SQL Server Error Description: The error log file could not be created. Make sure you have the appropriate permissions and that the ErrorLogFilePath is valid
. Error on Line 1. The step failed.
Did you check the obvious permission and size issues for the log file
location?
Thanks
Michael
"Nitin" <Nitin@.discussions.microsoft.com> wrote in message
news:D780E0E2-3FA2-4F6B-BFFD-987E528682C8@.microsoft.com...
> Hi guys
> I am running COM component from SQL server jobs.
> The COM component uses SQLXML bulk object to copy the data to SQL server.
> I do get following error. The error comes some times only some. It is not
> consistant
> can anyone tell me why it is happening some times only and how to resolve
> it
> thanks in advance
> error :-
> Executed as user: myserver\Administrator. Error Code: 0 Error Source=
> Microsoft XML Bulkload for SQL Server Error Description: The error log
> file could not be created. Make sure you have the appropriate permissions
> and that the ErrorLogFilePath is valid. Error on Line 1. The step
> failed.
|||Yes
I did check the permission and size thats not the problem
funny thing is that if i run the job explicitly it does runs properly but if i schedule it to run automatically it gives me this error
thanks
Nitin
"Michael Rys [MSFT]" wrote:
> Did you check the obvious permission and size issues for the log file
> location?
> Thanks
> Michael
> "Nitin" <Nitin@.discussions.microsoft.com> wrote in message
> news:D780E0E2-3FA2-4F6B-BFFD-987E528682C8@.microsoft.com...
>
>
|||This sounds like you run the scheduled job with less permissions than when
you do. Is the scheduled job running as a different user?
Michael
"Nitin" <Nitin@.discussions.microsoft.com> wrote in message
news:C6033E80-4C72-44D5-B59C-3B750EE27C23@.microsoft.com...[vbcol=seagreen]
> Yes
> I did check the permission and size thats not the problem
> funny thing is that if i run the job explicitly it does runs properly but
> if i schedule it to run automatically it gives me this error
> thanks
> Nitin
> "Michael Rys [MSFT]" wrote:
|||Hi Michael
The schedule job gets run by SQL server Agent and the SQL server agent is running under administrator user. The SQL server job is calling is COM+ (in which i am using SQLXML bulkupload) and it runs under seperate user which has also got the administrator
permission. I dont know this happens some times only.
thanks for your kind support
Nitin
"Michael Rys [MSFT]" wrote:
> This sounds like you run the scheduled job with less permissions than when
> you do. Is the scheduled job running as a different user?
> Michael
> "Nitin" <Nitin@.discussions.microsoft.com> wrote in message
> news:C6033E80-4C72-44D5-B59C-3B750EE27C23@.microsoft.com...
>
>
|||Hi Michael
The schedule job gets run by SQL server Agent and the SQL server agent is running under administrator user. The SQL server job is calling is COM+ (in which i am using SQLXML bulkupload) and it runs under seperate user which has also got the administrator
permission. I dont know this happens some times only.
thanks for your kind support
Nitin
"Michael Rys [MSFT]" wrote:
> This sounds like you run the scheduled job with less permissions than when
> you do. Is the scheduled job running as a different user?
> Michael
> "Nitin" <Nitin@.discussions.microsoft.com> wrote in message
> news:C6033E80-4C72-44D5-B59C-3B750EE27C23@.microsoft.com...
>
>
|||Hi Michael
The schedule job gets run by SQL server Agent and the SQL server agent is running under administrator user. The SQL server job is calling is COM+ (in which i am using SQLXML bulkupload) and it runs under seperate user which has also got the administrator
permission. I dont know this happens some times only.
thanks for your kind support
Nitin
"Michael Rys [MSFT]" wrote:
> This sounds like you run the scheduled job with less permissions than when
> you do. Is the scheduled job running as a different user?
> Michael
> "Nitin" <Nitin@.discussions.microsoft.com> wrote in message
> news:C6033E80-4C72-44D5-B59C-3B750EE27C23@.microsoft.com...
>
>
|||Hi Michael
The schedule job gets run by SQL server Agent and the SQL server agent is running under administrator user. The SQL server job is calling is COM+ (in which i am using SQLXML bulkupload) and it runs under seperate user which has also got the administrator
permission. I dont know this happens some times only.
thanks for your kind support
Nitin
"Michael Rys [MSFT]" wrote:
> This sounds like you run the scheduled job with less permissions than when
> you do. Is the scheduled job running as a different user?
> Michael
> "Nitin" <Nitin@.discussions.microsoft.com> wrote in message
> news:C6033E80-4C72-44D5-B59C-3B750EE27C23@.microsoft.com...
>
>
|||Are you possibly running two jobs at once and one can not access the file
because the other still has it open?
Irwin
Irwin Dolobowsky
Program Manager - SqlXml
http://blogs.msdn.com/irwando
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nitin" <Nitin@.discussions.microsoft.com> wrote in message
news:75EB6BBE-9E47-4279-9D89-D2D5BC418B59@.microsoft.com...[vbcol=seagreen]
> Hi Michael
> The schedule job gets run by SQL server Agent and the SQL server agent is
> running under administrator user. The SQL server job is calling is COM+
> (in which i am using SQLXML bulkupload) and it runs under seperate user
> which has also got the administrator permission. I dont know this happens
> some times only.
> thanks for your kind support
> Nitin
>
> "Michael Rys [MSFT]" wrote:
|||Irwin
Possibly this could be the cause , I will keep different file name and try to run the jobs so that it wont use same file name
will let you know whats the outcome
thanks for your help
Nitin
"Irwin Dolobowsky [MS]" wrote:
> Are you possibly running two jobs at once and one can not access the file
> because the other still has it open?
> Irwin
> --
> Irwin Dolobowsky
> Program Manager - SqlXml
> http://blogs.msdn.com/irwando
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Nitin" <Nitin@.discussions.microsoft.com> wrote in message
> news:75EB6BBE-9E47-4279-9D89-D2D5BC418B59@.microsoft.com...
>
>
Error - updating tables row using SqlDataSource
I have such a problem:
i try to update a row in my table using:
protected void selectButton_Click(object sender, EventArgs e)
{
String taskID = projectsGridView.SelectedRow.Cells[0].Text;
usersSqlDataSource.UpdateCommand = "update [Users] set [TaskID]=@.task where [UserID]=1";
usersSqlDataSource.UpdateParameters.Add("task", taskID);
usersSqlDataSource.Update();
}
And i receive error on usersSqlDataSource.Update():
You have specified that your update command compares all values on SqlDataSource 'usersSqlDataSource', but the dictionary passed in for oldValues is empty
What have i done wrong? Parameter are not set?
Check ConflictDetection attribute in your DataSource declaration.
Based on your usage it should be
ConflictDetection="OverwriteChanges"
Refer to the following link to better understand the implications of this setting
http://msdn2.microsoft.com/en-US/library/system.web.ui.webcontrols.sqldatasource.conflictdetection.aspx
|||One way to solve this is to change the ConflictDetection property of your datasource to OverWriteChanges. At the moment it is set at CompareAllValues. If you want to keep the CompareAllValues setting, you need to add the old Values for each parameter to the UpdateParameters collection too.http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.oldvaluesparameterformatstring(vs.80).aspx
Yes, it works fine now, thanks!
Sunday, February 19, 2012
Error - ReportsViwer with Parameters
Hi,
We trying to deploy Parameter added Report and its giving following error
at Microsoft.VisualBasic.CompilerServices.Symbols.Container..ctor(Object Instance)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.InternalLateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames, Boolean ReportErrors, ResolutionFailure& Failure)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames)
at aspx_abe_asr_report.btnRun_Click(Object sender, EventArgs e) in D:\ABE\ABE\dotNET\ABE_WEB\ABE_BETA\reports\abe_asr_report.aspx.vb:line 25
the code is
Dim datasource As New ReportDataSource("DataSet1_ABE_TKT_TICKET_MASTER", outDs.Tables(0))
Dim vAgentName As String = ""
vAgentName = Session("Login")(1).ToString
ReportViewer1.LocalReport.DataSources.Add(datasource)
Dim p_AgentName As New ReportParameter("pAgentName", vAgentName)
ReportViewer1.LocalReport.SetParameters((New ReportParameter() {p_AgentName}))
ReportViewer1.Visible = True
ReportViewer1.LocalReport.Refresh()
Pls help
Nilaksha.
Could you please provide some more context on your scenario? What are you trying to do?
Daniel Roth
error - microsoft jet database engine can not find the object tabble_name
Hi,
I try to export my data from sql server to excel, when i preview the
data, it all runs fine. When i run export, it prompt me this error. How can
i ensure this object is exist? and how do i verify this error? In the
enterprise manager, i can view the records for my table.
--
Thank you very much!
Best regards,
FlorenceHi Forence,
Florence Lee wrote:
> I try to export my data from sql server to excel, when i preview the
> data, it all runs fine. When i run export, it prompt me this error. How can
> i ensure this object is exist? and how do i verify this error? In the
> enterprise manager, i can view the records for my table.
If you can use the Enterprise Manager to view your table records, you
may want to consider just using the EM to export your table to a comma
delimited file. You should be able to do this by using the "export"
task from within the Enterprise Manager, using the DTS wizard. Once you
have the comma delimited file, you can then use Excel to import that.
It's a workaround, but a workaround that should work for you. :)
Hope this helps.|||Hi,
I try to use the dts to direct export to excel, come out this error why?
I dun want to export to text files then just back to excel.
--
Thank you very much!
Best regards,
Florence
"William R. Lorenz" <wrl@.express.org> wrote in message
news:eFoSj5K6EHA.3944@.TK2MSFTNGP12.phx.gbl...
> Hi Forence,
> Florence Lee wrote:
> > I try to export my data from sql server to excel, when i preview
the
> > data, it all runs fine. When i run export, it prompt me this error. How
can
> > i ensure this object is exist? and how do i verify this error? In the
> > enterprise manager, i can view the records for my table.
> If you can use the Enterprise Manager to view your table records, you
> may want to consider just using the EM to export your table to a comma
> delimited file. You should be able to do this by using the "export"
> task from within the Enterprise Manager, using the DTS wizard. Once you
> have the comma delimited file, you can then use Excel to import that.
> It's a workaround, but a workaround that should work for you. :)
> Hope this helps.
I try to export my data from sql server to excel, when i preview the
data, it all runs fine. When i run export, it prompt me this error. How can
i ensure this object is exist? and how do i verify this error? In the
enterprise manager, i can view the records for my table.
--
Thank you very much!
Best regards,
FlorenceHi Forence,
Florence Lee wrote:
> I try to export my data from sql server to excel, when i preview the
> data, it all runs fine. When i run export, it prompt me this error. How can
> i ensure this object is exist? and how do i verify this error? In the
> enterprise manager, i can view the records for my table.
If you can use the Enterprise Manager to view your table records, you
may want to consider just using the EM to export your table to a comma
delimited file. You should be able to do this by using the "export"
task from within the Enterprise Manager, using the DTS wizard. Once you
have the comma delimited file, you can then use Excel to import that.
It's a workaround, but a workaround that should work for you. :)
Hope this helps.|||Hi,
I try to use the dts to direct export to excel, come out this error why?
I dun want to export to text files then just back to excel.
--
Thank you very much!
Best regards,
Florence
"William R. Lorenz" <wrl@.express.org> wrote in message
news:eFoSj5K6EHA.3944@.TK2MSFTNGP12.phx.gbl...
> Hi Forence,
> Florence Lee wrote:
> > I try to export my data from sql server to excel, when i preview
the
> > data, it all runs fine. When i run export, it prompt me this error. How
can
> > i ensure this object is exist? and how do i verify this error? In the
> > enterprise manager, i can view the records for my table.
> If you can use the Enterprise Manager to view your table records, you
> may want to consider just using the EM to export your table to a comma
> delimited file. You should be able to do this by using the "export"
> task from within the Enterprise Manager, using the DTS wizard. Once you
> have the comma delimited file, you can then use Excel to import that.
> It's a workaround, but a workaround that should work for you. :)
> Hope this helps.
error - microsoft jet database engine can not find the object tabble_name
Hi,
I try to export my data from sql server to excel, when i preview the
data, it all runs fine. When i run export, it prompt me this error. How can
i ensure this object is exist? and how do i verify this error? In the
enterprise manager, i can view the records for my table.
Thank you very much!
Best regards,
Florence
Hi,
I try to use the dts to direct export to excel, come out this error why?
I dun want to export to text files then just back to excel.
Thank you very much!
Best regards,
Florence
"William R. Lorenz" <wrl@.express.org> wrote in message
news:eFoSj5K6EHA.3944@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Hi Forence,
> Florence Lee wrote:
the[vbcol=seagreen]
can
> If you can use the Enterprise Manager to view your table records, you
> may want to consider just using the EM to export your table to a comma
> delimited file. You should be able to do this by using the "export"
> task from within the Enterprise Manager, using the DTS wizard. Once you
> have the comma delimited file, you can then use Excel to import that.
> It's a workaround, but a workaround that should work for you.
> Hope this helps.
I try to export my data from sql server to excel, when i preview the
data, it all runs fine. When i run export, it prompt me this error. How can
i ensure this object is exist? and how do i verify this error? In the
enterprise manager, i can view the records for my table.
Thank you very much!
Best regards,
Florence
Hi,
I try to use the dts to direct export to excel, come out this error why?
I dun want to export to text files then just back to excel.
Thank you very much!
Best regards,
Florence
"William R. Lorenz" <wrl@.express.org> wrote in message
news:eFoSj5K6EHA.3944@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Hi Forence,
> Florence Lee wrote:
the[vbcol=seagreen]
can
> If you can use the Enterprise Manager to view your table records, you
> may want to consider just using the EM to export your table to a comma
> delimited file. You should be able to do this by using the "export"
> task from within the Enterprise Manager, using the DTS wizard. Once you
> have the comma delimited file, you can then use Excel to import that.
> It's a workaround, but a workaround that should work for you.
> Hope this helps.
Subscribe to:
Posts (Atom)