Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved PowerServer Sql Connection

  1. How-to
0
Votes
Undo
  1. billy hugon
    billy hugon
  2. PowerBuilder
  3. Wednesday, 13 December 2023 13:58 PM UTC

I got the SqlServer connection working in the database configuration and can compile run the application in client server.  But when I configure the PowerServer project (database), I'm not able to connect.  Below is my Database connection.  Below that is what I have for the PowerServer connection.  This database is running on my laptop.  It fails when I click the dropdown for the Connect to Database.

 

Here is the error for the below connection.

 

Here is my PowerServer project database information

Save As Excel formatting issues
SMTPClient.Send keeps returning an error
Accepted Answer
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 13 December 2023 14:52 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Billy,

 

Try using an IP instead of (LocalDb).

127.0.0.1 is a reserved IP that refers to your own machine, so you should use that and try again. If that still doesn't work, I suggest assigning a static port to the MSSQLLocalDB instance, and configure the PowerServer project with that IP:port instead of Instance Name

Regards,
Francisco

Comment
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.