Major
Reputation: 339
Connect to MSSQL database with period in the name, using ODBC
If I have a database named something like "foo4.3" and I attempt to connect to it using odbc it looks for a database named "foo4". The period works fine in any other string (for instance puts "foo4.3" outputs "foo4.3" so I'm a little confused as to why it is attempting to look for a database named "foo4". I've already tried the literal string version (single quotes) as well as the escape enabled string (double quotes) and attempted to escape the period but I get the same results.
Upvotes: 1
Views: 1356
Answers (1)
Related Questions
- How can I get Rails to connect to a SQL Server database with a period in it's name?
- Connecting to an MSSQL database from a Ruby on Rails application running on Ubuntu
- Connecting to MS SQL Server 2005 from Mac using Ruby, ODBC and FreeTDS
- Ruby on Rails Set up MS SQL Connection to remote Database in database.yml
- Connect to MSSQL database with Ruby
- Connecting to MSSQL from Ruby on Rails from Ubuntu
- How to connect from ruby to MS Sql Server
- How to connect to SQL Server 2005 database through Ruby
- Ruby connecting to SQL Server
- Ruby Connecting to SQL Server 2005