RE: [NF] SQL Server access via ODBC won't work from one workstation

2020-10-07 Thread Paul H. Tarver
+1 Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, October 07, 2020 2:42 PM To: profoxt...@leafe.com Subject: RE: [NF] SQL Server access via ODBC won't work from one workstation Hosts file? -

RE: [NF] SQL Server access via ODBC won't work from one workstation

2020-10-07 Thread Richard Kaye
Hosts file? -- rk -Original Message- From: ProfoxTech On Behalf Of Ted Roche Sent: Wednesday, October 7, 2020 2:53 PM To: profoxt...@leafe.com Subject: Re: [NF] SQL Server access via ODBC won't work from one workstation On Wed, Oct 7, 2020 at 4:49 AM Alan Bourke wrote: &

Re: [NF] SQL Server access via ODBC won't work from one workstation

2020-10-07 Thread Ted Roche
On Wed, Oct 7, 2020 at 4:49 AM Alan Bourke wrote: > What version is SQL Server? There was a cumulative update to SQL Server > 2019 recently which caused a lot of problems. > SQL Server Express 11.0.2100.60 > > When creating the System DSN, does it work with an IP address as opposed > to the hos

Re: [NF] SQL Server access via ODBC won't work from one workstation

2020-10-07 Thread Alan Bourke
What version is SQL Server? There was a cumulative update to SQL Server 2019 recently which caused a lot of problems. When creating the System DSN, does it work with an IP address as opposed to the hostname, i.e. xxx.xxx.xxx.xxx\SQLEXPRESS Is the SQL Server instance using dynamic ports and it'