Printable View
If I install service pak 4 and I don't have SQLServer installed, will I be able to connect to a SQLServer DBase on another machine from my prog using the
.ConnectionString = SQLOLEDB ......
or will I still have to use DSN??
Thanks in advance
rhnewfie
Service Pack 4 has nothing to do with database connectivity. You have to make sure that you have the latest MDAC (Microsoft Data Access Components) installed.
To be sure, Download the latest MDAC 2.6 from Microsoft web site
Yeah, I found that out after, but service pak 4 will work by default because it won't let you install unless you have already installed mdac_typ.exe first.