exec a ssis pkg from java or .net application

hi, does anyone know if an ssis pkg can be executed from a java or .net application?

You can execute packages using the DTSExec program and passing it command line arguments. And this could be done in any windows application where you can invoke the DTSExec program, including .NET and Java applications.

|||I think you meant DTExec, not DTSexec.|||

If running a .net app from a citrix server, would any componenets need to be installed like they had to be for DTS in SQL 2000? I keep trying to find some info on this and can't find anything.

Thanx,

Mike

Exclusive DB access

Hi,
I'm searching a way or a method to gain exclusive access for a short time
period (minutes) to a SQL 2000 database from a VB application using ADO and
SQLDMO, in order to do some data historization and computation, and
preventing that others users may connect to the database during this time.
After searching in the SQLDMO object model, I couldn't find anything adequate
for this purpose. Is the only way to lock/unlock all the tables ?
Has anyone an idea ?
Roberto
Answered in .connectivity
Please do not multi-post.
Regards
Mike
"GunSmoke_62" wrote:

> Hi,
> I'm searching a way or a method to gain exclusive access for a short time
> period (minutes) to a SQL 2000 database from a VB application using ADO and
> SQLDMO, in order to do some data historization and computation, and
> preventing that others users may connect to the database during this time.
> After searching in the SQLDMO object model, I couldn't find anything adequate
> for this purpose. Is the only way to lock/unlock all the tables ?
> Has anyone an idea ?
> Roberto

Exclusive DB access

Hi,
I'm searching a way or a method to gain exclusive access for a short time
period (minutes) to a SQL 2000 database from a VB application using ADO and
SQLDMO, in order to do some data historization and computation, and
preventing that others users may connect to the database during this time.
After searching in the SQLDMO object model, I couldn't find anything adequat
e
for this purpose. Is the only way to lock/unlock all the tables ?
Has anyone an idea ?
RobertoAnswered in .connectivity
Please do not multi-post.
Regards
Mike
"GunSmoke_62" wrote:

> Hi,
> I'm searching a way or a method to gain exclusive access for a short time
> period (minutes) to a SQL 2000 database from a VB application using ADO an
d
> SQLDMO, in order to do some data historization and computation, and
> preventing that others users may connect to the database during this time.
> After searching in the SQLDMO object model, I couldn't find anything adequ
ate
> for this purpose. Is the only way to lock/unlock all the tables ?
> Has anyone an idea ?
> Robertosql

Exclusive DB access

Hi,
I'm searching a way or a method to gain exclusive access for a short time
period (minutes) to a SQL 2000 database from a VB application using ADO and
SQLDMO, in order to do some data historization and computation, and
preventing that others users may connect to the database during this time.
After searching in the SQLDMO object model, I couldn't find anything adequate
for this purpose. Is the only way to lock/unlock all the tables ?
Has anyone an idea ?
RobertoAnswered in .connectivity
Please do not multi-post.
Regards
Mike
"GunSmoke_62" wrote:
> Hi,
> I'm searching a way or a method to gain exclusive access for a short time
> period (minutes) to a SQL 2000 database from a VB application using ADO and
> SQLDMO, in order to do some data historization and computation, and
> preventing that others users may connect to the database during this time.
> After searching in the SQLDMO object model, I couldn't find anything adequate
> for this purpose. Is the only way to lock/unlock all the tables ?
> Has anyone an idea ?
> Roberto

Exclude rows with no data

