Showing posts with label programming. Show all posts
Showing posts with label programming. Show all posts

Monday, March 26, 2012

Offtopic: "query analyzer" for odbc datasources

I usually do sql-server programming but sometimes I also need to test and query ODBC-datasources with SQL such as Access or Progress databases. I usually do this using active server pages which I find rather obscure, and I would prefer to have a nice little program sort of like query analyzer, where I can specify the connection-string and write my SQL in there somewhere. Does anyone know of such a program?To test and query ODBC-datasources in the manner described one may use Microsoft Query MSQRY32.exe, Sql Plus, Sql *, or a variety of similar tools from packages like ER Studio, ERWin, etc.|||I posted this message in a usenet group aswell and someone came up with a neet little _free_ program that was exactly what I was looking for with alot of nice features...

-> http://www.indus-soft.com/winsql/sql

Friday, March 23, 2012

of the 8 versions of sql server 2000...

which one would I use to get used to the general interface of sql server programming on? -Standard and enterprise seem a little over the top for this purpose,
-it sounds like developer is for built for engineering 3rd party apps
-personal is geared toward roadwarriors...maybe it will work?
The programming interface is basically the same on all versions. Developer
Edition is a full-featured edition, targeted at people who build ANY apps
for SQL Server not just ISVs if that's what you mean by 3rd party apps.
Regards,
Greg Linwood
SQL Server MVP
"supernaut" <supernaut@.discussions.microsoft.com> wrote in message
news:90E5ABA4-BB05-4AB7-9CAA-85E92870B791@.microsoft.com...
> which one would I use to get used to the general interface of sql server
programming on? -Standard and enterprise seem a little over the top for
this purpose,
> -it sounds like developer is for built for engineering 3rd party apps
> -personal is geared toward roadwarriors...maybe it will work?
>
|||Beauty! Thanks for the info!
"Greg Linwood" wrote:

> The programming interface is basically the same on all versions. Developer
> Edition is a full-featured edition, targeted at people who build ANY apps
> for SQL Server not just ISVs if that's what you mean by 3rd party apps.
> Regards,
> Greg Linwood
> SQL Server MVP
> "supernaut·" <supernaut@.discussions.microsoft.com> wrote in message
> news:90E5ABA4-BB05-4AB7-9CAA-85E92870B791@.microsoft.com...
> programming on? -Standard and enterprise seem a little over the top for
> this purpose,
>
>

of the 8 versions of sql server 2000...

which one would I use to get used to the general interface of sql server pro
gramming on? -Standard and enterprise seem a little over the top for this p
urpose,
-it sounds like developer is for built for engineering 3rd party apps
-personal is geared toward roadwarriors...maybe it will work?The programming interface is basically the same on all versions. Developer
Edition is a full-featured edition, targeted at people who build ANY apps
for SQL Server not just ISVs if that's what you mean by 3rd party apps.
Regards,
Greg Linwood
SQL Server MVP
"supernaut" <supernaut@.discussions.microsoft.com> wrote in message
news:90E5ABA4-BB05-4AB7-9CAA-85E92870B791@.microsoft.com...
> which one would I use to get used to the general interface of sql server
programming on? -Standard and enterprise seem a little over the top for
this purpose,
> -it sounds like developer is for built for engineering 3rd party apps
> -personal is geared toward roadwarriors...maybe it will work?
>|||Beauty! Thanks for the info!
"Greg Linwood" wrote:

> The programming interface is basically the same on all versions. Developer
> Edition is a full-featured edition, targeted at people who build ANY apps
> for SQL Server not just ISVs if that's what you mean by 3rd party apps.
> Regards,
> Greg Linwood
> SQL Server MVP
> "supernaut·" <supernaut@.discussions.microsoft.com> wrote in message
> news:90E5ABA4-BB05-4AB7-9CAA-85E92870B791@.microsoft.com...
> programming on? -Standard and enterprise seem a little over the top for
> this purpose,
>
>sql