Type: Posts; User: T2T2
Search took 0.01 seconds.
December 6th, 2006 12:13 AM
For anyone who is interested, I have worked this problem and come up with the following solution.
Within my select statement I use Case statements to set up the 3 address lines.
December 4th, 2006 11:18 PM
I was unsuccesful finding a thread on this topic to my surprise so I am sorry if I am doubling up.
I am using sql server 2000 to extract data from a software package.
This package contains 2...
August 16th, 2006 09:38 PM
thanks for your posts.
The system I am working on is a customer relations management package (Goldmine).
The particular srectype code identifies sales rep activities
c - call
August 13th, 2006 12:21 PM
I don't understand, what do you mean by -
"I would reccomend to do it function of the app logic"
August 13th, 2006 12:07 PM
sorry I am not answering your question.
I am using 2000 at the moment, and I am having all sorts of problems.
You mentioned in your post that it is buggy, I am starting to loose...
August 2nd, 2006 02:15 AM
Within the VS editor I used the Server Explorer to create a SQL Server 2000 connection.
I then incorporated the connection into the web form by dragging a table. This created a SqlConnection...
I like your user id name.
I am only starting to appreciate (understand) datasets.
Your examples actually illustrated to me how sql can be employed with adaptors, which I will now...
I should have added the approach I am taking to learn and develop a project. It is web form based.
In the early days of my VB6 learnings, I worked with bound controls off the editor.
I will read through those links you suggest.
I am still thinking VB6 and RecordSet processing.
One process I will be programming will involve the user entering parameters which will...
Ali thanks for the advice on the express version.
I had a look at the quick tour and got the impression it may not be able to connect to SQL Server Databases across network servers. It...
:lol: Looks like I have a lot more to learn than I thought.
I purchased VB.net which has the framework 1.1
When I try to connect to my local sql server databases, I get an error saying this...
Thanks for the quick replies.
I guess the .net environment is more complex because of the integration of various facilities.
Installing VB.net on my laptop was very involved.
With my vb6...
I was looking for some guidance in this area.
I have been productive with VB6 on recent projects but have only experimented with ASP.Net and briefly with Asp Classic.
I am hoping to jump into...
Hi, I was hoping to get some advice on Hex Editors.
I noticed there is a lot of commercial and free choices.
This thread caught my attention, as I am a VB6 programmer.
Do either of you use a...
March 21st, 2006 05:05 AM
I downloaded the INIReader.zip file from the other thread.
I believe I do have windows authentication set, but have not updated my connectionstring? I'll check it out at work...
March 19th, 2006 08:21 PM
if I understand your approach, you are suggesting that the user enters the server and sql server log in details to build the connectionstring statement at run time.
March 16th, 2006 05:57 PM
our dba talks of "memory leaks" with respect to SQL Server applications.
I don't know what this means myself, but I assume that he has statistical diagnostics which indicate that...
March 15th, 2006 08:04 PM
We run VB6 applications connected to SQL Server 2000.
The issue I have is that we need to move the databases to a different server from time to time.
Mainly for maintenance reasons, the DBA has...
March 14th, 2006 07:46 PM
I am using VB6 to build custom processes for a software product going by the name of Goldmine.
The Goldmine documentation recommends access via Goldmine's Com Server.
It instructs you to add a...
February 28th, 2006 06:53 PM
Thanks for the advice.
I have just been asked to consider Publications Subscriptions (PS).
So now i have to compare DTS with PS. ?
Great more documentation to read through.
I believe with PS...
February 27th, 2006 11:19 PM
I have never used DTS, but I believe it is the tool for my current project.
We have regional databases supporting sales reps across the country. For the purposes of management reporting we want to...
February 18th, 2006 08:44 PM
Yes, this code was written by a collegue and forwarded to myself.
I tested the code on his server (sydney australia) and it worked perfectly.
Unfortunately, here in Melbourne the server and my...
February 16th, 2006 11:35 PM
Sorry and thanks for the help.
I guess that exposes me as a newbee web programmer.
February 15th, 2006 05:39 PM
Peejavery thanks for your interest.
The code is based on 5 files (2 being .gif files to show left/right arrows for calendar month scrolling).
I will eventually embed this into a host...
February 15th, 2006 05:33 AM
I have some asp code that pops up a calendar and allows the user to scroll months, and to choose a date.
The web form shows a start date and an end date.
There is a submit button, that calls up a...
Click Here to Expand Forum to Full Width