Field Definition report results no record

Hi guys, sorry my poor english,
I'm trying to create a simple example of a report that receive the recordset from my VB6 application. The recordset have only one field like the rpt and the ttx file.

My project use these references:
Microsoft Remote Data Object 2.0
Crystal Reports ActiveX Designer Run Time Library 10.0
Crystal Report Viewer Control

To reproduce the example in VB, create a new project, include the references, create a command button and a CRViewer and after paste the code inside the form.

--- Code ---
Option Explicit
Dim cnFin As RDO.rdoConnection
Dim Crystal As CRAXDRT.Application

Private Sub Command1_Click()
Dim rsFin As RDO.rdoResultset
Dim rpFin As Report

'Opening table
Set rsFin = cnFin.OpenResultset( _
"SELECT ALL FinCPSequencia " & _
"FROM FinMovtoPagar " & _
"WHERE CodEstab = 5", RDO.rdOpenKeyset, RDO.rdConcurRowVer)
If rsFin.RowCount > 0 Then
'Opens report
Set rpFin = Crystal.OpenReport(App.Path & "\Test.rpt")
'Defines parameters
rpFin.ParameterFields.Item(1).AddCurrentValue "Title"
'Set DataSoruce
rpFin.Database.SetDataSource rsFin
'Shows report
With CRViewer1
.ReportSource = rpFin
.ViewReport
End With
Else
MsgBox "No record"
End If
End Sub
Private Sub Form_Load()
'Connecting with database
Set cnFin = RDO.rdoEnvironments(0).OpenConnection("", , , _
"DRIVER=SQL Server;SERVER=127.0.0.1;UID=BNP;PWD=password;APP=BNPGest;WSID=NBNIETTO;DATABASE=BNPGEST_DESENV;LANGUAGE=us_english;Network=DBMSSOCN;Address=127.0.0.1,1433")
'Initiating Crystal
Set Crystal = New CRAXDRT.Application
End SubThe same example using ADO works fine, but I have to keep the project with RDO.
I found this article: http://support.businessobjects.com/library/kbase/articles/c2016624.asp?ref=devzone_xiresources_tipsandtricks , But the report yet results no records even using the batchclient. Does anyone can help me?

field Compatable with uniqueidentifier (GUID)

hi there Guys!
I am looking for some field, which is compatable with GUID or maybe
some function which converts a CHAR/VARCHAR/INT to uniqueidentifier
(GUID) ?
Any suggestions?Hi
You cannot convert directly a value as CHAR(n)/VARCHAR(n) as
DECLARE @.str VARCHAR(1)
SET @.str = 'V'
SELECT CAST(@.str as UNIQUEIDENTIFIER)
What do you try to accomplish?
"hack_tick" <sharma.vasudev@.gmail.com> wrote in message
news:1131530112.619103.39140@.z14g2000cwz.googlegroups.com...
> hi there Guys!
> I am looking for some field, which is compatable with GUID or maybe
> some function which converts a CHAR/VARCHAR/INT to uniqueidentifier
> (GUID) ?
> Any suggestions?
>|||Thankyou for the Reply, currently I want to add some dozens of Test
data, which are reference across using GUID as the foreign Key, in
order for me to have the foreign key in other table I was looking for
someway to have my own simple GUID so that i can remember what i did :-)

Feedback regarding Feedback on the Feedback Center

Just a note to the MS guys...

I'm fully supportive of the product Feedback Center initiative and the subsequent withdrawal of sqlwish.

Problem is, if nobody ever gives us feedback on the things that we submit then it simply is a glorified version of sqlwish with no added value.

I apologise if there are plans afoot to address to offer feedback to the things we put up there but I (and others) have been freely submitting bugs and suggestions for a few months now without hearing anything back and I'm beginnign to wonder why we bother.

Even a simple "This is a good idea and will be considered for Katmai" or "This is a terrible idea now go and stick your head back in the sand" would be better than a cut and pasted response which is just about all I've seen so far.

Comments?

-Jamie

I agree I am unclear as to the purpose of the feedback centre. We appreciate that 2005 is done an dusted therefore if an issue is suggestion is now being closed as won't fix or by design that is implying it won't be fixed for the next 4 years. If something has missed SP1 and is therefore (one hopes) being considered for Katmai then it should have an appropriate status.

