Advertisement

11.23.2007 at 09:48AM PST, ID: 22979242 | Points: 500
[x]
Attachment Details

Progress linked server

Zones: MS SQL Server, Progress 4GL Database, SQL Query Syntax
Tags: server, progress, linked
I need to access some information from my Database in Progress, thru one  VB.net application, however I can not install to much ODBC drivers. So I want to do it on a SQL SERVER using the linked server options.

Im using
exec sp_addlinkedserver @server = 'LnkServer', @srvproduct = '', @provider = 'MSDASQL

but i get this error when I try to retrieve the information
OLE DB provider 'MSDASQL' reported an error.  
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005:   ].

How i can create the linked server and how I can retrive the Information from that SERVER
Start your free trial to view this solution
Question Stats
Zone: Database
Question Asked By: Jaaze
Question Asked On: 11.23.2007
Participating Experts: 4
Points: 500
Views: 0
Translate:
Loading Advertisement...
11.23.2007 at 10:15AM PST, ID: 20340108
PaultheBroker:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.23.2007 at 10:18AM PST, ID: 20340117
Jaaze:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.23.2007 at 10:47AM PST, ID: 20340221

Rank: Guru

Yveau:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.26.2007 at 07:34PM PST, ID: 20355443
cbitting:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.27.2007 at 06:19AM PST, ID: 20357967
Jaaze:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.27.2007 at 02:05PM PST, ID: 20361718

Rank: Guru

Yveau:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.27.2007 at 02:48PM PST, ID: 20362013
Jaaze:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.27.2007 at 02:54PM PST, ID: 20362041

Rank: Guru

Yveau:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.27.2007 at 02:59PM PST, ID: 20362067
Jaaze:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.27.2007 at 03:03PM PST, ID: 20362090

Rank: Guru

Yveau:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.27.2007 at 03:30PM PST, ID: 20362231
Jaaze:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.27.2007 at 03:38PM PST, ID: 20362264

Rank: Guru

Yveau:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.27.2007 at 04:26PM PST, ID: 20362435
Jaaze:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.28.2007 at 11:55AM PST, ID: 20368145

Rank: Guru

Yveau:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
01.14.2008 at 10:54AM PST, ID: 20655468
chrisryhal:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
01.14.2008 at 10:55AM PST, ID: 20655476
chrisryhal:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
01.14.2008 at 11:00AM PST, ID: 20655520
Jaaze:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
01.14.2008 at 11:04AM PST, ID: 20655551
chrisryhal:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
01.14.2008 at 11:43AM PST, ID: 20656001
Jaaze:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
20080236-EE-VQP-29 / EE_QW_2_20070628