BDE admin connecting problem, How do I connect via IP address.

Hot Topic

Permissions in SQLExpress
LOcking data in partitions
Parallel activations with GET CONV GROUP
Error with Subscription
Not in correct state to become principal
Retain Analysis Services Formatting When retrieving data via MDX to Reporting Services
error trying to import packages to the MSDB
Passport sign out from this forum
error message saying I do not meet minimum hardware requirements
How to deploy Semantic Models manually?

SQL Server

2000 - Add New Report wizard blows up
SSIS and COM
Retrieving a piece of datalogged equipment by most recent time
How to check two datetime values intercepted
RelativeTime
Error opening VSA from Script component and Script Task
IF statement Errors in huge SQL Query
What Data Mining tasks can be automated and scheduled via Integration Services Packages?
SQLExpress ASP3.0 Permissions and Connectivity
conversation groups and processing in order on the target end

BDE admin connecting problem, How do I connect via IP address.

Hi, I am connecting from clientside with sql server 2005 installed trying to connect to a database running on a server with sql server 2000 installed. this is not a 2000 to 2005 compatibility issue.
I can connect locally fine to the server and log in using the sa account, however for BDE admin i HAVE to use the server name instead of ip address. If i try to use the ip address of the server, the connection dosnt get established. *this is all happening localy on our own network.

How to I use ip address to connect instead of the server name I will need to connect remotely outside of our network later on, and i dont think I can use the servername. Does anyone have a solution thanks.





Answer this question

BDE admin connecting problem, How do I connect via IP address.

  • crazychemist

    thanks for the input, we figured out the problem though, it seems the server uses a proprietary listening port, say.. "3314" set up for their server. we were able to connect after setting up an alias for sql server.


  • jd.conley

    BDE = borland database engine


  • FMorse

    I have more questions

    1) does SQL server 2005 come with a client only tool
    2) is there a way to connect via an alias with an application without installing sql server 2005


    thanks in advance!



  • Julie Clark

    I suggest creating an ODBC DSN and using that from BDE rather than the SQLLINK driver

  • TP Diffenbach

    1/ Yes its called SQL Server Management Studio (or Express Edition of SSMS) for management and there are dev tools, config tools etc

    2/ you need to install SQL Server Computer Manager to config alias's



  • BDE admin connecting problem, How do I connect via IP address.
Answer this question