URGENT-&>conection Problem Between App. Server - Data Base

Feb 18, 2004

I need solve this problem. I have this software running at 2 locations (1 and 2)

- the 1) got a app server and the data base, in the same computer;

- the 2) got a app server, acessing the data base of the 1)

- the conection between the two is all right, like a local network, by air.

- at 1) it runs all right, but the 2), when have to acess the data base (at 1), the conection becames too

slowwwwwwww.... impossible to work

Somebody acess data base via internet, or acess a data base that stay phisically away from the app server ??

Could it be a data trasmisson protocol problem ???

sorry the language errors ... thats the best i can :) hehe

thank you , since now

Júlio

View 4 Replies

SQL Server 2000 - Conection Could Be Not Be Established

Feb 6, 2006

When trying to connect to my SQL Server I'm getting the following error:

******************************************

A connection could not be established to (local).

Reason: Logon failed for user.

Please vertify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (local) node) and try again.

******************************************

SQL Server is definately running, but I'm unable to connect.

I've tried changing the ODBC settings but I can't get past the "MIcrosoft SQL Server DNS Configuration" window. I choose "With Windows NT authentication using the network lognin ID" and click "Conect to SQL Server to obtain default setting for the additional congiruation options" and click "Next" but I get stopped by the following error:

connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user machine1Administrator'

Does anyone have any ideas on what I need to do to fix this? If it helps, this all seems to have started occuring since I changed the Administrator password

View 4 Replies View Related

Access Data Base To SQL Server Managment

Dec 15, 2006

Hi all,

I have a data base made in MS access and i wanted to know if it is possible to import it into MS SQL server management. If it is possible could somebody write an example, from which i can learn how do i do that?

Thank you for your time and help
Best regards,
BoSCHoW.

bOSTJAN

View 5 Replies View Related

Connecting To Data Base In Sql Server 2000 - ActiveX Script Of A SQL Job

Jan 21, 2008

Hi All,

I' m trying to execute activeX script from a job. I could do it successfully. But when i tried to access data base the job is failed when running.

My Requirement : I would like to send a mail in a scheduled base using a job and activeX script.

I could send a mail giving static parameters. But as i need to make the parameter values of activeX script dynamic, i tried to connect data base and retrieve the required data as shown below.
When i parse the script it showed success.But this is failing when it is running.

while creating a job i had selected ActiveX script option with vbscript language
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Set con = Server.CreateObject("ADODB.Connection")
con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=welcome;Initial Catalog=MyDatabase;Data Source=(local); "
Set rs = Server.CreateObject("ADODB.Recordset")
Set rs = con.execute("select fromid,toid,seqid from MailsLog where status='N'")
while rs.eof <> true
con.execute ("update MailsLog set status='Y' where seqid = " & rs("seqid"))
wend
set rs = nothing
set con = nothing

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Could any one please help me in this regard, of accessing activeX script with connecting to data base.

I' ll be so kind of any immediate response.
Thanking You

Ganesh