Table / View / Synonym not found

[el_Erik]

Moin Moin,

We have an application an fetch data's from a progress database via odbc driver.
We have used OpenLink Generic 32 Bit Driver 4.0.

After an update of progress db and the odbc driver we use the Progress OpenEdge 10.2B Driver.
Now we get the error: Table / View / Synonym not found
The reason is that the schema name ist not specified in the SQL query.

I would not rebuild the whole interface.
It is possible to access by a SQL-statement select * from <tablename> instead select * from pub.<tablename>?
Can I assign the user to the database schema pub?

Thanks in Advanced

Marco

 

[Marian EDU]

Update your connection string by adding this... INITIALIZATIONSTRING=SET SCHEMA 'PUB'

hope will work for ODBC as well, this is the JDBC variant

jdbc:datadirect:openedge://localhost:35000;databaseName=sports2000;INITIALIZATIONSTRING=set schema 'PUB'

 

[el_Erik]

Hello Marian,

thanks for your tip.

I have added the INITIALIZATIONSTRING to my ODBC connection string. But it doesnt work. Hmm....
Where can i find a good manual to the odbc driver?

Best greetings to Bucharest.

Marco

 

[Marian EDU]

Well, as we are talking about windows here things are much easier that that initialization string

[TD="colspan: 2"] ID: P21008 Title: "How to set the default SQL-92 Schema on Windows for ODBC Connection ?"
[/TD]

[TD="class: solutiontitletiny"]Created: 03/12/2003[/TD]
[TD="class: solutiontitletiny, width: 80%"]Last Modified: 03/21/2008[/TD]

[TD="class: solutiontitletiny, colspan: 2"]Status: Verified
[/TD]

[TD="colspan: 2"]

Goals:
How to set the default SQL-92 Schema on Windows for ODBC Connection ?
How to avoid specifying the "PUB" schema in a SQL query
[/TD]

[TD="colspan: 2"][/TD]

[TD="colspan: 2"]

Facts:
Progress 9.x
OpenEdge 10.x
Windows NT 32 Intel/Windows 2000
[/TD]

[TD="colspan: 2"][/TD]

[TD="colspan: 2"][/TD]

[TD="colspan: 2"]

Fixes:
Edit the Windows registry and depending if you are using a User or System DSN, add the default schema from the following entry:

HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\<your DSN name>

or

HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\<your DSN name>
For 64 bit Windows systems, you can find these keys under:
HKEY_CURRENT_USER\Software\Wow6432Node\ODBC\ODBCI.INI
or

HKEY_LOCAL_MACHINE\Software\Wow6432Node\ODBC\ODBCI.INI



To add the Default Schema (typically PUB if it is a 4GL Table):
- Select the DSN Name,
- In the right side of the Window, right-click
- Select "New"
- Select "String Value"
- Type "DefaultSchema"
- Enter
- Double-Click on the newly added entry "DefaultSchema"
- Enter the Default Schema (example : PUB)
[/TD]