RDO 2.0 and Visual Basic 5 application stopped working with SQL Server 2005

We have a legacy application that is still in wide use. It is Visual Basic 5 and RDO 2.0 using ODBC to connect to SQL Server database.

When trying to connect to SQL Server 2005, it can no longer update or insert data. It reads data fine. The error message it gives is 16933, "The cursor does not include the table being modified or the table is not updatable through the cursor."

Has anybody else seen this problem? Any help would be appreciated.

Yes, we've seen this. It's hinted at in the documentation, although none of our examples seemed to exactly match what's documented. In several cases we were able to fix the problem by swapping the "from" table with a join table, but in one case we had to give up on the cursor.

RDL File from Report Designer

I'm very new to Reporting Services, so I have a basic question. Once I have
designed a report in Report Designer (generated an RDL file), without
deploying it to the Report Server, is it possible to view this report somehow
given this RDL file alone?You can view the report in Preview mode or debug local mode which takes the
secuity policy setting to run the report.
This two method of viewing the report does not require to deploy the report
in the report server.
HTH
Balaji
--
Message posted via http://www.sqlmonster.com|||Thanks for your reply. I guess I need to make myself more clear. I mean
whether I could view the report outside of Report Designer without deploying
the report?
For example, in Crystal Reports, all we need is a report viewer dll plus the
report definition. In other words, the report is really portable.
Thanks
jenny
"BALAJI via SQLMonster.com" wrote:
> You can view the report in Preview mode or debug local mode which takes the
> secuity policy setting to run the report.
> This two method of viewing the report does not require to deploy the report
> in the report server.
> HTH
> Balaji
> --
> Message posted via http://www.sqlmonster.com
>|||Visual Studio 2005 will have two controls (winform and webform) that will
either work with RS or can work in local mode. In local mode you give it a
report and the dataset, no server necessary.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<yinjennytam@.newsgroup.nospam> wrote in message
news:DF5FCCA2-F0F3-47A2-BC12-183DA08E7345@.microsoft.com...
> Thanks for your reply. I guess I need to make myself more clear. I mean
> whether I could view the report outside of Report Designer without
> deploying
> the report?
> For example, in Crystal Reports, all we need is a report viewer dll plus
> the
> report definition. In other words, the report is really portable.
> Thanks
> jenny
>
> "BALAJI via SQLMonster.com" wrote:
>> You can view the report in Preview mode or debug local mode which takes
>> the
>> secuity policy setting to run the report.
>> This two method of viewing the report does not require to deploy the
>> report
>> in the report server.
>> HTH
>> Balaji
>> --
>> Message posted via http://www.sqlmonster.com|||Thanks for your quick reply!
Good point! I've heard of that too, but does it work with custom data
processing extension? We have defined our own datasource and I can't seem to
find a way to run the report in VS 2005 in local mode. :-(
Thanks
Jenny
"Bruce L-C [MVP]" wrote:
> Visual Studio 2005 will have two controls (winform and webform) that will
> either work with RS or can work in local mode. In local mode you give it a
> report and the dataset, no server necessary.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <yinjennytam@.newsgroup.nospam> wrote in message
> news:DF5FCCA2-F0F3-47A2-BC12-183DA08E7345@.microsoft.com...
> > Thanks for your reply. I guess I need to make myself more clear. I mean
> > whether I could view the report outside of Report Designer without
> > deploying
> > the report?
> >
> > For example, in Crystal Reports, all we need is a report viewer dll plus
> > the
> > report definition. In other words, the report is really portable.
> >
> > Thanks
> > jenny
> >
> >
> > "BALAJI via SQLMonster.com" wrote:
> >
> >> You can view the report in Preview mode or debug local mode which takes
> >> the
> >> secuity policy setting to run the report.
> >>
> >> This two method of viewing the report does not require to deploy the
> >> report
> >> in the report server.
> >>
> >> HTH
> >> Balaji
> >>
> >> --
> >> Message posted via http://www.sqlmonster.com
> >>
>
>|||In the local mode of the ReportViewer, you don't need a data extension -
your code supplies the dataset. Data extensions are only needed on the
Report Server.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<yinjennytam@.newsgroup.nospam> wrote in message
news:5B0DA793-B022-4159-8735-3336C9E310E3@.microsoft.com...
> Thanks for your quick reply!
> Good point! I've heard of that too, but does it work with custom data
> processing extension? We have defined our own datasource and I can't seem
> to
> find a way to run the report in VS 2005 in local mode. :-(
> Thanks
> Jenny
>
> "Bruce L-C [MVP]" wrote:
>> Visual Studio 2005 will have two controls (winform and webform) that will
>> either work with RS or can work in local mode. In local mode you give it
>> a
>> report and the dataset, no server necessary.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <yinjennytam@.newsgroup.nospam> wrote in message
>> news:DF5FCCA2-F0F3-47A2-BC12-183DA08E7345@.microsoft.com...
>> > Thanks for your reply. I guess I need to make myself more clear. I
>> > mean
>> > whether I could view the report outside of Report Designer without
>> > deploying
>> > the report?
>> >
>> > For example, in Crystal Reports, all we need is a report viewer dll
>> > plus
>> > the
>> > report definition. In other words, the report is really portable.
>> >
>> > Thanks
>> > jenny
>> >
>> >
>> > "BALAJI via SQLMonster.com" wrote:
>> >
>> >> You can view the report in Preview mode or debug local mode which
>> >> takes
>> >> the
>> >> secuity policy setting to run the report.
>> >>
>> >> This two method of viewing the report does not require to deploy the
>> >> report
>> >> in the report server.
>> >>
>> >> HTH
>> >> Balaji
>> >>
>> >> --
>> >> Message posted via http://www.sqlmonster.com
>> >>
>>|||Please bear with me as I'm still very new to this Reporting Services. Maybe
I should explain my problem.
So far I have attempted to create my own data processing extension using the
Reporting Services of SQL Server 2005 April CTP version and even successfully
created reports (.rdl files). Although I have some troubles getting the
Report Server up and running sometimes, I managed to deploy those reports and
view them in Report Manager. So far so good. However, ideally we need to
support mobile users. The question is how do we make reports portable to
them? Is it possible for mobile users to view reports without a connection
to Report Server? Something like the Report Designer when we preview the
reports (or does this go through the Report Server behind the scene?).
We want to make use of our custom data processing extension to feed the data
to the reports. With ReportViewer controls, it looks like that there are two
options, one of which (as you mentioned) requires us to supply the dataset
and the other requires a connection to the Report Server.
Previously, with Crystal Reports, we support our mobile users with a simple
Report Viewer dll so that they can view reports even when disconnected.
Also, I'm very impressed with the powerful ReportBuilder (seen the webcast)
and even played with it a little bit. Unfortunately, it seems to me that I
cannot set up a model designer based on my custom data processing extension
... :-( Is that right?
Thank you very much for reading this post. :-)
Jenny
"Brian Welcker [MSFT]" wrote:
> In the local mode of the ReportViewer, you don't need a data extension -
> your code supplies the dataset. Data extensions are only needed on the
> Report Server.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> <yinjennytam@.newsgroup.nospam> wrote in message
> news:5B0DA793-B022-4159-8735-3336C9E310E3@.microsoft.com...
> > Thanks for your quick reply!
> >
> > Good point! I've heard of that too, but does it work with custom data
> > processing extension? We have defined our own datasource and I can't seem
> > to
> > find a way to run the report in VS 2005 in local mode. :-(
> >
> > Thanks
> > Jenny
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Visual Studio 2005 will have two controls (winform and webform) that will
> >> either work with RS or can work in local mode. In local mode you give it
> >> a
> >> report and the dataset, no server necessary.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> <yinjennytam@.newsgroup.nospam> wrote in message
> >> news:DF5FCCA2-F0F3-47A2-BC12-183DA08E7345@.microsoft.com...
> >> > Thanks for your reply. I guess I need to make myself more clear. I
> >> > mean
> >> > whether I could view the report outside of Report Designer without
> >> > deploying
> >> > the report?
> >> >
> >> > For example, in Crystal Reports, all we need is a report viewer dll
> >> > plus
> >> > the
> >> > report definition. In other words, the report is really portable.
> >> >
> >> > Thanks
> >> > jenny
> >> >
> >> >
> >> > "BALAJI via SQLMonster.com" wrote:
> >> >
> >> >> You can view the report in Preview mode or debug local mode which
> >> >> takes
> >> >> the
> >> >> secuity policy setting to run the report.
> >> >>
> >> >> This two method of viewing the report does not require to deploy the
> >> >> report
> >> >> in the report server.
> >> >>
> >> >> HTH
> >> >> Balaji
> >> >>
> >> >> --
> >> >> Message posted via http://www.sqlmonster.com
> >> >>
> >>
> >>
> >>
>
>|||VS 2005 will have both a webform and winform control. When operating in
local mode you give it the report and dataset. These controls are available
in Beta 2 of VS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<yinjennytam@.newsgroup.nospam> wrote in message
news:8E8E3B78-31EB-4262-9F7A-096AE009EE0F@.microsoft.com...
> Please bear with me as I'm still very new to this Reporting Services.
> Maybe
> I should explain my problem.
> So far I have attempted to create my own data processing extension using
> the
> Reporting Services of SQL Server 2005 April CTP version and even
> successfully
> created reports (.rdl files). Although I have some troubles getting the
> Report Server up and running sometimes, I managed to deploy those reports
> and
> view them in Report Manager. So far so good. However, ideally we need to
> support mobile users. The question is how do we make reports portable to
> them? Is it possible for mobile users to view reports without a
> connection
> to Report Server? Something like the Report Designer when we preview the
> reports (or does this go through the Report Server behind the scene?).
> We want to make use of our custom data processing extension to feed the
> data
> to the reports. With ReportViewer controls, it looks like that there are
> two
> options, one of which (as you mentioned) requires us to supply the dataset
> and the other requires a connection to the Report Server.
> Previously, with Crystal Reports, we support our mobile users with a
> simple
> Report Viewer dll so that they can view reports even when disconnected.
> Also, I'm very impressed with the powerful ReportBuilder (seen the
> webcast)
> and even played with it a little bit. Unfortunately, it seems to me that
> I
> cannot set up a model designer based on my custom data processing
> extension
> ... :-( Is that right?
> Thank you very much for reading this post. :-)
> Jenny
>
> "Brian Welcker [MSFT]" wrote:
>> In the local mode of the ReportViewer, you don't need a data extension -
>> your code supplies the dataset. Data extensions are only needed on the
>> Report Server.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> <yinjennytam@.newsgroup.nospam> wrote in message
>> news:5B0DA793-B022-4159-8735-3336C9E310E3@.microsoft.com...
>> > Thanks for your quick reply!
>> >
>> > Good point! I've heard of that too, but does it work with custom data
>> > processing extension? We have defined our own datasource and I can't
>> > seem
>> > to
>> > find a way to run the report in VS 2005 in local mode. :-(
>> >
>> > Thanks
>> > Jenny
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Visual Studio 2005 will have two controls (winform and webform) that
>> >> will
>> >> either work with RS or can work in local mode. In local mode you give
>> >> it
>> >> a
>> >> report and the dataset, no server necessary.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> <yinjennytam@.newsgroup.nospam> wrote in message
>> >> news:DF5FCCA2-F0F3-47A2-BC12-183DA08E7345@.microsoft.com...
>> >> > Thanks for your reply. I guess I need to make myself more clear. I
>> >> > mean
>> >> > whether I could view the report outside of Report Designer without
>> >> > deploying
>> >> > the report?
>> >> >
>> >> > For example, in Crystal Reports, all we need is a report viewer dll
>> >> > plus
>> >> > the
>> >> > report definition. In other words, the report is really portable.
>> >> >
>> >> > Thanks
>> >> > jenny
>> >> >
>> >> >
>> >> > "BALAJI via SQLMonster.com" wrote:
>> >> >
>> >> >> You can view the report in Preview mode or debug local mode which
>> >> >> takes
>> >> >> the
>> >> >> secuity policy setting to run the report.
>> >> >>
>> >> >> This two method of viewing the report does not require to deploy
>> >> >> the
>> >> >> report
>> >> >> in the report server.
>> >> >>
>> >> >> HTH
>> >> >> Balaji
>> >> >>
>> >> >> --
>> >> >> Message posted via http://www.sqlmonster.com
>> >> >>
>> >>
>> >>
>> >>
>>

rda.pull exception

Hi,

I have followed the technical artical "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual Basic.NET" to create a sample application.

But when I run debug mode and get an exception unexpected as following as doing rad.pull :

Immediate Window:

A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll

Message Box

[Contacts]

Code:

Private Sub RADPullButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RADPullButton.Click

Try
VerifyDatabaseExists()
Dim rda As SqlCeRemoteDataAccess
rda = GetRDAObject()
rda.Pull("Contacts", _
"SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax FROM Customers", _
My.Settings.ServerOleDBNorthwindConnectionString, _
RdaTrackOption.TrackingOnWithIndexes, _
"Contacts_Errors")

Catch ex As Exception
MessageBox.Show(ex.ToString())
Finally
Windows.Forms.Cursor.Current = Cursors.Default
End Try

End Sub

Thanks in advance,

JD

You need to grab all the error information, by following the guidelines in this topic from SQL CE Books online - Handling Errors in Managed Applications http://msdn2.microsoft.com/en-us/library/ms174079.aspx

|||

HI ErikEJ,

I have following the link to catch real sql server compact edition error exception

Here is what I got and I still don't know what this meas:

Error Code:80004005
Message :[Contacts]
Minor Err: 28573
Source: Microsoft SQL Server Compact Edition
Err. Par.: Contacts

Thanks a lot,

JD

|||

There already is a local table with the same name as used in your RDA definition. See this very helpful post by laxmi at http://blogs.msdn.com/sqlservercompact/archive/2007/01/23/rda-subscriptions.aspx

|||

I am having a similar problem. When I pull the tables, I also create an error table (tablename_err). If I have to pull a table again, I first drop the table if it exists and then attempt to pull it again. I cannot do this though because when I drop the table, the error table does not get dropped and it will not let me pull a another error table (error 28573). I have attempted to explicitly drop the error table, but I am not allowed to do that either as that generates the 28605 error: "DDL operations on the table are restricted." I did not have this problem with SQLCE 2.0, only since I migrated to SQLMobile (3.0). How do I get rid of the original error tables so that I can pull again?

|||

One doesn't has to drop the error tables explicitly. These will be dropped automatically when the associated RDA tracked table is dropped. For e.g.:

rda.pull(@."pulltable", @."select * from foo", <conn string to SQL server>, RDATrackOption.TrackingOn, @."err_pull");

when one drops pulltable, err_pull automatically gets dropped since it is associated with pulltable which is being tracked. Please refer to "Maintaining Error Tables" in http://msdn2.microsoft.com/en-us/library/ms171782.aspx

Could you verify if you are indeed dropping all the local data tables into which you are attempting to pull data?

rda.pull exception

Hi,

I have followed the technical artical "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual Basic.NET" to create a sample application.

But when I run debug mode and get an exception unexpected as following as doing rad.pull :

Immediate Window:

A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll

Message Box

[Contacts]

Code:

Private Sub RADPullButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RADPullButton.Click

Try
VerifyDatabaseExists()
Dim rda As SqlCeRemoteDataAccess
rda = GetRDAObject()
rda.Pull("Contacts", _
"SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax FROM Customers", _
My.Settings.ServerOleDBNorthwindConnectionString, _
RdaTrackOption.TrackingOnWithIndexes, _
"Contacts_Errors")

Catch ex As Exception
MessageBox.Show(ex.ToString())
Finally
Windows.Forms.Cursor.Current = Cursors.Default
End Try

End Sub

Thanks in advance,

JD

You need to grab all the error information, by following the guidelines in this topic from SQL CE Books online - Handling Errors in Managed Applications http://msdn2.microsoft.com/en-us/library/ms174079.aspx

|||

HI ErikEJ,

I have following the link to catch real sql server compact edition error exception

Here is what I got and I still don't know what this meas:

Error Code:80004005
Message :[Contacts]
Minor Err: 28573
Source: Microsoft SQL Server Compact Edition
Err. Par.: Contacts

Thanks a lot,

JD

|||

There already is a local table with the same name as used in your RDA definition. See this very helpful post by laxmi at http://blogs.msdn.com/sqlservercompact/archive/2007/01/23/rda-subscriptions.aspx

|||

I am having a similar problem. When I pull the tables, I also create an error table (tablename_err). If I have to pull a table again, I first drop the table if it exists and then attempt to pull it again. I cannot do this though because when I drop the table, the error table does not get dropped and it will not let me pull a another error table (error 28573). I have attempted to explicitly drop the error table, but I am not allowed to do that either as that generates the 28605 error: "DDL operations on the table are restricted." I did not have this problem with SQLCE 2.0, only since I migrated to SQLMobile (3.0). How do I get rid of the original error tables so that I can pull again?

|||

One doesn't has to drop the error tables explicitly. These will be dropped automatically when the associated RDA tracked table is dropped. For e.g.:

rda.pull(@."pulltable", @."select * from foo", <conn string to SQL server>, RDATrackOption.TrackingOn, @."err_pull");

when one drops pulltable, err_pull automatically gets dropped since it is associated with pulltable which is being tracked. Please refer to "Maintaining Error Tables" in http://msdn2.microsoft.com/en-us/library/ms171782.aspx

Could you verify if you are indeed dropping all the local data tables into which you are attempting to pull data?

rda.pull exception

Hi,

I have followed the technical artical "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual Basic.NET" to create a sample application.

But when I run debug mode and get an exception unexpected as following as doing rad.pull :

Immediate Window:

A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll

Message Box

[Contacts]

Code:

Private Sub RADPullButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RADPullButton.Click

Try
VerifyDatabaseExists()
Dim rda As SqlCeRemoteDataAccess
rda = GetRDAObject()
rda.Pull("Contacts", _
"SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax FROM Customers", _
My.Settings.ServerOleDBNorthwindConnectionString, _
RdaTrackOption.TrackingOnWithIndexes, _
"Contacts_Errors")

Catch ex As Exception
MessageBox.Show(ex.ToString())
Finally
Windows.Forms.Cursor.Current = Cursors.Default
End Try

End Sub

Thanks in advance,

JD

You need to grab all the error information, by following the guidelines in this topic from SQL CE Books online - Handling Errors in Managed Applications http://msdn2.microsoft.com/en-us/library/ms174079.aspx

|||

HI ErikEJ,

I have following the link to catch real sql server compact edition error exception

Here is what I got and I still don't know what this meas:

Error Code:80004005
Message :[Contacts]
Minor Err: 28573
Source: Microsoft SQL Server Compact Edition
Err. Par.: Contacts

Thanks a lot,

JD

|||

There already is a local table with the same name as used in your RDA definition. See this very helpful post by laxmi at http://blogs.msdn.com/sqlservercompact/archive/2007/01/23/rda-subscriptions.aspx

|||

I am having a similar problem. When I pull the tables, I also create an error table (tablename_err). If I have to pull a table again, I first drop the table if it exists and then attempt to pull it again. I cannot do this though because when I drop the table, the error table does not get dropped and it will not let me pull a another error table (error 28573). I have attempted to explicitly drop the error table, but I am not allowed to do that either as that generates the 28605 error: "DDL operations on the table are restricted." I did not have this problem with SQLCE 2.0, only since I migrated to SQLMobile (3.0). How do I get rid of the original error tables so that I can pull again?

|||

One doesn't has to drop the error tables explicitly. These will be dropped automatically when the associated RDA tracked table is dropped. For e.g.:

rda.pull(@."pulltable", @."select * from foo", <conn string to SQL server>, RDATrackOption.TrackingOn, @."err_pull");

when one drops pulltable, err_pull automatically gets dropped since it is associated with pulltable which is being tracked. Please refer to "Maintaining Error Tables" in http://msdn2.microsoft.com/en-us/library/ms171782.aspx

Could you verify if you are indeed dropping all the local data tables into which you are attempting to pull data?

RDA Pull Fail

I try to pull data from SQL 2005 Express Edition to SQL Mobile 5.0, with Visual Basic 2005.
It keep prompt me the error Native Error:

System.Data.SqlServerCe.SqlCeException was unhandled
HResult=-2147024809
Message="An error has occurred on the computer running IIS. Try restarting the IIS server."
NativeError=28022
Source="Microsoft SQL Server 2005 Mobile Edition"
StackTrace:
at System.Data.SqlServerCe.NativeMethods.CheckHRESULT()
at System.Data.SqlServerCe.SqlCeRemoteDataAccess.Pull()
at PDA2007.PULLPUSH.btn_pull_Click()
at System.Windows.Forms.Control.OnClick()
at System.Windows.Forms.Button.OnClick()
at System.Windows.Forms.ButtonBase.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at PDA2007.PULLPUSH.Main()

Below is my coding :

Private Sub btn_pull_Click(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles btn_pull.Click

Const gRemoteProvider = "Provider=SQLOLEDB.1;Persist Security

Info=False; " & _

"User ID=dmspda;Password=dmspda;Initial

Catalog=dmspda;Data Source=INSPIRON6000"

Const gInternetURL = "HTTP://192.168.1.3/Sync/SSCESA30.DLL"

Const gInternetLogin = "INSPIRON6000\IUSR_INSPIRON6000"

Const gInternetPwd = ""

Dim rda As SqlCeRemoteDataAccess

rda = New SqlCeRemoteDataAccess

rda.LocalConnectionString = "Data Source=\My Documents\pda.sdf"

rda.InternetUrl = gInternetURL

rda.InternetLogin = gInternetLogin

rda.InternetPassword = gInternetPwd

rda.Pull("pda_uom", "Select * from pda_uom", gRemoteProvider,

RdaTrackOption.TrackingOn)

End Sub

I have been refer to a lot of website and read articles, help forum, have try to disable Firewall, allow HTTP and HTTPS, uninstall anti-virus system. I have no idea, what is this problem and how to solve it ? If you face same problem before, hope can give some comment here, appreciate it!

Developed Machine:
* XP Pro S2
* SQL Server 2005 Express Edition
* Visual Studio 2005

Device :
* SQL Mobile 2005
* Window Mobile 5.0

Hullo xiaoytan

I have facing the same error as u faced, could u solved this pbm, then please let me know , how to do it ?

Thank u.

Rate() and PMT()

If you are familiar with Crystal reports or Visual basic, you may be familiar with the Rate and Pmt functions.

I need to duplicate them in SQL sever 7.

Anybody have code for this already? I hate re-inventing the wheel.

More (Unnecesary) details:
I have a client who has handed me the formula that I need to use for calculating Interest rates. Unfortunatly, the formula was written in Crystal reports, so now I need to pick it apart and do the work that CR does automaticly. Any help?Check this site, it should contain what you're looking for:

http://www.wheatworks.com/formula.htm