An example is the Tabs issue. http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=0010c553-d46e-42d0-b548-38b5f9ea79aa

Raised against CTP in June, A fix put in for RTM. Not sufficient in my book, the issue is reopene dby Erland and closed again saying a DCR has been raised but not in the feedback centre. This suggests that next version stuff is not being taken from product feedback centre.

This confusion is further exaserpated by a user group meeting on wednesday ran by members of the User Experience bods from the SQL Team. They are really wanting feedback from users, but currently I am not sure were to direct feedback.

|||

Any comment?

Favorite Monitoring (Performance) Tools?

I'm fairly new to the DBA thing.
I've been doing quite a bit of research on monitoring MSSQL performance.

What tools are you guys using?
PerfMon, Dbartisan, Spotlight, or what?

I'd like to find some free or affordable way to watch our Servers to check health/performance/etc.If you're using SQL 2005 (SP2), you can use a combination of SQL Health and History (aka SQL H2) and the new SQL Dashboard. Both require SQL Reporting services.

I'm using a set of vb scripts that use WMI queries to gather basic information: storage, network config, os config, installed apps, memory and cpu utilization. These are stored in a database. You can do a google on "wmi computer inventory vb script" and I think it will come up with a variety of examples.

Regards,

hmscott|||"whatsup" has a lot of robust automation for wmi if you're looking for a prepackaged solution. We've had reasonable luck with it so far.

fatal error 7105

hi guys,
does anyone know what would have caused this error happened:
[microsoft][ODBC sql server driver][sql server]warning:fatal error 7105
i have check with microsoft technet and it said:
Page %S_PGID, slot %d for text, ntext, or image node does not exist.
thanks.
best regards,
kharulli

Hi,

these datatypes are stored as pointers. It seems that your pointers are pointing to orphanded pages, so you can

1. Check the SQL Server log to see what happened.
2. Run DBCC CHECKDB to check the concistency of your database. (or run DBCC CHECKTABLE on single tables).

DBCC should find the error in your tables.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Moving to the "SQL Server Database Engine", which is closer related to the error you see.

|||

In %mssql%\log directory check the errorlogs and sql*.mdmp or sql*.txt files. Can you share these?

Any idea what was running on the server when you hit this?

Thanks

Failure to Connect Locally when Offline

Hi guys,
I sent this same message to the connection newsgroup, but I thought it
wouldn't hurt to post it here too.
We use replication, so a few clients connect to the network database,
and sometimes to MSDE on their computer when outside the office. They use
their domain Windows account to connect to both.
Here what is happening, they are able to connect fine to MSDE when they
are in their office, but when they leave the office, they can no longer
connect locally. They still use their domain account when they are offline.
Any idea why this would happen?
Thanks,
Maer
Is there a chance that MSDE cannot verify the domain account when they are
offline?
S
"Maer" <maer@.auditleverage.com> wrote in message
news:uwwU2Sq3HHA.5212@.TK2MSFTNGP04.phx.gbl...
> Hi guys,
> I sent this same message to the connection newsgroup, but I thought it
> wouldn't hurt to post it here too.
> We use replication, so a few clients connect to the network database,
> and sometimes to MSDE on their computer when outside the office. They use
> their domain Windows account to connect to both.
> Here what is happening, they are able to connect fine to MSDE when they
> are in their office, but when they leave the office, they can no longer
> connect locally. They still use their domain account when they are
> offline.
> Any idea why this would happen?
> Thanks,
> Maer
>
|||what is the connection error that they are getting?
relevantNoise - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Maer" <maer@.auditleverage.com> wrote in message
news:uwwU2Sq3HHA.5212@.TK2MSFTNGP04.phx.gbl...
> Hi guys,
> I sent this same message to the connection newsgroup, but I thought it
> wouldn't hurt to post it here too.
> We use replication, so a few clients connect to the network database,
> and sometimes to MSDE on their computer when outside the office. They use
> their domain Windows account to connect to both.
> Here what is happening, they are able to connect fine to MSDE when they
> are in their office, but when they leave the office, they can no longer
> connect locally. They still use their domain account when they are
> offline.
> Any idea why this would happen?
> Thanks,
> Maer
>