| |
| |
| |
|
Page: 1 2
Comments:
<0> but mysql 5.0 allows for normal sql
<0> well, sort of
<0> closest they've gotten yet anyway
<1> we need to fight against it
<0> I think the mysql guys do that fight best themselves
<0> I've been in meeting where a company was laughed out of the room because they suggested using mysql for an enterprise solution
<2> @ whynomysql
<3> whynomysql = because we said so ;it's probably easier to answer the question yourself by asking 'Why am I using MySQL?'
<4> Is there a free database engine works better than mysql 5.0?
<2> postgres
<2> @/ postgres
<3> Search on postgres returned: rdbms pginstaller
<0> depends on your criteria
<2> @ pginstaller
<3> pginstaller = http://pginstaller.projects.postgresql.org/ a windows postgresql installer
<2> forgot I put that out there
<0> if you're doing windows, personally I would say Microsoft SQL Server 2005 Express
<4> LVK: I just want standard SQL instructions to work with all the latest stuff like recursion.
<2> oracle and IBM are both free in that respect too
<0> recursion? that's platform dependant
<5> http://www.break.com/index/weresinking.html
<0> many of the latest versions of the engines support recursive queries now, but the syntax differs
<2> there is no "standard" recursion
<4> Oh, it would still be nice to have.
<4> Windows are so complicated that SQL should have book or at least tutorial to deal specifically with overlapping windows. Every time I search for one on google I get "working with SQL in windowsXP" as a result
<5> Windows are so complicated that SQL should have book or at l
<5> you should first learn the difference between
<5> SQL
<5> MS SQL
<5> Oracle SQL
<5> MySQL
<5> and then learn the difference between searching with different phrases
<5> and then try grasping some comprehension and some research skills would help too
<6> Arrakis your enter key is not a replacement for the space bar
<2> seems to be
<7> or a comma
<5> Commas are totally overrated
<8> or breathing
<4> You guys allow Arrakis to post flamebait?
<5> yeah, but i like breathing
<5> that's not flamebait
<5> thats honesty
<4> that's more flamebait
<5> now try learning the difference between flamebait and honesty/Analysis
<1> arrakis does what he likes
<1> and no one can stop him
<5> Mwuahahah
<5> Mwuahahahha
<4> Quant: Can I do what I like without anyone stopping me too?
<1> you could try
<5> hey
<1> no guarantees though
<5> u stole my line :(
<5> :p
<4> Hey LVK you have no research skills according to Arrakis b/c you couldn't solve the SQL problem either.
<4> I'm outs, laters y'all.
<2> I hate you guys
<1> what happend cooj
<0> Well, personally I thought I did solve the problem
<0> but who cares
<0> it was not *my* problem :)
<9> i have ACT 2005 database, which uses MSSQL, I'd like to export my data to use in another application, but ACT's export tools are crap
<9> and i dont know how to directly query this database
<9> ACT export only provides contact info, and doesnt export notes/history
<0> do you know SLQ?
<0> SQL I mean
<2> when did act start using mssql?
<9> cojoNEs version 7 i think
<9> yes i know sql well, just not mssql
<9> i think act uses a 'lite' version of mssql
<9> it has no query tools
<9> "Each copy of ACT! 2005 Premium includes a license of SQL Server 2000 Standard "
<9> "ACT! 2005 program code has been rewritten. ACT! now is using Structured Query Language (SQL), which provides a relational database (instead of dBase code which provides a flat database)."
<9> i can buy this, http://www.jltechnical.com/ACT7Export.htm ... just thought there has to be a way to get the data from sql server
<2> you just want to query the db?
<2> get toad for sql server
<2> it should work
<9> ok
<0> or just download the trial of sql server (or perhaps even sql server 2005 express)
<9> toad found the database but i'm having trouble authenticating
<9> ACT is such a PITA ...
<2> im sure its not the same as your login to act
<9> no, windows auth for administrator doesnt work either
<10> !info warez
<1> heh
<2> have you checked the act support sites?
<0> z4M04: "warez" is not found in any of the lists, please try again
<9> ya, the company ****s all around
<9> decent support info, but everything requies a login and nothing is easy
<9> they try to force the paid support ... who will tell you what the manual says
<9> http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic834.aspx
<9> looks impossible
<9> Anyway, regarding SQL access in Act!7 (aka 2005) - you can't do it. Period.
<9> During the install process, a script is run that removes administrator
<9> access from the SQL instance. This same script is found within one (or
<9> more) of the DLLs that come with Act!
<9> now here's from ACT documentation, The Reset SQL P***word button allows the machine user to reset the local SQL p***word (sa)
<9> whenever he or she needs to, for example, for security reasons. It does not allow you to
<9> determine the SQL p***word, nor does it provide you with the SQL p***word.
<6> ...ok
<6> no spam
<9> sorry, thanks for your help, toad is pretty sweet
<2> good luck
<6> you're welcome
Return to
#sql
or
Go to some related
logs:
aaron north roadie nin guitar tech
#beginner
#beginner
#gentoo
#politics
#beginner
#nhl
#politics
#politics
#solaris
|
|