Gosh, I wasted alot of time playing around with this. An ODBC direct link is fine, as long as your data source doesnt change. eg: your software goes out to a customer, with different servername, database name, login, etc. You can program vb to change the the datasource information at runtime before the report loads. Thats gives you better customisation. Or alternately, as I have come to realise, do all your data selection in vb, and pass a dataset to CR instead. When designing the report, run your program quickly, but include a dataset.writeschema (c:\myschema.xsd) Then when you set the datasource for the report, choose xml. So much easier, neater programming, better maintainability. The selection criteria in CR becomes redundant (which is a blessing). Or... yeh, if its just 1 report in your office, odbc links are fine! :)

Hi, Thank you for your reply. Now my code runs fine. I just exclude single quotes. As far as like operator is concerned, i concat the % sign with the alphabets like A,B or C etc. Thank you EsHbAn BaHaDuR

Hi Eshban: Feel free to post the error message here. Deepak Kumar Vasudevan Personal Web: http://vdeepakkumar.netfirms.com/ I Blog At: http://deepak.blogdrive.com/

have you tried this? Select * from books where year(publishingdate) = '" & ComVal.text & "'

myDatagrid.DataSource = Nothing TOXCCT >>> GEII power [toxcct][VisualCalc]

In fact, this error only occurs when we put the code inline. If we use code-behind, this error does not happen. So IMHO, the posters might have thought that the readers also use the code-behind model by default in order to run the sample code in the same way as they did.

u actaully need to download MSXML v4.0 SP2 from the Microsoft website or just google around for MSXML v4.0 SP2 and ur done with it. Your dom application should work fine. Regards Wilbur J. Pereira http://groups-beta.google.com/group/DotNetStarters "If they love me let them, for the heck of it.If they don't, who da heck cares about it"

* Copy the backup file on to the other computer * In Enterprise Manager, open the tree on to the SQL Server instance running on the other computer (you may have to register the other SQL Server with your local Enterprise Manager if it is not already there - alternatively go to the Enterprise Manager on the other computer) * Right click on the databases folder icon in Enterprise manager and select All Tasks-->Restore Database My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Use Import and Export Data from SQL Server. Work hard, Work effectively.

Colin Angus Mackay wrote: May I ask why? minimal downtime and no data loss,it is best to move it by detaching and then reattaching the database on the new server. The database will be offline during the move but it is better to have it offline than to miss transactions when backing up and then restoring the database on the new server.

good news it can be done bad news is I dont use querys like that. In the report designer if you add the 2 database and link the like fields like a user ID or a author name they will show the information form both databases. second to do the selectionformula call the like id from one of the fields I would use the one with the most fields called from it. use the fllowing CrystalReportViewer1.SelectionFormula ="{Customer.Cust_No } = " & CInt(txtCustNo.Text) for string you have to use CrystalReportViewer1.SelectionFormula ="{Customer.Cust_Name } = ' " & CInt(txtCustNo.Text) & "'" you can put anything where txtCustno.text i normally name my strings and put them there. James Kennelly

Use a Regular Expression (RegEx class) to evaluate if the address is sytactically correct: Public Function IsEmail(ByVal emailAddress As String) As Boolean Dim strRegex As String = "^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}" & _ @"\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\" & _ @".)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$" Dim re As New Regex(strRegex) If re.IsMatch(emailAddress) Return True; Else Return False End Function * Code snippet taken from this[^] Code Project article by Vasudevan Deepak Kumar. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Here's instruction for including the control in your project: [^] Are you familiar with the MaskedEdit control in VB6? It's just about the same. If you aren't familiar, then you can Google it or look further on vbcity.com, just remember you are looking for VB6 instructions, not VB.NET.

How else are you going to get the data out of the database? RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

There are might be many problem or area that you need to check about this systme: 1. Try to test a new connection whether it could connect successfully or not. 2. Make sure the user name and password is correct. 3. An IP address of the connection point to the server is wrong. 4. Make sure that the device driver of modem or network card is enable or install correctly.

Start a form up with FixedSingle, Window State maximized. Then click the Maximize button in the form's control box. You'll figure it out. :-)

Backup the database then restore it on the new computer. Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums