Solved

How to connect with  local SQl database to ISP SQL database

Posted on 2004-05-03
3
232 Views
Last Modified: 2012-05-04
HI there

How to connect with  local SQl database to ISP SQL database?

thanks in advance
0
Comment
Question by:chetanpatel
  • 2
3 Comments
 
LVL 4

Accepted Solution

by:
astankovic earned 200 total points
ID: 10977687
What do you mean by connecting? What exactly do you need to do?
You can use Enterprise Manager to connect to remote database and view/edit data and/or db objects, if that is what you need to do.
0
 
LVL 34

Expert Comment

by:arbert
ID: 10977876
You will need to change your connection string to whatever the ISP gives you.  Most likely it will be SQL Authentication and they will provide an IP address and username/password.
0
 
LVL 34

Expert Comment

by:arbert
ID: 10979165
chetanpatel, why did you post a new question in regards to this matter and not follow up on the above responses????
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now