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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Link Server Example Pls 1
- Thread starter datenis
- Start date
-
1
- #2
What have you tried? Are you getting an error?
I haven't done it myself (no need) but have seen it and might be able to offer suggestons.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
I haven't done it myself (no need) but have seen it and might be able to offer suggestons.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
- Thread starter
- #3
Hi Mirtheil
I've searched on the net and tried this:
exec sp_addlinkedserver @server='PSQLDEMODATAODBC',
@srvproduct='',@provider='MSDASQL', @datasrc='Demodata',
@location='',@provstr='DBQ=Demodata;Driver=c:\pvsw\bin\w3odbcci.dll'
but I get the following message: Error 7399: OLE DB Provider 'MSDASQL' Reported an error."
- d
I've searched on the net and tried this:
exec sp_addlinkedserver @server='PSQLDEMODATAODBC',
@srvproduct='',@provider='MSDASQL', @datasrc='Demodata',
@location='',@provstr='DBQ=Demodata;Driver=c:\pvsw\bin\w3odbcci.dll'
but I get the following message: Error 7399: OLE DB Provider 'MSDASQL' Reported an error."
- d
Try:
sp_addlinkedserver 'PSQLDEMODATAODBC', ' ', 'MSDASQL', 'DEMODATA'
When you specify the "MSDASQL", you don't need the providerstring or location values.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
sp_addlinkedserver 'PSQLDEMODATAODBC', ' ', 'MSDASQL', 'DEMODATA'
When you specify the "MSDASQL", you don't need the providerstring or location values.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
- Thread starter
- #5
- Thread starter
- #6
Hi Mirtheil,
After I created the linked server I wanted to test out some simple queries on the database.
I looked to the net for more help and it led me to perform the sp_catalogs to get the name of the db I'm connecting to:
sp_catalogs @server_name = 'DEMODATA'
I executed it and got the following error message:
Server: Msg 7399, Level 16, State 1, Procedure sp_catalogs, Line 4
OLE DB provider 'UNKNOWN' reported an error. One or more arguments were reported invalid by the provider.
[OLE/DB provider returned message: The parameter is incorrect.]
[OLE/DB provider returned message: [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Driver not capable.]
From the error message it looks bad... "Driver Not Capable" Is it a simple thing that I'm missing, ie downloading a driver or a syntax issue, or something more complicated?
If you want to know which version I'm running, on the About for the Control Center it States 7.82.198.004
Thanks,
-d
After I created the linked server I wanted to test out some simple queries on the database.
I looked to the net for more help and it led me to perform the sp_catalogs to get the name of the db I'm connecting to:
sp_catalogs @server_name = 'DEMODATA'
I executed it and got the following error message:
Server: Msg 7399, Level 16, State 1, Procedure sp_catalogs, Line 4
OLE DB provider 'UNKNOWN' reported an error. One or more arguments were reported invalid by the provider.
[OLE/DB provider returned message: The parameter is incorrect.]
[OLE/DB provider returned message: [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Driver not capable.]
From the error message it looks bad... "Driver Not Capable" Is it a simple thing that I'm missing, ie downloading a driver or a syntax issue, or something more complicated?
If you want to know which version I'm running, on the About for the Control Center it States 7.82.198.004
Thanks,
-d
- Status
Similar threads
- Locked
- Question