Wilson writes "Hi, I have Sql Server 2000 on win98, i can't retrieve any data. Instead, it shows an error, says that some files is missing or is not registered.
the mssql was reinstalled and it's goin then same.
what could be the problem? what could be the solution?"
Hi,
iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Now iam devloping a Window Appplication in which I need to populate a grid from Sqlserver2000 (dev edition) which installed on remote (i.e another network)....when i try to run my application it gives me a error tht "Unable to connect to sqlserver2005".actaully i specified in my connection string to connect to Sqlserver2000 on the remote machine.
I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine
With regards
Mahender
hiam working with VS2005(asp,c#),sql server2000.
i uploaded my application to the webserver.when i try to interact with database in my webpages.it is giving error
error:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
actually am using sqlserver2000,but it is giving error regarding 2005.how can i resolve this.
my web.config settings are like this..
<?xml version="1.0"?><!--
Note: As an alternative to hand editing this file you can use the
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in
machine.config.comments usually located in
WindowsMicrosoft.NetFrameworkv2.xConfig
--><configuration>
<appSettings>
<add key="cn" value="User ID=redot;Password=redot;Data Source=216.185.43.148:8077;Initial Catalog=redot" />
<!--<add name="redotConnectionString" connectionString="Data Source=REDOT;Initial Catalog=redot;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>-->
<!--<add key="smtpServer" value="smtp.mydomain.com" />-->
</appSettings><connectionStrings>
<!--<remove name="LocalSqlServer"/>--><!--<add name="ConnectionString" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot; Password=redot"providerName="System.Data.SqlClient" />-->
<add name="redotConnectionString" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString1" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString2" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString3" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString4" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString5" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString6" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString7" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString8" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString9" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString10" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
</connectionStrings><system.web>
<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=216.185.43.148:8077;User ID=redot;Password=redot;Trusted_Connection=True"cookieless="false" timeout="60"
/>
<compilation debug="true" />
<!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user. -->
<!--<customErrors mode="Off"></customErrors>-->
<!--<customErrors mode="On" defaultRedirect="error.aspx"/>--><!--<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />-->
<customErrors defaultRedirect="http://seafarersjobs.com/errorStatus.htm" mode="On">
<error statusCode="404" redirect="filenotfound.htm" />
</customErrors></system.web>
<system.net><mailSettings>
<smtp><network host="216.185.54.55" port="25" />
<!--password="123456" userName="redot"--></smtp>
</mailSettings></system.net>
</configuration>
can anyone help me ASAP ..pls
Thanks
Shobha
Hi,I am unable to load data in dataset via sqlconncetion object. Always i get error at ds.fill.Thanks in advance. PLS Help.Sudipta Datta www.geocities.com/dattasudipta
View 1 Replies View RelatedThe SqlServer2000 error logs go to Program FilesMicrosoft SQL ServerMssqlLog directory by default.
How can I change their location. I could change SqlServerAgent logs but did not find any help or way to change the location of these. Would anyone please help?
Thanks
Vinnie
hi... i need help.
i tried to install sql server 2000 on my laptop (WinXP os) and when i reach the form where im supposed to click "Install Database Server", the next form after clicking "Install Database Server" wont show, and there are no error messages. I tried everything i could but it didnt work. My last choice is to format my computer - but i dont want to do that.
there are two processes running on the background that has SQL in its name - SETUPSQL.EXE and SQLSTP.EXE. I think this shows that the setup is still running.
i need help asap please, and i dont want to format my computer...
thanks in advance!
I've tried to install the server part of SQL Server 7 under both win 98 and w2k professional, but both times i get an error message telling me that "The Enterprise Edition server component cannot be installed on the_name_of_the_os using this cd. Only client components will be available for installation."
Anyone got a quick and easy solution to this problem?
Thanks in advance
/Jimmy
Hello,
I recently received my free evaluation to SQL Server 7. I installed it on my windows 98 computer and I am able to
start the services to SQL server. However, when I go into enterprise manager I am unable to get connected to be able to
begin creation on a database. I am also unable to create a proper DSN connection to the SQL server database. I am doing
all of this on my local computer and I am unable to get it working I just need to be able to connect to SQL on my local computer.
Please help. I am not a beginner to creating databases I have done numerous Access databases and know how to
create DSN's but I have never done one for SQL Server 7. If any one knows how to do this please let me know or if their is
a good tutorial on how to do that.
Thank you, in advanced.
Joey
Hi all!
When installing SQL6.5 on a Win98 client, I get an error:
"A critical error has occurred. The INF SETUP has a badly formed file description line in section [UtilDLLs]. This error prevents setup from continuing."
I can use the same CD to load to any 95 or NT machine, but it chokes on 98.
Any assistance is greatly appreciated.
Thanks,
Tony Vinson
Hi!
I have tried installing SQL Server 7.0 on my Win 98 machine. My machine has all the latest service packs and I think it is reasonably up to date. I've tried installing from the disc 3 times and it fails to install:
the Server Network Utility and Service Manager.
As a result, I am unable to register my local machine as a SQL server.
Any ways around this? Quick fixes?
Thanks!
--Michelle
I have tried everything that me and the net guys could come with and still no luck. All the WinXP Pro boxes see the server, can talk to it, the whole nine yards. All the Win98 boxes simply won't. I've checked the SQL Server instance. It appears ok. I've checked my application code to be sure I was using the IP address instead of the actual server name to avoid DNS problems. Downloaded and installed the latest SQL server drivers on all but one of the Win98 machines. Same with the latest Novell drivers. Everything worked Friday (no changes to application or DB between then and now).
What else can it be?
System specs:
Novell backbone (5.x and 6.x)
Win2000 Server with multiple SQL Server 2000 instances running (including the one I'm trying to connect to)
Mix of WinXPPro and Win 98 on desktops
Win98 running Novell 3.4 client
WinXP Pro running Novel 4.9 client
Application is VFP 8 SP1
Latest MDAC (2.8) on two Win98 and 2.5 on another
Thanks for any help provided.
Richard
Hi allIs it possible to install MS SQL Client 2005 on Windows 98 ? I tried to dothis today but I got error with informations about rejects in libraries.What should I do to install it ?Thanks for your answer
View 1 Replies View RelatedQuick Question: It does not appear that SQL Server Express supports Win98.
View 4 Replies View Relatedhi there,
i have following system:
the MSDN is running on a win98 machine,
the client-applications, which uses the DB are running on winXP.
there are (SOMETIME!) connection problems to the DB, i guess because of
connection timeouts.
unfortunately i can not change the system, i only can change some setting
or install additionally components such as MDAC.
what can i do,
please help me, it is a support case for a customer.
thank you very much.
mik
I am developing a project in Vb.net
using MSDE 2000 as backend.
I want to deployment my project in win98 OS PCs.
is it possible to install msde 2000 in win98
bye
S.Muhilan
dear all,
i try to install sql 7.o std version on my developement win98 computer but
setup will give me option to create only "Program Files" folder but not "Data"
base folders(Grayed). i did it b4 on my notebook & another desktop(as i change my computer, i did not have problem.) Can some one help or suggess me what i should do?? thanks.
javid
I have some bookkeeping files that were saved using win98 backup that i need to restore to my accounting program on my winxp computer.. i have no idea how to do that. The files that are backed up belong to the same program on both the win98 and winxp.
View 1 Replies View RelatedHi, I have a little question regarding
SQLServer2000 vs ADO of Visual Basic 6
In a code snipplet a have something like:
Conn1.BeginTrans
Set rec_tmp = Conn1.Execute("SELECT * FROM IDENTIFICATIONS;")
Conn1.Execute "DELETE FROM CARS WHERE CAR_ID = 8;"
.
.
.
Conn1.CommitTrans
and whe VB tries to execute the line with the
DELETE sentence the Err object says something like:
"cannot create a new connection because you are in
distributed or manual transaction mode"
However, if I remove the line that executes the sentence
SELECT * FROM IDENTIFICATIONS the error never shows up.
Seems like I can´t execute a SELECT before a DELETE/UPDATE
even if I execute the SELECT in some other table.
I´ve tried changing the IsolationLevel, Mode and Cursor
Location properties and the error always occurs.
Furthermore, I tried putting the SELECT out of the
transaction and the error continues showing up.
Why does this occurs? Is there a way to solve it?
NOTE: I need forcely to execute that SELECT before the DELETE.
Thanks for the time
Roland
Hi, I have a little question regarding
SQLServer2000 vs ADO of Visual Basic 6
In a code snipplet a have something like:
Conn1.BeginTrans
Set rec_tmp = Conn1.Execute("SELECT * FROM IDENTIFICATIONS;")
Conn1.Execute "DELETE FROM CARS WHERE CAR_ID = 8;"
.
.
.
Conn1.CommitTrans
and whe VB tries to execute the line with the
DELETE sentence the Err object says something like:
"cannot create a new connection because you are in
distributed or manual transaction mode"
However, if I remove the line that executes the sentence
SELECT * FROM IDENTIFICATIONS the error never shows up.
Seems like I can´t execute a SELECT before a DELETE/UPDATE
even if I execute the SELECT in some other table.
I´ve tried changing the IsolationLevel, Mode and Cursor
Location properties and the error always occurs.
Furthermore, I tried putting the SELECT out of the
transaction and the error continues showing up.
Why does this occurs? Is there a way to solve it?
NOTE: I need forcely to execute that SELECT before the DELETE.
Thanks for the time
Roland
date(m/dd/yyyy)9/18/2006 In this above table i want to select only the month in this format Sep 2006 . How to do that ?
View 1 Replies View RelatedHello everyone,My project (asp.net and sqlserver2000) is working fine in my intranet. But sometime, it cannot connect to sqlserver, it shows "SQLServer does not exists or access denied". If I restart my dbserver and webserver, then it again works fine.Please give me a solution.
View 1 Replies View RelatedHi,
I have created the below procedure in SQL SERVER 2005.
But when I copy out the same in SQL SERVER 2000. I get an error at the underlined place. It says
Line 32: Incorrect syntax near '('.
ALTER procedure [dbo].[VTELcardvalidation1]
@CardValue1 int,
@CardValue2 int,
@CardValue3 int,@Result nvarchar(50)output
as
begin
declare @CrdPinNo varchar(100)
declare @CrdNo nvarchar(100)declare @count int
declare @inc int
declare @concat nvarchar(200)create table #temptable(crno nvarchar(50),pno nvarchar(50))
--First Card
--Change here
select @count=count(cardno) from vendorcardvalidation where cardvalue=1500 and flag=0if (@count)>@CardValue1
begin
declare cur1 cursor forselect top(@CardValue1) pin,cardno from vendorcardvalidation where cardvalue=1500 and flag=0 order by cardno
open cur1fetch next from cur1 into @CrdPinNo,@CrdNo
while(@@fetch_status=0)
beginupdate vendorcardvalidation set flag=1 where cardno=@CrdNo
insert into #temptable values(1500,@CrdPinNo)fetch next from cur1 into @CrdPinNo,@CrdNo
endclose cur1
deallocate cur1
set @Result='Success'end
else
begin
set @Result='Failure'
end
select * from #temptable
drop table #temptable
end
It seems the the word 'top' will not be supported in sqlserver 2000. What should I do?
Regards
cmrhema
Sir,i am running .net1.1 on my system with sqlserver as my database.I am devaloping an e-trading project in ASP.NET with VB.net.My problem is that,I am not getting the correct syntax to query the database with SELECT(with WHERE clause)in vb.net.Please help me.
View 1 Replies View RelatedHi,
I would like to create groups in SQLServer2000.Do i need to do this by roles or can i create groups for each database.I read some where that there where
no groups for SQLServer7.0. Is this option available for the latest versions.
Any help will be appreciated.
Thanks in Advance.
Ran.
I turned the Audit ALL option on SQLServer instance "security" tab and restarted the SQLServer but do not see any information logged in SQLServer Logs though I tried to access databases and logged in a couple of times through Query Analyzer. Why is that no logging happened and how can I get this fixed?
Any help is appreciated.
Vinnie
Hai
I wrote a sp in sqlserver2000 and sp consists of 1 input parameter of type datetime and everything is working fine but if i pass the argument of invalid date format it is giving error.Is there any way to handle errors in sps and even if i give invalid format it should not raise errors.Pls reply as early as possible.
Thanks
Aruna
More of a SQL Server problem than a ASP one but hope you can help me :)
Im tryin to do my first data based application using ASP.net and silly me I forgot to add users when I created then database so now Visual Studio can't access it.
Can someone tell me the syntax to add/create a user to MSSQL database so I can then grant them privelidges to the tables.
thanks very much
Tom
hi all,
my problem is failure in the connection to SQLserver2000 remotly( to city a) by enterprise manager or query analyzer via windows authentication ( this error appears "login failed for (domain/user)" ),while no problems happened in the connection when i would to connect to other servers at other locations(to cities b,c) via windows authentication.
note that i can access to (city a)server via sql server authentication , but i want to access to this server(city a) via windows authenication as the other locations because this authentication mode is policy of our system, and note also that persons in city b can access to all servers (city a,c) via windows authenication .
regards,
Hi,
If access database has an extension of .mdb then what is sqlserver2000 file extension?
Hi all,
I created a database maintenance plan with backup + transsactionlog backup+optimizations. The first two jobs work fine but the Optimizations job is failing with error:
sqlmaint.exe failed. SQLSTATE 42000, Error: 22029. The step failed.
User is admin on local box and "sysadmin" in db server role. Any suggestions to resolve this?
Thanks
Vinnie
When I click on Enterprise manager->Database this is the error I am getting:
A runtime error has occurred. Do you wish to debug. Line 306 Error: unspecified error. Yes/No
This is happening on user databases only not the SQL standard dbs; pubs,master,northwind.
How can I fix this?
Thanks for any help.
Vinnie
Hi All,
I understand I can use Index tuning Wizard to index a DB. I understand as well I have to feed it with a workload file, which is a collection of queries. I do have a limited number of stored procedure (150-200 in total) being constanlty executed against this DB (around 700MB).
Can I generate a workload file with these storedprocedures optimizing so the DB for their execution?
If yes, how? can someone point out some good tutorial about this?
Any help would be much appreciated,
JI
I created table with "id" field as "uniqueidentifier" (primary key).I connect via ODBC from MS-Acces.-->>> Don't know how to something like "Autonumber" in MS-Access.Let me know If any trigger or something like this is required.Please post some code of trigger if need.Until now I have only developed some native MS-Accessdatabases. I hope there is some solution about "Autonumbering records"in SQLServer.SqlServer 2000, Access Xp.Marek Bħbski
View 2 Replies View Related