Opening sql files opens new instance of SQL Management Studio

Hi Folks,

I'm sure this has been answered before but all my searches for this problem don't find what I need. It's a quirk but driving me nuts.

If I have sql management studio open and I view a sql file from Vault, or double-click it in explorer, it always opens a new instance of mgmt studio. I open 5 sql files, 5 instances of mgmt studio.

How do I tell my system to reuse mgmt studio to open sql files if it's open?

Thanks in Advance,

-David

What version of SQL Server Management Studio do you have?

9.00.1399 = RTM
9.00.2047 = SP1
9.00.3042 = SP2

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

OpenDataSource trouble with Advantage SQL

Hi folks.
I'm trying to connect to a Medisoft Advantage SQL db through SQL Server
using OpenDataSource or OpenRowSet. I have general connections to the db
working fine, but not with OpenDataSource or OpenRowSet.

I've tried variations on:

select * from
OpenDataSource(
'Advantage OLE DB Provider',
'Data Source=C:\MediData\Tutor\mwddf.add;
User ID=user;Password=password;
Advantage Server Type=ADS_LOCAL_SERVER;
Initial Catalog=mwddf.add;')...MWPAT

Which gives:
OLE DB error trace [OLE/DB Provider 'Advantage OLE DB Provider'
IColumnsInfo::MapColumnIDs returned 0x80040e21: [COLUMN_NAME=TABLE_CATALOG
ORDINAL=-1], [COLUMN_NAME=TABLE_SCHEMA ORDINAL=-1], [COLUMN_NAME=TABLE_NAME
ORDINAL=-1], [COLUMN_NAME=TABLE_TYPE ORDINAL=-1], [COLUMN_NAME=TABLE_GUID
ORDINAL=-1]].

I've also tried:

select * from
Openrowset(
'Advantage OLE DB Provider',
'Data Source=C:\MediData\Tutor\mwddf.add;User
ID=user;Password=password;Initial Catalog=mwddf.add;Advantage Server
Type=ADS_REMOTE_SERVER',
MWPAT)
and 'Select * from MWPAT'.
These last yield:

[OLE/DB provider returned message: No Data Source specified]

which seems closer.

Can anyone help? I think this is all Advantage-specific. I've posted on
their boards, but their not very active...

Thanks.

DavidHi David,

what is the version of database you are using. 6, 7.0, 7.1 or 8

thanks
vaddi

Quote:

Originally Posted by David Horowitz

Hi folks.
I'm trying to connect to a Medisoft Advantage SQL db through SQL Server
using OpenDataSource or OpenRowSet. I have general connections to the db
working fine, but not with OpenDataSource or OpenRowSet.

I've tried variations on:

select * from
OpenDataSource(
'Advantage OLE DB Provider',
'Data Source=C:\MediData\Tutor\mwddf.add;
User ID=user;Password=password;
Advantage Server Type=ADS_LOCAL_SERVER;
Initial Catalog=mwddf.add;')...MWPAT

Which gives:
OLE DB error trace [OLE/DB Provider 'Advantage OLE DB Provider'
IColumnsInfo::MapColumnIDs returned 0x80040e21: [COLUMN_NAME=TABLE_CATALOG
ORDINAL=-1], [COLUMN_NAME=TABLE_SCHEMA ORDINAL=-1], [COLUMN_NAME=TABLE_NAME
ORDINAL=-1], [COLUMN_NAME=TABLE_TYPE ORDINAL=-1], [COLUMN_NAME=TABLE_GUID
ORDINAL=-1]].

I've also tried:

select * from
Openrowset(
'Advantage OLE DB Provider',
'Data Source=C:\MediData\Tutor\mwddf.add;User
ID=user;Password=password;Initial Catalog=mwddf.add;Advantage Server
Type=ADS_REMOTE_SERVER',
MWPAT)
and 'Select * from MWPAT'.
These last yield:

[OLE/DB provider returned message: No Data Source specified]

which seems closer.

Can anyone help? I think this is all Advantage-specific. I've posted on
their boards, but their not very active...

Thanks.

David