Database

FirstPrevNext

Re: More Background info trev777727-Feb-09 4:01 trev7777 27-Feb-09 4:01  Hi there.... I'm connecting via OLEDB 4.0; Username and PWD are blank (in fact, they're not listed in the xml file that was generated, merely a "Persist Security Info=True" line there; MS-Access ver 2003; Crystal Reports ver 10; VS 2008 Pro. Many thanks. Re: More Background info trev777727-Feb-09 4:03 trev7777 27-Feb-09 4:03  Oops, almost forgot. I've tried leaving the username and password blank when prompted. Re: Access mdb Eddy Vluggen27-Feb-09 4:52 Eddy Vluggen 27-Feb-09 4:52  Can you try this one? Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=; I are troll Re: Access mdb trev777727-Feb-09 8:47 trev7777 27-Feb-09 8:47  Hey there.... tried and still get the "login failed" ... I can't find anything else in the connection string that causes it to do that...I'll admit it's interesting Re: Access mdb trev777727-Feb-09 8:57 trev7777 27-Feb-09 8:57  I'm gonna try rewriting the connection string and see what I get.... Re: Access mdb Eddy Vluggen27-Feb-09 9:27 Eddy Vluggen 27-Feb-09 9:27  Have you considered reinstalling the drivers[^]? Can you post an example of your connectionString? I are troll Re: Access mdb trev77776-Mar-09 5:15 trev7777 6-Mar-09 5:15  Hey there, Sorry for the late reply and I very much appreciate the help. I decided to use an SQL db instead and haven't had any problems (though I admittedly haven't been able to figure out what the problem was with the Access db). Anywho, thanks everybody for the ideas!!!! trev LOG file growing unexpectedly Aman786Singh27-Feb-09 0:45 Aman786Singh 27-Feb-09 0:45  Month before, One of my database size was 15GB. But today i have looked it , it grows to 35GB. In which MDF(Data file) Size is 13603584 KB and LDF(Log File) sixe is 39793536 KB. after analyzing it for a few hours i had seen growth of Log files is so fast. i ran sp_dboption '<dbname>', 'trunc. log on chkpt.', 'TRUE' CHECKPOINT use master Go EXEC sp_configure 'show advanced option', '1' RECONFIGURE EXEC sp_configure USe <dbname> GO DBCC SHRINKFILE (<dbname>_LOG, 1) GO But it does not help me. kindly let me know how to truncate it or How to reduce log file size.?? thanks in advance. Re: LOG file growing unexpectedly Eddy Vluggen27-Feb-09 4:58 Eddy Vluggen 27-Feb-09 4:58  SQL Server tries to protect you, by remembering what you did to it's databases. Or your databases, depending on your point of view Read this[^] to understand why this happens. Read on here[^] for some remedies. I are troll set permission for user at particular database Guvera27-Feb-09 0:40 Guvera 27-Feb-09 0:40  Hi friends, I am using asp.net 2.0 application & ms server 2005. Using sp_addlogin,sp_adduser and sp_password I create a login and set username and password for particular database.While i connect my sql server i give login(not default login sa) name example itect and give password ****. I set permission to user for particular database. While i login i didnt access all the db.I can accessed only that what permission i gave for db.Its working fine. What my question is while i login at a particular login name and password i need to show in my ms server 2005 as a particular db only. suppose i give permission user 'Guvera' to db 'dbmap' means can i show only dbmap??? Unfortunately in my ms server i see all db but i cant access. Shall i show only my access db ?? Is it possible?? Please clear my doubts. If any mistake in my doubts, plear tell what is it?? Every Successful Person Have A Painful Story Inconsistent view behaviour hairy_hats26-Feb-09 23:51 hairy_hats 26-Feb-09 23:51  We've had a view working fine in SQL 2000 which has one field (used for sorting) which is defined by calling a function that returns a text string. In SQL 2000 you can either run the query in Design View or select Open View and it works the same in both cases. In SQL 2005 if you run the query in Design view it works fine and the data is sorted correctly, but if you just do Open View to see the data then the data isn't sorted. Any thoughts? TIA. how to get the table scripts as each sql file lakshmichawala26-Feb-09 21:06 lakshmichawala 26-Feb-09 21:06  iam using sql script wizard to script the table scripts of my table ...iam succeeded in this case and my getting all the table creation scripts in one .sql file but how can i get each individual script ie one creation script one .sql file like that is it possible Re: how to get the table scripts as each sql file J4amieC26-Feb-09 21:55 J4amieC 26-Feb-09 21:55  There is an option in the wizard for "1 file" or "1 object per file" Re: how to get the table scripts as each sql file lakshmichawala26-Feb-09 22:07 lakshmichawala 26-Feb-09 22:07  hi mr i tried but i didnot find will u plz guide where it is Re: how to get the table scripts as each sql file J4amieC26-Feb-09 23:51 J4amieC 26-Feb-09 23:51  Im using SQL 2005 - if you have another version you're on your own. Right Click database > Tasks > Generate Scripts Follow wizard until the page titled "Output Options" Script Mode > Script to File > Files to generate > File per object Re: how to get the table scripts as each sql file lakshmichawala26-Feb-09 23:58 lakshmichawala 26-Feb-09 23:58  hi i tried the same what u said but iam unable to get the option of Script Mode > Script to File > Files to generate > File per object in my sql server version tat is the last one file per object iam unable to get Re: how to get the table scripts as each sql file J4amieC27-Feb-09 1:17 J4amieC 27-Feb-09 1:17  There has been an option to script objects to separate files in every version of SqlServer ive ever used (6.5 onwards). If you are unable to find that option by reading each page of the wizard I suggest you go for another career - one that does not involve using your eyes or brain. Getting error too much 'Error: 18056, Severity: 20, State: 23'. Tarun Dudhatra26-Feb-09 20:34 Tarun Dudhatra 26-Feb-09 20:34  Hello Dear, We developed one project nameed Richmedia. We are servering advertising banner on in.msn.com. So when msn page call from any corner of the world it will ping our server on proirity base. Our database is Sql Server 2005. We have optimised all dotnet code after we came to know about that in SQL Server LOg File there are lots of error. And all error is like same Error: 18056, Severity: 20, State: 23. 2009-02-20 17:53:25.07 spid249 The client was unable to reuse a session with SPID 249, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message. Can Anyone tell me why I am getting this error frequently? Any help would be appreciated. TarDak prevent database from restore Ebube26-Feb-09 7:16 Ebube 26-Feb-09 7:16  Hi am working on application that most be highly secure how can i ensure that if somebody broke into the database and backup he canoot restore on another machine how good is .net encrption. i want to be sure that people canoot crack the password over the network i need help please Row data needs as Column data rajg8226-Feb-09 2:52 rajg82 26-Feb-09 2:52  Hi All, Currently I have the following dataset: Name UserEmailId RoleName RoleID A A@A.com Admin 1 A A@A.com Dev 2 A A@A.com Tester 3 NOW I WANT THE ABOVE DATASET AS: Name UserEmailId RoleName1 RollName2 RollName3 A A@A.com Admin Dev Tester OR Name UserEmailId RoleID1 RoleID2 RoleID3 A A@A.com 1 2 3 Please provide the solution. Thanks Rajesh Ram raj Re: Row data needs as Column data J4amieC26-Feb-09 3:06 J4amieC 26-Feb-09 3:06  rajg82 wrote: Please provide the solution. Thanks The solution is to properly define your table structures in the first place. User Table UserId, Username, Email Role Table RoleId, RoleName UserRole Table UserId, RoleId Re: Row data needs as Column data rajg8226-Feb-09 4:48 rajg82 26-Feb-09 4:48  Hi J4amieC Yes, I have the same table structure what u mentioned. thx. raj Re: Row data needs as Column data Mycroft Holmes26-Feb-09 19:08 Mycroft Holmes 26-Feb-09 19:08  I think you may be looking for a pivot table clickety[^] Never underestimate the power of human stupidity RAH how to read the xml data from sql server icanmakeiteasy26-Feb-09 0:29 icanmakeiteasy 26-Feb-09 0:29  hey can any one tell me how to read the xml data from sql server.... thanks in advance icanmakeiteasy Re: how to read the xml data from sql server J4amieC26-Feb-09 0:48 J4amieC 26-Feb-09 0:48  1) Open a connection 2) Issue a SQL Command using one of the FOR XML commands or read froma n Xml column 3) Close Connection Further reading[^]

Last Visit: 31-Dec-99 18:00     Last Update: 9-Jun-24 11:49 Refresh ᐊ Prev1...895896897898899900901902903904 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.