| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> wen i try to access the db
<1> nikkie:: maybe that user doesn't have a remote access privilege granted
<1> Bronso:: well that's a tough one. but since i don't know much about sql 2005.. hmm
<0> the permissions are set the exact same from the old server box that works still.. and the new one
<1> maybe the network setup for the sql server wasn't set correctly hold on a sec
<0> ok
<0> i hav gotomypc as well if ur willing :D
<1> nikkie:: have you allowed using "TCP/IP" protocol on SQL server netowkr utility?
<0> yes 1433 port
<1> try to change "Provider=sqloledb" to "Providerr={SQL Server}"
<0> k one sec
<1> well i am not sure what the problem is exactly.. just something i might or might not do if that happens
<0> keep the " ?
<1> TDD(Test Drivent Development) using Unit-testing requires me to remember so many god damn acronyms
<1> nikkie:: only the beginning and the ending ones
<1> by the way, s/Providerr/Providerr
<1> i messed up my spelling tahnks to this cheap Infrared wireless keyboard from Microsoft
<0> hehe
<1> s/from/by
<0> page wont even load now
<0> would u mind hoppin on my pc remotely to take a peak? ive spent the last 8 hours tryin to find it
<0> d2d?
<1> bah. i say that you reinstall your SQL server for now :) i am doing some other testing
<0> np
<0> already did that 3 times
<1> btw, what language are you using to connect the database?
<0> enterprise
<0> oh
<0> javascript i thnk it is
<1> uhm.. that's not cool. but then are you using ADO or ADO.net to connect?
<0> im not sure.. our former IT created this
<0> just bugs me cuz it works on the old server box
<0> but not this new one
<0> yet the settings are identical
<2> then the settings are *not* identical
<0> ty i realize that
<0> but i cant find where they *aren't*
<2> nikkie : what *exactly* are you trying to do, and what *exactly* is the error?
<1> <sarcasm>wooo wee i am going to Burger King for lunch!</sarcasm>
<0> one sec ill show u the actual page
<0> just rebootin
<2> what do you mean by 'actual page'?
<0> ok i have an .htm file looking locally for the mssql db
<0> inside the htm code is this...
<0> Provider=sqloledb; data source = (local); initial catalog = avtronics; user id = avlogger; p***word = p***word
<0> i submit to try and connect to the DB and it gives me an error page
<0> in the log i find.. "avlogger_access_denied
<2> nikkie : next time you say 'it', you get a kick/ban
<0> avlogger is setup in the DB users and security area with all the permissions set
<0> :/
<2> so, what happens if you create an odbc datasource and use that to test the connection to the database?
<0> how do i do that
<2> do what?
<0> creating an obdc datasource to test the connection.. i have never done that before
<2> which os?
<0> server 2003 sbs
<2> ffs
<2> control panel, admin, data sources
<0> well i created one using similar settings and it tested successfully
<3> ownage
<3> i wanted to go to Burger KING myself but someone bought buncha brunch sandwiches... gosh this tastes awful
<0> meh
<4> hi
<5> hi
<4> w***up?
<5> gas prices
<4> pretty quiet in here
<4> heh
<5> no. everyone else just doesnt want to talk to you
<5> they say you gossip
<5> why would it be bustling with activity on 2pm on sunday?
<4> i do
<4> you look fat in those pants, btw
<5> those arent pants. i just have hairy legs
<4> because the world is full of dorks with nothing better to do?
<4> oh, you just look fat then
<4> i was going to ask a question, but i actually found it on google first
<4> (i'm sure you're disappointed)
<4> i guess i'm just here for the entertainment now
<4> so much for that theory
<6> i have a Categories table and a posts table that have CategoryID connected to the ID of the Categories table how can i take out one post form each category by Date field on the Post table
<6> any1 ?
<2> HMS : what do you mean by 'take out'? which rdbms?
<5> hms is this mysql?
<6> access
<5> dont use dates as your primary keys
<6> take out = show
<5> it gets a bit unruly with less thought out applications
<6> amm i dont undestand
<5> what if you have 2 entries submitted around the same time?
<6> ie i have forums and i want to show the most resent posts
<5> access dates dont handle second or millisecond well
<6> 1 post from each forum
<6> ya i sow that
<5> order by datefield desc
<6> i did select top 1 id from t Ordery By dDate
<6> and i got 4 results
<5> whats t?
<6> ?
<6> -y
<6> table
<5> so you want the MAX :P date
<6> amm ya
<6> but how can it be that i get 4 results ?
<7> Any partiular reason you're not using the max() function?
<6> nop
<6> didnt thought about it
<6> ok
<6> but still
<6> thats not the post
<6> point
<6> i got many posts from the same forum
<6> or categorie
<6> any idea ?
<6> Jarett_ ?
<5> i dont expect any consistency from access
<7> Oh, access. God knows.
<6> amm ok
<6> and if it was mssql?
<6> what sould be the query ?
<6> http://img405.imageshack.us/my.php?image=relations5dq.jpg - thats the tables and the relations
<6> any1 ?
<8> nice topic
<9> now, why would vix dcc me a rar file when i joined the channel?
Return to
#sql
or
Go to some related
logs:
#politics
#stocks
brutefore url
#worldcup
bootini
#worldcup
+onfocusedrecordchange
#winvista
failed to open /root/.cvspass
#politics
|
|
