Wednesday, March 28, 2012
Problem in Exporting Crystal Reports
I have been using Crystal Reports 8.5 with VB6.0.
I want to set the Export options through VB code.
But when I call the Export method ,the settings whatever I made is not active,it is displaying the default settings only.
How to resolve this?
Thanks in Advance for all helps!
Regards,
Muthukumar.CThere are plenty of articles in Business Objects knowledge base about how to export reports using various interfaces:
http://support.businessobjects.com/library/kbase/articles/c2010117.asp
http://support.businessobjects.com/communityCS/FilesAndUpdates/autexprt.zip.asp
Be sure to always check the knowledge base before posting to forum. In most cases, you will find the solution much faster than you expect.
Friday, March 23, 2012
Problem in back-up database
i have two different hard disk drives, here i call it HDD1 and HDD2. i want to format my HDD1, but all my database tables are stored in HDD1. i want to know is there any way for me to backup my database table to HDD2, and restore it back later to HDD1.
thanks to you all.You can either do a back up and restore or detach the database files, move them, and then re-attach them. There's on option when restoring backups to move the data files. Detaching the database basically closes the files and removes them from the SQL server. Re-attaching them brings them back to 'life'. Either would work. Check BOL|||I already used the wizard in sql server to backup my file, the back-up file ends with .bak extension, right? But the problem is i don't know how to restore it back. I have tried using "Restore" function from sql server, but it does not work.|||The .bak file is the correct file. Dig into books on line about restoring from a file. Pretty hard to diagnose via email, but unless your SQL installation is somehow corrupted, it should be able to restore a backup file.
Wednesday, March 21, 2012
problem getting result set through a stored procedure call using VB.
returns XML string format of a select query on a temporary table
created by the stored procedure itself and values also inserted within
the stored procedure.See if this helps: http://www.sqlxml.org/faqs.aspx?faq=104
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"abc" <er.nehasinghal@.gmail.com> wrote in message
news:1121936278.733465.80930@.g47g2000cwa.googlegroups.com...
Problem regarding getting an XML script from a stored procedure that
returns XML string format of a select query on a temporary table
created by the stored procedure itself and values also inserted within
the stored procedure.sql
Tuesday, March 20, 2012
Problem executing a stored proc, please help
I have stored proc that processes about 60,000 rows using a cursor. When I
call the SP from Query Analyzer, I get the following error message after
processing about 12,000 records :
Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
ODBC: Msg 0, Level 16, State 1
Communication link failure
Connection Broken
12614 records
What can i do to make this SP run sucessfully ? I even tried using a table
variable instead of a cursor, but got the same result. Please suggest .
THE output from SP_CONFIG on database server is
Option
config_value
------
affinity mask 0
allow updates 0
awe enabled 0
c2 audit mode 0
cost threshold for parallelism 5
Cross DB Ownership Chaining 0
cursor threshold -1
default full-text language 1033
default language 0
fill factor (%) 0
index create memory (KB) 0
lightweight pooling 0
locks 0
max degree of parallelism 0
max server memory (MB) 2147483647
max text repl size (B) 65536
max worker threads 255
media retention 0
min memory per query (KB) 1024
min server memory (MB) 0
nested triggers 1
network packet size (B) 4096
open objects 0
priority boost 0
query governor cost limit 0
query wait (s) -1
recovery interval (min) 0
remote access 1
remote login timeout (s) 20
remote proc trans 0
remote query timeout (s) 0
scan for startup procs 0
set working set size 0
show advanced options 1
two digit year cutoff 2049
user connections 0
user options 0Hi
It would help if you posted DDL and example data such as
http://www.aspfaq.com/etiquette.asp?id=5006 and
example data as insert statements
http://vyaskn.tripod.com/code.htm#inserts
Connection broken implies a network failure/disconnection, possibly a
timeout but you do not indicate how long this process takes.
Check your SQL server version and service pack level, you may also want to
check MDAC version and consistancy along with the SQL Server log and event
log to see if there is any more information that may help.
Other posts on this http://tinyurl.com/4ebus may be helpful.
John
"rajeshlh" <rajeshlh@.discussions.microsoft.com> wrote in message
news:F1F399D6-BB17-4FC9-BF10-4F7D3A31F7B1@.microsoft.com...
> Hi All,
> I have stored proc that processes about 60,000 rows using a cursor. When I
> call the SP from Query Analyzer, I get the following error message after
> processing about 12,000 records :
>
> Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (InvalidParam()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> ODBC: Msg 0, Level 16, State 1
> Communication link failure
>
> Connection Broken
>
>
> 12614 records
>
> What can i do to make this SP run sucessfully ? I even tried using a table
> variable instead of a cursor, but got the same result. Please suggest .
>
> THE output from SP_CONFIG on database server is
> Option
> config_value
> ------
> affinity mask 0
> allow updates 0
> awe enabled 0
> c2 audit mode 0
> cost threshold for parallelism 5
> Cross DB Ownership Chaining 0
> cursor threshold -1
> default full-text language 1033
> default language 0
> fill factor (%) 0
> index create memory (KB) 0
> lightweight pooling 0
> locks 0
> max degree of parallelism 0
> max server memory (MB) 2147483647
> max text repl size (B) 65536
> max worker threads 255
> media retention 0
> min memory per query (KB) 1024
> min server memory (MB) 0
> nested triggers 1
> network packet size (B) 4096
> open objects 0
> priority boost 0
> query governor cost limit 0
> query wait (s) -1
> recovery interval (min) 0
> remote access 1
> remote login timeout (s) 20
> remote proc trans 0
> remote query timeout (s) 0
> scan for startup procs 0
> set working set size 0
> show advanced options 1
> two digit year cutoff 2049
> user connections 0
> user options 0
>
>
>
Problem executing a stored proc
Hi All,
I have stored proc that processes about 60,000 rows using a cursor. When I call the SP from Query Analyzer, I get the following error message after processing about 12,000 records :
Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
ODBC: Msg 0, Level 16, State 1
Communication link failure
Connection Broken
12614 records
What can i do to make this SP run sucessfully ? I even tried using a table variable instead of a cursor, but got the same result.
THE output from SP_CONFIG is
Option config_value
---------------------------------------
| affinity mask | 0 |
| allow updates | 0 |
| awe enabled | 0 |
| c2 audit mode | 0 |
| cost threshold for parallelism | 5 |
| Cross DB Ownership Chaining | 0 |
| cursor threshold | -1 |
| default full-text language | 1033 |
| default language | 0 |
| fill factor (%) | 0 |
| index create memory (KB) | 0 |
| lightweight pooling | 0 |
| locks | 0 |
| max degree of parallelism | 0 |
| max server memory (MB) | 2147483647 |
| max text repl size (B) | 65536 |
| max worker threads | 255 |
| media retention | 0 |
| min memory per query (KB) | 1024 |
| min server memory (MB) | 0 |
| nested triggers | 1 |
| network packet size (B) | 4096 |
| open objects | 0 |
| priority boost | 0 |
| query governor cost limit | 0 |
| query wait (s) | -1 |
| recovery interval (min) | 0 |
| remote access | 1 |
| remote login timeout (s) | 20 |
| remote proc trans | 0 |
| remote query timeout (s) | 0 |
| scan for startup procs | 0 |
| set working set size | 0 |
| show advanced options | 1 |
| two digit year cutoff | 2049 |
| user connections | 0 |
| user options | 0 |