Search results for query: *

I am trying to connect to a SQL Server database from a PDA app written in C#. The server name in the connection string is the dns name\sql instance name. It will not connect to the database and says 'SQL server does not exist or access denied' or something like that. However if I swap the dns...

Hi all, Hope someone can help. I have a small vb.net 2005 application that sits on a customers server and checks an Access database every 5 seconds for exports and import files (if they exist) from exported files from an SAP system. This all works well when the connection to the database is...

Hi there, I dont normally put 'Please Help' in my threads but I am in serious need of help on this one. I am a complete 'Newbie' when it comes to Websphere. I have to write an interface application between a .net application and IBM Websphere. Can someone point me in the right direction...

I am having a discussion with a colleague in the office here regarding text field lengths in databases. The main discussion is regarding where to control the length of the string that you are entering into the database. To explain further, You have a form with a text box and you want to limit...

Please can someone help. When opening an existing project or starting a new one in visual Studio .net 2003, the Development Enviroment will crash asking if I wanr to report the error. If I tick Restart the Microsoft Development Enviroment it will reopen fine but I get the same crash if I try...

Hi All, Can someone help me with the best way to do the following. From time to time we need to add a new field into a SQL database to go with a new (VB 6) executable that we distribute to our customers. However we do not have a dial in to this customer and they will not send the database to...

Hi all, What is the vb.net EOF equivalent? Cheers Andy

Hi all, I am importing records into a database from a csv file and everything is working fine apart from one thing. At the moment the code works by adding a record from the csv file into the database if it doesn't exist. The table it is importing into has a primary key on the Product Code and...

I have a user control with a label and a text box which I have placed on a form. When I change the caption in the properties list, the control only shows the changes when I click the main form. It does not dynamically change the caption as I type like it does for the standard label control...

Does anyone konw of a way in stopping the print progress dialog box from appearing. My application is sending on average 80 pages to the printer using Report.PrintOut method in Crytsal. We are printing labels and don't want the box which appears with a cancel button to appear. This is...

Hi all, Could someone please point me in the right direction for integrating the CR Report designer into a VB 6 application. We already have a viewer and are considering distributing a design function for some of our applications. However I am not sure how to get started and what...

Does anyone know of a VB6 add in that can detect and highlight any sub or functions that are not called anywhere in the code? I am stripping one of our products down to a smaller version and taking huge chunks of code out. Would like to remove unused sections of code. Any help appreciated.

Why are the hex colour values in VB &HBBGGRR Where B=Blue, G=Green and R=Red. This has annoyed me this afternoon as I wrote a small application to convert RGB values to Hex and noticed it was always re-arranging the last 2 and first 2 hex values. I got more confused when looking on web...

I wonder if anyone has had this issue before. When connecting to a remote PC through Windows XP Remote Desktop the text in any text editor (Notepad, VB6 IDE, Word etc) always highlights when using the cursor keys. Imagine holding down shift and then using the arrow keys and this is the affect...

I recently created an application that needed a reference to SQLDMO. This then created in the Solution Explorer a reference to SQLDMO and also in the working folder a file called Interop.SQLDMO.dll. Everything was fine until I went to run the program standalone as an application. It gave an...

I wonder if anyone can be kind enough to explain the differences between Long, Integer, Single and Double data types in VB 6. I am a little confused mainly regarding Single and Double data types. Why are they called Single Floating point and double floating point. I have looked at all the...

Hi, I have a real problem trying to add a user in VB.Net using SQLDMO. The real crux is that the code works in VB 6. Would appreciate any help as this problem is doing my head in. Code below- Dim oServerName As New SQLDMO.SQLServer Dim oDBLogin As New SQLDMO.Login Dim oDBUser As...

My company has a customer who seems to be having problems with there tape backup. They backup using a SQL Query that backs up to '\\.\Tape0'. When looking into the contents of the tape, various backup sets were there but only the time was showing not the date. Does anyone know what could be...

Is there anyway using T-SQL that a query can write to a text file that could be saved to the local disk drive. Thanks in advance Andy

Hi All Reading through these forums, considered opinion seems to be that the best backup option is to backup to disk from SQL and then use a third party tool to backup to tape such as Backup Exec etc. Can ask why? Leaving disk backups aside, I have always found backing up to tape from SQL...