"Error Locating Server/Instance Specified [xFFFFFFFF]". SQLSRV32 to the rescue.

When connecting to SQL Server and when the connection fails the reason for the error may sometimes be a bit unclear.   For this example I have a SQL Server 2008 instance called Spike2008 running on a machine called SpikeSrv2008 (running on Windows Server 2008). So the full name of the server is SpikeSrv2008\Spike2008.  …

3

How to create a DNS less linked server in Access to SQL Server.

  Sometimes you may want to use Access as a front end for SQL Server. When doing this you typically have linked tables to the SQL Server and you have the .mdb on a shared drive for users to access.   Normally you create a DSN and use that for the linked server. All works…

8

SQL Server Error: 10060 SQL Server Error: 10061

Ok, new entry with connectivity problems and examples.   The scenario: You have a SQL Server 2005 that is up and running you also know that the SQL Browser service is up and running. So on the server side, all is well.   On a side note, if you do not know what the SQL…

5

Dude, where did my ODBC System DSN go?!

When creating ODBC DSN’s, sometimes it all seems to go well. You open the ODBC Data Source Administrator. You enter the connection details for a new User DSN, test the connection and all is well.   BTW: instead of going: Control Panel -> Administrative Tools -> Data Sources (ODBC), just hit the WindowsKey+R, this opens…

1

How to use a FileDsn in .Net

  Another short one.   I saw a question on how to use FileDsn’s in a .Net application. This may not be the most common scenario, but it can be done. I’ll show you how.   This example will assume that you have an Access database located at C:\Temp. This Access database is called TestAcc.mdb…

1

Creating a new system DSN: "Faulting application odbcad32.exe, version 3.526.3959.0, faulting module unknown, version 0.0.0.0, fault address 0x5bb312de"

  This is an issue that I have seen a few times, so it could be worth mentioning. The error is as follows: When trying to create a new System DSN using the ODBC Data Source Administrator, the odbcad32.exe process goes down.   And you will see something like this in the event viewer:  …

2