Connect CR To SQL Without DSN !

I am using CR 8.5 n SQL server 2k. I want to create a DSNLess report. I have tried using the Data Explorer -> More Data Sources -> Microsoft Sql Server Option. The report by itself works fine but I don't know how to connect a dsnless report from my vbcode [CrViewer control] .

Any Help will really be appriated.

Thanx.
- Marjo

I use OLE DB (ADO) as a data source when designing my reports (CR 9).

Here's in part how I call my report on my form:

VB Code:

'+-----------------+
        '| SQL SERVER INFO |
        '+-----------------+
        crConnectionInfo = New ConnectionInfo
        With crConnectionInfo
            .ServerName = "MYSQLSERVER"
            .DatabaseName = "MYDATABASE"
            .UserID = "MYUSERID"
            .Password = "MYPASSWORD"
        End With

Hope this helps.

Quote:

---

crConnectionInfo = New ConnectionInfo
With crConnectionInfo
.ServerName = "MYSQLSERVER"
.DatabaseName = "MYDATABASE"
.UserID = "MYUSERID"
.Password = "MYPASSWORD"
End With

---

Thanks ARPrince for replying. I am using 8.5 and I couldn't find the connectionInfo. Can you please provide me more details.

I don't use CR 8.5 so I may not be in the best position to assist you. I was thinking it would be more or less the same but It may not be supported by CR 8.5 afterall.

Thanks ARPrince once again.

Can anybody else help me please, I am desperately searching for a solution to this problem.

Here is my DSN-less connection String when I am using VB6, CR8.5 and SQL 7:

VB Code:

ConnectString = "Provider=SQLOLEDB;DATA SOURCE=192.168.XXX.XX;Initial Catalog=Database Name;USER ID=UserName;Password=Password"

Good Luck