Search:

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.




addr1 =...

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...

Aniskan,

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
a -...

Daniela,

I don't understand, what do you mean by -

"I would reccomend to do it function of the app logic"

Thy02k,

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...

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...

Hedge fund,

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.
Then I...

Daniela,

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...

Thanks Shuja,

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...

Thanks Zmyint,

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.

This isn't...

Exterminator,

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...

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...

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...

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...

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...

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...

Sorry and thanks for the help.

I guess that exposes me as a newbee web programmer.

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...

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...