Search results for query: *

I'm doing a bulk insert from a text file and get error: Bulk insert: Unexpected end-of-file (EOF) encountered in data file Here is my sp: CREATE PROCEDURE MyJobs @PathFileName varchar(100) as If Exists(Select * From Information_Schema.Tables Where Table_Type = 'Base Table' And Table_Name =...

I have a datagridview that does not allow to resize columns. I have tried to set properties but cannot get it to work. Can anyone tell me what is wrong? 'DataGridView1 ' Me.DataGridView1.AllowUserToAddRows = False Me.DataGridView1.AllowUserToDeleteRows = False...

I have a windows form that displays a data grid and a crystal report. How Can I add a 2nd (new) report to the form or will this have to be a sub report off the main report? I tried to add a totally new report but it gave me errors when I tried to rebuild the project. Any litterature out there...

Does anyone have a quick solution for disabling the "Main Report" tab?

I'm using crystal report in my vb application, binding it to a data set and displaying the report. When I display the report, the left part of the report is blank (navigation section??), it looks like the report is split in two parts. This part consumes too much space of the screen. How can I...

I have an application that reads from a data base table and fills a DataSet and consequently binds to a DataGrigView. Now I need to add a Crystal Report Viewer to the same form and display the query result. I have defined my data set in the code (no user controls from tool box). When I try to...

I'm trying to drop a table and get error. I've tried to use the 'If Exists..." but cannot get the syntax to work Error: Cannot drop the table 'JobTable', because it does not exist in the system catalog. CREATE PROCEDURE sp_CreateJobTable as DROP TABLE JobTable create table JobTable ( job_date...

I have an application (vb 2005) that reads 8 different tables in 8 different data base and builds a table for the selected records (using sp's). This table is used as basis for building a data grid and cosequently export to crystal report. My question: How can I create a table for each user, so...

I have a stored procedure that creates a temp table (see code below). 1. How can I drop the table if it exists? 2. Also I have define a field called "job_date" and I get an error if I specify 'date' as type (so I changes it to 'int')? create table #jobtemptable ( job_date int, job_number...

I have a linked server set up to a db2 data base. We are running MS Sequel Server 2005. 1. If I run the following everything works fine and resulset is displayed: Exec ('Call QGPL.get_companies (?,?)', o_drky, o_drdl01) AT AS400SRV_MSDASQL 2. When I try to get the result into a temp table...

I have db2/400 set up as linked server and need to call a sp that returns company codes. After executing the sp I do not see any resultset in Sequel Server even if I am trying to load the result set into a temp table. I know the connection is working beacuse when I do a straight select it brings...

I am excuting a call to a sp on the db2 platform (linked server) and trying to capture the result set into a temp table and display the results. The temp table is empty allthough the sp is being executed. Any clues??? create table #tempTable (o_drky char(50), o_drdl01 varchar(50)) insert into...

Trying to execute a sp on db2 from sequel server. Getting error. EXEC AS400SRV_IBMDA400_OLEDB.vgsysb.qgpl.get_company' 010' The error: OLE DB provider "IBMDA400" for linked server "AS400SRV_IBMDA400_OLEDB" returned message "SQL0104: Token { was not valid. Valid tokens: ( END GET SET...

iSeries as Linked Server -------------------------------------------------------------------------------- I have set up the iSeries as linked server (in 2005). When I execute a view from Sequel Server against a table (selecting just 1 record where the selection matches the keys) the response...

We are using CR XI and I need to select records from 2 different databases which are identical (one remote and one local)and compare. My question is: Where in CR XI would I enter the sql statment, I tried in the "record selection formula editor" and also under "add command" in data base...

I have 2 tables that are identical. These tables are being replicated and should contain the same number of records and data etc. From time to time, for whatever reason, these tables get out of "sync". Now, I need to compare compare records in the 2 tables. I have sql code that looks at both...

After doing a ftp and mget (download multiple files) I need to rename files that were downloaded. I have a script that works on my local machine (see below) but does not work on the client machine which is a Unix box. The error I get is that specified path was not found. How do I specify a path...

I have a ftp script that connects to a client site and picks up files using wild card like *.asc. I need to use wild card since files that are placed in the folder are dynamically named based upon date and time. This works fine. Next thing I need to do (in the ftp script) is either 1. rename all...

I'm doing an ftp and need to rename files that I have selected in my ftp. I am using rename and selecting all files with a specific extension. This does not work. If I specify the exact file name and extension it works. Since I may select multiple file to be ftp'ed I need to do a mass rename for...

I have code that retrieves files at a client site. Once the files been retrieved I need to copy the same files to a backup directory. How do I do this and where should the code go? Thank you. Here is the code I have: ' VBScript FTP Download from St Paul Travellers Option Explicit Dim objFSO...