ClassNotFound

Dear all
I'm new on Java. Now I got a error in my program is
java.lang.ClassNotFoundException and the class is :
com.microsoft.jdbc.sqlserver.SQLServerDriver .
My classpath already contain that 3 JAR files
(msbase.jar,msutil.jar,mssqlserver.jar) and my servlet already included the
javax.sql.* and javax.naming.*. So now I don't know what i'm missing now.
anyone here can help me to solve this problem ? please give me some idea...
Thanks a lot !!
Ivan
This is definetly a classpath issue. Esle Open all jar and see if you can find the class you are looking for
|||Thx Neo,
I have found the problem now, the classpath I have been setting up before.
Actually the problem was I need to copy those JDBC JAR files to lib\
directory then it will be fine.
"neo" <anonymous@.discussions.microsoft.com> bl
news:538F8F46-32AA-4F42-A4EA-FC83131F384E@.microsoft.com g...
> This is definetly a classpath issue. Esle Open all jar and see if you can
find the class you are looking for

Choose MSDE install location?

I'm trying to install MSDE at c:\Program Files\Microsoft\SQL Server\ (as
opposed to ...\Microsoft SQL Server\).
I tried using the DATADIR= and TARGETDIR= options, but they don't seem to
affect the COM and Tools folders (which always get installed at
...\Microsoft SQL Server\80\). I don't see any other options to set the
location for those two folders.
Am i missing something, or am i stuck with keeping the COM and Tools
directories where they are?
/
hi,
I HATE PDAs wrote:
> I'm trying to install MSDE at c:\Program Files\Microsoft\SQL Server\ (as
> opposed to ...\Microsoft SQL Server\).
> I tried using the DATADIR= and TARGETDIR= options, but they don't
> seem to affect the COM and Tools folders (which always get installed
> at ...\Microsoft SQL Server\80\). I don't see any other options to
> set the location for those two folders.
> Am i missing something, or am i stuck with keeping the COM and Tools
> directories where they are?
you do not have control over a "little" part of the installations... this
with regard to all binaries that will be shared among all available SQL
Server / MSDE 2000 instances... these shared binaries will always be
installed there, and present at the higher service pack level..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Chinese chars in SQL?

We have a need to enter and store Chinese characters in a SQL Server table.
Has anyone done this before?
We're using ASP .NET to program entry forms, so they'd have to accept
Chinese chars, the data would be stored in SQL Server, and then search
results would have to display Chinese as well.
What additional technology might we need to implement this?
Thanks!!As far as I know you may use datatype as NVarchar / Nchar.
Even if the datatype the column is Varchar / Char it should still be able to save it, provided you take care of it in UI i.e. ASP page using code-page setting.|||You would need to store data as Unicode (i.e. nvarchar) and select the
approriate Chinese collation for your data. You need to also make sure that
your application is ready to process Chinese (or other) data:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxorilocalizationplanning.asp
--
Michiel Wories, SQL Server PM
This posting is provided "AS IS" with no warranties, and confers no rights.
--
"Dean J. Garrett" <deanj_garrett@.yahoo.com> wrote in message
news:Ojae0LPmDHA.372@.TK2MSFTNGP11.phx.gbl...
> We have a need to enter and store Chinese characters in a SQL Server
table.
> Has anyone done this before?
> We're using ASP .NET to program entry forms, so they'd have to accept
> Chinese chars, the data would be stored in SQL Server, and then search
> results would have to display Chinese as well.
> What additional technology might we need to implement this?
> Thanks!!
>
>|||Thank you! I'll follow your advice.
"Michiel Wories [MS]" <mwories@.online.microsoft.com> wrote in message
news:3f97f365$1@.news.microsoft.com...
> You would need to store data as Unicode (i.e. nvarchar) and select the
> approriate Chinese collation for your data. You need to also make sure
that
> your application is ready to process Chinese (or other) data:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html
/vxorilocalizationplanning.asp
> --
> Michiel Wories, SQL Server PM
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> --
> "Dean J. Garrett" <deanj_garrett@.yahoo.com> wrote in message
> news:Ojae0LPmDHA.372@.TK2MSFTNGP11.phx.gbl...
> > We have a need to enter and store Chinese characters in a SQL Server
> table.
> > Has anyone done this before?
> >
> > We're using ASP .NET to program entry forms, so they'd have to accept
> > Chinese chars, the data would be stored in SQL Server, and then search
> > results would have to display Chinese as well.
> >
> > What additional technology might we need to implement this?
> >
> > Thanks!!
> >
> >
> >
>

