473,836 Members | 1,457 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Yet another BCP issue

bc
Hello all,

Background:
I've posted a couple questions recently regarding using BCP to extract
many tables to text files. I've written an extract application that
bcp's about 100 tables from a database to text files. I've run into a
couple limitations using BCP, but I finally landed on (what I thought)
was a solid solution. I now call bcp passing a sproc name and a
parameter or two and having that sproc execute the query for me,
thereby doing the extracts to the proper files.

Background-Detail:
The sproc that executes the query seems to be working just fine for
all but a couple tables. I have a need for extracting files in a
particular format (quoted and pipe-delimited, with quoted and piped
column headers as the first row in the resulting file), and that's
what my sproc does. For a given table name, I select all the columns
and interrogate their column type (systype) and wrap the proper
formatting around the particular field value (i.e. "|" + field_name +
"|"). After building the proper SQL query, I execute it and the
results are bcp'd to the specified extract file.

Issue:
For some reason, any table that contains a bit field as the last field
in the table design, BCP cannot execute the query, claiming there's a
syntax error near the end of my query (unclosed quotation mark). For
bit field types in SQL Server, the select query that I build for the
format of the extract involves a SELECT..CASE statement to convert a 1
to TRUE and 0 to FALSE. The odd thing is that the query that is built
in the sproc will work just fine in SQL Query Analyzer, as well as
just putting the desired query in a varchar variable in a sproc
(without building it by looking up field types) and executing it via
BCP. BCP only croaks when I run the sproc as designed and the final
field selected in the generated query has a type of 'bit'. There are
other tables that contain bit fields and BCP seems to run the extract
queries just fine for those instances. The only difference being that
those table designs don't contain a bit field as the last field.

It's a tough thing to accurately describe, so please reply with
further questions, and I'll try to help you better understand. But the
root issue is that the SAME EXACT query will work in query analyzer as
well as a stored procedure, but not when executing the stored
procedure via BCP.

Anyone seen this type of inconsistency using BCP?

Thanks for any help on this one.

/bc
Jul 20 '05 #1
9 10096
bc (bk***@excite.c om) writes:
For some reason, any table that contains a bit field as the last field
in the table design, BCP cannot execute the query, claiming there's a
syntax error near the end of my query (unclosed quotation mark). For
bit field types in SQL Server, the select query that I build for the
format of the extract involves a SELECT..CASE statement to convert a 1
to TRUE and 0 to FALSE. The odd thing is that the query that is built
in the sproc will work just fine in SQL Query Analyzer, as well as
just putting the desired query in a varchar variable in a sproc
(without building it by looking up field types) and executing it via
BCP. BCP only croaks when I run the sproc as designed and the final
field selected in the generated query has a type of 'bit'. There are
other tables that contain bit fields and BCP seems to run the extract
queries just fine for those instances. The only difference being that
those table designs don't contain a bit field as the last field.


This could certainly be easier to answer if you included:

o The BCP command.
o The error message.
o The stored procedure.
o The actually generated SQL.
--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2
bc
Erland Sommarskog <so****@algonet .se> wrote in message news:<Xn******* *************** @127.0.0.1>...
bc (bk***@excite.c om) writes:
For some reason, any table that contains a bit field as the last field
in the table design, BCP cannot execute the query, claiming there's a
syntax error near the end of my query (unclosed quotation mark). For
bit field types in SQL Server, the select query that I build for the
format of the extract involves a SELECT..CASE statement to convert a 1
to TRUE and 0 to FALSE. The odd thing is that the query that is built
in the sproc will work just fine in SQL Query Analyzer, as well as
just putting the desired query in a varchar variable in a sproc
(without building it by looking up field types) and executing it via
BCP. BCP only croaks when I run the sproc as designed and the final
field selected in the generated query has a type of 'bit'. There are
other tables that contain bit fields and BCP seems to run the extract
queries just fine for those instances. The only difference being that
those table designs don't contain a bit field as the last field.


This could certainly be easier to answer if you included:

o The BCP command.
o The error message.
o The stored procedure.
o The actually generated SQL.


Okay, here goes...

Here's my BCP command:
bcp "EXEC SCMDC..scm_extr acts_SelectByTa bleName
'ITEM_SERVICE_C ONTROL'" queryout
\\ausscmdevdb02 \bc_test\SCMDC_ Extracts\chassi s.txt -c -r \r\n -S
ausscmdevdb02 -U <user> -P <password>

