I have a word template that merges data from a sql DB. I did not write it. The server crashed and a new server was installed. I am having a connection problem. It is a template that was written prior to 2005.
This is part of the code concerning the connection
Public drive As New ADODB.Connection
Public cmd As New ADODB.Command
Public DOTainCntFlag As String
Public Sub GetLPMain()
On Error GoTo Err_GetLDriving
Dim sqlstring As String
Dim lpmrs As New ADODB.Recordset
' Connects to database and gets Driversrecord
Customer_num = [custNumber]
' Set ADO connection
Set cmd.ActiveConnection = drive
I'm getting the following error. I've googled it and still the same
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.