I have a report created using MDX imported from another application. In
order to provide flexibility, this MDX carries in several fields that are not
necessarily used when the report is created. (The report prompts for
parameters which determine whether it should be created using budget or
actual data.) Because of this, I am getting rows of data where there are no
values for the type of report I am requesting. For example, if I have budget
data but no actual data for an item, this item still shows up when I request
the report for actual data. Is there any way to prevent these rows from
appearing?On Mar 2, 11:33 am, ppbedz <ppb...@.discussions.microsoft.com> wrote:
> I have a report created using MDX imported from another application. In
> order to provide flexibility, this MDX carries in several fields that are not
> necessarily used when the report is created. (The report prompts for
> parameters which determine whether it should be created using budget or
> actual data.) Because of this, I am getting rows of data where there are no
> values for the type of report I am requesting. For example, if I have budget
> data but no actual data for an item, this item still shows up when I request
> the report for actual data. Is there any way to prevent these rows from
> appearing?
I'm not familiar w/MDX; however, you should be able to filter the
results by something like Sum(Fields!ActualData.Value) > 0. Hope this
is helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||I tried the following filter "=Fields!GrossSales.Value > 0". I get an error
message that says "Processing of filter can not be performed. Please check
the data type value retuend by the filter expression." Can you tell me what
this means and how to set up the statement properly. Thank you for your
help. I'm learning this tool on a "need to know" basis and I have 60 reports
to create w/o any real training.
"EMartinez" wrote:
> On Mar 2, 11:33 am, ppbedz <ppb...@.discussions.microsoft.com> wrote:
> > I have a report created using MDX imported from another application. In
> > order to provide flexibility, this MDX carries in several fields that are not
> > necessarily used when the report is created. (The report prompts for
> > parameters which determine whether it should be created using budget or
> > actual data.) Because of this, I am getting rows of data where there are no
> > values for the type of report I am requesting. For example, if I have budget
> > data but no actual data for an item, this item still shows up when I request
> > the report for actual data. Is there any way to prevent these rows from
> > appearing?
> I'm not familiar w/MDX; however, you should be able to filter the
> results by something like Sum(Fields!ActualData.Value) > 0. Hope this
> is helpful.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||On Mar 4, 8:54 am, ppbedz <ppb...@.discussions.microsoft.com> wrote:
> I tried the following filter "=Fields!GrossSales.Value > 0". I get an error
> message that says "Processing of filter can not be performed. Please check
> the data type value retuend by the filter expression." Can you tell me what
> this means and how to set up the statement properly. Thank you for your
> help. I'm learning this tool on a "need to know" basis and I have 60 reports
> to create w/o any real training.
> "EMartinez" wrote:
> > On Mar 2, 11:33 am, ppbedz <ppb...@.discussions.microsoft.com> wrote:
> > > I have a report created using MDX imported from another application. In
> > > order to provide flexibility, this MDX carries in several fields that are not
> > > necessarily used when the report is created. (The report prompts for
> > > parameters which determine whether it should be created using budget or
> > > actual data.) Because of this, I am getting rows of data where there are no
> > > values for the type of report I am requesting. For example, if I have budget
> > > data but no actual data for an item, this item still shows up when I request
> > > the report for actual data. Is there any way to prevent these rows from
> > > appearing?
> > I'm not familiar w/MDX; however, you should be able to filter the
> > results by something like Sum(Fields!ActualData.Value) > 0. Hope this
> > is helpful.
> > Regards,
> > Enrique Martinez
> > Sr. SQL Server Developer
It seems like you might not have set the 'Value' part of the filter to
an integer value. By default, the filter sets all numbers in the
'Value' column to strings unless you use an = sign before it. You
might want to try something like: in the 'Expression' column enter:
=Fields!GrossSales.Value; in the 'Operator' column select '>'; and in
the 'Value' column enter: =0
If this does not correct the problem, you will most likely need to
convert the results of 'Fields!GrossSales.Value' to an integer: via
something like: CInt(Fields!GrossSales.Value).
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thank you. I had to use the "cint" in the expression column AND the "=0"
in the value column. I appreciate youe help!
PB
"EMartinez" wrote:
> On Mar 4, 8:54 am, ppbedz <ppb...@.discussions.microsoft.com> wrote:
> > I tried the following filter "=Fields!GrossSales.Value > 0". I get an error
> > message that says "Processing of filter can not be performed. Please check
> > the data type value retuend by the filter expression." Can you tell me what
> > this means and how to set up the statement properly. Thank you for your
> > help. I'm learning this tool on a "need to know" basis and I have 60 reports
> > to create w/o any real training.
> >
> > "EMartinez" wrote:
> > > On Mar 2, 11:33 am, ppbedz <ppb...@.discussions.microsoft.com> wrote:
> > > > I have a report created using MDX imported from another application. In
> > > > order to provide flexibility, this MDX carries in several fields that are not
> > > > necessarily used when the report is created. (The report prompts for
> > > > parameters which determine whether it should be created using budget or
> > > > actual data.) Because of this, I am getting rows of data where there are no
> > > > values for the type of report I am requesting. For example, if I have budget
> > > > data but no actual data for an item, this item still shows up when I request
> > > > the report for actual data. Is there any way to prevent these rows from
> > > > appearing?
> >
> > > I'm not familiar w/MDX; however, you should be able to filter the
> > > results by something like Sum(Fields!ActualData.Value) > 0. Hope this
> > > is helpful.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. SQL Server Developer
> It seems like you might not have set the 'Value' part of the filter to
> an integer value. By default, the filter sets all numbers in the
> 'Value' column to strings unless you use an = sign before it. You
> might want to try something like: in the 'Expression' column enter:
> =Fields!GrossSales.Value; in the 'Operator' column select '>'; and in
> the 'Value' column enter: =0
> If this does not correct the problem, you will most likely need to
> convert the results of 'Fields!GrossSales.Value' to an integer: via
> something like: CInt(Fields!GrossSales.Value).
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||One more question....For some reason the Table filter list has the and/or
column on the selection grayed out. I would like to be able to say "sales OR
pounds" not =0. Do you have any idea why the and/or column is not available
under the table filter properties?
Thank you,
PB
"EMartinez" wrote:
> On Mar 4, 8:54 am, ppbedz <ppb...@.discussions.microsoft.com> wrote:
> > I tried the following filter "=Fields!GrossSales.Value > 0". I get an error
> > message that says "Processing of filter can not be performed. Please check
> > the data type value retuend by the filter expression." Can you tell me what
> > this means and how to set up the statement properly. Thank you for your
> > help. I'm learning this tool on a "need to know" basis and I have 60 reports
> > to create w/o any real training.
> >
> > "EMartinez" wrote:
> > > On Mar 2, 11:33 am, ppbedz <ppb...@.discussions.microsoft.com> wrote:
> > > > I have a report created using MDX imported from another application. In
> > > > order to provide flexibility, this MDX carries in several fields that are not
> > > > necessarily used when the report is created. (The report prompts for
> > > > parameters which determine whether it should be created using budget or
> > > > actual data.) Because of this, I am getting rows of data where there are no
> > > > values for the type of report I am requesting. For example, if I have budget
> > > > data but no actual data for an item, this item still shows up when I request
> > > > the report for actual data. Is there any way to prevent these rows from
> > > > appearing?
> >
> > > I'm not familiar w/MDX; however, you should be able to filter the
> > > results by something like Sum(Fields!ActualData.Value) > 0. Hope this
> > > is helpful.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. SQL Server Developer
> It seems like you might not have set the 'Value' part of the filter to
> an integer value. By default, the filter sets all numbers in the
> 'Value' column to strings unless you use an = sign before it. You
> might want to try something like: in the 'Expression' column enter:
> =Fields!GrossSales.Value; in the 'Operator' column select '>'; and in
> the 'Value' column enter: =0
> If this does not correct the problem, you will most likely need to
> convert the results of 'Fields!GrossSales.Value' to an integer: via
> something like: CInt(Fields!GrossSales.Value).
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||On Mar 5, 7:16 am, ppbedz <ppb...@.discussions.microsoft.com> wrote:
> One more question....For some reason the Table filter list has the and/or
> column on the selection grayed out. I would like to be able to say "sales OR
> pounds" not =0. Do you have any idea why the and/or column is not available
> under the table filter properties?
> Thank you,
> PB
> "EMartinez" wrote:
> > On Mar 4, 8:54 am, ppbedz <ppb...@.discussions.microsoft.com> wrote:
> > > I tried the following filter "=Fields!GrossSales.Value > 0". I get an error
> > > message that says "Processing of filter can not be performed. Please check
> > > the data type value retuend by the filter expression." Can you tell me what
> > > this means and how to set up the statement properly. Thank you for your
> > > help. I'm learning this tool on a "need to know" basis and I have 60 reports
> > > to create w/o any real training.
> > > "EMartinez" wrote:
> > > > On Mar 2, 11:33 am, ppbedz <ppb...@.discussions.microsoft.com> wrote:
> > > > > I have a report created using MDX imported from another application. In
> > > > > order to provide flexibility, this MDX carries in several fields that are not
> > > > > necessarily used when the report is created. (The report prompts for
> > > > > parameters which determine whether it should be created using budget or
> > > > > actual data.) Because of this, I am getting rows of data where there are no
> > > > > values for the type of report I am requesting. For example, if I have budget
> > > > > data but no actual data for an item, this item still shows up when I request
> > > > > the report for actual data. Is there any way to prevent these rows from
> > > > > appearing?
> > > > I'm not familiar w/MDX; however, you should be able to filter the
> > > > results by something like Sum(Fields!ActualData.Value) > 0. Hope this
> > > > is helpful.
> > > > Regards,
> > > > Enrique Martinez
> > > > Sr. SQL Server Developer
> > It seems like you might not have set the 'Value' part of the filter to
> > an integer value. By default, the filter sets all numbers in the
> > 'Value' column to strings unless you use an = sign before it. You
> > might want to try something like: in the 'Expression' column enter:
> > =Fields!GrossSales.Value; in the 'Operator' column select '>'; and in
> > the 'Value' column enter: =0
> > If this does not correct the problem, you will most likely need to
> > convert the results of 'Fields!GrossSales.Value' to an integer: via
> > something like: CInt(Fields!GrossSales.Value).
> > Regards,
> > Enrique Martinez
> > Sr. SQL Server Developer
You're welcome. Glad to be of assistance. I have not been able to get
the filter options to allow 'or' in my experiences so far. You might
need to have the filtering in the query or stored procedure that is
sourcing the report to allow for more flexibility. Just a thought.
Regards,
Enrique Martinez
Sr. SQL Server Developer

Exchange Server or NS filtering email addresses?

My Notification Services (NS 2.0 SP1) application works fine, except one big problem:

I am using a built-in SMTP provider, and notifications are delivered ONLY to those subscribers who have email addresses within our company's domain.

That is, all subscribers with addresses like someone@.ourcompany.com always get their notifications, whereas any other email addresses do not work. I tried my gmail.com, aim.com, and optonline.net email addresses, and none of them ever received a notification, not even once.