Here's the error message the BCP command displays:
SQLState = 37000, NativeError = 170
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
Incorrect syntax
near 'E'. SQLState = 37000, NativeError = 105 Error = [Microsoft][ODBC
SQL Server Driver][SQL Server]Unclosed quotation mark before the
character string ' FROM FULFILLMENT_LOC ATION_CLASS '.

Here's some sample generated SQL that the sproc eventually runs (you
should be able to put this query in Query Analyzer to see it better).
This is the query that works just fine in Query Analyzer, but not thru
BCP!:

SELECT + '"' + ISNULL(CAST(ful fillment_loc_id AS nvarchar(4000)) , '')
+ '"|' + CASE WHEN sp_flag = 1 THEN 'True|' WHEN sp_flag IS NULL THEN
'|' ELSE 'False|' END FROM fulfillment_loc ation_class


Here's the stored procedure code (kind of long). You should be able to
put this in Query Analyzer and see it okay. Can look at my initial
post in this thread to see a brief explanation of what I'm doing in
the sproc:

CREATE PROCEDURE dbo.scm_Extract s_SelectByTable Name
@p_sExtractTabl eName varchar(1000),
@p_sExtractHint varchar(1000) = ''

AS SET NOCOUNT ON

DECLARE @sExtractQuery nvarchar(4000)
DECLARE @sCharValueSele ct nvarchar(1000)
DECLARE @sIntValueSelec t nvarchar(1000)
DECLARE @sMoneyValueSel ect nvarchar(1000)
DECLARE @sDateTimeValue Select nvarchar(1000)
DECLARE @sBitValueSelec t nvarchar(1000)
DECLARE @sUniqueIDSelec t nvarchar(1000)

SET @sExtractQuery = 'SELECT '
SET @sCharValueSele ct = ' + ''"'' + ISNULL(CAST(**C OLUMN** AS
nvarchar(4000)) , '''') + ''"|'' '
SET @sIntValueSelec t = ' + ISNULL(CAST(**C OLUMN** AS
nvarchar(4000)) , '''') + ''|'' '
SET @sMoneyValueSel ect = ' + ISNULL(CAST(**C OLUMN** AS
nvarchar(4000)) , ''0'') + ''|'' '
SET @sDateTimeValue Select = ' + ISNULL(CONVERT( nvarchar(4000),
**COLUMN**, 121), '''') + ''|'' '
SET @sBitValueSelec t = ' + CASE WHEN **COLUMN** = 1 THEN ''True|''
WHEN **COLUMN** IS NULL THEN ''|'' ELSE ''False|'' END'
SET @sUniqueIDSelec t = ' + ''{'' + ISNULL (CONVERT(nvarch ar(36),
**COLUMN**), '''') + ''}'' + ''|'' '

SELECT @sExtractQuery = @sExtractQuery +
CASE types.name
-- Text
WHEN 'nvarchar' THEN REPLACE(@sCharV alueSelect, '**COLUMN**',
cols.name)
WHEN 'varchar' THEN REPLACE(@sCharV alueSelect, '**COLUMN**',
cols.name)
WHEN 'char' THEN REPLACE(@sCharV alueSelect, '**COLUMN**',
cols.name)
WHEN 'nchar' THEN REPLACE(@sCharV alueSelect, '**COLUMN**',
cols.name)
WHEN 'ntext' THEN REPLACE(@sCharV alueSelect, '**COLUMN**',
cols.name)
WHEN 'text' THEN REPLACE(@sCharV alueSelect, '**COLUMN**',
cols.name)
WHEN 'char' THEN REPLACE(@sCharV alueSelect, '**COLUMN**',
cols.name)
WHEN 'sql_variant' THEN REPLACE(@sCharV alueSelect, '**COLUMN**',
cols.name)