Checking which tables were modified by a program?

Is it possible to know what tables were modified when running an application
?
I'm working on a program that has several different components, but I'm only
testing one. I would like to see what tables were affected by this one
component (either by updating or inserting data to a table or several tables
).
Thanks.You can use SQL Server Profiler to show all the commands sent to the
database. I would filter the commands at least down to a specific user if
you are running profiler on a multi user system.
"VMI" wrote:

> Is it possible to know what tables were modified when running an applicati
on?
> I'm working on a program that has several different components, but I'm on
ly
> testing one. I would like to see what tables were affected by this one
> component (either by updating or inserting data to a table or several tabl
es).
> Thanks.|||You can also filter by applicationname in profiler. Its part of the selecte4
d
data in the default trace template.
--
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/
"VMI" wrote:

> Is it possible to know what tables were modified when running an applicati
on?
> I'm working on a program that has several different components, but I'm on
ly
> testing one. I would like to see what tables were affected by this one
> component (either by updating or inserting data to a table or several tabl
es).
> Thanks.

checking the existance of fields and types

I'm trying to write a program in cold fusion to check the existance of
fields and data types according to requirements

I was looking at the syscolumns table for some of this information but
I've discovered that in my playing (creating and deleting tables) thre
are multiple entries for a field that is in table that is created then
deleted then created again.

Is this a problem? Is there a better way to get at the information ie
the table, field, and type exist in a database?Use the INFORMATION_SCHEMA views. See Books Online for details.

Most metadata can be retrieved more easily from the info schema than
from system tables. There are some exceptions but system tables are
best left alone unless you really have to use them. They will be
supported only for backwards compatibility and won't reflect new
features in future versions.

--
David Portas
SQL Server MVP
--|||William Kossack (kossackw@.njc.org) writes:
> I'm trying to write a program in cold fusion to check the existance of
> fields and data types according to requirements
> I was looking at the syscolumns table for some of this information but
> I've discovered that in my playing (creating and deleting tables) thre
> are multiple entries for a field that is in table that is created then
> deleted then created again.

This sounds very strange. My guess is that you are joining syscolumns
with systypes incorrectly. (Those two tables are indeed a bit tricky
to match up.) Care to post a query that gives funny result?

> Is this a problem? Is there a better way to get at the information ie
> the table, field, and type exist in a database?

Some people tout the INFORMATION_SCHEMA views, but since they only
give a subset of the metadata information, they're pretty useless in
my opinion. They are mainly interesting if you want to write portable
meta-data queries.

There are also functions like object_id, columnproperty which can be
useful at times, but they have the drawback that they are restricted
to the current database.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

check version of sql 2005

how do i check whether i have installed 64 bit /32 bit sql server 2005... if i see Program files and Program files (x86) directory can i be sure...

one more query..Is windows 2003 enterprise edition 64 bit Itanium based operating systems

Thanks in advance

Is this really a SSIS question or the SQL engine?

The standard SELECT/PRINT @.@.VERSION command works here for the SQL engine, just look in the output for x64 vs x86, or Itanium I presume, but cannot confirm, e.g.

Microsoft SQL Server 2005 - 9.00.2153.00 (X64)
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)
on Windows NT 5.2 (Build 3790: Service Pack 1)

The presence of the Program Files (x86) directory means you are running on a 64-bit OS with WOW support. The 64-bit applications are installed in the alternative Program Files, so the presence of SQL in there would indicate you have a 64-bit install of SQL as well.

Windows 2003 Enterprise Edition comes in Itanium, x64 and x86 flavours.

|||

Is there a mapping table available between @.@.version string and the SQL Server 2005?

For example,

SQL Server 2005 RTM x86 (32-bit) Enterprise Edition --> @.@.version=?

SQL Server 2005 RTM x64 (32-bit) Enterprise Edition --> @.@.version =?

SQL Server 2005 RTM IA64 (64-bit) Enterprise Edition -->@.@.version=?

SQL Server 2005 with SP1 (32-bit) --> @.@.version=?

etc, etc.

I am particularly interested in the build number of SP1 vs. RTM so that I can build a process to check if SP1 has been deployed successfully or not.

Thanks

Sean

|||The "current" release with all the hot fixes is 9.00.2153. If you version is other, you need updates.

See: http://support.microsoft.com/kb/321185|||

SQL Server Version Database
(http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx)

