Search results for query: *

This worked. Thanks! Crystal is strange indeed...never cared for the interface...

Good news / bad news: I can execute the following statement in a query window (SQL 2005) on my computer AT HOME, and it works! SELECT * FROM OPENROWSET ( 'MSDASQL', 'Driver={MySQL ODBC 5.1 Driver}; DB=MySqlDB; SERVER=MyServer.com; uid=MyUserName; pwd=MyPassword', 'SELECT * FROM...

I have a small follow up: I noticed that after I replaced the table with the stored procedure, the original table name did not change under [Field Explorer | Database Fields.] Is there anyway to rename this table name/label? (I'm not even sure what Crystal calls this label - but it is the same...

Using "Set Datasource Location" worked pefectly. Thanks.

Sorry. This is Crystal 10.

After a lot of hacking and with the help of some other detailed documents I found, I was able to link to the remote MySQL database from my instance of SQL 2005 on my local machine at home. (Were your instructions for SQL 2000 EM?) Thanks for pointing me in the right direction. I have made some...

I have a report that used to connect to a table, now it connects to a stored proc that returns the same fields. Problem is that the fields on the report still get their values from the table, but I want to them to get their values from the stored proc. Is there some easy way to keep my report...

I solved it myself. I had to make sure that every path in the stored procedure would return a dataset. One of my IF...ELSE blocks had a branch that did not return a dataset. Once I fixed that, the error message went away.

I'm using Crystal 10. I have a stored procedure I wrote that exists in an MS SQL 2000 database. From the Crystal development environment, I open the Database Expert window so that I can select the Stored Procedure I want to base the report on. When I try to select my stored proc (by moving it...

OK thanks. I'll give this a try when I get home...

I should add that, I am not an expert on Web Services or Security, but surely there must be some way to secure data published by a Web Service? I wouldn't be opening anything on the MS SQL side, only on the MySQL side - the source of the data.

If this approach of a linked server would be more secure then that's what I should do. It sounds like it might be easier too? Have you done this before?

CHALLENGE: I need to create some kind of process that grabs data from a MySQL database and puts it into a MS SQL 2005 database. One database lives on a Linux server and the other lives on a Windows server. The only way the two databases can connect to each other is through the internet. The...

Is there ever any risk in changing the database owner to 'sa' ??? Just wondering...

Thanks mrdenny. Big help.

MrDenny, I think you hit the nail on the head. I just checked, and yes, she is a member of the Administrators group on the machine on which the SQL server is running. So basically, you're saying that overrides any security settings in SQL Server?

Also, I just created a new Server Login and Database User, and gave it the same rights as "Sue.Jones" (refer to previous post) and the new user was not able to edit data. There is something different about "Sue.Jones" that I am missing. Could it have something to do with her logging into the...

OK, we tried editing a row from EM, and then closing the table and reopening - and the change was still there. I'm going to try starting from scratch - creating a new user and see what happens. Maybe there is something hidden in this user's settings somewhere that I just can't see... Any other...

She does not have any administrative rights on our domain and her SQL Login is not associated with *any* Server Roles.

I should clarify one more thing. When I say she is able to edit data in the table, I mean she is opening up EM, opening a table and editing a field in a row of data. The change keeps.