Database and Reporting | Forum profile

/solved solution: wrong: If rs(vFieldName).Value = Null Then correct: If IsNull(rs.Fields(vFieldName).Value) Then

In other words, my friend has to convert his syntax to SQL server. I'll find out if he actually using Access 2005 or some variations of it. Thanks for the info!

Version of SQLServer?

Yes, I can access the internet via LAN & ADSL. The strange thing is that there is no problem with the LAN access or any other restriction, just remote connection to SQL Server!

I have even seen references to MySQL as SQL Server. As for conversion, if OP's friend is using Access there use to be an upsizing wizard which would make some of the transition easier...

Hi, I created an ActiveX dll that has a form in it. My caller program has a button and once this button is click, it will ask this dll to open the form and perform its operation. Question: Now in my dll, I am retrieving data from a database directly. This is not exactly what I want. I want to retrieve data externally and pass in the data as recordset into my dll to be displayed on the form. How can I achieve this? Is it possible to create...

Hi there I need to do something in sql like this: I have a table with grades in this table in included the average of each person from prior date. Know in this table I have present grades and average of pervious ones for each student. Know I need to calculate overall average for each student. I add the coursecode to my table then I can find the previous average for each individual. But I don't know how I can write the sql command to do...

where (and how) is the connection declared? IMO, it's usually better to declare and instantiate the database objects explicitly , and not implicitly. The resulting machine code is more efficient. Code: dim rs as adodb.recordset '... set rs = new ADODB.recordset '... rs.open strSQL, cn '... rs.close set rs = nothing

Dear friends Pls give me solutions that how can we set authentication mode(Windows authentication/Sql authentication) in crystal report 8.5 through vb 6.0 and database is sql server 2008. I designed my report with Windows authentication and now through vb code i want to connect report through Sql authentication(which required user name & password.) is there any way through which we can set this ? I am opening my report through craxdrt...

Hi there I need to do something in sql like this: I have a table with grades in this table in included the average of each person from prior date. Know in this table I have present grades and average of pervious ones for each student. Know I need to calculate overall average for each student. I add the coursecode to my table then I can find the previous average for each individual. But I don't know how I can write the sql command to do...