Search results for query: *

Hi !! I've solved the problem with OUT parameters :p !! This seems to be a problem with the ODBC stack of Microsoft !! Problem does not arise with other drivers !! This problem arises not only with the ODBC-JDBC driver but with apps like Visual Basic, VC++, etc with use MS ODBC stack !! The...

Hello, I am using the MS SQL 2000 JDBC driver from microsoft to connect to a SQL2000 DB. The connections work fine but when I try to call a stored procedure which has OUTPUT parameters I get an exception. Here is the code snippet: CallableStatement stmt = con.prepareCall("{(call...

Whether any problem will occur if i use Oracle 8 or Oracle 8i with forms 4.5 Will anybody give the compatible versions between oracle 8 or Oracle 8i with Developer 2000.

I provided sample user defined function, create function fn_test(@orgname varchar(200),@Renname varchar(200), @Tempname varchar(200)) returns int as begin declare @cmdsql varchar(250) declare @retval int set @cmdsql = 'copy ' + @orgname + ' ' + @renname exec @retval = exec master..xp_cmdshell...

I think Cursors may help u. @@FETCH_STATUS parameter helps u to find end of file.

I am scheduling the job with TSQL("Select statement"), directs the output to the text file using "Advanced" option in Job step. Scheduling works fine, but i want to format the output. When i open the text file, it shows step name, executed time, number of rows affected,etc...

I am using crytal report viewer in visual basic to display the report. Most of the my reports are graphical type. If i export the report(through export button in viewer toolbar) to word document or HTML page, only empty files get created. What's the reason?. I am refreshing the report for every...

Whether it is possible to append the text file using bcp utility.

I am Using 2 Stored procedures A and B and about 8 tables. In Stored Procedure A, i am calling Stored procedure B. Stored Procedure B returns about 300000 records to stored procedure where i copy to flat file. I set query time out, connection time out to zero, still successive statements after...

Yes, I am copying data from one database to another and deleting from the source database for specified condition. I tried using bcp, but the problem is, I have an identity field in the table, if i set the "-e" option to set the identity to true in bcp, first time it works fine, when...

I am using crystal reports in VB Client. When I package through Visual Studio tool "Package & Deployment", it shows the dependency file "Crystal". In my machine there is no file type of crystal. If i ignore this file while packaging my application runs proper, but in report...

I am using VB Client to get the specific condition like Backup to database, flatfile, date range, percentage of data to be pruned, etc. I am using DTS Package to do this functionality. But for 600000 records(each table)- 11 tables, to backup 20% of data, time taken to backup is about 1 hour. I...

How to save the report in .jpg or paint format at run time without using export option of crystal report from visual basic.

Hi, How to save the report(generated using crytal report) in .html, .jpeg format without using export option in crytal report designer. If i export my graph(developed using crystal report) in word document, only empty template get created. How to solve this?

Hi, Use SQLDMO object library to retrieve the database list. Refer books online, Search for SQLDMO. In MSDN search for SQLDMO->CREATE TABLE. u will find the sample code. In Visual Basic using references add SQL DMO object library and create the instance of SQLDMO and u will find lot of methods.

I am using Crystal report viewer in VB to display the reports. I want to save the report in .jpg or any other valid format and send a mail as attachement. Whether it is possible?

I am using stored procedures to insert the data, if stored procedure fails VB gives a common error like &quot;<Stored procedure name> expects parameter &quot;. I want the exact ODBC error which is thrown by database.