[teiid-designer-issues] [JBoss JIRA] Commented: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-927:
---------------------------------------
your xmi file (model) contains connection properties which include a URL :
key="connection:connection-url"
value="jdbc:sqlserver://10.102.59.4\SQLEXPRESS;databaseName=ContinuumDB"
Not sure the impact of // and \ characters in same URL on Windows.
In order for the Preview Data action to be enabled you need the following:
1) Preview is enabled ( See drop-down option in the Teiid View toolbar)
2) There is a connected Teiid server instance defined in the Teiid View
3) A valid executable relational table or procedure must be selected
4) If a view table or procedure is selected, then the backing transformation must
represent a valid SQL Query
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: sqlserver.png, UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira