473,549 Members | 2,746 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

problem with database connectivity

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
1 2426
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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
4103
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
3
2091
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...
3
3466
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...
0
1123
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....
47
2427
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...
22
4300
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....
0
1236
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...
6
3243
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.
0
4526
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...
0
7524
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7451
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...
0
7720
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7475
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...
0
7812
tracyyun
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...
0
5089
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3501
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1061
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
766
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.