Gagan:

(I posted this before, but something happened to it when I pressed the Post button).

I don't know why you are working so hard with this.  Using your example:

"User 1

reads the...

DO NOT BOTHER WITH THIS PROBLEM.

It was another developer's - He loaded a copy of the database onto his machine for testing.  When he...

I more or less decided that the best way to go would be to use 2 queries, one for the actual data, the other for the titles - and put...

Thomas:

Due to design restrictions (as I mentioned in my previous posting here), I cannot do an "EXEC SQL" OR a Recordset Update or Delete or Insert. 

Basically, I am allowed to...

Firstly: Thomas - Thanks, that's essentially what I'm looking for (Like I said, my brain is on SLOW - and I have sixteen other problems to solve in the next...

Thomas:  Thanks, I have checked and IDENT_CURRENT works for this situation. 

I would like to embed SQL2 into SQL3 and get the same (correct) results.

Thanks again,

Allan

I asked this same question on 10/29/2003. (Topic: "Copying Diagram?"). The best answer was from a posting from Brian Knight (11/13/2003) - Article "Transfering a SQL...

It depends on how your system is to be deployed.

If you intend to send it out to a client (or clients), and have it installed as a standalone,...

I'm assumiing that you're programming with Visual Basic 6.0 (not VB.NET).

Bill Vaughan's book is a good reference. If you are going with ADO, I'd recommend "ADO Programming in Visual...

mom - I still get the same error - for both versions.

Thanks anyway,

Allan

I'm running SQL Server 2000 (Developer's Edition) on my notebook under Windows 2000.

This is a standalone installation, and network rights are NOT an issue. Just to be sure,...

I stand corrected!

Brian Knight has posted (11/13/2003) an article "Transfering a SQL Server Diagram". It looks good.

Thanks Brian -

Allan

Attempting to connect via osql returns the following:

[DBMSLPCN]SQL Server does not exist or access denied.

[DBMSLPCN]ConnectionOpen (Connect()).

This is the same error I get from other methods.

Note that when I...

This is a brief follow-up: I finally removed SQL Server from my notebook, and re-installed it. I was unable to recreate the same instance (or even just create...

Just to be sure everyone understands what my problem is: It is not with the VB app. I have not changed the connect string in over a month,...