The versions will also be included in any KB that accompanies a service pack or hotfix, for the latter at a file level as well, since not all fixes change the @.@.version result.

The edition is not considered part of the version (build number), but is included in the @.@.version result.

For SSIS, there are some more notes here, as off course you may have patched SSIS independently of the engine, or may not even have the engine installed-

Service Pack Versions
(http://wiki.sqlis.com/default.aspx/SQLISWiki/ServicePackVersions.html)

Check sql table input at certian times and send email

I have a .net web application and need to create a program that needs to check the database every two hours and if data has not been input send the user an email message. I have heard this can be done via SQL Server - events or triggers? Can anyone tell me where I can find example code or more information on this. Thank you in advance.

Hi,

Yes since your whole work is within the database then I think setting up a "SQL job" will be the best possible solution also you can schedule it to run on certain times. Basically you need to create a "stored procedure" which will check the table and will be sending mail and you can call this stored procedure from your job. Mails can be sent by using "SQL Mail" or using .NET framework (if you are using Sql Server 2005).

I have marked the importent terms in the mail. You can get best materials on them in Books Online in Sql Server.

Hope it helps!

Bhaskar!

|||

In a well trafficed website, I usually drop that in the login.aspx page, or if I have enabled cookies, then another often hit page.

You can also do this using sql agent. Write the stored procedure to scan the table, and generate the emails. Then tell sql agent to execute that stored procedure every two hours.

Check Server Disk Space Daily

I know can execute perfmon program to determine disk space on the server.
I would like a simple SQL Server job (SQL Server 2000) I can set up to run
once a day. Check all drives on the server if unused disk space is less than
10% then send alert message.
Please help me with this task.
See if this helps.
Using xp_fixeddrives to Monitor Free Space
http://www.databasejournal.com/features/mssql/article.php/3080501
AMB
"Joe K." wrote:

> I know can execute perfmon program to determine disk space on the server.
> I would like a simple SQL Server job (SQL Server 2000) I can set up to run
> once a day. Check all drives on the server if unused disk space is less than
> 10% then send alert message.
> Please help me with this task.
|||Grab sp_diskspace from here http://www.sqldbatips.com/showcode.asp?ID=4 and
simply insert results into a table and run your check against it.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:1C11A458-4317-40F0-A4E5-0C07520C88D5@.microsoft.com...
> I know can execute perfmon program to determine disk space on the server.
> I would like a simple SQL Server job (SQL Server 2000) I can set up to run
> once a day. Check all drives on the server if unused disk space is less
> than
> 10% then send alert message.
> Please help me with this task.

Check Server Disk Space Daily

I know can execute perfmon program to determine disk space on the server.
I would like a simple SQL Server job (SQL Server 2000) I can set up to run
once a day. Check all drives on the server if unused disk space is less than
10% then send alert message.
Please help me with this task.Grab sp_diskspace from here http://www.sqldbatips.com/showcode.asp?ID=4 and
simply insert results into a table and run your check against it.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:1C11A458-4317-40F0-A4E5-0C07520C88D5@.microsoft.com...
> I know can execute perfmon program to determine disk space on the server.
> I would like a simple SQL Server job (SQL Server 2000) I can set up to run
> once a day. Check all drives on the server if unused disk space is less
> than
> 10% then send alert message.
> Please help me with this task.

Check Server Disk Space Daily

I know can execute perfmon program to determine disk space on the server.
I would like a simple SQL Server job (SQL Server 2000) I can set up to run
once a day. Check all drives on the server if unused disk space is less tha
n
10% then send alert message.
Please help me with this task.See if this helps.
Using xp_fixeddrives to Monitor Free Space
http://www.databasejournal.com/feat...cle.php/3080501
AMB
"Joe K." wrote:

> I know can execute perfmon program to determine disk space on the server.
> I would like a simple SQL Server job (SQL Server 2000) I can set up to run
> once a day. Check all drives on the server if unused disk space is less t
han
> 10% then send alert message.
> Please help me with this task.|||Grab sp_diskspace from here http://www.sqldbatips.com/showcode.asp?ID=4 and
simply insert results into a table and run your check against it.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:1C11A458-4317-40F0-A4E5-0C07520C88D5@.microsoft.com...
> I know can execute perfmon program to determine disk space on the server.
> I would like a simple SQL Server job (SQL Server 2000) I can set up to run
> once a day. Check all drives on the server if unused disk space is less
> than
> 10% then send alert message.
> Please help me with this task.