Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

defining ODBC access to 3rd party SQL Server

Status
Not open for further replies.
Helfrich

Helfrich

Technical User
Joined
Dec 6, 2001
Messages
1
Location
DE
I try to use MS SQL Server to access data from 3rd party SQL Server via ODBC. ODBC System DSN pointing to 3rd party SQL Server is operational (tested with MS Access).
I created an connection server in MS SQL Server (Microsoft OLE DB Provider for ODBC Driver, data source name of System DSN).
Questions:
1.) is this configuration complete, or what is missing?
2.) can you explain the error messages I got:
error 7311: schemarowset of OLE DB-Provider 'UNKNOWN' couldn't be received. Provider supports interface, but returns error code at usage: UNINTYP: Unsupported InfoType: 1209 ?

Please, give me some hints how to set up a correct communication.

Thanks in advance,

Karsten Helfrich
 
Status
Not open for further replies.

Similar threads

MathiasB
  • Locked
  • Question Question
Parameterised sql server query
Replies
8
Views
887
Chriss Miller
C
V
  • Locked
  • Question Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
1K
Volvere
V
gbaughma
  • Locked
  • Question Question
SQL Performance
Replies
11
Views
1K
pjw001
pjw001
Steve Yu
  • Locked
  • Question Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN
Replies
3
Views
886
Chris Miller
Chris Miller
elly00
  • Locked
  • Question Question
create sql view using batch file
Replies
5
Views
966
Mike Lewis
Mike Lewis

Part and Inventory Search

Sponsor

Back
Top