Home » Archived » BIRT » How sun.jdbc.odbc can read data in network ?
| How sun.jdbc.odbc can read data in network ? [message #251438] |
Tue, 07 August 2007 09:45  |
Eclipse User |
|
|
|
Originally posted by: subianto.liawidjaya.planatations.co.id
I am trying BIRT data source with driver class :
sun.jdbc.odbc.JdbcOdbcDriver
then, at data source (Database URL) I fill : jdbc:odbc:posdbf
(* my odbc database is DBF, it's name : posdbf, and it's free table locate
at C:\POS\DATABASE)
I make data set and running the report design :
*. preview in Report-Design - Eclipse SDK = good
*. view report in Report-Design-Eclipse SDK = good
*. view with (tomcat+birt viewer 2.2), address http://localhost:8080/.... =
good
my problem is :
if ODBC (POSDBF) I set the data location in network, G:\POS\DATABASE
*. preview in Report-Design - Eclipse SDK = good
*. view report in Report-Design-Eclipse SDK = good
*. view with (tomcat+birt viewer 2.2), address http://localhost:8080/.... =
NO RESULT
if I read log, the error is :
*****************************
SEVERE: Cannot get resultset metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not
return a ResultSet object.
SQL error #1: [Microsoft][ODBC Visual FoxPro Driver]File 'operator.dbf' does
not exist.
;
java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]File
'operator.dbf' does not exist.
*****************************
I am using WIN XP, and the server is WIN NT.
maybe I miss someting must set in tomcat or birt viewer 2.2 ?, anyone can
explain this case, please ?
Thanks.
|
|
|
| Re: How sun.jdbc.odbc can read data in network ? [message #251531 is a reply to message #251438] |
Tue, 07 August 2007 17:58  |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
This looks like a permission issue. Can you try to setup the DSN and
use the network button, and specifically setup a username and password
to connect to the remove system?
Jason
BIRT wrote:
> I am trying BIRT data source with driver class :
> sun.jdbc.odbc.JdbcOdbcDriver
> then, at data source (Database URL) I fill : jdbc:odbc:posdbf
>
> (* my odbc database is DBF, it's name : posdbf, and it's free table locate
> at C:\POS\DATABASE)
>
> I make data set and running the report design :
> *. preview in Report-Design - Eclipse SDK = good
> *. view report in Report-Design-Eclipse SDK = good
> *. view with (tomcat+birt viewer 2.2), address http://localhost:8080/.... =
> good
>
> my problem is :
> if ODBC (POSDBF) I set the data location in network, G:\POS\DATABASE
>
> *. preview in Report-Design - Eclipse SDK = good
> *. view report in Report-Design-Eclipse SDK = good
> *. view with (tomcat+birt viewer 2.2), address http://localhost:8080/.... =
> NO RESULT
>
> if I read log, the error is :
>
> *****************************
> SEVERE: Cannot get resultset metadata.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not
> return a ResultSet object.
> SQL error #1: [Microsoft][ODBC Visual FoxPro Driver]File 'operator.dbf' does
> not exist.
> ;
> java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]File
> 'operator.dbf' does not exist.
> *****************************
>
> I am using WIN XP, and the server is WIN NT.
>
> maybe I miss someting must set in tomcat or birt viewer 2.2 ?, anyone can
> explain this case, please ?
> Thanks.
>
>
|
|
|
| Re: How sun.jdbc.odbc can read data in network ? [message #251827 is a reply to message #251531] |
Thu, 09 August 2007 00:45 |
| Eclipse User |
|
|
|
Originally posted by: subianto.liawidjaya.plantations.co.id
Hi Jason,
Yes, when setup the DSN and choose the network button I have to map
network drive (map to G:\) and I can see the files (DBF files) when setup
the DSN.
But how I put the username and password in DSN ? because when I explore with
IE, the drive G shows files and FOXPRO can open the files (DBF files) in
drive G.
Thanks.
"Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
news:f9abom$pk$1@build.eclipse.org...
> This looks like a permission issue. Can you try to setup the DSN and use
> the network button, and specifically setup a username and password to
> connect to the remove system?
>
> Jason
>
> BIRT wrote:
>> I am trying BIRT data source with driver class :
>> sun.jdbc.odbc.JdbcOdbcDriver
>> then, at data source (Database URL) I fill : jdbc:odbc:posdbf
>>
>> (* my odbc database is DBF, it's name : posdbf, and it's free table
>> locate at C:\POS\DATABASE)
>>
>> I make data set and running the report design :
>> *. preview in Report-Design - Eclipse SDK = good
>> *. view report in Report-Design-Eclipse SDK = good
>> *. view with (tomcat+birt viewer 2.2), address
>> http://localhost:8080/.... = good
>>
>> my problem is :
>> if ODBC (POSDBF) I set the data location in network, G:\POS\DATABASE
>>
>> *. preview in Report-Design - Eclipse SDK = good
>> *. view report in Report-Design-Eclipse SDK = good
>> *. view with (tomcat+birt viewer 2.2), address
>> http://localhost:8080/.... = NO RESULT
>>
>> if I read log, the error is :
>>
>> *****************************
>> SEVERE: Cannot get resultset metadata.
>> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does
>> not return a ResultSet object.
>> SQL error #1: [Microsoft][ODBC Visual FoxPro Driver]File 'operator.dbf'
>> does not exist.
>> ;
>> java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]File
>> 'operator.dbf' does not exist.
>> *****************************
>>
>> I am using WIN XP, and the server is WIN NT.
>>
>> maybe I miss someting must set in tomcat or birt viewer 2.2 ?, anyone
>> can explain this case, please ?
>> Thanks.
|
|
|
| Re: How sun.jdbc.odbc can read data in network ? [message #251870 is a reply to message #251827] |
Thu, 09 August 2007 14:43 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
When you map the drive you have the option to use your username or
"Connect using a different use name". If your username is working this
should not be an issue. Is tomcat running as the same user you
connected the network drive with?
Jason
Bian wrote:
> Hi Jason,
>
> Yes, when setup the DSN and choose the network button I have to map
> network drive (map to G:\) and I can see the files (DBF files) when setup
> the DSN.
> But how I put the username and password in DSN ? because when I explore with
> IE, the drive G shows files and FOXPRO can open the files (DBF files) in
> drive G.
>
> Thanks.
>
>
>
>
> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
> news:f9abom$pk$1@build.eclipse.org...
>> This looks like a permission issue. Can you try to setup the DSN and use
>> the network button, and specifically setup a username and password to
>> connect to the remove system?
>>
>> Jason
>>
>> BIRT wrote:
>>> I am trying BIRT data source with driver class :
>>> sun.jdbc.odbc.JdbcOdbcDriver
>>> then, at data source (Database URL) I fill : jdbc:odbc:posdbf
>>>
>>> (* my odbc database is DBF, it's name : posdbf, and it's free table
>>> locate at C:\POS\DATABASE)
>>>
>>> I make data set and running the report design :
>>> *. preview in Report-Design - Eclipse SDK = good
>>> *. view report in Report-Design-Eclipse SDK = good
>>> *. view with (tomcat+birt viewer 2.2), address
>>> http://localhost:8080/.... = good
>>>
>>> my problem is :
>>> if ODBC (POSDBF) I set the data location in network, G:\POS\DATABASE
>>>
>>> *. preview in Report-Design - Eclipse SDK = good
>>> *. view report in Report-Design-Eclipse SDK = good
>>> *. view with (tomcat+birt viewer 2.2), address
>>> http://localhost:8080/.... = NO RESULT
>>>
>>> if I read log, the error is :
>>>
>>> *****************************
>>> SEVERE: Cannot get resultset metadata.
>>> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does
>>> not return a ResultSet object.
>>> SQL error #1: [Microsoft][ODBC Visual FoxPro Driver]File 'operator.dbf'
>>> does not exist.
>>> ;
>>> java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]File
>>> 'operator.dbf' does not exist.
>>> *****************************
>>>
>>> I am using WIN XP, and the server is WIN NT.
>>>
>>> maybe I miss someting must set in tomcat or birt viewer 2.2 ?, anyone
>>> can explain this case, please ?
>>> Thanks.
>
>
|
|
|
| Re: How sun.jdbc.odbc can read data in network ? [message #251935 is a reply to message #251870] |
Fri, 10 August 2007 00:29 |
| Eclipse User |
|
|
|
Originally posted by: subianto.liawidjaya.plantations.co.id
Jason,
I install tomcat in my computer (win XP) and login with the same user
that I connect to network drive.
Thanks.
"Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
news:f9f937$j60$1@build.eclipse.org...
>
>
> When you map the drive you have the option to use your username or
> "Connect using a different use name". If your username is working this
> should not be an issue. Is tomcat running as the same user you connected
> the network drive with?
>
> Jason
>
> Bian wrote:
>> Hi Jason,
>>
>> Yes, when setup the DSN and choose the network button I have to map
>> network drive (map to G:\) and I can see the files (DBF files) when setup
>> the DSN.
>> But how I put the username and password in DSN ? because when I explore
>> with IE, the drive G shows files and FOXPRO can open the files (DBF
>> files) in drive G.
>>
>> Thanks.
>>
>>
>>
>>
>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>> news:f9abom$pk$1@build.eclipse.org...
>>> This looks like a permission issue. Can you try to setup the DSN and
>>> use the network button, and specifically setup a username and password
>>> to connect to the remove system?
>>>
>>> Jason
>>>
>>> BIRT wrote:
>>>> I am trying BIRT data source with driver class :
>>>> sun.jdbc.odbc.JdbcOdbcDriver
>>>> then, at data source (Database URL) I fill : jdbc:odbc:posdbf
>>>>
>>>> (* my odbc database is DBF, it's name : posdbf, and it's free table
>>>> locate at C:\POS\DATABASE)
>>>>
>>>> I make data set and running the report design :
>>>> *. preview in Report-Design - Eclipse SDK = good
>>>> *. view report in Report-Design-Eclipse SDK = good
>>>> *. view with (tomcat+birt viewer 2.2), address
>>>> http://localhost:8080/.... = good
>>>>
>>>> my problem is :
>>>> if ODBC (POSDBF) I set the data location in network, G:\POS\DATABASE
>>>>
>>>> *. preview in Report-Design - Eclipse SDK = good
>>>> *. view report in Report-Design-Eclipse SDK = good
>>>> *. view with (tomcat+birt viewer 2.2), address
>>>> http://localhost:8080/.... = NO RESULT
>>>>
>>>> if I read log, the error is :
>>>>
>>>> *****************************
>>>> SEVERE: Cannot get resultset metadata.
>>>> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does
>>>> not return a ResultSet object.
>>>> SQL error #1: [Microsoft][ODBC Visual FoxPro Driver]File 'operator.dbf'
>>>> does not exist.
>>>> ;
>>>> java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]File
>>>> 'operator.dbf' does not exist.
>>>> *****************************
>>>>
>>>> I am using WIN XP, and the server is WIN NT.
>>>>
>>>> maybe I miss someting must set in tomcat or birt viewer 2.2 ?, anyone
>>>> can explain this case, please ?
>>>> Thanks.
>>
|
|
|
| Re: How sun.jdbc.odbc can read data in network ? [message #251977 is a reply to message #251935] |
Fri, 10 August 2007 14:48 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Bian,
Can you log a bugzilla entry for this.
Jason
Bian wrote:
> Jason,
>
> I install tomcat in my computer (win XP) and login with the same user
> that I connect to network drive.
> Thanks.
>
> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
> news:f9f937$j60$1@build.eclipse.org...
>>
>> When you map the drive you have the option to use your username or
>> "Connect using a different use name". If your username is working this
>> should not be an issue. Is tomcat running as the same user you connected
>> the network drive with?
>>
>> Jason
>>
>> Bian wrote:
>>> Hi Jason,
>>>
>>> Yes, when setup the DSN and choose the network button I have to map
>>> network drive (map to G:\) and I can see the files (DBF files) when setup
>>> the DSN.
>>> But how I put the username and password in DSN ? because when I explore
>>> with IE, the drive G shows files and FOXPRO can open the files (DBF
>>> files) in drive G.
>>>
>>> Thanks.
>>>
>>>
>>>
>>>
>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>> news:f9abom$pk$1@build.eclipse.org...
>>>> This looks like a permission issue. Can you try to setup the DSN and
>>>> use the network button, and specifically setup a username and password
>>>> to connect to the remove system?
>>>>
>>>> Jason
>>>>
>>>> BIRT wrote:
>>>>> I am trying BIRT data source with driver class :
>>>>> sun.jdbc.odbc.JdbcOdbcDriver
>>>>> then, at data source (Database URL) I fill : jdbc:odbc:posdbf
>>>>>
>>>>> (* my odbc database is DBF, it's name : posdbf, and it's free table
>>>>> locate at C:\POS\DATABASE)
>>>>>
>>>>> I make data set and running the report design :
>>>>> *. preview in Report-Design - Eclipse SDK = good
>>>>> *. view report in Report-Design-Eclipse SDK = good
>>>>> *. view with (tomcat+birt viewer 2.2), address
>>>>> http://localhost:8080/.... = good
>>>>>
>>>>> my problem is :
>>>>> if ODBC (POSDBF) I set the data location in network, G:\POS\DATABASE
>>>>>
>>>>> *. preview in Report-Design - Eclipse SDK = good
>>>>> *. view report in Report-Design-Eclipse SDK = good
>>>>> *. view with (tomcat+birt viewer 2.2), address
>>>>> http://localhost:8080/.... = NO RESULT
>>>>>
>>>>> if I read log, the error is :
>>>>>
>>>>> *****************************
>>>>> SEVERE: Cannot get resultset metadata.
>>>>> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does
>>>>> not return a ResultSet object.
>>>>> SQL error #1: [Microsoft][ODBC Visual FoxPro Driver]File 'operator.dbf'
>>>>> does not exist.
>>>>> ;
>>>>> java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]File
>>>>> 'operator.dbf' does not exist.
>>>>> *****************************
>>>>>
>>>>> I am using WIN XP, and the server is WIN NT.
>>>>>
>>>>> maybe I miss someting must set in tomcat or birt viewer 2.2 ?, anyone
>>>>> can explain this case, please ?
>>>>> Thanks.
>
|
|
|
| Re: How sun.jdbc.odbc can read data in network ? [message #253494 is a reply to message #251977] |
Mon, 27 August 2007 03:18 |
| Eclipse User |
|
|
|
Originally posted by: subianto.liawidjaya.plantations.co.id
Hi... Jason,
Actually I solve my problem (sun.jdbc.odbc... driver connect to database in
network with local odbc). The problem is at setting Tomcat.
After we install Tomcat 5.523, we must add some bat files to setting the
tomcat (I learn and copied the setting file from installing JASPER SERVER).
Now, my problem is solved.
thanks for your help Jason.
Best regards,
Bian.
"Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
news:f9hton$6sb$3@build.eclipse.org...
> Bian,
>
> Can you log a bugzilla entry for this.
>
> Jason
>
> Bian wrote:
>> Jason,
>>
>> I install tomcat in my computer (win XP) and login with the same
>> user that I connect to network drive.
>> Thanks.
>>
>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>> news:f9f937$j60$1@build.eclipse.org...
>>>
>>> When you map the drive you have the option to use your username or
>>> "Connect using a different use name". If your username is working this
>>> should not be an issue. Is tomcat running as the same user you
>>> connected the network drive with?
>>>
>>> Jason
>>>
>>> Bian wrote:
>>>> Hi Jason,
>>>>
>>>> Yes, when setup the DSN and choose the network button I have to map
>>>> network drive (map to G:\) and I can see the files (DBF files) when
>>>> setup the DSN.
>>>> But how I put the username and password in DSN ? because when I explore
>>>> with IE, the drive G shows files and FOXPRO can open the files (DBF
>>>> files) in drive G.
>>>>
>>>> Thanks.
>>>>
>>>>
>>>>
>>>>
>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>> news:f9abom$pk$1@build.eclipse.org...
>>>>> This looks like a permission issue. Can you try to setup the DSN and
>>>>> use the network button, and specifically setup a username and password
>>>>> to connect to the remove system?
>>>>>
>>>>> Jason
>>>>>
>>>>> BIRT wrote:
>>>>>> I am trying BIRT data source with driver class :
>>>>>> sun.jdbc.odbc.JdbcOdbcDriver
>>>>>> then, at data source (Database URL) I fill : jdbc:odbc:posdbf
>>>>>>
>>>>>> (* my odbc database is DBF, it's name : posdbf, and it's free table
>>>>>> locate at C:\POS\DATABASE)
>>>>>>
>>>>>> I make data set and running the report design :
>>>>>> *. preview in Report-Design - Eclipse SDK = good
>>>>>> *. view report in Report-Design-Eclipse SDK = good
>>>>>> *. view with (tomcat+birt viewer 2.2), address
>>>>>> http://localhost:8080/.... = good
>>>>>>
>>>>>> my problem is :
>>>>>> if ODBC (POSDBF) I set the data location in network,
>>>>>> G:\POS\DATABASE
>>>>>>
>>>>>> *. preview in Report-Design - Eclipse SDK = good
>>>>>> *. view report in Report-Design-Eclipse SDK = good
>>>>>> *. view with (tomcat+birt viewer 2.2), address
>>>>>> http://localhost:8080/.... = NO RESULT
>>>>>>
>>>>>> if I read log, the error is :
>>>>>>
>>>>>> *****************************
>>>>>> SEVERE: Cannot get resultset metadata.
>>>>>> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement
>>>>>> does not return a ResultSet object.
>>>>>> SQL error #1: [Microsoft][ODBC Visual FoxPro Driver]File
>>>>>> 'operator.dbf' does not exist.
>>>>>> ;
>>>>>> java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]File
>>>>>> 'operator.dbf' does not exist.
>>>>>> *****************************
>>>>>>
>>>>>> I am using WIN XP, and the server is WIN NT.
>>>>>>
>>>>>> maybe I miss someting must set in tomcat or birt viewer 2.2 ?,
>>>>>> anyone can explain this case, please ?
>>>>>> Thanks.
>>
|
|
|
Goto Forum:
Current Time: Sun Sep 01 09:27:41 GMT 2024
Powered by FUDForum. Page generated in 0.03235 seconds |
] 
Search
Help
Register
Login
Home
