ODBC Connection

[plineham]

I'm trying to set up an ODBC connection to a progress database using the merant 3.6 driver.

Can anyone let me know what the default username and port is for a database. My colleagues are no help.

Thanks for your help
Paul

 

[fizz]

Additional question rather than reply

I have ODBC connections established using Merant 3.60 through Crystal Reports XI, but am only able to see Tables. I am trying to create views as commands in Crystal but get Driver errors- Details: 42502............. Table/View/Synonym not Found.

I get this error regardless of the complexity of the SQL statement, even when copying a Crystal SQL (that runs) into the Command window.

Are there alternative drivers, or is it simply not possible to access/use a Progress database in this manner?

I am only able to see Tables with any of the Tools provided by my application vendor as well. I can build a Query, but I cannot perform Grouping on them. Am I asking too much of Progress?


Thanks

 

[BONO]

Fizz,
default username = user to connect to database
port = Port declared on server for the broker of the database (It can be port number or service name)

A default progress user can be used for odbc connection : sysprogress

It's recommanded to use a specific borker for odbc connection

 

[Progress_Guy]

Table/View/synonym not found

In a hurry so I'm gonna' be a little lazy here.

Firstly check the Progress Web Site technical support section they're some solutions here. if still struggling send me a message and I'll try and help as done a reasonable amount of work with ODBC.

Thanks.

 

[fizz]

Thanks Dave but my problem appears to be related to the less than full support offered by Progress 9.1D to Crystal v11. This is compounded by the limited access allowed by the front-end vender to the DB.

I have no information regarding when the DB will/may be upgraded so will have to persevere in the interim.

Thanks for your offer though

 

[vdennis]

ODBC yet?

Did you ever get your connection?
-Dennis-

 

[BONO]

Hello,
For information,
i've download demo version of Crystal 11 and i can do same things that with 9 and no connection pb

 

[fizz]

I have discovered that Progress 9.1D doesn't support Crystal XI, as noted on the Progress site. That is the cause of my problems. there is no intention of upgrading the DB in the packaged app (at least not in the forseeable future by the vendor) so I'll just have to try something else.

I have a connection, no problems there, just can't use anything bar tables.

I have been considering trying to create a link via SQL Enterprise Manager to the Progress DB and see if I can bypass the issues that way. Haven't got round to it yet though.

Has any one else tried/succeeded in this??

 

[vdennis]

I am using 9.1d098 and CRXI on a system, so you have other problems. If you can, check out the setting for the SQL of PROGRESS. There are several KB's on that issue and a must read is #20143. If you have paid for Progress support, they WILL help you in this matter.

One thing I did was to seperate the SQL from the 4GL as far as data servers go. Don't know why, but I remember someone once told me I would get better performance. It works.

Also, what version of CR? The standard version I think only works with a local PC. You would need to check out BusinessObjects on that. I am running both CR9 and CR11 Developers edition. That may be something to look into as well.
-Dennis-

 

[fizz]

Thanks for the suggestions. Unfortunately, I have very limited access to the actual Database. It is locked within an application and supported by the vendors of that app. The level of access is basically tables only, no ability to modify or add tables, no access to views or stored proc's (if they even exist). I certainly have no access to SQL settings etc.

I am running CR 11 Developer. The issue is very much with the access permitted to the database from any external source. CR 9 would have been a better option as it is fully supported by Progress 9.1d. 9.1E supports CR 11.

I have only a few weeks left on this contract so shall persevere till then.

Thanks to every one for their help.

 

[vakpal]

I have another ODBC problem.

So i use Progress 9.1E01, and Simple ODBC driver (DATA DIRECT 4.10).

When i try connect to online database trough ODBC i give an error message.
[DataDirect][ODBC PROGRESS Driver][PROGRESS]Exceeding permissible number of connections

I don't undarstand this, because i can connect to test database.
This 2 database absolute runing same parameters.

I loked for a solution on Progress KB, but i haven't found a utilizable.

I tried change -Mn, -Mi, - Ma database parameters, but these still doesen't work

Have anybody ide, how solve this thing?

 

[Casper]

Hi vakpal,

Did you try to set up a secondray broker for sql connections? Most likely your servers are ocupied with 4GL connections and so there is no more room for sql92 clients.
See also:
KB 20415
KB p7834


HTH,

Casper.

 

[vakpal]

Hi vakpal,

Did you try to set up a secondray broker for sql connections? Most likely your servers are ocupied with 4GL connections and so there is no more room for sql92 clients.
See also:
KB 20415
KB p7834


HTH,

Casper.

THX.

It looks good.
But i have a problem with this
I made a simple empty database in my local pc, and this is work.
(ODBC connection and secondray broker too)

After i tried this with test database, when i connected to secondray broker i gave an error message : [DataDirect][ODBC PROGRESS Driver][PROGRESS]Error in Network Daemon.
Stange because the secondray broker runing that is looks runing.
(In ProControl)

