Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sheekom
Starting Member
1 Post |
 Posted - 2012-08-08 : 16:52:20
|
| I am trying to connect using ODBC Data source to my SQL server 2012 database using the following stringProvider=SQLNCLI11;Server=SQLSERVER2012;Data Source=omsGUAS;Integrated Security=SSPI;User ID=sa;pwd=Naina2010;DataTypeCompatibility=80;MARS Connection=False;and it does not work from Excel VBA while I have tested the ODBC connection using ODBC connection wizard. I get "can not connect to SQL server error". However, if I replace the Database name instead of ODBC Database name, it works as follows:Provider=SQLNCLI11;Server=SQLSERVER2012;Database=omsGUAS_OMS;Integrated Security=SSPI;User ID=sa;pwd=Naina2010;DataTypeCompatibility=80;MARS Connection=True;What am I missing here. First string used to work with SQL 2000 and I have migrated the database successfully to SQL 2012 in 2 phase steps.Any help and/or suggestion would be appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
using ODBC data source to connect to SQL 2012