FW: ODBC Connection

From: Steve Salt

Date: 18 Apr 2008

It contains multiple lines of the ilk:
grant select on PUB."_View-Ref" to 'odbc' , 'someuser';

followed by a final:
commit;

these are generated by a .p that iterates round the _file table.


Regards,

Steve


From: Thierry [mailto:ae0b643c-b939-8280-de11-7303afddb940] 
Sent: 18 April 2008 14:38
To: Steve Salt; 
Subject: RE: ODBC Connection

Hi,
�
I would suspect that those error messages come from the <grantlist-file> file.
You would have to look at the content of the file. 

-- Thierry.

> Subject: ODBC Connection
> Date: Fri, 18 Apr 2008 10:33:35 +0100
> From: 992cb84b-7460-5eb2-de11-4003214a47c7
> To: 
> 
> Hi,
> 
> Progress 10.1B03, HPUX ITANIUM B.11.23 U ia64.
> 
> When we moved from AIX (Progress Version 9.1D) to HPUX Itanium (10.0B)
> we found that the sqlexp tool didn't work - this was noted on the Kbase,
> so we waited for the next version for a fix.
> 
> Now that we are using 10.1B03, I tried to start ODBC connections using 
> sqlexp -user dba -password <password> -db <dbname> -S <dbname> -H
> <server> -infile <grantlist-file>
> 
> which yielded:
> 
> OpenEdge Release 10.1B03 as of Sat Nov 3 00:02:55 EDT 2007
> Connecting user "dba" to URL "jdbc:datadirect:openedge://
> <server>:-1;databaseNam
> e=<dbname>;serviceName=<dbname>"... (8920)
> === SQL Exception 1 ===
> SQLState=23000
> ErrorCode=-10102
> [DataDirect][OpenEdge JDBC Driver][OpenEdge] Integrity constraint
> violation:uniq
> ueness constraint violation (7518)
> === SQL Exception 1 ===
> SQLState=42S02
> ErrorCode=-20005
> [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/View/Synonym not
> found (7519)
> === SQL Exception 1 ===
> SQLState=42S02
> ErrorCode=-20005
> [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/View/Synonym not
> found (7519)
> === SQL Exception 1 ===
> SQLState=42S02
> ErrorCode=-20005
> [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/View/Synonym not
> found (7519)
> === SQL Exception 1 ===
> SQLState=42S02
> ErrorCode=-20005
> [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/View/Synonym not
> found (7519)
> 
> 
> Looking at the database log file I see:
> 
> [ae0b643c-b939-8280-de11-7903e3f99eaf] P-10997 T-1 I SQLSRV2 3: (-----)
> SQL Server 10.1B.03 started, configuration: "<dbname>.virtualconfig" 
> [ae0b643c-b939-8280-de11-7903e4f99eaf] P-10997 T-1 I SQLSRV2 3: (-----)
> "<dbname>" started on port 1063, pid 10997 (0x00002af5).
> [ae0b643c-b939-8280-de11-7903e5f99eaf] P-10997 T-1 I SQLSRV2 3: (-----)
> Thread stack size: 1024000 (bytes).
> [ae0b643c-b939-8280-de11-7903e5f99eaf] P-10997 T-1 I SQLSRV2 3: (-----)
> DLC from ENVIRONMENT VARIABLE is: /dlc/101B03 
> [ae0b643c-b939-8280-de11-7903e5f99eaf] P-10997 T-1 I SQLSRV2 3: (-----)
> WRKDIR from ENVIRONMENT VARIABLE is: /wrk/ 
> [ae0b643c-b939-8280-de11-7903e5f99eaf] P-10997 T-1 I SQLSRV2 3: (-----)
> JDKHOME from DEFAULT is: 
> [ae0b643c-b939-8280-de11-7903e5f99eaf] P-10997 T-1 I SQLSRV2 3: (-----)
> JREHOME from ENVIRONMENT VARIABLE is: /dlc/101B03/jre 
> [ae0b643c-b939-8280-de11-7903e5f99eaf] P-10997 T-1 I SQLSRV2 3: (-----)
> CLASSPATH from DEFAULT is: 
> [ae0b643c-b939-8280-de11-7903e5f99eaf] P-10997 T-1 I SQLSRV2 3: (-----)
> PROSQL_LOCKWAIT_TIMEOUT value is: 5 seconds
> [ae0b643c-b939-8280-de11-7903a5e5aaaf] P-10997 T-3 I SRV 3: (8873)
> Login usernum 71, remote SQL client. 
> [ae0b643c-b939-8280-de11-7903a6e5aaaf] P-10997 T-3 I SRV 3: (7129)
> Usr 71 set name to dba. 
> [ae0b643c-b939-8280-de11-7903a7e5aaaf] P-10997 T-3 I SRV 3: (453)
> Logout by dba on .
> 
> What should I do next? How can I find out what "] Integrity constraint
> violation:uniqueness constraint violation (7518)" refers too. Ditto
> "Table/View/Synonym not found (7519)"
> 
> Is this a problem with the sqlexp tool or our configuration? To my
> knowledge we did not change anything when we moved from our previous
> platform / Progress version.
> 
> Any suggestions?
> 
> Regards,
> 
> Steve Salt,
> Analyst Programmer / Database Administrator
> The Danwood Group
> 
> **********************************************************************
> This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.
> 
> This footnote also confirms that this email message has been swept by Kaspersky and Panda EnterpriSecure for the presence of computer viruses.
> 
> The Danwood Group Ltd is a company registered in England (no. 1056774) with its address at Harrisson Place, Whisby Road, Lincoln, Lincolnshire, LN6 3DG.
> **********************************************************************
> 
________________________________________
Discutez gratuitement avec vos amis en vid�o ! T�l�chargez Messenger, c'est gratuit !
**********************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by Kaspersky and Panda EnterpriSecure for the presence of computer viruses.

The Danwood Group Ltd is a company registered in England  (no. 1056774) with its address at Harrisson Place, Whisby Road, Lincoln, Lincolnshire, LN6 3DG.
**********************************************************************