Search results for query: *

I am browsing files from the References dialog box except .dll files are not being displayed so I can't reference them. There are being displayed in Explorer so the hidden attribute is turned off. Does anyone know how I can force these files to be displayed in the Browse option of References...

Does anyone know do the methods associated with a common dialog control differ depending on the version of vb being used? I have an application created with an earlier version of VB and when I try to compile it using v5 or 6, the common dialog methods in the code aren't recognised. Examples are...

Hi, I want to insert into a table on AS/400 using a sql statement embedded in Visual Basic. I am connecting to the database using ODBC. Could someone please tell me if the following statement will work. I'm presuming that regular sql syntax is fine but can someone let me know if I'm wrong (do...

Hi, I'm trying to open SQL Server and can't because the tempdb has been marked as SUSPECT. Does anyone know how I can repair the tempdb? Thanks in advance, Gillian

Hi all, Is there any way I can edit a DTS file? My problem is that I have an asterix in my source table pathname and I need to remove it or the transfer doesn't work. There are reasons why I can't create a new file and edit the path there. Has anyone any ideas? Thanks, Gillian

Hi again, I don't think my last post was explained properly. My problem is I'm connecting to a DB2 database via ODBC from VB. I think what the problem might be, is that the database doesn't have a logical name and so my connection string contains the path to the database. The path however...

Hi all, I have set up a ODBC DSN pointing at a DB2 database using the Client Access driver. When I run my VB application, it can't see the DSN (getting that message "data source name not found - no default driver specified...). I'm not at all familiar with AS/400/DB2. Are there any...

Hi all, Can someone tell me how to send a text file from within VB? Thanks, Gillian

Hi, Can someone please help. I am running the following sql from the query analyzer and vb: select * from DWCSYPER where convert(datetime,CPFDAT) < '02/01/2000' Where CPFDAT is a field with datatype char. When run from vb, I get no records - when run from the Analyzer, I get one record...

Hi, Can someone please help. I am running the following sql from the query analyzer and vb: select * from DWCSYPER where convert(datetime,CPFDAT) < '02/01/2000' Where CPFDAT is a field with datatype char. When run from vb, I get no records - when run from the Analyzer, I get one record...

Hi, I have the following sql statement: select CPYEA4, CPPERI from DWCSYPER where '01/01/99' BETWEEN convert(datetime,CPFDAT) and convert(datetime,CPTDAT) where CPFDAT and CPTDAT are char datatype. The statement returns a value but also returns the following error message: The...

Hi, I have the following sql statement: select CPYEA4, CPPERI from DWCSYPER where '01/01/99' BETWEEN convert(datetime,CPFDAT) and convert(datetime,CPTDAT) where CPFDAT and CPTDAT are char datatype. The statement returns a value but also returns the following error message: The...

Hi, I'm populating a combo box from a SQL Server table using the following code: <SELECT id=select1 name=cboSector2> <%Do Until rs.EOF%> <OPTION><%=rs(&quot;Sectorname&quot;)%></Option> <% rs.MoveNext Loop%> </SELECT> My problem is that I want the...

Hi all, I am running an Access query from VB. The query includes a linked sql server table. When I execute the query directly from Access, it runs fine. However when I try to execute it from VB using command.execute the connection between Access and SQL Server is lost. Anyone have any ideas why...

Hi, I have the following code: insert into DWCSYPER (CPCONO,CPDIVI,CPPETP,CPYEA4,CPPERI,CPTX15,CPFDAT,CPTDAT,CPNCDY,CPNWDY,CPNBDY) select CPCONO,CPDIVI,CPPETP,CPYEA4,CPPERI,CPTX15,CPFDAT,CPTDAT,CPNCDY,CPNWDY,CPNBDY from CSYPER The problem is I'm inserting to a SQL Server database and...