As soon as I change a particular subscriber's email address from whatever to anybody@.ourcompany.com (whether I do it via SMI or directly in the NS subscribers table, does not matter), it works again.

So, something is filtering emails based on the recipients' addresses.
I do not know for sure whether it's done by NS or by the SMTP server, but the situation is the same regardless of whether I use my local machine's SMTP server or our company's MS Exchange Server 5.5 (I specify it only in the InstanceConfiguration.xml file).

Could someone point me in the right direction as to where to look for what's causing this kind of filtering, please?

Thank you very much!Answering my own question...
Here's what the Exchange Server 5.5 returns in an exception message:
The server rejected one or more recipient addresses. The server response was: 550 Relaying is prohibited.
It's a spam-filtering -related feature.

EXCEPTION_ACCESS_VIOLATION Error 17883

We installed a Server 2003 Standard and SQL 2000 Sp3a
This is a replace of an NT4 Server With SQL 7.
The application has never had SQL related problems,
Now after 4 hours live production the SQL Server hung with dumps in the SQL
log's starting one hour before complete hung.
Errormessages :
Error 17883
EXCEPTION_ACCESS_VIOLATION
The sheduler appeers to be hung
Then a dump in the log
Same select statement with the same spid
over and again for about one hour then complete stop of SQL 2000
Customer not very pleased an lots of stress for the technical guys and the s
oftware guys.
Also Errors in the Application Log for SQL Server.
The machine is an Xeon Processor 2.8 Ghz (Server 2003 sees it as a dual proc
essor machine)
2 GB of Memory
360 MB dedicated for SQL 2000
100 GB raid 5 hard disk U320
Database size 450 MB
Happens on a simple select statement.
Thanks a lot
Luc VanleeuwI have had the same thing happen to me and after some research found the
following article:
http://support.microsoft.com/default.aspx?kbid=810885
I too just moved to Windows 2003 server with SQL and applied SP3a. I think
when I applied this patch it "blew away" my previous patch installation of
MS03-031: Cumulative Security Patch for SQL. I am going to apply this
tonight and see if it fixes my problem...let you know...or let me know if
you have any luck...
Jim
"Luc Vanleeuw" <anonymous@.discussions.microsoft.com> wrote in message
news:5AFD1596-C167-407C-9DBC-F01712DE600F@.microsoft.com...
> We installed a Server 2003 Standard and SQL 2000 Sp3a
> This is a replace of an NT4 Server With SQL 7.
> The application has never had SQL related problems,
> Now after 4 hours live production the SQL Server hung with dumps in the
SQL log's starting one hour before complete hung.
> Errormessages :
> Error 17883
> EXCEPTION_ACCESS_VIOLATION
> The sheduler appeers to be hung
> Then a dump in the log
> Same select statement with the same spid
> over and again for about one hour then complete stop of SQL 2000
> Customer not very pleased an lots of stress for the technical guys and the
software guys.
> Also Errors in the Application Log for SQL Server.
> The machine is an Xeon Processor 2.8 Ghz (Server 2003 sees it as a dual
processor machine)
> 2 GB of Memory
> 360 MB dedicated for SQL 2000
> 100 GB raid 5 hard disk U320
> Database size 450 MB
> Happens on a simple select statement.
> Thanks a lot
>
> Luc Vanleeuw
>

EXCEPTION_ACCESS_VIOLATION Error

