-----Original Message-----
From: support@arrah.in [mailto:support@arrah.in]
Sent: Wednesday, June 04, 2008 1:31 PM
To: Larry Uzzel
Subject: RE: Data Profiler Error
Hi larry,
To me it seems like you have trimmed version of JRE. You can download
full version of JRE at http://java.sun.com/javase/downloads/index.jsp
it will come with all the jar files. then you have to change your path
to include new JRE before old JRE.
let me know if it works.
Reagrds,
Vivek
[Hide Quoted Text]
> Thanks for the reply.
>
> That file is not there.
> The only jar file I see is javaws.jar.
>
> Any ideas where I can get rt.jar? I find a lot of references on the
> internet to it, but it isn't clear how to get it and install it.
>
>
>
>
> Larry Uzzel
> Developer
> IT Applications
>
>
> -----Original Message-----
> From: support@arrah.in [mailto:support@arrah.in]
> Sent: Wednesday, June 04, 2008 12:03 PM
> To: Larry Uzzel
> Subject: Re: Data Profiler Error
>
> Hi larry,
> Thanks for downloading data profiler.
>
> 1.) sun.jdbc.odbc.JdbcOdbcDriver should be in rt.jar
> 2.) You go your java/jre lib and look for rt.jar then type
> > jar -tvf rt.jar
> you should be able to see sun.jdbc.odbc.JdbcOdbcDriver
> 3.) if it is there try to put this classpath ( not needed for Window
XP)
[Hide Quoted Text]
>
> I have not tested with vista. But below is a link which faces same
> problems as your
> http://forum.java.sun.com/thread.jspa?threadID=5297405&tstart=105
>
> I hope solves your problem. If nor please send me screen shot of the
> error message and stack flow.
>
> Thanks,
> Vivek
>
>
>> I get a "Driver Value Not Found" error when trying to launch Profiler
>> from vista.
>>
>>
>>
>> java -classpath "saxon.jar;.;jeval.jar;lucene-core-2.2.0.jar;jxl.jar"
>> Profiler
>>
>>
>>
>>
>>
>> Here's the sql server configuration, which agrees with a DSN
>>
>>
>>
>>
>>
>> Database_Type="SQL_SERVER"
>>
>> Database_Driver="sun.jdbc.odbc.JdbcOdbcDriver"
>>
>> Database_Protocol="jdbc:odbc"
>>
>> Database_DSN="DEV16SQL"
>>
>> Database_User="ReportUser"
>>
>> Database_Passwd="******"
>>
>> Database_Catalog=""
>>
>> Database_SchemaPattern=""
>>
>> Database_TablePattern=""
>>
>> Database_ColumnPattern=""
>>
>> Database_TableType="TABLE"
>>
>>
>>
>> Any ideas?
>>
>>
>>
>> Here's the java version
>>
>>
>>
>>
>>
>>
>>
>> I don't know where the sun drivers would be, how to check for them.
>>
>> Thanks!
>>
>>
>>
>>
>> Larry Uzzel
>> Developer
>> IT Applications
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ok I'm up and running.
Do you have a link to pricing info for > 60 days?
Larry Uzzel
Developer
IT Applications
-----Original Message-----
From: support@arrah.in [mailto:support@arrah.in]
Sent: Friday, June 06, 2008 1:05 PM
To: Larry Uzzel
Subject: RE: Data Profiler Error
This error it gets because it is attaching catalog name in front of
table name.
There are two ways to do it :
1.) While you are creating a DSN you might have chosen SQL Server but
might have chosen DB as DataWarehouse
2.) in configFile.txt you can add "DataWarehouse" in Database_Catalog
field.
You still can go to Tools-->SQL Inteface and type "select * from Time"
see if works ot you have to type select * from DataWarehouse.Time
let me know if it works.
Reagrds,
Vivek
[Hide Quoted Text]
> Progress. I redid the data source so it sort of works, but now get
> this.
>
> Larry Uzzel
>
> Developer
>
> IT Applications
>
>
>
>
>
> -----Original Message-----
> From: support@arrah.in [mailto:support@arrah.in]
> Sent: Friday, June 06, 2008 11:54 AM
> To: Larry Uzzel
> Subject: RE: Data Profiler Error
>
>
>
> I hope you got my last mail about how to creare system DSN. If not go
to
[Hide Quoted Text]
>
> Control Panel --> admintrative tools --> data source create a DSN for
>
> SQL server. have the same name in configFile.txt
>
>
>
> Let me know if it works.
>
> Regards,
>
> Vivek
>
>
>> No. Did you get my screenshot?
>> The config file I sent was the one you sent me with the DSN name etc.
>
>> filled out. Here it is again
>
>> Here's my launch command:
>
>>
>
>> C:\"Program Files"\Java\jdk1.6.0_06\jre\bin\java -classpath
> "C:\Program
>
>>
>
>>
>
>> Is there a specific way other than sql server I need to configure my
>
>> DSN?
>
>>
>
>> Larry Uzzel
>
>>
>
>> Developer
>
>>
>
>> IT Applications
>
>>
>
>> -----Original Message-----
>
>> From: support@arrah.in [mailto:support@arrah.in]
>
>> Sent: Friday, June 06, 2008 9:10 AM
>
>> To: Larry Uzzel
>
>> Subject: RE: Data Profiler Error
>
>>
>
>>
>
>>
>
>> is it working now or not ?
>
>>
>
>> Regards,
>
>>
>
>> Vivek
>
>>
>
>>> Thanks for sceen shot. The problem does not seems to be classpath.
It
[Hide Quoted Text]
>
>> is
>
>>
>
>>> not reaching there yet :) The problem seems to in parsing the file
>
>>
>
>>> configFile.txt
>
>>
>
>>> Seems like you have forgetten to remove the hashout /* */ around
>
>>
>
>>> the SQLServer block.
>
>>
>
>>> I have atatched a configFile.txt Just put your SQL server parameter
> in
>
>>
>
>>> it and replace the older one and run. I tested with JRE 1.6.0_06. It
>
>> is
>
>>
>
>>> working fine.
>
>>
>
>>>
>
>>
>
>>> If you still face any problem send me your configFile.txt as
>
>> attachment.
>
>>
>
>>>
>
>>
>
>>> Will appreciate if you can provide some feedback.
>
>>
>
>>>
>
>>
>
>>> Regards,
>
>>
>
>>> Vivek
>
>>
>
>>>
>>>> From: support@arrah.in [mailto:support@arrah.in]
>
>>
>
>>>> Sent: Wednesday, June 04, 2008 12:03 PM
>
>>
>
>>>> To: Larry Uzzel
>
>>
>
>>>> Subject: Re: Data Profiler Error
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>> Hi larry,
>
>>
>
>>>>
>
>>
>
>>>> Thanks for downloading data profiler.
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>> 1.) sun.jdbc.odbc.JdbcOdbcDriver should be in rt.jar
>
>>
>
>>>>
>
>>
>
>>>> 2.) You go your java/jre lib and look for rt.jar then type
>
>>
>
>>>>
>
>>
>
>>>> > jar -tvf rt.jar
>
>>
>
>>>>
>
>>
>
>>>> you should be able to see sun.jdbc.odbc.JdbcOdbcDriver
>
>>
>
>>>>
>
>>
>
>>>> 3.) if it is there try to put this classpath ( not needed for
Window
[Hide Quoted Text]
>
>>
>
>>>> XP)
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>> I have not tested with vista. But below is a link which faces same
>
>>
>
>>>>
>
>>
>
>>>> problems as your
>
>>
>
>>>>
>
>>
>
>>>> http://forum.java.sun.com/thread.jspa?threadID=5297405&tstart=105
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>> I hope solves your problem. If nor please send me screen shot of
So I downloaded, installed and changed the command to the following.
Same error.
Any ideas?
java -classpath "C:\Program
Files\Java\jdk1.6.0_06\jre\lib\rt.jar;saxon.jar;.;jeval.jar;lucene-core-
2.2.0.jar;jxl.jar" Profiler
Larry Uzzel
Developer
IT Applications
-----Original Message-----
From: support@arrah.in [mailto:support@arrah.in]
Sent: Wednesday, June 04, 2008 1:31 PM
To: Larry Uzzel
Subject: RE: Data Profiler Error
Hi larry,
To me it seems like you have trimmed version of JRE. You can download
full version of JRE at
http://java.sun.com/javase/downloads/index.jsp
it will come with all the jar files. then you have to change your path
to include new JRE before old JRE.
let me know if it works.
Reagrds,
Vivek
[Hide Quoted Text]
> Thanks for the reply.
>
> That file is not there.
> The only jar file I see is javaws.jar.
>
> Any ideas where I can get rt.jar? I find a lot of references on the
> internet to it, but it isn't clear how to get it and install it.
>
>
>
>
> Larry Uzzel
> Developer
> IT Applications
>
>
> -----Original Message-----
> From: support@arrah.in [mailto:support@arrah.in]
> Sent: Wednesday, June 04, 2008 12:03 PM
> To: Larry Uzzel
> Subject: Re: Data Profiler Error
>
> Hi larry,
> Thanks for downloading data profiler.
>
> 1.) sun.jdbc.odbc.JdbcOdbcDriver should be in rt.jar
> 2.) You go your java/jre lib and look for rt.jar then type
> > jar -tvf rt.jar
> you should be able to see sun.jdbc.odbc.JdbcOdbcDriver
> 3.) if it is there try to put this classpath ( not needed for Window
XP)
[Hide Quoted Text]
>
> I have not tested with vista. But below is a link which faces same
> problems as your
> http://forum.java.sun.com/thread.jspa?threadID=5297405&tstart=105
>
> I hope solves your problem. If nor please send me screen shot of the
> error message and stack flow.
>
> Thanks,
> Vivek
>
>
>> I get a "Driver Value Not Found" error when trying to launch Profiler
>> from vista.
>>
>>
>>
>> java -classpath "saxon.jar;.;jeval.jar;lucene-core-2.2.0.jar;jxl.jar"
>> Profiler
>>
>>
>>
>>
>>
>> Here's the sql server configuration, which agrees with a DSN
>>
>>
>>
>>
>>
>> Database_Type="SQL_SERVER"
>>
>> Database_Driver="sun.jdbc.odbc.JdbcOdbcDriver"
>>
>> Database_Protocol="jdbc:odbc"
>>
>> Database_DSN="DEV16SQL"
>>
>> Database_User="ReportUser"
>>
>> Database_Passwd="******"
>>
>> Database_Catalog=""
>>
>> Database_SchemaPattern=""
>>
>> Database_TablePattern=""
>>
>> Database_ColumnPattern=""
>>
>> Database_TableType="TABLE"
>>
>>
>>
>> Any ideas?
>>
>>
>>
>> Here's the java version
>>
>>
>>
>>
>>
>>
>>
>> I don't know where the sun drivers would be, how to check for them.
>>
>> Thanks!
>>
>>
>>
>>
>> Larry Uzzel
>> Developer
>> IT Applications
Ok I'm up and running.
Do you have a link to pricing info for > 60 days?
Larry Uzzel
Developer
IT Applications
-----Original Message-----
From: support@arrah.in [mailto:support@arrah.in]
Sent: Friday, June 06, 2008 1:05 PM
To: Larry Uzzel
Subject: RE: Data Profiler Error
This error it gets because it is attaching catalog name in front of
table name.
There are two ways to do it :
1.) While you are creating a DSN you might have chosen SQL Server but
might have chosen DB as DataWarehouse
2.) in configFile.txt you can add "DataWarehouse" in Database_Catalog
field.
You still can go to Tools-->SQL Inteface and type "select * from Time"
see if works ot you have to type select * from DataWarehouse.Time
let me know if it works.
Reagrds,
Vivek
[Hide Quoted Text]
> Progress. I redid the data source so it sort of works, but now get
> this.
>
> Larry Uzzel
>
> Developer
>
> IT Applications
>
>
>
>
>
> -----Original Message-----
> From: support@arrah.in [mailto:support@arrah.in]
> Sent: Friday, June 06, 2008 11:54 AM
> To: Larry Uzzel
> Subject: RE: Data Profiler Error
>
>
>
> I hope you got my last mail about how to creare system DSN. If not go
to
[Hide Quoted Text]
>
> Control Panel --> admintrative tools --> data source create a DSN for
>
> SQL server. have the same name in configFile.txt
>
>
>
> Let me know if it works.
>
> Regards,
>
> Vivek
>
>
>> No. Did you get my screenshot?
>> The config file I sent was the one you sent me with the DSN name etc.
>
>> filled out. Here it is again
>
>> Here's my launch command:
>
>>
>
>> C:\"Program Files"\Java\jdk1.6.0_06\jre\bin\java -classpath
> "C:\Program
>
>>
>
Files\Java\jdk1.6.0_06\jre\lib\rt.jar;saxon.jar;.;jeval.jar;lucene-core-
[Hide Quoted Text]
>
>> 2.2.0.jar;jxl.jar" Profiler
>>
>
>> Is there a specific way other than sql server I need to configure my
>
>> DSN?
>
>>
>
>> Larry Uzzel
>
>>
>
>> Developer
>
>>
>
>> IT Applications
>
>>
>
>> -----Original Message-----
>
>> From: support@arrah.in [mailto:support@arrah.in]
>
>> Sent: Friday, June 06, 2008 9:10 AM
>
>> To: Larry Uzzel
>
>> Subject: RE: Data Profiler Error
>
>>
>
>>
>
>>
>
>> is it working now or not ?
>
>>
>
>> Regards,
>
>>
>
>> Vivek
>
>>
>
>>> Thanks for sceen shot. The problem does not seems to be classpath.
It
[Hide Quoted Text]
>
>> is
>
>>
>
>>> not reaching there yet :) The problem seems to in parsing the file
>
>>
>
>>> configFile.txt
>
>>
>
>>> Seems like you have forgetten to remove the hashout /* */ around
>
>>
>
>>> the SQLServer block.
>
>>
>
>>> I have atatched a configFile.txt Just put your SQL server parameter
> in
>
>>
>
>>> it and replace the older one and run. I tested with JRE 1.6.0_06. It
>
>> is
>
>>
>
>>> working fine.
>
>>
>
>>>
>
>>
>
>>> If you still face any problem send me your configFile.txt as
>
>> attachment.
>
>>
>
>>>
>
>>
>
>>> Will appreciate if you can provide some feedback.
>
>>
>
>>>
>
>>
>
>>> Regards,
>
>>
>
>>> Vivek
>
>>
>
>>>
>>>> From: support@arrah.in [mailto:support@arrah.in]
>
>>
>
>>>> Sent: Wednesday, June 04, 2008 12:03 PM
>
>>
>
>>>> To: Larry Uzzel
>
>>
>
>>>> Subject: Re: Data Profiler Error
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>> Hi larry,
>
>>
>
>>>>
>
>>
>
>>>> Thanks for downloading data profiler.
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>> 1.) sun.jdbc.odbc.JdbcOdbcDriver should be in rt.jar
>
>>
>
>>>>
>
>>
>
>>>> 2.) You go your java/jre lib and look for rt.jar then type
>
>>
>
>>>>
>
>>
>
>>>> > jar -tvf rt.jar
>
>>
>
>>>>
>
>>
>
>>>> you should be able to see sun.jdbc.odbc.JdbcOdbcDriver
>
>>
>
>>>>
>
>>
>
>>>> 3.) if it is there try to put this classpath ( not needed for
Window
[Hide Quoted Text]
>
>>
>
>>>> XP)
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>> I have not tested with vista. But below is a link which faces same
>
>>
>
>>>>
>
>>
>
>>>> problems as your
>
>>
>
>>>>
>
>>
>
>>>> http://forum.java.sun.com/thread.jspa?threadID=5297405&tstart=105
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>> I hope solves your problem. If nor please send me screen shot of
the
[Hide Quoted Text]
>
>>
>
>>>>
>
>>
>
>>>> error message and stack flow.
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>>
>
>>
>
>>>> Thanks,
>
>>
>
>>>>
>
>>
>
>>>> Vivek
>
>>
>