<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: arial,helvetica,sans-serif; font-size: 10pt; color: #000000'>Hello all.<br><br>All ports match, and from Dev Studio I am able to enter in "Teiid Instance" configuration window and "Test Administration Connection" and "Test JDBC Connection" with success. I am using the same configurations which I am used to with my linux instances, and they work fine all the time.<br><br>I tried Van Halbert approach (described in <span style="font-style: italic;">http://teiid.blogspot.com/2013/06/expose-excel-data-as-odata-feed-using.html</span>), without success:<br><br>1. Using the VDB below (copied from the blog), I got the following error: <span style="font-weight: bold;">Caused by: org.xml.sax.SAXParseException: cvc-complex-type.2.1: Element
'property' must have no character or element information item
[children], because the type's content type is empty.</span><div style="font-style: italic;" class="container"><div class="line number1 index0 alt2"><code class="js plain"><vdb name=</code><code class="js string">"odbc"</code> <code class="js plain">version=</code><code class="js string">"1"</code><code class="js plain">></code></div><div class="line number2 index1 alt1"><code class="js spaces"> </code><code class="js plain"><property name=</code><code class="js string">"UseConnectorMetadata"</code> <code class="js plain">value=</code><code class="js string">"true"</code><code class="js plain">></code></div><div class="line number3 index2 alt2"><code class="js spaces"> </code><code class="js plain"><model name=</code><code class="js string">"excel"</code><code class="js plain">></code></div><div class="line number4 index3 alt1"><code class="js spaces"> </code><code class="js plain"><source connection-jndi-name=</code><code class="js string">"java:/odbcDS"</code> <code class="js plain">name=</code><code class="js string">"connector"</code> <code class="js plain">translator-name=</code><code class="js string">"jdbc-simple"</code><code class="js plain">></code></div><div class="line number5 index4 alt2"><code class="js spaces"> </code><code class="js plain"></model></code></div><div class="line number6 index5 alt1"><code class="js plain"></property></vdb></code></div></div><br>2. I changed the VDB to the format shown below, and I got the following error: <span style="font-weight: bold;">VDB odbc.1 model "excel" metadata failed to load. Reason:TEIID11010 java.sql.SqlException: [Microsoft][ODBC Driver Manager] The driver does not offer support for this function.</span><br><div style="font-style: italic;" class="container"><div class="line number1 index0 alt2"><code class="js plain"><vdb name=</code><code class="js string">"odbc"</code> <code class="js plain">version=</code><code class="js string">"1"</code><code class="js plain">></code></div><div class="line number2 index1 alt1"><code class="js spaces"> </code><code class="js plain"><property name=</code><code class="js string">"UseConnectorMetadata"</code> <code class="js plain">value=</code><code class="js string">"true"/</code><code class="js plain">></code></div><div class="line number3 index2 alt2"><code class="js spaces"> </code><code class="js plain"><model name=</code><code class="js string">"excel"</code><code class="js plain">></code></div><div class="line number4 index3 alt1"><code class="js spaces"> </code><code class="js plain"><source connection-jndi-name=</code><code class="js string">"java:/odbcDS"</code> <code class="js plain">name=</code><code class="js string">"connector"</code> <code class="js plain">translator-name=</code><code class="js string">"jdbc-simple"/</code><code class="js plain">></code></div><div class="line number5 index4 alt2"><code class="js spaces"> </code><code class="js plain"></model></code></div><div class="line number6 index5 alt1"><code class="js plain"></vdb><br><span style="font-style: italic;"></span><br></code><code class="js plain"></code></div></div>I was able to query my Excel data directly using SquirreL SQL client and Microsoft ODBC driver.<br><br>In both cases depicted above, I was not able to access OData via browser (http://localhost:8080/odata/odbc/excel.Sheet1). After input my credentials I got another error: <span style="font-weight: bold;">HTTP Status 403: Access to the requested resource has been denied</span>.<div><br>I attached my excel file. It is very simple (2 columns), and once I get this working I will have to use the one provided by the customer.<br><br>Regards,<br><br>Thiago Araki<br><br></div><hr id="zwchr"><div style="color: rgb(0, 0, 0); font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><b>From: </b>"Rob Cernich" <rcernich@redhat.com><br><b>To: </b>"Ramesh Reddy" <rareddy@redhat.com><br><b>Cc: </b>"Robert Stryker" <rstryker@redhat.com>, "Max Rydahl Andersen" <max.andersen@redhat.com>, sme-dataservicesplatform@redhat.com, "jbosstools-dev" <jbosstools-dev@lists.jboss.org><br><b>Sent: </b>Thursday, March 13, 2014 2:34:01 PM<br><b>Subject: </b>Re: [jbosstools-dev] JBDS 7.1 (Teiid Designer) problem in Windows XP SP3<br><br>You might make sure the server configuration in the tools is configured to listen to the management port...and make sure the configured port matches.<br><br>----- Original Message -----<br>> Even that needs a ODBC DSN created for Excel on Windows platform, if you<br>> already have VDB configured this will work. If you are trying to build<br>> the VDB and preview while doing so then you will still see below issue.<br>> <br>> Ramesh..<br>> <br>> On Thu, 2014-03-13 at 09:54 -0400, Van Halbert wrote:<br>> > Here' a blog by Ramesh:<br>> > http://teiid.blogspot.com/2013/06/expose-excel-data-as-odata-feed-using.html<br>> > <br>> > Maybe this is an option for you.<br>> > <br>> > Van<br>> > <br>> > ----- Original Message -----<br>> > From: "Ted Jones" <tejones@redhat.com><br>> > To: "Thiago Araki" <taraki@redhat.com>, "Max Rydahl Andersen"<br>> > <max.andersen@redhat.com>, "Robert Stryker" <rstryker@redhat.com>,<br>> > "jbosstools-dev" <jbosstools-dev@lists.jboss.org><br>> > Cc: sme-dataservicesplatform@redhat.com<br>> > Sent: Thursday, March 13, 2014 8:53:04 AM<br>> > Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3<br>> > <br>> > Adding Max, Rob and jbosstools-dev for their insights...<br>> > <br>> > ----- Original Message -----<br>> > <br>> > > From: "Thiago Araki" <taraki@redhat.com><br>> > > To: "Ted Jones" <tejones@redhat.com><br>> > > Cc: sme-dataservicesplatform@redhat.com<br>> > > Sent: Thursday, March 13, 2014 8:21:11 AM<br>> > > Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3<br>> > <br>> > > Hello Ted,<br>> > <br>> > > I did not, but I tried now with this option and unfortunately the same<br>> > > thing<br>> > > happened.<br>> > <br>> > > I am stuck with this problem and my time is running out to deliver this<br>> > > POC.<br>> > > The reason I am using a Windows environment is because I need to<br>> > > integrate<br>> > > data from an Excel data source, and the only way I found to do it is with<br>> > > the Microsoft ODBC driver.<br>> > <br>> > > Regards,<br>> > <br>> > > Thiago<br>> > <br>> > > ----- Original Message -----<br>> > <br>> > > From: "Ted Jones" <tejones@redhat.com><br>> > > To: "Thiago Araki" <taraki@redhat.com><br>> > > Cc: sme-dataservicesplatform@redhat.com<br>> > > Sent: Wednesday, March 12, 2014 6:42:17 PM<br>> > > Subject: Re: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3<br>> > <br>> > > Hi Thiago,<br>> > <br>> > > When creating your server connection in JBDS, did you check the "Server<br>> > > is<br>> > > externally managed. Assume server is started." radio button? I've<br>> > > attached a<br>> > > screenshot.<br>> > <br>> > > I know this was the way best way to go at one point, so I always do this<br>> > > now<br>> > > out of habit.<br>> > > ----- Original Message -----<br>> > <br>> > > > From: "Thiago Araki" <taraki@redhat.com><br>> > > <br>> > > > To: sme-dataservicesplatform@redhat.com<br>> > > <br>> > > > Sent: Wednesday, March 12, 2014 4:27:34 PM<br>> > > <br>> > > > Subject: JBDS 7.1 (Teiid Designer) problem in Windows XP SP3<br>> > > <br>> > <br>> > > > Hello all,<br>> > > <br>> > <br>> > > > I am having problems with JBoss Dev Studio (with Teiid Designer) 7.1 in<br>> > > > a<br>> > > > Windows environment (Windows XP SP3).<br>> > > <br>> > <br>> > > > When I start my Runtime Server via Dev Studio, the server finishes the<br>> > > > initialization (I can see it in the Console view and and access it via<br>> > > > JBoss<br>> > > > EAP web console) but the progress bar keeps the status "starting JBoss<br>> > > > EAP<br>> > > > 6<br>> > > > Server..." and never finishes. Because of this situation, every<br>> > > > operation<br>> > > > that needs to sync with my server, for instance, Preview Data, gets<br>> > > > queued<br>> > > > and never executes.<br>> > > <br>> > <br>> > > > If I manually start JBoss EAP 6 outside Dev Studio, them try to connect<br>> > > > via<br>> > > > Server View (acknowledging the server is already started), the problem<br>> > > > is<br>> > > > that the progress bar stays in "Performing pre-launch check..." status<br>> > > > forever, and I also cannot interact with my server from my project.<br>> > > <br>> > <br>> > > > In both cases I am able to enter in "Teiid Instance" configuration<br>> > > > window<br>> > > > and<br>> > > > "Test Administration Connection" and "Test JDBC Connection" with<br>> > > > success.<br>> > > <br>> > <br>> > > > It seems to me that something is being incorrectly locked in the plugin<br>> > > > that<br>> > > > integrates Dev Studio and JBoss EAP for this situation.<br>> > > <br>> > <br>> > > > I tried both Oracle JDK 1.6 and 1.7 with the same results. I have<br>> > > > already<br>> > > > re-installed both JBoss EAP and Dev Studio (including version 7.0) and<br>> > > > every<br>> > > > time this behavior occurs.<br>> > > <br>> > <br>> > > > In my Linux machine this problem never happens.<br>> > > <br>> > <br>> > > > Can anybody help me?<br>> > > <br>> > <br>> > > > Thanks,<br>> > > <br>> > <br>> > > > Thiago Araki<br>> > > <br>> > <br>> <br>> <br>> _______________________________________________<br>> jbosstools-dev mailing list<br>> jbosstools-dev@lists.jboss.org<br>> https://lists.jboss.org/mailman/listinfo/jbosstools-dev<br>> <br><br></div><br></div></body></html>