problem with database connectivity - Microsoft SQL Server

harish

I am using java applications to connect to my MS SQL Server database.
I am using ODBC for database connectivity.
If i am running my java applications in a remote PC and try to connect
to database server, unless i login to the
serer, i am unable to connect to database.
If a login to database server with it's username and password, then
the database is getting connected.

It is not correct to login to database server for database
connectivity.
what is the solution for this?

Jul 20 '05 #1

Subscribe Reply

2442

Simon Hayes

ha*******@yahoo .com (harish) wrote in message news:<ff******* *************** ****@posting.go ogle.com>...

I am using java applications to connect to my MS SQL Server database.
I am using ODBC for database connectivity.
If i am running my java applications in a remote PC and try to connect
to database server, unless i login to the
serer, i am unable to connect to database.
If a login to database server with it's username and password, then
the database is getting connected.

It is not correct to login to database server for database
connectivity.
what is the solution for this?

I'm not sure that I understand your question - do you mean that you
can only connect to MSSQL with Windows authentication, but you want to
use a SQL login? Or that you have to connect to Windows (eg. connect
to a file share) before you can connect to MSSQL?

Whatever the issue, it would be helpful if you could provide some
extra information - what version of MSSQL, what operating system on
the server and client, what authentication mode (Windows only or
Windows + SQL), how you want to connect (Windows account or SQL
login), what error you see when you try to connect etc.

Simon

Jul 20 '05 #2

Similar topics

4132

Problem Installing SQL 7 or SQL SERVER 2000 on Laptop

by: AlessanBar | last post by:

Hello Friends !! I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following configuration: Pentium III Brand : Toshiba Speed : 500 Mhz RAM : 192 MB Hard Disk : 6 GB

Microsoft SQL Server

2106

database connectivity through C program

by: junaid | last post by:

Hi to all, Can it is possible to connect to the databse like postgre or mysql through a C programm? I know the basics of C and I have developed a small program which uses a file for the repositary of the data.But I want to use a database for this, insted of file. If possible please give some Code snippets for the connectivity as well as how to run the queries.

C / C++

3492

Database Connectivity using DSN

by: Niks | last post by:

Hi, I need to connect to SQL server Database using a System DSN. Can anyone tell me how to connect to SQL Server using DSN in ASP.NET (VB.Net). Using a Try Catch block. Does anyone know how to create a "filename.DSN" file. I know how to create a system DSN, but my N/W admin has asked me to create a DSN file to send him. which would be a file name with ".DSN" extension, so that he can place it on the server.

ASP.NET

1132

Database Connectivity Problem ...

by: C Newby | last post by:

I have two applications, one a windows form app, and one an ASP.NET app that are both trying to connect to the same SQL Server database. I have a connection string similiar to: Data Source=MySQLServer;User ID=SomeUser;Password=SomePassword;Initial Catalog=SomeDBName So i'm using sql server authentication and not integrated security. When running my windows form app, the db connection is made just fine. However,

ASP.NET

2474

Database Connectivity

by: Ivan Weiss | last post by:

Hi all, I am just getting started on a new app and am a rusty VB6 guy who is looking to create something on the side to serve as a corporate workbench for my company. ADO.net is new to me so I have some books and need to do some learning but I am seeing a few different ways to get started. Would you recommend going with the controls built into Visual Studio,

Visual Basic .NET

4329

ExecuteNonQuery - problem

by: b_r | last post by:

Hi, I'm trying to make a simple operation (insert into DB) in VB 2005 and SQL Server. The code is as follows: Dim sConnectionString As String = _ "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DB.mdf....

Visual Basic .NET

1246

Should I write database connectivity code each time ?

by: dalaimanoj | last post by:

I have a form with buttons 'View', 'Save', 'Delete', 'Edit' and some textboxes to input data.. On clicking each buttons the database is connected and the respective action is done. For example clicking on Save button inserts records, clicking on Delete button delete the specified record and clicking on View button the record from database table is fetched etc. So my question is 1. Should I write the database connectivity code and the...

.NET Framework

3254

MS Access database connectivity problem

by: praveenb000 | last post by:

we hosted a website http://vijayawadanalanda.org developed using asp.net and back end MS Accees database. There is some database connectivity problem occurring when saving the information in page url : http://vijayawadanalanda.org/feedback.aspx getting error: Not a valid file name. Please provide me solution to rectify this problem.

ASP.NET

4543

SQL1336N and DB2 CONNECTIVITY PROBLEM. What am I doing wrong?

by: okonita | last post by:

Hi all, I am having a DB2 connectivity problem that I hope someone can help me resolve. I need this to test Replication and such other things. What am I doing wrong here? Any help that I can get will be highly appreciated. First, the error that I am getting when I try to connect to the remote host after performing NODE and database catalog is the following: SQL1336N The remote host "WINSVR2008R2-2" was not found. SQLSTATE=08001. I...

DB2 Database

9480

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10153

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10093

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9952

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7500

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5511

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4053

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3654

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2880

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General