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