Hi all,
One of our clients is using SQL7/SP4 and their database is working correctly
with our application and not producing any errors. To help locate an
intermittent problem with our application I did a backup of the database and
returned it to our office.
The backup went fine and was verified and the restore to our SQL/SP4 Server
in the office went without any errors.
However if you try and look at any Tables, SP's or Views in EM you receive
the following error msg:
SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
The error log shows:
****************************************
************************************
***
*
* BEGIN STACK DUMP:
* 03/24/04 08:02:31 spid 9
*
* Exception Address = 0051ACE7 (CObjectScan::LParentid + 10)
* Exception Code = c0000005 E
* Access Violation occurred reading address 00000000
* Input Buffer 1428 bytes -
* s e l e c t s 1 = o . n a m e , s 2 = u s e r _ n a m e ( o
* . u i d ) , o . c r d a t e , o . i d , N ' S y s t e m O b j ' =
* ( c a s e w h e n ( O B J E C T P R O P E R T Y ( o . i d , N ' I
* s M S S h i p p e d ' ) = 1 ) t h e n 1 e l s e O B J E C T P R
* O P E R T Y ( o . i d , N ' I s S y s t e m T a b l e ' ) e n d ) ,
* o . c a t e g o r y , 0 , O b j e c t P r o p e r t
* y ( o . i d , N ' T a b l e H a s A c t i v e F u l l t e x t I n d e
* x ' ) , O b j e c t P r o p e r t y ( o . i d , N ' T a b l e F u l
* l t e x t C a t a l o g I d ' ) , N ' F a k e T a b l e ' = ( c a
* s e w h e n ( O B J E C T P R O P E R T Y ( o . i d , N ' t a b l
* e i s f a k e ' ) = 1 ) t h e n 1 e l s e 0 e n d ) ,
* ( c a s e w h e n ( O B J E C T P R O P E R T Y ( o . i d ,
* N ' I s Q u o t e d I d e n t O n ' ) = 1 ) t h e n 1 e l s e
* 0 e n d ) , ( c a s e w h e n ( O B J E C T P R O P E R T Y ( o
* . i d , N ' I s A n s i N u l l s O n ' ) = 1 ) t h e n 1 e l s
* e 0 e n d ) f r o m d b o . s y s o b j e c t s
* o , d b o . s y s i n d e x e s i w h e r e O B J E C T P R O P
* E R T Y ( o . i d , N ' I s T a b l e ' ) = 1 a n d i . i d
* = o . i d a n d i . i n d i d < 2 a n d o . n a m e n o
* t l i k e N ' # % ' o r d e r b y s 1 , s 2
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 008d2fff 004d3000
* ntdll 77f60000 77fbefff 0005f000
* KERNEL32 77f00000 77f5efff 0005f000
* ADVAPI32 77dc0000 77dfefff 0003f000
* USER32 77e70000 77ec1fff 00052000
* GDI32 77ed0000 77efbfff 0002c000
* RPCRT4 77e10000 77e66fff 00057000
* ole32 77b20000 77bd0fff 000b1000
* OLEAUT32 65340000 653dafff 0009b000
* VERSION 77a90000 77a9afff 0000b000
* SHELL32 77c40000 77d7afff 0013b000
* COMCTL32 71710000 71793fff 00084000
* LZ32 779c0000 779c7fff 00008000
* opends60 41060000 41085fff 00026000
* ums 41090000 4109cfff 0000d000
* MSVCRT 78000000 78043fff 00044000
* sqlsort 04000000 0408efff 0008f000
* MSVCIRT 780a0000 780b1fff 00012000
* sqlevn70 410a0000 410a6fff 00007000
* rpcltc1 77bf0000 77bf6fff 00007000
* COMNEVNT 410b0000 410fefff 0004f000
* ODBC32 012b0000 012e4fff 00035000
* comdlg32 77d80000 77db1fff 00032000
* SQLWOA 41100000 4110bfff 0000c000
* odbcint 013f0000 01405fff 00016000
* NDDEAPI 75a80000 75a87fff 00008000
* WINSPOOL 77c00000 77c17fff 00018000
* SQLTrace 41130000 4117dfff 0004e000
* NETAPI32 4ca00000 4ca40fff 00041000
* NETRAP 77840000 77848fff 00009000
* SAMLIB 777e0000 777ecfff 0000d000
* WSOCK32 776d0000 776d7fff 00008000
* WS2_32 776b0000 776c3fff 00014000
* WS2HELP 776a0000 776a6fff 00007000
* WLDAP32 77950000 77978fff 00029000
* SSNMPN70 41190000 41195fff 00006000
* SSMSSO70 411a0000 411aafff 0000b000
* SSMSRP70 411b0000 411b7fff 00008000
* ENUdtc 69140000 69156fff 00017000
* XOLEHLP 69360000 69368fff 00009000
* MTXCLU 69790000 6979cfff 0000d000
* ADME 69120000 69132fff 00013000
* DTCUtil 69000000 69009fff 0000a000
* DTCTRACE 68ff0000 68ff6fff 00007000
* CLUSAPI 7f230000 7f23cfff 0000d000
* RESUTILS 7f250000 7f259fff 0000a000
* msafd 77660000 7766efff 0000f000
* wshtcpip 77690000 77698fff 00009000
* rpclts1 77e00000 77e06fff 00007000
* RpcLtScm 74fa0000 74faafff 0000b000
* MSWSOCK 77670000 77686fff 00017000
* rnr20 74ff0000 74ffdfff 0000e000
* RpcLtCcm 74fc0000 74fcefff 0000f000
* security 76e70000 76e81fff 00012000
* msapsspc 24900000 24910fff 00011000
* MSVCRT40 779d0000 779e4fff 00015000
* schannel 77400000 7741dfff 0001e000
* MSOSS 5e380000 5e3a4fff 00025000
* CRYPT32 5cf00000 5cf74fff 00075000
* MSASN1 24930000 2493ffff 00010000
* digest 24940000 2494ffff 00010000
* msnsspc 716d0000 716eefff 0001f000
* SQLRGSTR 411c0000 411c4fff 00005000
* sqlmap70 415b0000 415c5fff 00016000
* ntwdblib 73320000 73363fff 00044000
* MAPI32 6fa90000 6fb6afff 000db000
* MPR 77720000 77730fff 00011000
* contab32 6eaf0000 6eb08fff 00019000
* EMSABP32 626f0000 62713fff 00024000
* EMSUI32 625d0000 625f0fff 00021000
* WMSUI32 6def0000 6e017fff 00128000
* GAPI32 6fbf0000 6fc07fff 00018000
* xpsqlbot 41820000 41825fff 00006000
* sqlboot 417f0000 417f7fff 00008000
* xpstar 411d0000 41200fff 00031000
* SQLWID 412f0000 412f5fff 00006000
* SQLSVC 415e0000 415f8fff 00019000
* odbcbcp 25510000 25516fff 00007000
* SQLRESLD 41320000 41325fff 00006000
* W95SCM 41210000 41217fff 00008000
* SQLSVC 42480000 42485fff 00006000
* sqlimage 72a00000 72a2cfff 0002d000
*
* Edi: 256CF9D4: 00100009 005f92d5 256cfa44 00000000 0078eecb 256cfb50
* Esi: 256CF944: 00000000 00000000 00000000 00000000 0000002a 1520fbc8
* Eax: 00000000:
* Ebx: 00000007:
* Ecx: 00000009:
* Edx: 0000002C:
* Eip: 0051ACE7: abe85030 c0830081 e128a150 57fc458d 5651ec8b 55c3008b
* Ebp: 256CF9E0: 00000007 1548d1f8 0bdc9e2e 00100009 005f92d5 256cfa44
* SegCs: 0000001B:
* EFlags: 00010246: 0020006d 00610072 0067006f 00720050 005c003a 0043003b
* Esp: 256CF8EC: 00000000 00000008 005f9290 256cfa10 256cfa10 005ecc26
* SegSs: 00000023:
****************************************
************************************
***
The Short Stack Dump is empty.
I've tried restoring the DB to several SQL 7 Servers but with the same
result. I have taken other backups from the clients SQL 7 Server but all
the restores to our Servers give the same result. Restores to our clients
PC work correctly.
DBCC CheckDB at our office produces the following:
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:325) with latch type SH. sysobjects failed.
Server: Msg 8944, Level 16, State 1, Line 1
Table Corrupt: Object ID 1, index ID 0, page (1:325), row 62. Test (nVarCols
&& (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
DBCC results for 'JagTrain'.
CHECKDB found 0 allocation errors and 1 consistency errors in table
'sysobjects' (object ID 1).
CHECKDB found 0 allocation errors and 1 consistency errors in database
'JagTrain'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKDB (JagTrain ).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
The commands:
exec sp_dboption 'JagTrain', 'single user', 'on'
GO
DBCC CHECKDB ('JagTrain', repair_allow_data_loss)WITH NO_INFOMSGS
Produces:
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
The database is now single user.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:325) with latch type SH. sysobjects failed.
Server: Msg 8944, Level 16, State 1, Line 1
Table Corrupt: Object ID 1, index ID 0, page (1:325), row 62. Test (nVarCols
&& (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
CHECKDB found 0 allocation errors and 1 consistency errors in table
'sysobjects' (object ID 1).
CHECKDB found 0 allocation errors and 1 consistency errors in database
'JagTrain'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKDB (JagTrain repair_allow_data_loss).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
If anyone has any ideas as to what might be causing this problem it would be
appreciated.
Thanks in advance,
Greg
--
greghines@.bigfoot.com.NOSPAM
Remove NOSPAM when replyingHi Greg,
Judging from your DBCC CHECKDB output, it appears that your sysobjects
table has been corrupted. Unfortunately this is probably one of the most
important system tables in the database as it contains information for each
object in the database. The Repair option most likely will not fix the
corruption.
If the backup exhibits same problem, that means the database has been
backed up with corruption. You may have to find other ways to regenerate
your data, or go to an even older backup.
Yih-Yoon Lee
On Wed, 24 Mar 2004 08:24:39 +1100, Greg Hines wrote:

> DBCC CheckDB at our office produces the following:
> Server: Msg 8966, Level 16, State 1, Line 1
> Could not read and latch page (1:325) with latch type SH. sysobjects faile
d.
> Server: Msg 8944, Level 16, State 1, Line 1
> Table Corrupt: Object ID 1, index ID 0, page (1:325), row 62. Test (nVarCo
ls
> && (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
> DBCC results for 'JagTrain'.
> CHECKDB found 0 allocation errors and 1 consistency errors in table
> 'sysobjects' (object ID 1).
> CHECKDB found 0 allocation errors and 1 consistency errors in database
> 'JagTrain'.
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKDB (JagTrain ).
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> The commands:
> exec sp_dboption 'JagTrain', 'single user', 'on'
> GO
> DBCC CHECKDB ('JagTrain', repair_allow_data_loss)WITH NO_INFOMSGS
> Produces:
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> The database is now single user.
> Server: Msg 8966, Level 16, State 1, Line 1
> Could not read and latch page (1:325) with latch type SH. sysobjects faile
d.
> Server: Msg 8944, Level 16, State 1, Line 1
> Table Corrupt: Object ID 1, index ID 0, page (1:325), row 62. Test (nVarCo
ls
> && (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
> CHECKDB found 0 allocation errors and 1 consistency errors in table
> 'sysobjects' (object ID 1).
> CHECKDB found 0 allocation errors and 1 consistency errors in database
> 'JagTrain'.
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKDB (JagTrain repair_allow_data_loss).
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
> If anyone has any ideas as to what might be causing this problem it would
be
> appreciated.
> Thanks in advance,
> Greg|||Hi Yih-Yoon Lee,
You maybe correct but DBCC CheckDB on our clients computer (ie where the
backup came from) comes up clean. And I've done the backup and restore
several times all with the same result. Plus all backups pass verification.
Any other information you can provide would be appreciated.
Greg
--
greghines@.bigfoot.com.NOSPAM
Remove NOSPAM when replying
"Yih-Yoon Lee" <lee@.yihyoon.com> wrote in message
news:1avgpv091zsvt.1gwr1xbhp2fh7.dlg@.40tude.net...
> Hi Greg,
> Judging from your DBCC CHECKDB output, it appears that your sysobjects
> table has been corrupted. Unfortunately this is probably one of the most
> important system tables in the database as it contains information for
each
> object in the database. The Repair option most likely will not fix the
> corruption.
> If the backup exhibits same problem, that means the database has been
> backed up with corruption. You may have to find other ways to regenerate
> your data, or go to an even older backup.
> Yih-Yoon Lee
> On Wed, 24 Mar 2004 08:24:39 +1100, Greg Hines wrote:
>
failed.
(nVarCols
by
failed.
(nVarCols
by
would be

EXCEPTION_ACCESS_VIOLATION

I got this error when i try to insert a data in a table
with a Text Column in a distributed application (MSTDC
COM+ ASP), somebody have some one idea about this
error ? more descriptions from event viewer :
Error : 0 Severity : 19 State : 0
SqlDumpExceptionHandler: Process 61 generated fatal
exception
c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.Check your SQL Server error log for the exact stack dump that goes with the
Access Violation (AV) message. Pull out the keywords from the first couple
of lines of the dump and search for them in the online Knowledge Base.
Also, use profiler to find out what the exact command is that results in
the AV and see if the same thing happens when you run that command from
Query Analyzer.
Are you on the latest service pack for SQL Server?
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Exception while using MS SQL SERVER 2005

Hi
When I deploy my application on JBOSS connecting to SQL SERVER 2005 using the latest beta driver, I get this exception
com.microsoft.sqlserver.jdbc.SQLServerException: Server failed to resume the transaction, desc: 5000000003
There is no transaction context here, its just a select query.
The same application works fine on SQL SERVER 2000 with new DRIVER (2005 driver)
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
I'll take a look at this and post back to you.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Naren Chelluri" <naren.chelluri@.emagia.com> wrote in message
news:efDvk2W1FHA.3720@.TK2MSFTNGP14.phx.gbl...
> Hi
> When I deploy my application on JBOSS connecting to SQL SERVER 2005 using
> the latest beta driver, I get this exception
> com.microsoft.sqlserver.jdbc.SQLServerException: Server failed to resume
> the transaction, desc: 5000000003
> There is no transaction context here, its just a select query.
> The same application works fine on SQL SERVER 2000 with new DRIVER (2005
> driver)
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
> ASP.NET resources...

Exception in xa_open with SqlServer 2000 SP3a on Win 2003

Hi!
I have an application server and try to access my SqlServer 2000
database running on Win 2003 using a two-phase commit connection
(datasource property enable2Phase=true). The JDBC driver is SP3.
I receive the following exception:
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]xa_open (0) returns -3
at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown
Source)
at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sErrorToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sReplyToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.pro cessReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sReply(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.SQLServerImplStatemen t.getNextResultType(Unknown
Source)
at
com.microsoft.jdbc.base.BaseStatement.commonTransi tionToState(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExec ute(Unknown
Source)
at
com.microsoft.jdbc.base.BasePreparedStatement.post ImplExecute(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecut e(Unknown Source)
at
com.microsoft.jdbc.base.BaseStatement.executeUpdat eInternal(Unknown Source)
at
com.microsoft.jdbc.base.BasePreparedStatement.exec uteUpdate(Unknown Source)
at
com.microsoft.jdbcx.sqlserver.SQLServerImplXAResou rce.executeXaRpc(Unknown
Source)
at
com.microsoft.jdbcx.sqlserver.SQLServerImplXAResou rce.executeXaRpc(Unknown
Source)
at
com.microsoft.jdbcx.sqlserver.SQLServerImplXAResou rce.open(Unknown Source)
at com.microsoft.jdbcx.base.BaseXAConnection.<init>(U nknown Source)
at
com.microsoft.jdbcx.base.BaseXADataSource.getXACon nection(Unknown Source)
at
com.microsoft.jdbcx.sqlserver.SQLServerDataSource. getXAConnection(Unknown
Source)
If I disable either the enable2Phase or use a SqlServer database on
Win2000 everything works fine.
Any ideas?
My JDBC driver reports the following:
Database product name : Microsoft SQL Server
Database product version : Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
JDBC driver name : SQLServer
JDBC driver version : 2.2.0040
David S. Faller wrote:

> Hi!
> I have an application server and try to access my SqlServer 2000
> database running on Win 2003 using a two-phase commit connection
> (datasource property enable2Phase=true). The JDBC driver is SP3.
> I receive the following exception:
> Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
> JDBC][SQLServer]xa_open (0) returns -3
Hi. That's not a driver issue, it is a failure of an ancillary ddl that
implements the extended stored procedures thet SQLServer uses for XA.
There have been recent fixes to those DLLs, so the first thing to do is to
upgrade the DBMS to the latest fixpack.
Joe Weinstein at BEA

> at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)
> at
> com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sErrorToken(Unknown
> Source)
> at
> com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sReplyToken(Unknown
> Source)
> at
> com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.pro cessReplyToken(Unknown
> Source)
> at com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sReply(Unknown
> Source)
> at
> com.microsoft.jdbc.sqlserver.SQLServerImplStatemen t.getNextResultType(Unknown
> Source)
> at
> com.microsoft.jdbc.base.BaseStatement.commonTransi tionToState(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseStatement.postImplExec ute(Unknown
> Source)
> at
> com.microsoft.jdbc.base.BasePreparedStatement.post ImplExecute(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseStatement.commonExecut e(Unknown Source)
> at
> com.microsoft.jdbc.base.BaseStatement.executeUpdat eInternal(Unknown Source)
> at
> com.microsoft.jdbc.base.BasePreparedStatement.exec uteUpdate(Unknown Source)
> at
> com.microsoft.jdbcx.sqlserver.SQLServerImplXAResou rce.executeXaRpc(Unknown
> Source)
> at
> com.microsoft.jdbcx.sqlserver.SQLServerImplXAResou rce.executeXaRpc(Unknown
> Source)
> at
> com.microsoft.jdbcx.sqlserver.SQLServerImplXAResou rce.open(Unknown Source)
> at com.microsoft.jdbcx.base.BaseXAConnection.<init>(U nknown Source)
> at com.microsoft.jdbcx.base.BaseXADataSource.getXACon nection(Unknown
> Source)
> at
> com.microsoft.jdbcx.sqlserver.SQLServerDataSource. getXAConnection(Unknown
> Source)
> If I disable either the enable2Phase or use a SqlServer database on
> Win2000 everything works fine.
> Any ideas?
> My JDBC driver reports the following:
> Database product name : Microsoft SQL Server
> Database product version : Microsoft SQL Server 2000 - 8.00.760 (Intel
> X86)
> JDBC driver name : SQLServer
> JDBC driver version : 2.2.0040
|||Hi Joe,
Thanks for this information. I verified that the SQL Server has been
updated to SP3a and that the sqljdbc.dll in my SQL Server's binn
directory is the one shipped with the latest JDBC driver (SP3).
Still no luck...
Can you give me more details on which dll has to be updated and where to
get the update? The list of post-SP3 updates of SQL Server does not list
any XA related issues
(http://support.microsoft.com/common/...v2000presp4fix).
Thanks,
David Faller
Joe Weinstein wrote:
>
> David S. Faller wrote:
>
> Hi. That's not a driver issue, it is a failure of an ancillary ddl that
> implements the extended stored procedures thet SQLServer uses for XA.
> There have been recent fixes to those DLLs, so the first thing to do is to
> upgrade the DBMS to the latest fixpack.
> Joe Weinstein at BEA
>
>
|||Hi Joe,
Thanks for this information. I verified that the SQL Server has been
updated to SP3a and that the sqljdbc.dll in my SQL Server's binn
directory is the one shipped with the latest JDBC driver (SP3).
Still no luck...
Can you give me more details on which dll has to be updated and where to
get the update? The list of post-SP3 updates of SQL Server does not list
any XA related issues
(http://support.microsoft.com/common/...v2000presp4fix).
Thanks,
David Faller
Joe Weinstein wrote:
>
> David S. Faller wrote:
>
> Hi. That's not a driver issue, it is a failure of an ancillary ddl that
> implements the extended stored procedures thet SQLServer uses for XA.
> There have been recent fixes to those DLLs, so the first thing to do is to
> upgrade the DBMS to the latest fixpack.
> Joe Weinstein at BEA
>
>
|||David S. Faller wrote:

> Hi Joe,
> Thanks for this information. I verified that the SQL Server has been
> updated to SP3a and that the sqljdbc.dll in my SQL Server's binn
> directory is the one shipped with the latest JDBC driver (SP3).
> Still no luck...
> Can you give me more details on which dll has to be updated and where to
> get the update? The list of post-SP3 updates of SQL Server does not list
> any XA related issues
> (http://support.microsoft.com/common/...v2000presp4fix).
Hi. I am surprised that sp4 isn't out yet. I had been told it would have been.
I also have heqrd that MS will make no mention of the XA problem(s) until
the sp4 comes out, at which time it will be in the release notes.
Joe
[vbcol=seagreen]
>
> Thanks,
> David Faller
> Joe Weinstein wrote:
|||--
| Message-ID: <4151A8CE.20005@.bea.com>
| Date: Wed, 22 Sep 2004 09:31:10 -0700
| From: Joe Weinstein <joeNOSPAM@.bea.com>
| User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4)
Gecko/20030624 Netscape/7.1 (ax)
| X-Accept-Language: en-us, en
| MIME-Version: 1.0
| To: "David S. Faller" <davidfaller@.de.ibm.com>
| Subject: Re: Exception in xa_open with SqlServer 2000 SP3a on Win 2003
| References: <#W9Gg$#nEHA.2096@.TK2MSFTNGP15.phx.gbl>
<415062D3.6080401@.bea.com> <OSVCflIoEHA.2340@.TK2MSFTNGP10.phx.gbl>
| In-Reply-To: <OSVCflIoEHA.2340@.TK2MSFTNGP10.phx.gbl>
| Content-Type: text/plain; charset=us-ascii; format=flowed
| Content-Transfer-Encoding: 7bit
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: sj-ez-63-96-169-77.bea.com 63.96.169.77
| Lines: 1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.jdbcdriver:6296
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
|
|
| David S. Faller wrote:
|
| > Hi Joe,
| >
| > Thanks for this information. I verified that the SQL Server has been
| > updated to SP3a and that the sqljdbc.dll in my SQL Server's binn
| > directory is the one shipped with the latest JDBC driver (SP3).
| > Still no luck...
| >
| > Can you give me more details on which dll has to be updated and where
to
| > get the update? The list of post-SP3 updates of SQL Server does not
list
| > any XA related issues
| >
(http://support.microsoft.com/common/...v2000presp4fix).
|
| Hi. I am surprised that sp4 isn't out yet. I had been told it would have
been.
| I also have heqrd that MS will make no mention of the XA problem(s) until
| the sp4 comes out, at which time it will be in the release notes.
| Joe
|
| >
| >
| > Thanks,
| > David Faller
| >
| > Joe Weinstein wrote:
| >
| >>
| >>
| >> David S. Faller wrote:
| >>
| >>> Hi!
| >>>
| >>> I have an application server and try to access my SqlServer 2000
| >>> database running on Win 2003 using a two-phase commit connection
| >>> (datasource property enable2Phase=true). The JDBC driver is SP3.
| >>>
| >>> I receive the following exception:
| >>>
| >>> Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver
| >>> for JDBC][SQLServer]xa_open (0) returns -3
| >>
| >>
| >>
| >> Hi. That's not a driver issue, it is a failure of an ancillary ddl that
| >> implements the extended stored procedures thet SQLServer uses for XA.
| >> There have been recent fixes to those DLLs, so the first thing to do
| >> is to
| >> upgrade the DBMS to the latest fixpack.
| >> Joe Weinstein at BEA
| >>
| >>> at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown
| >>> Source)
| >>> at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown
| >>> Source)
| >>> at
| >>> com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sErrorToken(Unknown
| >>> Source)
| >>> at
| >>> com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sReplyToken(Unknown
| >>> Source)
| >>> at
| >>>
com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.pro cessReplyToken(Unknown
| >>> Source)
| >>> at
| >>> com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sReply(Unknown
Source)
| >>> at
| >>>
com.microsoft.jdbc.sqlserver.SQLServerImplStatemen t.getNextResultType(Unknow
n
| >>> Source)
| >>> at
| >>> com.microsoft.jdbc.base.BaseStatement.commonTransi tionToState(Unknown
| >>> Source)
| >>> at com.microsoft.jdbc.base.BaseStatement.postImplExec ute(Unknown
| >>> Source)
| >>> at
| >>> com.microsoft.jdbc.base.BasePreparedStatement.post ImplExecute(Unknown
| >>> Source)
| >>> at com.microsoft.jdbc.base.BaseStatement.commonExecut e(Unknown
| >>> Source)
| >>> at
| >>> com.microsoft.jdbc.base.BaseStatement.executeUpdat eInternal(Unknown
| >>> Source)
| >>> at
| >>> com.microsoft.jdbc.base.BasePreparedStatement.exec uteUpdate(Unknown
| >>> Source)
| >>> at
| >>>
com.microsoft.jdbcx.sqlserver.SQLServerImplXAResou rce.executeXaRpc(Unknown
| >>> Source)
| >>> at
| >>>
com.microsoft.jdbcx.sqlserver.SQLServerImplXAResou rce.executeXaRpc(Unknown
| >>> Source)
| >>> at
| >>> com.microsoft.jdbcx.sqlserver.SQLServerImplXAResou rce.open(Unknown
| >>> Source)
| >>> at com.microsoft.jdbcx.base.BaseXAConnection.<init>(U nknown
Source)
| >>> at
| >>> com.microsoft.jdbcx.base.BaseXADataSource.getXACon nection(Unknown
| >>> Source)
| >>> at
| >>>
com.microsoft.jdbcx.sqlserver.SQLServerDataSource. getXAConnection(Unknown
| >>> Source)
| >>>
| >>> If I disable either the enable2Phase or use a SqlServer database on
| >>> Win2000 everything works fine.
| >>>
| >>> Any ideas?
| >>>
| >>> My JDBC driver reports the following:
| >>> Database product name : Microsoft SQL Server
| >>> Database product version : Microsoft SQL Server 2000 - 8.00.760
| >>> (Intel X86)
| >>> JDBC driver name : SQLServer
| >>> JDBC driver version : 2.2.0040
| >>
| >>
| >>
|
|
We have a Knowledge Base article that describes some additional changes
that are required for XA transaction support on Windows Server 2003:
817066 INFO: Registry Entries Are Required for XA Transaction Support
http://support.microsoft.com/?id=817066
Please review this document and see if this resolves the issue.
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
|||Carb Simien [MSFT] wrote:
> We have a Knowledge Base article that describes some additional
> changes
> that are required for XA transaction support on Windows Server 2003:
> 817066 INFO: Registry Entries Are Required for XA Transaction
> Support
> http://support.microsoft.com/?id=817066
> Please review this document and see if this resolves the issue.
> Carb Simien, MCSE MCDBA MCAD
> Microsoft Developer Support - Web Data
>
I tried adding a registry entry for sqlsrv32.dll but I still get
"[SQLServer]xa_open (0) returns -3" in Java and "xa_open_entry failed"
in sqljdbc.log. Are there other DLLs I'm supposed to add? How do we
find out which DLLs need registry entries?
memebag
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message400191.html

exception in in connection with SQL server

Hi all,
I am using OdbcConnection for coonectivity with SQL Server db. My code
is working fine with windows application but in ASP.NET or in
webservice its raising following exception -
"ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.
ERROR [01000] [Microsoft][ODBC SQL Server Driver]
[DBNETLIB]ConnectionOpen (Connect())."
at System.Data.Odbc.OdbcConnection.Open()
Same code is working fine for Orace DSN.
My code:
OdbcConnection conn = new
OdbcConnection("dsn=MyDsn;uid=sa;pwd=stars;");
conn.Open();
Please help me to sort out this problem
Thanks
Dharmendra
Check the SQL Server log for login failures. How is your web
app authenticating? How is IIS configured? What are you
using in your config files for the application?
You need to see what login is failing depending on how you
have things configured.
-Sue
On 14 May 2007 23:03:36 -0700, tomar
<dharmendratomar2000@.gmail.com> wrote:

>Hi all,
>I am using OdbcConnection for coonectivity with SQL Server db. My code
>is working fine with windows application but in ASP.NET or in
>webservice its raising following exception -
> "ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
>Server does not exist or access denied.
>ERROR [01000] [Microsoft][ODBC SQL Server Driver]
>[DBNETLIB]ConnectionOpen (Connect())."
> at System.Data.Odbc.OdbcConnection.Open()
>Same code is working fine for Orace DSN.
>My code:
>OdbcConnection conn = new
>OdbcConnection("dsn=MyDsn;uid=sa;pwd=stars;");
>conn.Open();
>
>Please help me to sort out this problem
>Thanks
>Dharmendra

exception in in connection with SQL server

Hi all,
I am using OdbcConnection for coonectivity with SQL Server db. My code
is working fine with windows application but in ASP.NET or in
webservice its raising following exception -
"ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]
SQL
Server does not exist or access denied.
ERROR [01000] [Microsoft][ODBC SQL Server Driver]
[DBNETLIB]ConnectionOpen (Connect())."
at System.Data.Odbc.OdbcConnection.Open()
Same code is working fine for Orace DSN.
My code:
OdbcConnection conn = new
OdbcConnection("dsn=MyDsn;uid=sa;pwd=stars;");
conn.Open();
Please help me to sort out this problem
Thanks
DharmendraCheck the SQL Server log for login failures. How is your web
app authenticating? How is IIS configured? What are you
using in your config files for the application?
You need to see what login is failing depending on how you
have things configured.
-Sue
On 14 May 2007 23:03:36 -0700, tomar
<dharmendratomar2000@.gmail.com> wrote:

>Hi all,
>I am using OdbcConnection for coonectivity with SQL Server db. My code
>is working fine with windows application but in ASP.NET or in
>webservice its raising following exception -
> "ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLI
B]SQL
>Server does not exist or access denied.
>ERROR [01000] [Microsoft][ODBC SQL Server Driver]
>[DBNETLIB]ConnectionOpen (Connect())."
> at System.Data.Odbc.OdbcConnection.Open()
>Same code is working fine for Orace DSN.
>My code:
>OdbcConnection conn = new
>OdbcConnection("dsn=MyDsn;uid=sa;pwd=stars;");
>conn.Open();
>
>Please help me to sort out this problem
>Thanks
>Dharmendra

Exception from HRESULT: 0xC0048004

Hi, there;
I created a SSIS package in a ASP.NEP application which importing data from some .dbf file. "Exception from HRESULT: 0xC0048004" happened to two tables. I had a look this exception at http://msdn2.microsoft.com/en-us/library/ms345164.aspx, it says: The index is not valid. But there is no index defined in my destination table.

Does anybody how to resolve it?

Thanks

Qiuwei wrote:

Hi, there;
I created a SSIS package in a ASP.NEP application which importing data from some .dbf file. "Exception from HRESULT: 0xC0048004" happened to two tables. I had a look this exception at http://msdn2.microsoft.com/en-us/library/ms345164.aspx, it says: The index is not valid. But there is no index defined in my destination table.

Does anybody how to resolve it?

Thanks

its nothing to do with indexes in your tables. It is most likely referring to an attempt to reference an item in a collection within your package. It suggests that your package is corrupt.

Do you get the same error when you execute the package using dtexec.exe?

-Jamie

Exception comes from database,

Hi All,

Currently i am working on some web application, and facing some exceptions. Actually I am throwing exception from DB functions in some of cases, and then displaying error.aspx (custom error page). It is working fine.

But when i change language of browser from english to any other language, first time my custom error page comes, but afterwards, following error page comes:

Server error in '/sampletest' application
Exception of Project.module.myException is thrown.

Please help if any idea for same.

Please also let me know whether i have to kept lots of aspx files for different types of exception or messages.

Thanks In Advance
Arnold

If you give a sample of code then its easier to find where issue is...

Excel to Sql Server

Hi

I am trying to upload a excel spreadsheet using a web application application into a sql server database.

Basically I'm tryign to code a a upload button, that takes the excel spreadsheet and inserts it into a table in the database.

I have been lookign for code examples but cannot find out, and I am really struggling...any help would be greatly appreciated. I am trying to do this using asp.net (vb).

ThanksI'm not an app developer but this may help (or might not :))

http://www.sqldev.net/dts/DotNETCookBook.htm

Excel report migration + html display

Hi,
We have the following 2 problem areas in our application:
1) We have a excel report that calls a SQL SP which returns 13 resultsets.
These resultsets are then read by a excel macro and a report is printed in
the worksheet. We now want to move this to SSRS 2000. I was trying to find a
easy way out by embedding a excel object in the report and use the same
macro. Is this possible? If not then can anyone suggest any workaround? For
the SP's returning multiple resultsets, we are thinking of creating 13
datasets each of them will have their own SP.
In order to convert to SSRS 2000, do i need to recode the entire logic of
the macro in SSRS? or is there any better way.
2) As displaying of RTF is not supported in SSRS 2000, I was thinking of
writing some code which will parse the RTF and spit out a formatted HTML. Is
it possible to display HTML in the report? If not, then is there any
workaround?
3) I read in some of the posts that supporting HTML in SSRS will be a
security hole-what does that mean?
Thanks in advance
--
Afaq> <snip>
> We now want to move this to SSRS 2000. I was trying to
> find a
> easy way out by embedding a excel object in the report and use the
> same
> macro. Is this possible? If not then can anyone suggest any
> workaround? For
> the SP's returning multiple resultsets, we are thinking of creating 13
> datasets each of them will have their own SP.
> In order to convert to SSRS 2000, do i need to recode the entire logic
> of
> the macro in SSRS? or is there any better way.
> <snip>
> Thanks in advance
Hello Afaq,
SoftArtisans OfficeWriter is a report designer and custom rendering extension
for SSRS that lets you use real Excel and Word files as report templates,
and deliver those files intact. If you put VBA code in the template, it
will be preserved when it's delievered by Reporting Services:
http://officewriter.softartisans.com/officewriter-250.aspx
Best,
Chris

excel generated xml file to sql

hi,
i hv a report generated from a web-based application. although the extension
is '.xls', this is really an xml doc (am i correct?). i say this because if
i
'save as' the file, the extension that appears is 'XML spreadsheet'.
i don't want to open the file and save it as an excel file, because that
would mean there will be a manual process in my script. what is the best way
to import this file directly to sql? i tried DTS but DTS cannot recognize th
e
file.
thanks for your help!Do you want to import the XML as a BLOB or put it into tables?
Michael
"juvethski" <juvethski@.discussions.microsoft.com> wrote in message
news:A2B28AB0-A366-4E5E-AF3A-224E5E59239D@.microsoft.com...
> hi,
> i hv a report generated from a web-based application. although the
> extension
> is '.xls', this is really an xml doc (am i correct?). i say this because
> if i
> 'save as' the file, the extension that appears is 'XML spreadsheet'.
> i don't want to open the file and save it as an excel file, because that
> would mean there will be a manual process in my script. what is the best
> way
> to import this file directly to sql? i tried DTS but DTS cannot recognize
> the
> file.
> thanks for your help!|||i want to put it into a table. thanks in advance for the help.
cheers.
"Michael Rys [MSFT]" wrote:

> Do you want to import the XML as a BLOB or put it into tables?
> Michael
> "juvethski" <juvethski@.discussions.microsoft.com> wrote in message
> news:A2B28AB0-A366-4E5E-AF3A-224E5E59239D@.microsoft.com...
>
>|||i want to put it into a table. the table can be existing, or not yet
existing. thanks in advance.
cheers
"Michael Rys [MSFT]" wrote:

> Do you want to import the XML as a BLOB or put it into tables?
> Michael
> "juvethski" <juvethski@.discussions.microsoft.com> wrote in message
> news:A2B28AB0-A366-4E5E-AF3A-224E5E59239D@.microsoft.com...
>
>|||You may consider use Bulkload from Sqlxml or using OpenXml i nT-SQL if your
file size is not big.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"juvethski" <juvethski@.discussions.microsoft.com> wrote in message
news:A2B28AB0-A366-4E5E-AF3A-224E5E59239D@.microsoft.com...
> hi,
> i hv a report generated from a web-based application. although the
> extension
> is '.xls', this is really an xml doc (am i correct?). i say this because
> if i
> 'save as' the file, the extension that appears is 'XML spreadsheet'.
> i don't want to open the file and save it as an excel file, because that
> would mean there will be a manual process in my script. what is the best
> way
> to import this file directly to sql? i tried DTS but DTS cannot recognize
> the
> file.
> thanks for your help!

excel generated xml file to sql

hi,
i hv a report generated from a web-based application. although the extension
is '.xls', this is really an xml doc (am i correct?). i say this because if i
'save as' the file, the extension that appears is 'XML spreadsheet'.
i don't want to open the file and save it as an excel file, because that
would mean there will be a manual process in my script. what is the best way
to import this file directly to sql? i tried DTS but DTS cannot recognize the
file.
thanks for your help!
Do you want to import the XML as a BLOB or put it into tables?
Michael
"juvethski" <juvethski@.discussions.microsoft.com> wrote in message
news:A2B28AB0-A366-4E5E-AF3A-224E5E59239D@.microsoft.com...
> hi,
> i hv a report generated from a web-based application. although the
> extension
> is '.xls', this is really an xml doc (am i correct?). i say this because
> if i
> 'save as' the file, the extension that appears is 'XML spreadsheet'.
> i don't want to open the file and save it as an excel file, because that
> would mean there will be a manual process in my script. what is the best
> way
> to import this file directly to sql? i tried DTS but DTS cannot recognize
> the
> file.
> thanks for your help!
|||i want to put it into a table. thanks in advance for the help.
cheers.
"Michael Rys [MSFT]" wrote:

> Do you want to import the XML as a BLOB or put it into tables?
> Michael
> "juvethski" <juvethski@.discussions.microsoft.com> wrote in message
> news:A2B28AB0-A366-4E5E-AF3A-224E5E59239D@.microsoft.com...
>
>
|||i want to put it into a table. the table can be existing, or not yet
existing. thanks in advance.
cheers
"Michael Rys [MSFT]" wrote:

> Do you want to import the XML as a BLOB or put it into tables?
> Michael
> "juvethski" <juvethski@.discussions.microsoft.com> wrote in message
> news:A2B28AB0-A366-4E5E-AF3A-224E5E59239D@.microsoft.com...
>
>
|||You may consider use Bulkload from Sqlxml or using OpenXml i nT-SQL if your
file size is not big.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"juvethski" <juvethski@.discussions.microsoft.com> wrote in message
news:A2B28AB0-A366-4E5E-AF3A-224E5E59239D@.microsoft.com...
> hi,
> i hv a report generated from a web-based application. although the
> extension
> is '.xls', this is really an xml doc (am i correct?). i say this because
> if i
> 'save as' the file, the extension that appears is 'XML spreadsheet'.
> i don't want to open the file and save it as an excel file, because that
> would mean there will be a manual process in my script. what is the best
> way
> to import this file directly to sql? i tried DTS but DTS cannot recognize
> the
> file.
> thanks for your help!