cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Can't connect to MSSQL database -- architecture mismatch

Greetings.

 

Some time in the past month, I lost the ability to connect from my perl CGI script to my MSSQL database.  The error I get is this:

 

my $dbh = DBI->connect('dbi: ODBC:CorrectDatabaseName','username','password');

 

Unable for connect to server [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application (SQL-IM014)

 

I found a number of links

 

http://www.martin-evans.me.uk/node/81

 

https://communities.actian.com/s/article/The-specified-DSN-contains-an-architecture-mismatch-between...

 

https://www.perlmonks.org/?node_id=886878

 

that seem to imply that the Database or the Web Host (but not both) was updated, and the two can no longer talk to each other.

 

Can somebody guide me toward a resolution?