New SQL Server 2005 JDBC 1.0 & Visual J++

We have a legacy Java application that we maintain in Visual J++; we are
moving to SQL Server 2005 and would like to switch it from an old WebLogic
JDBC driver to the new Microsoft SQL Server 2005 JDBC Driver.
However, we're noticing strange behavior with regard to instantiating the
"com.microsoft.sqlserver.jdbc.SQLServerDriver" class (no class def found
errors even though the sqljdbc.jar file is specified on the correct path in
the Classpath environment variable, and using FileMon we can see the app
finding the file).
I assume this means that we're running under the old, and unsupported,
Microsoft Java VM. Is it possible this VM does not support the new JDBC
driver?
Steven Bras
Tessitura Network, Inc.Hi Steven,
Thank you for posting.
Regarding on the SQL Server 2005 JDBC driver, it is built against the SUN
J2se sdk 1.4 while the Microsoft's VJ++ jvm has already stoped updating, so
it dosn't support new built Java components. I suggest you tried testing
the JDBC driver through standard SUN J2SE SDK to see whether it works. For
VJ++ we may consider using the OLEDB COM interface to access the SQL Server.
Regards,
Steven Cheng
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Thanks for your response; can you point me to samples of how to use ole db i
n
java?
--
Steven Bras
Tessitura Network, Inc.
"Steven Cheng[MSFT]" wrote:

> Hi Steven,
> Thank you for posting.
> Regarding on the SQL Server 2005 JDBC driver, it is built against the SUN
> J2se sdk 1.4 while the Microsoft's VJ++ jvm has already stoped updating, s
o
> it dosn't support new built Java components. I suggest you tried testing
> the JDBC driver through standard SUN J2SE SDK to see whether it works. For
> VJ++ we may consider using the OLEDB COM interface to access the SQL Serve
r.
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
>
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
>|||Thanks for your response Steven,
I'm not quite sure about a complete example on connecting database through
OLEDB provider in VJ++, I think it'll be better to post in some VJ++ or
data accessing specific newsgroup. Also, have you any plan on migrating the
program to pure .net framework so that we have more choice on data
accessing to SQL Server?
Regards,
Steven Cheng
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)