Accessing MS SQL Server Online

[cjohnson]

I need to access a MS SQL Server Database online. I only need to read one line of data at a time - no writing. I can do this on a local database in VB.net with an sqlconnection, but can anyone tell me what libraries I need and what type of connection to do this in Excel VBA? I apologize, I know this is a VB.Net Forum, but what I usually would do in VB.net, I have been required to do in VBA. Any help appreciated.
Thanks,
Chris Johnson

 

[jmcilhinney]

This is a VB.NET forum exclusively. If you require VBA information then you should find a VBA forum to provide it. I'm quite sure that there are plenty around. The fact that it is similar is not a good reason to post here. C# is similar too, as is J#. Maybe Delphi too. The line must be drawn somewhere and it's drawn at VB.NET.