Question VBScript Connection String - RESOLVED

[apsrbstar]

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?

 

[Cringer]

What have you tried?

 

[apsrbstar]

I wish I'd kept a record, what I can remember is

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

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

 

[RealHeavyDude]

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.

 

[apsrbstar]

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.

 

[TomBascom]

In addition to RHD's "How to configure SQL-92" link you should also periodically update statistics so that the optimizer can pick good query plans:

http://knowledgebase.progress.com/a...en_US&c=Product_Group:OpenEdge&fs=Search&pn=1

http://knowledgebase.progress.com/a...en_US&c=Product_Group:OpenEdge&fs=Search&pn=1