#ODBC MANAGER NOT CREATING USER DSN DRIVER#
#ODBC MANAGER NOT CREATING USER DSN WINDOWS#

Your database administrator should be able to tell you whether the latest service pack has been applied. That would enable you to configure and test the connection without receiving a 'user is not associated with a trusted SQL Connection' error.

#ODBC MANAGER NOT CREATING USER DSN DRIVER#

NOTE: if the only message you see is 'Port Scan has completed', then the server is not listening on that port, or the port is not reachable from your Mac! Contact your database administrator or network support staff to determine the correct port or to have the port opened on your organization's network equipment.įinally, the latest service packs from Microsoft should be applied to the SQL Server. failed-ERRORIM002MicrosoftODBC Driver ManagerData source name not found. Creating and configure a Linked Server using the ODBC driver via SQL Server Management Studio. You can also use the 'runas' command to launch the ODBC Data Source Administrator under your admin account while logged under your normal account. Decide if you want all users on your client system to be able to access to the DSN for the Vertica database. When you use the Port Scan tool to scan the default port 1433, you should see a message that says: Click System DSN tab and click Add button (a System DSN is available to all users of the computer, including Services. Double-click Administrative Tools, and then double-click Data Sources (ODBC). Use the Port Scan tool of the Network Utility application to verify your server is listening on the port you have configured, and the port is reachable from your Mac. To open ODBC Administrator, click Start, point to Settings, and then click Control Panel. If you get this message immediately, then you either have the wrong port or the port is being blocked by the network equipment (such as a router or firewall). Use the Ping and Trace Route tools of the Network Utility application in the /Applications/Utilities folder to verify you can reach your server's IP address. Please look at the attached image, Step 1.

#ODBC MANAGER NOT CREATING USER DSN WINDOWS#

If you get this message after waiting more than 60 seconds, then you either have the wrong IP address for the server or the server is not reachable from your Mac. However, when I try to add a System DSN via windows odbc manager - I receive: Connection failed: SQL State: 01000.

Odbc manager not creating user dsn