Unable to connect to Progress datasource with ASP

A

arobbo

New Member
Hi guys , been using simple ASP to connect to an MS Access database for applications on our company intranet.

Our order entry server uses progress, I can connect to this using the ODBC built into MS Access for VB applications etc

I've never been able to connect to the live datasourece directly through ASP though.

In the past I've used MS Access to copy data from the progress database into access overnight as a scheduled task and then display this using ASP but this is less than ideal.

I've installed Progress Client Networking on our Domain Controller (which acts as webserver) , our file server (where the asp pages are) and the terminal servers which our users would login to.

When I try to connect to our data source I get the following error message



Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /scripts/test.asp, line 9

The connection code I'm using is as follows :

Code: 
<%
 
DIM adoCon
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.ConnectionString = "DSN=livesxe_fs;UID=*****;PWD=*****"
adoCon.Open
Dim rsCompany
Dim strSQL
Set rsCompany = Server.CreateObject("ADODB.Recordset")
strSQL = "select * from aret where cono = 1 and custno = 1075 "
rsCompany.Open strSQL, adoCon

%>
TEST <BR>
Company name <% = rsCompany("name") %>
<%
'close db connection
set rstemp = nothing
conntemp.Close
%>

The version of Progress I have installed is 9.1E04

Any ideas on what I might be doing wrong ?

thanks very much for your help

Andy
 
Just guessing:
  • Did you define the ODBC data source on your domain controller?
  • Is the data source defined as a machine data source and is not accessible under the user account on which behalf the whole things is running?
HTH, RealHeavyDude.
 
Thank you for your reply.

Did you define the ODBC data source on your domain controller?
Click to expand...

Not too sure what you mean , I have a file DSN and system DSN set up on the DC, Terminal Server and File Server, is there any other way to define the ODBC datasource on my DC ?

Is the data source defined as a machine data source and is not accessible under the user account on which behalf the whole things is running?
Click to expand...

The datasource hostname is the linux server that hosts the progress application, not too sure how I would ensure that the internet user account has permission to view this ?

Sorry to be a bit vague, my ASP applications work very well through MS Access and my ODBC queries through progress work very well through MS Access but getting the ASP application to work directly through Progress is a new world for me.

Many thanks for your assistance it is much appreciated

Andy
 
You didn't answer RHD's question on user DSN vs System DSN, so:

Are you sure you didn't try to connect to userDSN in stead of System DSN. This will work with Access but wont work with ASP (it will give you the same error as you are getting now).

Casper.
 
Guys , the problem has been resolved , it was an error on my part , I was trying to connect to a system DSN using the name of a file DSN.

We have connectivity and are away !!

My thanks for your time in helping me with this

Cheers

Andy
 
You must log in or register to reply here.
Back
Top