Try this;

declare

@sql varchar(100)

, @sqlstr varchar(200)

select @sql = 'SELECT * FROM T1'

select @sqlstr = 'SELECT * FROM OPENQUERY(MYSQL_LINK, '''+@sql+''')'

exec(@sqlstr)

David

Scott,

You need to set the database in single user mode, not the server. Per BOL...

The database must be in single-user mode to use a repair option and can be one...

Steve's right. NT 4.0 could be ugly but 2000 is better. I have done the 4.0 personally and messed it up the first time.

Several of my crew have done...

Andy,

The application breaks. The grid is a FlexGrid v6.

Thanks

David

Yes, we are using DAO. I have been able to go through your ADO tutorial and found it to be pretty easy but I am just breaking into the VB...

Brian,

I tried your suggestion and still get the -1. Not a big problem but causes our VB guy to work with the Record Set differently.

Antares,

Here is the code...

Here is a glimpse of a mocked up version of the procedure. Pretty straight forward. Any other thoughts.

create procedure usp_Test1

@filtid int,

@ownrep varchar(32),

@owngrp varchar(32)

as

set nocount on

declare

@sqlstr varchar(512),

@wherestmt varchar(512)

set @wherestmt...

Andy - That was already done. See this is kind of weird and my lack of VB knowledge (although that is changing rapidly) is not helping here.

I actually found...

Wait, I posted again but recant. Do you mean add the set nocount on in the VB command line or in the Stored Proc?

Edited by - DavidB on 07/08/2002 ...

We use it on all our servers, including all our SQL Servers, and have had no ill effects.

Our environment may not be the best acid test as we do...

Sounds like you should try using bulk insert or bcp. Search in Books on Line for details but a simple statement would look something like this;

BULK INSERT Northwind.dbo.[Order Details]

...

Your gut feeling is, in my opinion, correct. While it may be possible to recover a database using that strategy, I would not recommend it. There are a ton of...

See post http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=5157

David

If you are creating the DTS package from your machine then it references the ODBC data sources on your machine for the connection to the local database. When attempting to...

I would like to think there is a better way but the only way that I could find is to enable modifications to the system tables (Server Settings) and then...