dpatrickcollins
Programmer
- Nov 18, 2002
- 79
This seems like an obvious question but one I cannot find an answer to: Is there a way to connect a Crystal Report to a SQL SERVER database natively, i.e. without requiring an ODBC datasource? Code snippet:
With crConnectionInfo
.ServerName = "ServerName"
.DatabaseName = "DatabaseName"
.UserID = "UserID"
.Password = "Password"
End With
If I place the name of the ODBC datasource for "ServerName", all is well. But if I place the actual SQL SERVER name, it does not work.
I am using Crystal 10 developer and vb.net 2003
With crConnectionInfo
.ServerName = "ServerName"
.DatabaseName = "DatabaseName"
.UserID = "UserID"
.Password = "Password"
End With
If I place the name of the ODBC datasource for "ServerName", all is well. But if I place the actual SQL SERVER name, it does not work.
I am using Crystal 10 developer and vb.net 2003