-- Numbers
WHEN 'int' THEN REPLACE(@sIntVa lueSelect, '**COLUMN**',
cols.name)
WHEN 'decimal' THEN REPLACE(@sIntVa lueSelect, '**COLUMN**',
cols.name)
WHEN 'float' THEN REPLACE(@sIntVa lueSelect, '**COLUMN**',
cols.name)
WHEN 'tinyint' THEN REPLACE(@sIntVa lueSelect, '**COLUMN**',
cols.name)
WHEN 'bigint' THEN REPLACE(@sIntVa lueSelect, '**COLUMN**',
cols.name)
WHEN 'smallint' THEN REPLACE(@sIntVa lueSelect, '**COLUMN**',
cols.name)
WHEN 'binary' THEN REPLACE(@sIntVa lueSelect, '**COLUMN**',
cols.name)
WHEN 'varbinary' THEN REPLACE(@sIntVa lueSelect, '**COLUMN**',
cols.name)
WHEN 'numeric' THEN REPLACE(@sIntVa lueSelect, '**COLUMN**',
cols.name)
WHEN 'real' THEN REPLACE(@sIntVa lueSelect, '**COLUMN**',
cols.name)

-- Money
WHEN 'money' THEN REPLACE(@sMoney ValueSelect, '**COLUMN**',
cols.name)
WHEN 'smallmoney' THEN REPLACE(@sMoney ValueSelect, '**COLUMN**',
cols.name)

-- Datetime
WHEN 'datetime' THEN REPLACE(@sDateT imeValueSelect, '**COLUMN**',
cols.name)
WHEN 'timestamp' THEN REPLACE(@sDateT imeValueSelect, '**COLUMN**',
cols.name)
WHEN 'smalldatetime' THEN REPLACE(@sDateT imeValueSelect,
'**COLUMN**', cols.name)

-- Bit
WHEN 'bit' THEN REPLACE(@sBitVa lueSelect, '**COLUMN**',
cols.name)

-- Unique Identifier
WHEN 'uniqueidentifi er' THEN REPLACE(@sUniqu eIDSelect,
'**COLUMN**', cols.name)
--ELSE ''
END
FROM syscolumns cols
INNER JOIN sysobjects obj ON
obj.id = cols.id
INNER JOIN systypes types ON
types.xtype = cols.xtype
WHERE obj.id = (SELECT id FROM sysobjects WHERE name =
@p_sExtractTabl eName) AND
types.name <> 'sysname' -- I noticed some columns are repeated in
syscolumns for a given table. The only difference
-- is the column type. So a column name can be listed 2x in
syscolumns, but one record will have
-- a type of 'nvarchar' and the other 'sysname'. For this
purpose, I want DON'T want the sysname type.
ORDER BY cols.colid

--
-- Add From clause with table name and any optional query hints
(where clauses and/or order by clauses)
--

-- Modify the query string to remove the last two characters (i.e. |'
) so the query will execute properly.
-- If the last select statement in the query string IS NOT a CASE
statement, then don't edit the string built thus far.
DECLARE @CheckString nvarchar(20)
SET @CheckString = RTRIM(RIGHT(@sE xtractQuery, 3))
-- print @sExtractQuery

