Question VBScript Connection String - RESOLVED

A

apsrbstar

Member
Hi all, I am trying to connect to Progress 9.1E in VBScript, and have tried countless connection string variations I've found, and just randomly tried, but in all cases I have had no success. Can anyone help me with it, please?
 
I wish I'd kept a record, what I can remember is
Code: 
dim con
set con=CreateObject("ADODB.Connection")
con.Connection = "DSN=livesxe;UID=xxx;PWD=xxx"
con.Open

Code: 
dim con
set con=CreateObject("ADODB.Connection")
con.Open "DSN=livesxe;UID=xxx;PWD=xxx"

but I tried a number of other variation on this general theme
 
You are just talking about what you tried in VB. Did anybody set up the database for SQL92 access properly?

If not, this arctilve might guide you in the right direction:
http://knowledgebase.progress.com/articles/Article/20143

BTW - Progress 9.1E is Stone Age software. Unless you are using the SQL access for occasional reports, it won't do you much good perfomance and stability wise.

Heavy Regards, RealHeavyDude.
 
Hi RHD, we use ODBC all day every day. Yes, performance is shoddy at best, but upgrading Progress is out of my reach at the moment. I've just been trialing an alternative way to deal with the problem, and that seems to be working fine, so I will bow out of this discussion and say thanks to you all.
 
You must log in or register to reply here.
Back
Top