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 |
|
nmarks
Yak Posting Veteran
53 Posts |
 Posted - 2008-05-19 : 04:38:48
|
| I had been using Excel to connect to SQL server. This worked merrily for about 6 months then I had reason to reinstall Visual Studio.Now I've reinstalled that, my connection between Excel ans SQL Server won't work. I thought the ADO code I had put in my VBA macro would be sufficient to connect, but obviously I need to do something else, but what? Please help!Do I need to create an ODBC connection in Control Panel? Or something else? The code is unchanged from before and the VBA project does reference the ADO object Library.(OS : Windows Vista Ultimate) |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-20 : 02:20:55
|
| You probvably need to check your references (In the VBA code) as it is likely the drivers have changed versions or locations. |
 |
|
|
nmarks
Yak Posting Veteran
53 Posts |
Posted - 2008-05-20 : 02:53:12
|
| No, that's not it, but thanks for bothering.Anyone else got any ideas? |
|
|
|
nmarks
Yak Posting Veteran
53 Posts |
Posted - 2008-05-20 : 02:53:13
|
| No, that's not it, but thanks for bothering.Anyone else got any ideas? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-20 : 03:02:05
|
| What error are you getting then? |
|
|
|
|
|
|
Excel : Connecting to SQL Server 2005