search

gflewis / sndml3

ServiceNow Data Mart Loader: an application to load SQL databases from ServiceNow
MIT License
30 stars 19 forks source link

Connecting to SQL Server #19

Closed ChuckHowie1 closed 4 years ago

ChuckHowie1 commented 4 years ago

Getting error: Exception in thread "main" servicenow.datamart.ResourceException: java.sql.SQLException: No suitable driver found for jdbc:mssql://servername.com/SNOW

running this from command line: C:\sndml3-master\sndml-3.1.2-bin\sndml-3.1.2>java -jar sndml-3.1.2-mssql.jar -p Profile.txt -t cmn_location

Profile is: servicenow.instance=https://company.service-now.com servicenow.username=snowacct servicenow.password=snowpwd datamart.url=jdbc:mssql://10.10.10.10;SNOW datamart.username=SNOW_Admin datamart.password=helloWorld Any help much appreciated... I have tried changing the sql server to the fqdn, as well as including the port..ie jdbc:mssql://servername.com:1433/SNOW and get the same error...i've tried semicolon then dbname ie 1433;SNOW ...same error

gflewis commented 4 years ago

For datamart.url, try jdbc:sqlserver://

Here is a reference: https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver15