Hi,
I created a DSN coonection to a SQL db and I have to use windows authentication. I was able to login under the computer's administrator account, but when I login as regular network user I got this error:
Connection failed:
SQL State: "28000"
SQL Server Error: 18456...
I understand I cannot install MSDE in computer that has SQL Server. What about the client ones? If I have a computer that only has SQL Server client network utility, can I install MSDE? Would it mess up the client utility and whatever applications that utilize it? Thank you for your time!
Hi,
I've been installing MSDE 1.0 in different computers that have Win98. Most of the installations went fine. However, I received "installation failed" on a few computers. I checked the errorlog file and it didn't tell me much except for "failed to get sqlservr image...
My user is using XP and has 20+ GB free disk space. But when unpacking msdex86.exe for installation the system complains "not enough disk space". Any idea what went wrong? Thanks!!!
I need to output the image from SQL server with ColdFusion interface too. However, my problem is that instead of storing the image's path in the field, I store the actual image in the field (no other option for me). Anyone know how I could output the image with ColdFusion? Thanks a million!
Yes it is a vb front end and sql server database. I do have the appropriate licenses. My problem is I am confused by how to use MSDE. Some of my questions are:
Does MSDE take my sql server database and install it into my clients' machines? or it basically replicates my sql server db?
Can I...
They don't have VB software either. My program is a standalone application. The clients will be getting a CD from me, install the software, and then use the application. It seems to me that MSDE is the only option I have, right?
I've developed a VB program with sql server 2000 database for my clients who do not have sql server software on their machines. I've read a lot of articles about MSDE 2000 but am getting confused. My question is, when my clients install my program, they'd have to install MSDE at the same time...
My program reads a Spanish text file and extract data and write it into a new text file. However, the program turns all the special characters into English characters when it write into new file. Anyone knows what went wrong? Thanks!
I have a stored proc that takes a parameter from the program and return a set of data. I can pass the parameter using ADODB.Command, but not ADODB.Recordset (there's no option to pass parameter). Is it even possible? If not, what's the better way to do it?
I'm using SQL server 2000 and have the following stored proc:
CREATE PROCEDURE sp_get_info
( @getID smallint,
@getContent varchar(500) OUTPUT) AS
DECLARE @rc Int
SELECT @getContent = tableB.contentDescription
FROM tableA, tableB
WHERE tableA.pageID = @getID
AND tableA.typeID =...
Yeah I used the command prompt window. I was following this http://www.mssqlcity.com/Articles/KnowHow/Textcopy.htm
What I'm trying to do is to store image into a database. The database is for a VB program. The database is read only.
I was trying to store an image using textcopy.exe. I enter all the correct info and the screen just disappear. No error message but the image is not stored. Am I using the correct method to store image?
Hello! First time poster so I hope I'm posting in the right forum. I have a standalone VB program that used to use Sybase as the DB and the program was distributed to the clients (all they needed to do was to install my program, no need to have Sybase). Now I have to do the same thing with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.