reports and SQL SERVER 2000

[958676347657023940]

HI,
I did migration of an Access Database toward SQL server 2000. My problem is that My code Visual basic doesn't work for datareports. Before i Used dataenvironment for reports...my queries works but in my VB code it does not
any idea?
many thanks

 

[SQLBill]

It depends. Did you check your coding? Access SQL and SQL Server's Transact-SQL are not totally the same.

Some SQL that works for Access won't work in SQL Server; such as IIF. For SQL Server, you need to change IIFs to CASE expressions.

-SQLBill

 

[958676347657023940]

Yes. I did. The probleme is that for example before I write in my VB Code :

DataEnvironment.Commands("Pool&quot
Load DataReportPublication

DataReportPublication.Refresh

DataReportPublication.Show

IT WORKED BEFORE BUT NOW IT DOES NOT I dont know why...even if my all queries works on SQl server..

 

[SQLBill]

None of that is SQL Server syntax. You should post this in the Visual Basic forum.

-SQLBill