Data source name

Hi

I want to ask thae while connecting with SQL server do we need the "Data Source Name" or just the "Database Name" in our java code. Actually I made the connectivity using ms access but now I want to connect with the Sql Server

Can anybody explain me the required changes.

if someone explain it i will be greatfull to one

[349 byte] By [Pradeep_Ranaa] at [2007-11-27 6:41:02]
# 1

set a data source name and use it for connection.

client server connection can work with latest version of SQL server but it requires jdbc api.

> Hi

>

>

>

> I want to ask thae while connecting with SQL server

> do we need the "Data Source Name" or just the

> "Database Name" in our java code. Actually I made the

> connectivity using ms access but now I want to

> connect with the Sql Server

>

> an anybody explain me the required changes.

>

> if someone explain it i will be greatfull to one

ochomoonyangoa at 2007-7-12 18:10:29 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
I downloade the sql server driver and installed also, I set the class path of the jar file alsoBut now I am getting the message as java.sql.SQLException: login failed for user '<null>' REason: NOt associated with a trusted SQL Server connection.
Pradeep_Ranaa at 2007-7-12 18:10:29 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3
Use mixed mode authentication. http://support.microsoft.com/kb/889615
dvohra09a at 2007-7-12 18:10:29 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...