Consultor Eletrônico



Kbase P95863: Getting "Datasource name not found and no default driver specified" when connecting to Dataserver fr
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   14/01/2009
Status: Verified

SYMPTOM(s):

Getting "Datasource name not found and no default driver specified" when connecting to Dataserver from AppServer

AppServers will not stay running

Using -Dsrv Svub,1 in startup parameters of AppServer did not allow AppServer's to connect

Connection was possible to schema holder on its own but not to both schema holder and MicroSoft SQL Server

FACT(s) (Environment):

OpenEdge 10.0B
MS SQL
MS SQL DataServer

CAUSE:

DataSource definition for the MicroSoft SQL Server was made in the "User" datasource section.

FIX:

Define the MicroSoft SQL Server datasource within the "System" datasource section of the ODBC Datasource Administrator tool.