Skip to main content
Solved

PSO 6.9 Installation on SQL Server (HTM Bulk Copy)

  • Oct 10, 2022 11:53 AM UTC
  • 4 replies
  • 140 views

Forum|alt.badge.img+5

Unable to get the HTM Bulk copy to work

 

Command Prompt

cd /d C:\IFS_PSO\Software\PSOHTM\GB_6597007783\scripts\SQL

”Hierarchical Travel Matrix Bulk Copy.bat” Hierarchical Travel Matrix dse1vmpe413 IFSPSO IFS0racl3

 

Receive the following error:-

SQLState = 08001, NativeError = 53
Error = [Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
SQLState = S1T00, NativeError = 0
Error = [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired
bulk copied data into Routing_Edge
bulk copying data into Routing_Network
SQLState = 08001, NativeError = 53
Error = [Microsoft][ODBC Driver 17 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53]. 

 

Best answer by mealuk

Hi

 

I have reverted back to using the installer tool which is easier to use.

 

Thought the scripts might be faster but looks like more work.

View original

4 replies

roklde
Superhero (Employee)
Forum|alt.badge.img+27
  • Superhero (Employee)
  • Oct 10, 2022 12:20 PM UTC

Hi Melanie,

it looks like a connection issue. From where are you trying to access the DB host dse1vmpe413? From your local machine or are you actually on this server? If you trying to connect from your local machine than you need to allow communication with the database through Port 1433. You can do this by running SQL Configuration Manager.

Note that you can also use the PSO Installer to install the HTM.


Best regards
Roman


Forum|alt.badge.img+5
  • Author
  • Do Gooder (Employee)
  • Oct 10, 2022 12:26 PM UTC

Hi

 

I am running this on the server running the SQL database. I will take a look at the installer tool will it handle the data import as well.


Forum|alt.badge.img+5
  • Author
  • Do Gooder (Employee)
  • Answer
  • Oct 10, 2022 12:40 PM UTC

Hi

 

I have reverted back to using the installer tool which is easier to use.

 

Thought the scripts might be faster but looks like more work.


roklde
Superhero (Employee)
Forum|alt.badge.img+27
  • Superhero (Employee)
  • Oct 10, 2022 1:29 PM UTC

By looking at the syntax, I think you should’ve put the database name in quotes as it includes blanks. 

However, if it runs now via the Installer that’s fine as well.