[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified

[pugazhendhiramakrishnan08121985]

Hi, I'm trying to benchmakr MSSQL running in Windows instance in the GCP platofmr from Hammer DB. When I try to build the schema I'm getting the below error:

Error in Virtual User 1: Connection to DRIVER=ODBC Driver 17 for SQL server; SERVER=x.x.x.x; UID=sqladmin; PWD=XXX could not be established : [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified.

When I checked the "librarycheck" command from the hammerdbcli it is showing success for the MS SQL but still I'm unable to build the schema. I even confirmed the port 1433 is opened between SQL server and the Hammer DB. Kindly do share your thoughts if you come across this issue.

[sm-shaw]

The error is shown here:

[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified.

Here is an example, We run librarycheck and the library is found

HammerDB CLI v4.4
Copyright (C) 2003-2022 Steve Shaw
Type "help" for a list of commands
The xml is well-formed, applying configuration
hammerdb>librarycheck
...
Checking database library for MSSQLServer
Success ... loaded library tdbc::odbc for MSSQLServer
...

We will also run the ODBC data sources tool and check what drivers we have:

Now lets try and use a driver that we don't have installed eg ODBC Driver 22 for SQL Server ...

We now get the same error that you get:

Error in Virtual User 1: Connection to DRIVER=ODBC Driver 22 for SQL Server;SERVER=(local)\SQLDEVELOP;TRUSTED_CONNECTION=YES could not be established : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
(connecting to database)

Verify you have the correct drivers installed that you want to use.

[pugazhendhiramakrishnan08121985]

Thanks for your prompt response, I understand there is a mis-match in the drivers but I'm not sure how to identify and to install the correct drivers. Can you please provide any knoeldge source to install the correct drivers. I tried setting us User SDN and System SDN as "ODBC driver"in the SQL server but that too didn't help.

[sm-shaw]

Use the ODBC Data Source Administrator, this is a driver configuration issue rather than a HammerDB one:

[pugazhendhiramakrishnan08121985]

In the MSSQL server I have already added the ODBC Driver for SQL 17 in both "System Data Source and User data source". Still same error.

[sm-shaw]

Note there is a 32-bit and 64-bit version of this tool, you need the 64-bit one.
To troubleshoot run the following in the CLI, it will list the ODBC drivers on your system. As above, this is a configuration issue, not a HammerDB one.

hammerdb>package require tdbc::odbc
1.1.1
hammerdb>tdbc::odbc::drivers
...
{ODBC Driver 11 for SQL Server} {UsageCount=1 APILevel=2 ConnectFunctions=YYY CPTimeout=60 DriverODBCVer=03.80 FileUsage=0 SQLLevel=1}
{ODBC Driver 13 for SQL Server} {UsageCount=1 APILevel=2 ConnectFunctions=YYY CPTimeout=60 DriverODBCVer=03.80 FileUsage=0 SQLLevel=1}
{ODBC Driver 17 for SQL Server} {UsageCount=1 APILevel=2 ConnectFunctions=YYY CPTimeout=60 DriverODBCVer=03.80 FileUsage=0 SQLLevel=1}
...
hammerdb>

[pugazhendhiramakrishnan08121985]

hammerdb>package require tdbc::odbc
1.1.1
hammerdb>tdbc::odbc::drivers
{SQL Server} {APILevel=2 ConnectFunctions=YYY CPTimeout=60 DriverODBCVer=03.50 FileUsage=0 SQLLevel=1 UsageCount=1}

I have tried to install Hammer DB in same SQL server and able to build the schema locally but if I try from remove Hammer DB it is failing, though both VMs are in same subnet and able to communicate through port 1433. If you see my output is completely different that what you have mentioned.

[sm-shaw]

You don't have any ODBC drivers installed. Install the required ODBC drivers, starting here.

[pugazhendhiramakrishnan08121985]

Thanks for your support in isolating this issue. After installing the correct version of ODBC drivers in both MS SQL and Hammer DB server, I'm able to build schema.