RODBC odbcDriverConnect() Connection Error

by

The correct syntax should be:

odbcDriverConnect('driver={SQL Server};server=servername\\instancename,port;database=testing;uid=abc;pwd=123456')

If you use Windows Authentication method:

odbcDriverConnect('driver={SQL Server};server=servername\\\\instancename,port;database=testing;trusted_connection=true')

Slash seems like an escape character, escaping slash works.

More Related Contents:

  1. How do I use cascade delete with SQL Server?
  2. An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON SQL Server
  3. How to add Active Directory user group as login in SQL Server
  4. Maximum size of a varchar(max) variable
  5. How to update large table with millions of rows in SQL Server?
  6. Why do table names in SQL Server start with “dbo”?
  7. Add alternating row color to SQL Server Reporting services report
  8. How to Use UTF-8 Collation in SQL Server database?
  9. How do you specify a different port number in SQL Management Studio?
  10. how to make your data horizontal
  11. How do I find a stored procedure containing ?
  12. Error: TCP Provider: Error code 0x2746. During the Sql setup in linux through terminal
  13. How to check if a Constraint exists in Sql server?
  14. An attempt to login using SQL authentication failed
  15. What does “ORDER BY (SELECT NULL)” mean?
  16. Parse XML in SQL Server
  17. Calling stored procedure using VBA
  18. How to find SQL Server running port?
  19. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  20. SQLServer IDENTITY Column with text
  21. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  22. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  23. Database design: Calculating the Account Balance
  24. Cannot bulk load. Operating system error code 5 (Access is denied.)
  25. RODBC Temporary Table Issue when connecting to MS SQL Server
  26. INFORMATION_SCHEMA vs sysobjects
  27. Does query plan optimizer works well with joined/filtered table-valued functions?
  28. What are row, page and table locks? And when they are acquired?
  29. Bootstrapping SQL Express from WiX?
  30. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?

Leave a Comment