In my connection string when using Data Source=ServerName I can get a
connection to SQL Server.
However, I can't connect using (local),(localhost),local or localhost.
Is there any reason why this would work for SQL Server 2000 and not for

I'm trying to write a method that will tell me what version, 8 or 9, I'm
running on.  When I connect to 2000, I use the old driver.  When I connect to
2005, I use the new driver.  I first used the
DatabaseMetaData.getDatabaseMajorVersion() method, but it is not supported in

I am want to use the 2005 driver to connect to a SQL Server 2000 database.    
Currenlty, I can not connect to my 2000 database with the sqljdbc.jar.     I
am using the new driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
I keep getting the message "No suitable driver" ...

Is it possible to register remote SQL Server 2005 in SQL Server 2000
Enterprise Manager?
Thank you
Al

I am facing following issue with SQL server 2000. If, while creating DB, I
choose collation as Chinese_PRC_BIN, SQL server becomes case sensitive.
e.g. if Table name is  "MYTABLE", following query fails
select * from mytable

Is it possible to restrict access to SQLServer only to selected applications
(the ones I develop)?. This is why I'm asking:
Suppose user "Mary" has access to certain tables for SELECT, UPDATE, INSERT,
DELETE, etc. I want Mary to delete records on tables only in certain

Does SQLServer 2005 Native client support windows 98?
Thanks

Is MARS supported through JDBC?  Is the connection the same?  Is this
documented anywhere?

I had a beta version of visual studio 2005, including SQL Server 2005, on my
PC. i have uninstalled these and now installed VB an d C# express but when I
try to install SQL xprs 2005 it tells me I have some beta stuff left.  
anybody know what I should be deleting?

Can this code be changed to use the windows Authentication instead of the
SQL Server login?
http://www.mvps.org/access/tables/tbl0014.htm

I have VS2005, SQL 2000, SQL Express and SQL 2005 installed on my laptop with
XP Pro.  I have no problems connecting to SQL 2000 but get the following
error when I try to connect to SQL2005.
"When connecting to SQL Server 2005, this

In my database I created a SQL Server user - malphaTest
In my WebConfig.xml
<add key="SQLConn"
value="Data Source=HIDSCFILE002;Initial Catalog=Membership;User

I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?

I've been trying to add a simple record to SQL Server 2000 and it is not
recognizing the insert statement. The SQL profiler is picking up the command
from the application, but it is not updating the table with the new record.
If there are any suggestions, it would be appreciated.

Does the today release new JDBC Driver support SSL encryption ?