Method:API Q&A

Re: Direct access to mssql server tables

lthames — Fri, 19 Feb 2010 23:35:32 GMT

Thanks Paul . . it's OK for the delay. But I'm glad you posted because I have a conference call with my client tomorrow morning and he'll be asking what I have found out.

To be completely honest I haven't spent enough time digging into anything to have an educated opinion of it . . . i bought a new computer last weekend and have spent all of this week getting my development software and applcations running under Windows 7.

But this is what my client is telling me . . . the report designer only allows relationships that are already set up by Method. That was the limitation he didn't like.

Re: Direct access to mssql server tables

Method_Paul — Fri, 19 Feb 2010 23:15:19 GMT

Sorry for not replying sooner. I didn't see your reply.

FYI - Method has a report designer. It's pretty powerful. I would say it is comparable to what you would get from MS Access reporting.

.....Method can do a lot!

Re: Direct access to mssql server tables

lthames — Fri, 12 Feb 2010 14:34:07 GMT

Paul, Thanks for answering my question. I am looking really forwrd to working with Method!

To answer your question . . . .No, I haven't used it yet. The reason I asked about the direct access was because one of the things the client I am developing for is wanting to be able to use Access to design reports and queries on the data. I will be using the API to integrate that somehow, and I have some ideas about how to accomplist that.

But I suggested that if there was direct access to the SQL server database, using the ms sql report designer would be an easier way to do what he wants, as he wouldn't need me to write anything to interface the two!

I was supposed to start working with the API yesterday but winter weather and electrical outages kept me from doing so. I'll be jumping back in tomorrow morning.

Have a great day!

Re: Direct access to mssql server tables

Method_Paul — Fri, 12 Feb 2010 13:36:56 GMT

With the MethodAPI you don't have direct access......but it is pretty close! You are pretty much writing SELECT statements against the SQL data. You have full control over which fields you are pulling in, and your WHERE is completely SQL format.

Have you used the API yet? If not, you'll find it is pretty much what you are asking for.

If you have used it, please let me know what you are trying to accomplish and where the shortcoming is for you.

Paul

Direct access to mssql server tables

lthames — Wed, 10 Feb 2010 16:48:14 GMT

Is there any way to gain read only access directly to the mssql server data (ie a connectin string) for development?