I Changed the port number 5 or 6 times, but always gave same Error message
Service name is correct, and Host name also and every thing is good.
But what's the problem?

 

[Casper]

What OS?
What version of Progress?
What version of datadirect driver?

Make sure the startup script for the secondeory broker looks like:

-db databasename
-H Hostname
-S ServicenameSqlconnection (different port from primary broker)
-N TCP
-Mpb #sqlservers needed
-m3
-ServerType SQL

What is the error number you get when connecting with odbc?
Is there anything in de db log?

Regards,

Casper.

NOTE: I previous post I meant KB p7843 instead of p7834

 

[vakpal]

What OS?
What version of Progress?
What version of datadirect driver?

Make sure the startup script for the secondeory broker looks like:

-db databasename
-H Hostname
-S ServicenameSqlconnection (different port from primary broker)
-N TCP
-Mpb #sqlservers needed
-m3
-ServerType SQL

What is the error number you get when connecting with odbc?
Is there anything in de db log?

Regards,

Casper.

NOTE: I previous post I meant KB p7843 instead of p7834

Windows Server 2003 + SP1
Progress Version 9.1E01
DadaDiret 4.10.01.00

I know the parameters, but now i use ProControl THX.

This is the First Broker and use 15304 port number
-L 150000
-c 350
-B 2000
-cpinternal 1250
-cpstream 1250
-cpcoll Hungarian
-cpcase Basic
-d ymd
-numsep 44
-numdec 46
-yy 1920
-S weseb2_t_q
-N TCP
-H whamfg
-TB 32
-TM 32
-t
-T E:\MFGDB\WRKEB2
-n 30
-Mn 7
-Mi 5
-Ma 5
-Mpb 4

This is a Secondary Broker Pf File, (port number 15308)
-L 150000
-c 350
-B 2000
-cpinternal 1250
-cpstream 1250
-cpcoll Hungarian
-cpcase Basic
-d ymd
-numsep 44
-numdec 46
-yy 1920
-S wessql_t_q
-N TCP
-H whamfg
-TB 32
-TM 32
-t
-T E:\MFGDB\WRKEB2
-Mi 5
-Ma 5
-Mpb 2
-m3
-ServerType SQL

Error Number? Just an error message.
[DataDirect][ODBC PROGRESS Driver][PROGRESS]Error in Network Daemon.
No more, no less

I just try a connection in Microsoft ODBC Data Source Administration program.

 

[BONO]

Hello,Are sure wessql_t_q is on the services file (windows\system32\driver\etc), with the correct port number. Have you tried to connect with -S <portnumber>.

To know if the service is ok u can use telnet, on progress knowledge base u've some example to determine where is the problem. Then the access permission denied can provide from a bad database param:

These 3 param are dependant :

Database and defaut configuration
-Mn = nb server (4 if the two broker are both l4g and sql)
-n = nb client (addition of Number of client/server of each server) + 1 for the watch dog)

L4G broker (1 server if only l4g, 2 if sql and l4g)
Number of client/server

SQL Broker (1 server if only l4g, 2 if sql and l4g)
Number of client/server


But with progress explorer tools it's easier to param than old procontrol.

U can have another kind of problem, user sysprogress is created on database ?

 

[vakpal]

Hello,Are sure wessql_t_q is on the services file (windows\system32\driver\etc), with the correct port number. Have you tried to connect with -S <portnumber>.

To know if the service is ok u can use telnet, on progress knowledge base u've some example to determine where is the problem. Then the access permission denied can provide from a bad database param:

These 3 param are dependant :

Database and defaut configuration
-Mn = nb server (4 if the two broker are both l4g and sql)
-n = nb client (addition of Number of client/server of each server) + 1 for the watch dog)

L4G broker (1 server if only l4g, 2 if sql and l4g)
Number of client/server

SQL Broker (1 server if only l4g, 2 if sql and l4g)
Number of client/server


But with progress explorer tools it's easier to param than old procontrol.

U can have another kind of problem, user sysprogress is created on database ?

:awink: I know how work services, and yes wessql_t_q and weseb2_t_q is exist on service file

You can see our database parameters in first page of this topic.
I think that is ok, but still dosen't work the odbc connection

I know the progress explorer is easier, but this is not my installation
When we have a Maintenance, i will change to explorer ASAP,
but now it is no way. We have a lot of databases, and these are use now.

But I'll try make a another test system, and use progress explorer.

Of Course sysprogress is exist.

 

[BONO]

I 've never param odbc broker without progress explorer tools, but the only thing i don't understand on your param is the -Mi, and why = -Ma, have u tried with both -Mi at 1, then you have 3 server then -Mn have to be set to 3
So i don't know exactly on u're param the impact of -Mpb.
The first broker start 2 server, one sql and one 4GL
so wich type of server the first -Mpb concern ?

 

[Casper]

What if you try to put
-ServerType 4GL to your primary broker?

Casper

 

[vakpal]

What if you try to put
-ServerType 4GL to your primary broker?

Casper

Hihi.
OK Good idea
I will try it on Monday.

THX.