IF (@CheckString <> 'END')
SET @sExtractQuery = LEFT(@sExtractQ uery,LEN(@sExtr actQuery)-2) +
'''' -- remove the last two characters (i.e. |' ) from query
--ELSE
--SET @sExtractQuery = @sExtractQuery + '"'

SET @sExtractQuery = RTRIM(LTRIM(@sE xtractQuery)) + ' FROM ' +
RTRIM(LTRIM(@p_ sExtractTableNa me)) + ' ' +
RTRIM(LTRIM(@p_ sExtractHint))

EXEC sp_executesql @sExtractQuery

SET NOCOUNT OFF
GO

Thanks a lot for any help on this. It's a weird one...

/bc
Jul 20 '05 #3
bc (bk***@excite.c om) writes:
Here's my BCP command:
bcp "EXEC SCMDC..scm_extr acts_SelectByTa bleName
'ITEM_SERVICE_C ONTROL'" queryout
\\ausscmdevdb02 \bc_test\SCMDC_ Extracts\chassi s.txt -c -r \r\n -S
ausscmdevdb02 -U <user> -P <password>

Here's the error message the BCP command displays:
SQLState = 37000, NativeError = 170
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
Incorrect syntax
near 'E'. SQLState = 37000, NativeError = 105 Error = [Microsoft][ODBC
SQL Server Driver][SQL Server]Unclosed quotation mark before the
character string ' FROM FULFILLMENT_LOC ATION_CLASS '.


I have looked at your procedure, and I'm afraid that it is back to the
drawing board.

There are two problems with the procedure. When I first ran it, and I
added a "SELECT @sExtractQuery" , NULL was all I got. When I first
ran the command "SET CONCAT_NULL_YIE LDS_NULL OFF", I did get some
SQL. However, BCP is an ODBC client, which means that by default it
runs with these options on: CONCAT_NULL_YIE LDS_NULL, ANSI_NULLS,
and ANSI_WARNINGS and ANSI_PADDING. The only option have control
over is QUOTED_IDENTIFI ER.

The second problem is the constrcut:

SELECT @x = @x + val FROM tbl ORDER BY val

This is called aggregate concatenation, and there is no correct behaviour
defined for this. That is, you may get what you expect, or you may get
something different. So you are better of replacing this with a cursor
loop.

See also http://support.microsoft.com/default.aspx?scid=287515.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #4
bc
Erland Sommarskog <es****@sommars kog.se> wrote in message news:<Xn******* *************** @127.0.0.1>...
bc (bk***@excite.c om) writes:
Here's my BCP command:
bcp "EXEC SCMDC..scm_extr acts_SelectByTa bleName
'ITEM_SERVICE_C ONTROL'" queryout
\\ausscmdevdb02 \bc_test\SCMDC_ Extracts\chassi s.txt -c -r \r\n -S
ausscmdevdb02 -U <user> -P <password>

Here's the error message the BCP command displays:
SQLState = 37000, NativeError = 170
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
Incorrect syntax
near 'E'. SQLState = 37000, NativeError = 105 Error = [Microsoft][ODBC
SQL Server Driver][SQL Server]Unclosed quotation mark before the
character string ' FROM FULFILLMENT_LOC ATION_CLASS '.


I have looked at your procedure, and I'm afraid that it is back to the
drawing board.

There are two problems with the procedure. When I first ran it, and I
added a "SELECT @sExtractQuery" , NULL was all I got. When I first
ran the command "SET CONCAT_NULL_YIE LDS_NULL OFF", I did get some
SQL. However, BCP is an ODBC client, which means that by default it
runs with these options on: CONCAT_NULL_YIE LDS_NULL, ANSI_NULLS,
and ANSI_WARNINGS and ANSI_PADDING. The only option have control
over is QUOTED_IDENTIFI ER.

The second problem is the constrcut:

SELECT @x = @x + val FROM tbl ORDER BY val

This is called aggregate concatenation, and there is no correct behaviour
defined for this. That is, you may get what you expect, or you may get
something different. So you are better of replacing this with a cursor
loop.

See also http://support.microsoft.com/default.aspx?scid=287515.


Erland,

Thanks for your help with this issue thus far. I appreciate it very
much.

Reading the link you provided that regarding aggregate conact.
statements and order by clauses was beneficial. Just commenting out my
order by clause allowed all necessary queries to work from BCP.
However, I need that order by clause, so I followed your advice and
used a cursor to build my select and then execute it, but I now get
the old 'BCP host-files must contain at least one column' error for
ALL queries, not just the couple that were bothering me before.

So, I did away with the cursor and opted for loading a temp table with
the values I need to key off of (where I would normally issue the
order by), and built the select from the temp table (already in the
order I need it), but I get the same original error - complaining
about an unclosed quote in the built select statement.

I'm beginning to think that your previous comment about going back to
the drawing board is right-on.

I'm about to throw in the towel on this BCP crap.

/bc
Jul 20 '05 #5
bc (bk***@excite.c om) writes:
However, I need that order by clause, so I followed your advice and
used a cursor to build my select and then execute it, but I now get
the old 'BCP host-files must contain at least one column' error for
ALL queries, not just the couple that were bothering me before.
Which probably have to do with the fact that when you queryout, BCP
must find out how the result set looks like, and therefore issues
the query first once with SET FMTONLY ON. In this mode, SQL Server
just sifts through the statements without executing them and reports
all result sets it finds. But if you are using temp tables that you
create in the procedure, there will be no result set to find.

I have not used queryout myself that much, but I've seen other MVPs
point out that queryout is not that robust.
So, I did away with the cursor and opted for loading a temp table with
the values I need to key off of (where I would normally issue the
order by), and built the select from the temp table (already in the
order I need it), but I get the same original error - complaining
about an unclosed quote in the built select statement.

I'm beginning to think that your previous comment about going back to
the drawing board is right-on.

I'm about to throw in the towel on this BCP crap.


BCP is not crap, but you have to take it for what it is. It is certainly
quite a squared tool. In many cases it is able to do the job, but if
you try to push it to its limits, you fall through quite soon.

I don't know exactly what you are really trying to do, but I get the
feeling that you are doing the mistake of trying to do everything in
T-SQL. My guess is that if I had your problem I would write a Perl
script which extracted the table information and save all data to
extract into a temp table, and then used the BCP API to bulk copy
the stuff out.

You don't have to do it in Perl, but you would to use something
from which you can access the BCP API, so you might have to resort
to C++, as there is no object model available.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #6
bc
>
I don't know exactly what you are really trying to do, but I get the
feeling that you are doing the mistake of trying to do everything in
T-SQL. My guess is that if I had your problem I would write a Perl
script which extracted the table information and save all data to
extract into a temp table, and then used the BCP API to bulk copy
the stuff out.

You don't have to do it in Perl, but you would to use something
from which you can access the BCP API, so you might have to resort
to C++, as there is no object model available.


I have a C# app that executes BCP commands to extract data from each
of my tables. All tables need to be extracted, but some are too large
for a single extract file. This situation requires ranges of data to
be pulled for each extract. Each BCP command includes a call to a a
stored proc, passing in a table name and optional hints (where clause
criteria, order by), as well as db login info.

Example: bcp "exec scmdc..scm_Extr acts_SelectByTa bleName
'ITEM_CATALOG', 'WHERE item_catalog_id between 10 and 19 order by
catalog_id asc'" -queryout -c \r\n \\file\location \name.txt <login
info>

The actual WORK is done in the stored proc. The extracts must be
formatted in a certain way. All fields should be pipe-delimited. If a
field is a char,varchar,nv archar,etc (text field), the value in the
extract should be quote-delimited (i.e. |"foo"|). If it's a numeric or
datetime field, there should NOT be any quotes -- just between the
pipes (i.e. |12345|). In order to determine how to format the
extracted data, I need to determine a field's type, then build a
SELECT statement and subsequently execute it to run the extract.

The stored proc logic:
- Get all fields for a given table and their type.
- Do this by selecting col_id, col_name, col_type from
sysobjects,sysc olumns db tables.
- Then use aggregate concatenation to build the select statement that
will be run to create an extract with the correct format for all the
records selected.
I spawn off multiple threads to do several BCP extracts at a time,
logging the number of records extracted and any errors along the way.

Hope that makes sense.

Erland, your help (along with others) in this forum has been a HUGE
help. I'll try and post my final stored proc code here soon. It's very
concise and quite speedy.
later,

/bc
Jul 20 '05 #7
bc (bk***@excite.c om) writes:
I have a C# app that executes BCP commands to extract data from each
of my tables. All tables need to be extracted, but some are too large
for a single extract file. This situation requires ranges of data to
be pulled for each extract. Each BCP command includes a call to a a
stored proc, passing in a table name and optional hints (where clause
criteria, order by), as well as db login info.


I would do the work to build the SQL statements in the C# app. That
would save you from all the hassle of BCP queryout playing tricks with
you, because BCP would just see the final SELECT statement.

Ideally, I would start the bulk copy from C# as well, but there is no bulk-
copy interface in ADO .Net.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #8
bc
>
I would do the work to build the SQL statements in the C# app. That
would save you from all the hassle of BCP queryout playing tricks with
you, because BCP would just see the final SELECT statement.
Yeah, I tried that initially (actually wrote the code in C# using
SQLDMO to look at a table and get the fields/types and built the
select statement), but the BCP queryout SQL hint got too large (1024
byte limit) on a couple tables, so that's why I went to TSQL. It's
actually working quite well now. The TSQL that I run to build the
select statement is sub-second in my unit tests. I'll send you the
..sql file of my sproc and you can have a look-see.

Ideally, I would start the bulk copy from C# as well, but there is no bulk-
copy interface in ADO .Net.


I used the SQLDMO COM component inside of C# to get the fields/types
for a particular table in my previous attempts (as noted in my
previous posts on this issue) at doing extracts using BCP. It seemed
to work just fine, albeit a little slow.

Thanks,

/bc
Jul 20 '05 #9
bc (bk***@excite.c om) writes:
Yeah, I tried that initially (actually wrote the code in C# using
SQLDMO to look at a table and get the fields/types and built the
select statement), but the BCP queryout SQL hint got too large (1024
byte limit) on a couple tables, so that's why I went to TSQL. It's
actually working quite well now. The TSQL that I run to build the
select statement is sub-second in my unit tests. I'll send you the
.sql file of my sproc and you can have a look-see.


Could have contructed views, and bulked from those. The views could
have been tempdb to not litter the main database.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
5229
by: Paul Mateer | last post by:
Hi, I have been running some queries against a table in a my database and have noted an odd (at least it seems odd to me) performance issue. The table has approximately 5 million rows and includes the following columns: DocID (INTEGER, PRIMARY KEY, CLUSTERED) IsRecord (INTEGER, NONCLUSTERED)
7
3306
by: George Hester | last post by:
Please take a look at this google artcle: http://groups.google.com/groups?hl=en&lr=&frame=right&th=55d6f4b50f5f9382&seekm=411f370d%241%40olaf.komtel.net#link9 The op was having trouble with access denied using resizeTo. I am having the same issue but the explanations in this article don't seem to apply here. I am not trying to resize a window with content from a different server. This issue lies here. What I do is make a popup...
2
2471
by: Anthony Cuttitta Jr. | last post by:
We have an application that outputs several different graphs from data downloaded from our AS400. The application has worked without (this) issue for several months now, but just recently, the workstation it is normally run from has been upgraded to WinXP from WinNT 5.0. The issue is that the graphs will either display the data within the recordsource (a query), OR it will display the "temp" data in the chart's datasheet (from initial...
0
3578
by: Kevin Spencer | last post by:
Hi all, I am working on a service that uploads METAR weather information to the National Weather Service FTP site. The service I'm authoring is hosted on a Windows 200 server, and the NWS FTP host is on a Unix server. I'm using the FtpWebRequest and FtpWebResponse classes to do the file uploading. I have tested it without any errors at all uploading to an IIS FTP server hosted on our network Most of the time it uploads without error to...
2
2826
by: Ben Rush | last post by:
Hello World, Okay, I have spent the day browsing the newsgroups and reading up on article after article concerning ViewState corruption and so forth, and I have a couple questions. We intermittantly get the following exception - EXCEPTION MESSAGE: The viewstate is invalid for this page and might be corrupted. STACK TRACE:
5
2530
by: Robert | last post by:
I have a series of web applications (configured as separate applications) on a server. There is a main application at the root and then several virtual directories that are independant applications. I am testing an upgrade of all of the sites and have converted the main root site...although not necessarily fixed any issues. I move on instead and converted one of the virtual roots that is a seperate
0
2231
by: Charles Leonard | last post by:
I am having yet another issue with Windows Server 2003. This time, the web service (a file import web service) appears to run except for one odd message: "ActiveX component can't create object". There are no other statements to indicate what object cannot be created. Otherwise, everything on the test Windows Server 2003 works fine—all import data updates correctly. Unfortunately, my normal development environment is not Windows...
4
3226
by: Paul | last post by:
Hi, I've been struggling with this today, I'm developing a DotNet2.0 website in C# that needs to call a long running data query. Obviously this is a good candidate for an Asynchronous call, so the page can carry on rendering whilst the call is taking place and also returning the ASP.NET worker thread to service another page request (for scalability). I have developed a very basic asynchronous object (for testing, that reproduces the same...
1
3276
by: AlekseyUS | last post by:
Hi, I'm a little stuck, I basically need to copy all the information within a specific file in Temp and append it to a file in another location. I'm not having any problems with smaller size log files stored within temp foldier and everything reads and appends perfectly, however when i try to read and append from IS12Install.log file in Temp all it appends to my destination file is: ÿþ= and a whole bunch of empty lines I believe...
13
3523
by: SAL | last post by:
Hello, I'm trying to include a popup in the ItemTemplate of a gridview row. The ItemTemplate for the field contains a textbox and when the user clicks in the textbox I want a popup panel to show allowing the user to make a selection from the popup window. I have enabled AJAX extensions and have a working sample outside of a gridview. However, when I click in the textbox of a gridview row, all I see is a really small square instead of the...
0
9813
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9665
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10249
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9367
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7785
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6976
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4447
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4007
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3108
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.