Progress V9.1E ODBC Problems?

[saroren]

Hi,

We are using Progress 9.1E Database in HP-UX 11.11 Unix Server.
Also the Progress is Installed in HP_UX.

We want to use Delphi to Connect to Progress Database from Windows.

First i tried to install Merant 3.7 ODBC Driver on my windows side and tried Test Connect via the ODBC Manager.

When i do the test connect it give the following error

"Specified Driver could not be loaded due to system error 126. "

When i searched for this error it says i need Progress Client Networking.

Is this a another piece of Software i need to install on my windows Clinet side.

Any help is really appericiated.

Thanks

 

[saroren]

Anyone Please Help!!!!!

 

[alfiee]

The client networking is an application that you have to install on your machine. It usually supplied with a driver that permits ODBC connection.

With a license am sure you would be able to download the client networking software from www.progress.com.

 

[saroren]

thanks Alfiee,

Got the Clinet Networking and now able to connect to the Progress Database from my Client.

 

[alfiee]

good to know. you always welcome when help is needed

 

[saroren]

Thanks Alfiee. Got one more question.

Is there any thing i need to do to start the SQL92

I am not able to do a select * from pub.customer ;


Please let me know.

Thanks

 

[alfiee]

You probably need to enclose the table name in quotes

e.g.

select * from pub."customer" ;

Cheers

 

[saroren]

Hi,

Thanks Again.

I found that i got the ODBC connection which does't use SQL-92.

So went i tried to use the DataDirect 4.1 odbc for SQL-92 V9.1e,

if give me error "Database not started". (8933)


I tried all the solutions from the KB, but still the same error.

So right now i have opened an Log with Progress (through QAD, as we bought Progress from QAD).

If you have any solutions, i would appreciate it.

Thanks

 

[JJames100]

I would REALLY appreciate help on this! Has there been any resolution to this? I have installed the progress client for 9.1E and am getting the "invalid attribute in connection"..."database not started" error msg (after a long wait), when testing the connection

 

[Casper]

What OS is your database on?

What connection string are you using?

Casper.

 

[JJames100]

I am using the administrator utility to set up an ODBC connection from a Windows XP machine to a server running Windows Server Enterprise Edition 2003 that the Progress database is installed on.

 

[Casper]

With what codepage is the database started?
What OS regional settings do you have at your XP machine? (language)

If for example your database has cpinternal ISO8859-1 and your regional settings is french then you have to set environment variable at XP machine: SQL_CLIENT_CHARSET wiht the value ISO8859-1.

HTH,

Casper

 

[saroren]

Its is working for me now. But i dont remember what fixed it.

But make sure these are done.

We have Progress Database in HP Unix Server.
I am using Delphi (from my Windows PC) to connect to Progress Database.

1) create a entry in the service file in unix server
/etc/services
<name> 2999/tcp

1a) create entry for Host file

/etc/hosts (the entry should be there already, just check the name)



2) create the same entry in your PC
/window/system32/drivers/etc/services
<name> 2999/tcp

3) when the database is started in the Unix Server use
proserve <database-name with path> <other parameters> -S <name created in the service file> -H <host name>

4) you have to create a user and grant dba access in the progress database
Search for KB ID - P69145
http://progress.atgnow.com/esprogress/categoryBrowse.do

Use the same username and password when you try to connect from your windows client.

5) Make sure you have Progress Client networking installed in the Windows side (you can get this from Progress.com). you need to register with progress using your serial and control number which came with your progress purchase. When you install this make sure you use complete installation.

5) Also look for solution ID : 20143 (has some good info needs to set it up)

6) I also had some problem with libusort.sl file . It was in /usr/dlc/lib folder in unix. i copied it to /usr/lib (But i dont remember , will look for some documentation , if i find it i will post it here.)

Hope this helps. These are some things i had to do to make my ODBC Work.

I might have missed something but will update if i remember.

Thanks
Saroren

 

[saroren]

Hi JJames100,


Look for these Solution ID in the KB.

P33660 - Title: "Error "Database is not started" when connecting to 9.1D databse through SQL-92."

ID: P18512
Title: "Cannot make any ODBC or JDBC connection to SQL-92 Database"



Go to http://knowledgebase.datadirect.com/

Search for "database not started" you will get lots of result.

I still remember once i fixed the librarys required then it worked.

Good Luck.