|
It seems that I'm out of date. (I hope I use correct word,my english is not very good.)I have to do something for myself.;)
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
I use Query Analyzer and like it a lot better than Enterprise Manager.
Andy Gaskell, MCSD MCDBA
|
|
|
|
|
Doh. I've been using it with the object browser window hidden.
I am a dumbass. Thanks for pointing it out, that is much better for editing stored procedures.
Michael
|
|
|
|
|
hi all,
I got the following error while running the asp page that makes use of Stored Procedure .What might be the problem ????
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method:
'CreateParameter(...).Append'
thanks
|
|
|
|
|
Could you give more details? When you use a command object, you usually need to do something like:
set cm = server.createobject("ADODB.Command")
cm.Parameters.Append cm.CreateParameter(...)
HTH
Wanderley
|
|
|
|
|
I'm using ADO to interface with MSDE (Microsoft SQL Server 7) but I still have some doubts:
1. What the 'sa' UserID ? Can I use it from my app ?
2. How can I create new accounts (userid+password) for the SQL Servers ? (no NT accounts) I have scanned all options of the "osql.exe" utility but I have found nothing.
Thanks in advance.
|
|
|
|
|
Frankesk wrote:
1. What the 'sa' UserID ? Can I use it from my app ?
Administrator. Don't use this for normal stuff, as it gives complete access to the database. e.g. create\delete databases, tables, etc. Equivelant of logging into the NT Machine as the local admin.
Frankesk wrote:
2. How can I create new accounts (userid+password) for the SQL Servers ? (no NT accounts) I have scanned all options of the "osql.exe" utility but I have found nothing.
Well I don't know about the MSDE extact, as I usually develop on a copy of SQL Server with the Enterprise Manager - which is a GUI front end with wizards etc to create new DB's, tables, Views all the way to new users and roles.
Otherwise you may have to do it programatically.
On Windows 2000, goto the Control Panel, Admin Tools, Server Extensions Admin. From the menu Add\Remove, and then add from the botton of the dialog. Choose Micorsoft Enterprise Manager.
From there you can then administor the Server though the MMC pluggin.
Hope this helps,
Giles
|
|
|
|
|
I'm going to search for the XP version of the admin extensions, if they exist.
Thanks.
|
|
|
|
|
Frankesk wrote:
1. What the 'sa' UserID ? Can I use it from my app ?
This is the administrator account in SQL Server. You can use this if you want, but its probably best to create a user with the minimum set of access rights required to do what you want.
Frankesk wrote:
2. How can I create new accounts (userid+password) for the SQL Servers ? (no NT accounts) I have scanned all options of the "osql.exe" utility but I have found nothing.
Have a look at sp_adduser and sp_addlogin in the BOL.
Dave
|
|
|
|
|
Recently i meet with a problem:
I want to store a word document into SQL SERVER and the field is image,but don't select from SQL SERVER.How can i do?
thanks!
|
|
|
|
|
Could anyone suggest how to get a list of SQL servers and a list of databases using ADO.NET?
In VB6, SQLDMO could be used for this, but how it is done in .NET?
Any help would be appreciated.
Thanks,
Denis
|
|
|
|
|
spbdenis wrote:
In VB6, SQLDMO could be used for this, but how it is done in .NET?
You can use SQLDMO from .NET: SQLDMO For C#[^]
|
|
|
|
|
I have a program which execute a procedure through odbc.
and the procedure is a big one, that takes several hours to
execute.
And the problem is that the my environment of the network is some bad, and during the long time of the execute, there would have an broken. and then the procedure will be return as an fail.
Can anybody has any ideas? please told me, Thanks in advance!
i am realfly8)
|
|
|
|
|
ummmmm maybe a dumb one but how does one execute an .exe from a sql batch in a stored proc for example?
any help qppreciated
---
"all's fair in love and war but in love there is no geneva convention"
|
|
|
|
|
Check out "xp_cmdshell" in SQL Server BOL.
Andy Gaskell, MCSD MCDBA
|
|
|
|
|
thanks andy
---
"all's fair in love and war but in love there is no geneva convention"
|
|
|
|
|
My program about ADO run correctly on my machine,but it can't correctly run on the machine whithout VisualC++ IDE. I find it runs the following statment:
_CommandPtr cmd;
_ConnectionPtr conn;
.......................................
cmd->ActiveConnection = conn;/Error occurs
I don't why.Can somebody help me!
Thanks very much!!
VCBeginer
|
|
|
|
|
Forlegend wrote:
it can't correctly run on the machine whithout VisualC++ IDE.
Maybe the problem is because you don't have MDAC on that machine.Are you sure about it?
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
Oh! I get it. Thank you again!!
VCBeginer
|
|
|
|
|
I can't run the code from the articles from CPj site. I haven't msado15.dll.
I have downloaded and installed MDAC 2.7.
I'm running WindowsXP. VC6 + SP5. MSDE + MSSQLServer 7
|
|
|
|
|
I'm sure it's somewhere on your system! Use the windows find utility to have a look for it. When you find it, copy it to c:\winnt\system32 and then from the dos prompt
cd to c:\<insert your="" win="" dir="" here="">\system32
regsvr32 msado15.dll
To unregister it, go back to the system32 directory, and type
regsvr32 -u msado15.dll
I'm running Win2k Pro, so I've never used XP, so I'm not sure what it calls the windows directory, but I'm sure you can figure it out! Good luck!
skydiving....if at first you don't succeed, you're fecked!
|
|
|
|
|
I found my copy of msado15.dll in c:\Program Files\Common Files\System\ado\
You should have it, but if you don't, drop me a mail...
skydiving....if at first you don't succeed, you're fecked!
|
|
|
|
|
Oh, thanks a lot, you have saved me... I used "Find" but nothing showed up (...)
I found it in c:\Program Files\Common Files\System\ado\ as you wrote.
Thanks again
|
|
|
|
|
Hi,
I’m working on a project for university and need some advice. Here is an idea of what it is about. “You are hired by a company with the following problem. They need an administration system for their independent employees and for their members. This company sells various kinds of batteries through a complicated sales hierarchy. The company has a few bosses. Each boss has a team of managers that works under him. Each manager has a team salesman than work under him. The salesman sells batteries to clients. Design a visual basic 6 application (using an access db) and design a basic administration system for this company. The administration system must keep track of the following data, all bosses and their managers, all managers and their consultants, all consultants and their client. You also need to store address and contact details for employees as well as information about the training they attend while working for the company.”
I have a few ideas on how to design the hierarchy but don’t know if it’s right.
What would the best way be to design the tables?
Thanks
|
|
|
|
|
Is Easy, you need to create a table of bosses, anhoter table for manager, another for salesman and other for clients.
Then you need to crete a table that inform the realation between bosses and Managers, other with the realtion with manager and salesman, and in the last one the relation between salesman and clients. With the correct FK you can control all the information.
For example.
One Bosss have several managers. Each manager have several salesman. and finally each salesman have several clients. With a simple and good query you can display all the information, and explot it. For example the Info of each client or each Salesman, etc.
Best Regards....
SSSHHH!!! take care because Toammasz Sowinski desagree with the homeworks....
Carlos Antollini.
Sonork ID 100.10529 cantollini
|
|
|
|