My VB 6 program uses this connection string to connect to the server:
user id=coord;data source=GS;persist security
info=True;Password=coord;initial catalog=CoordinatorTest
It works fine on all XP machines, but it doesn't work on only some of Vista
Business machines. It says Server doesn't exists or access denied. On some
other Vistas it works.
When I replace the name of the SQL Server with IP:
user id=coord;data source=10.22.52.4;persist security
info=True;Password=coord;initial catalog=CoordinatorTest
then it works.
I wouldn't want to create the different Connection strings for different
operating systems.
What's wrong with some of non working Vista's machines? What should be done
in order to make all of Vista machines work?
Thank you
vovan"vovan" <v@.v.com> wrote in message
news:%23v2T$CGEIHA.3332@.TK2MSFTNGP04.phx.gbl...
> When I replace the name of the SQL Server with IP:
> user id=coord;data source=10.22.52.4;persist security then it works.
It sounds like your Vista machines can locate data sources by IP address,
but not by hostname. You'd want to troubleshoot this as a general TCP/IP
Name resolution problem - make sure DNS Settings are correct; does a "ping
<hostname> from an Vista Command Line give same results as "ping <IP
address>"?; etc.
The Netdiag tool from the XP Support Tools also runs on Vista; just copy
over the netdiag.exe file from XP. Then run
C:\FOO>netdiag /v /debug
on the Vista machine, to run a comprehensive test for DNS and Domain
problems.
You don't say whether you're using ODBC, OLE DB, SQL Native Client, or what;
but generally, they should all work on Vista much the same as on XP. More
likely to be networking than compatibility, I'd guess.
Hope it helps,
--
Andrew McLaren
amclar (at) optusnet dot com dot au
Showing posts with label program. Show all posts
Showing posts with label program. Show all posts
Tuesday, March 27, 2012
Sunday, March 11, 2012
Connection gets lost
Hi,
I have a DSN set-up to access a SQL Server database from another
machine and program.
It is basically an import manager (third party product from an
external company), when I import it loads in a few thousand records
and then after about 2 minutes I get the following error:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied.
It then reconnects within a few minutes but misses loading the record
where the error happens.
Can someone help me locate the problem and how to fix it.
The external company has no problems with loading so i can only
imagine it is our SQL Server set-up
Thanks
ArchanaHi
"archanapatelwhite@.googlemail.com" wrote:
> Hi,
> I have a DSN set-up to access a SQL Server database from another
> machine and program.
> It is basically an import manager (third party product from an
> external company), when I import it loads in a few thousand records
> and then after about 2 minutes I get the following error:
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
> exist or access denied.
> It then reconnects within a few minutes but misses loading the record
> where the error happens.
> Can someone help me locate the problem and how to fix it.
> The external company has no problems with loading so i can only
> imagine it is our SQL Server set-up
> Thanks
> Archana
>
I would initially suspect something like your Anti-virus software,
anti-intusion software or firewall is breaking the connection e.g
http://support.microsoft.com/kb/170338/en-us
You may want to also check if you are on a recent SQL Server service pack
see
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html
John
I have a DSN set-up to access a SQL Server database from another
machine and program.
It is basically an import manager (third party product from an
external company), when I import it loads in a few thousand records
and then after about 2 minutes I get the following error:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied.
It then reconnects within a few minutes but misses loading the record
where the error happens.
Can someone help me locate the problem and how to fix it.
The external company has no problems with loading so i can only
imagine it is our SQL Server set-up
Thanks
ArchanaHi
"archanapatelwhite@.googlemail.com" wrote:
> Hi,
> I have a DSN set-up to access a SQL Server database from another
> machine and program.
> It is basically an import manager (third party product from an
> external company), when I import it loads in a few thousand records
> and then after about 2 minutes I get the following error:
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
> exist or access denied.
> It then reconnects within a few minutes but misses loading the record
> where the error happens.
> Can someone help me locate the problem and how to fix it.
> The external company has no problems with loading so i can only
> imagine it is our SQL Server set-up
> Thanks
> Archana
>
I would initially suspect something like your Anti-virus software,
anti-intusion software or firewall is breaking the connection e.g
http://support.microsoft.com/kb/170338/en-us
You may want to also check if you are on a recent SQL Server service pack
see
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html
John
Connection gets lost
Hi,
I have a DSN set-up to access a SQL Server database from another
machine and program.
It is basically an import manager (third party product from an
external company), when I import it loads in a few thousand records
and then after about 2 minutes I get the following error:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied.
It then reconnects within a few minutes but misses loading the record
where the error happens.
Can someone help me locate the problem and how to fix it.
The external company has no problems with loading so i can only
imagine it is our SQL Server set-up
Thanks
Archana
Hi
"archanapatelwhite@.googlemail.com" wrote:
> Hi,
> I have a DSN set-up to access a SQL Server database from another
> machine and program.
> It is basically an import manager (third party product from an
> external company), when I import it loads in a few thousand records
> and then after about 2 minutes I get the following error:
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
> exist or access denied.
> It then reconnects within a few minutes but misses loading the record
> where the error happens.
> Can someone help me locate the problem and how to fix it.
> The external company has no problems with loading so i can only
> imagine it is our SQL Server set-up
> Thanks
> Archana
>
I would initially suspect something like your Anti-virus software,
anti-intusion software or firewall is breaking the connection e.g
http://support.microsoft.com/kb/170338/en-us
You may want to also check if you are on a recent SQL Server service pack
see
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html
John
I have a DSN set-up to access a SQL Server database from another
machine and program.
It is basically an import manager (third party product from an
external company), when I import it loads in a few thousand records
and then after about 2 minutes I get the following error:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied.
It then reconnects within a few minutes but misses loading the record
where the error happens.
Can someone help me locate the problem and how to fix it.
The external company has no problems with loading so i can only
imagine it is our SQL Server set-up
Thanks
Archana
Hi
"archanapatelwhite@.googlemail.com" wrote:
> Hi,
> I have a DSN set-up to access a SQL Server database from another
> machine and program.
> It is basically an import manager (third party product from an
> external company), when I import it loads in a few thousand records
> and then after about 2 minutes I get the following error:
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
> exist or access denied.
> It then reconnects within a few minutes but misses loading the record
> where the error happens.
> Can someone help me locate the problem and how to fix it.
> The external company has no problems with loading so i can only
> imagine it is our SQL Server set-up
> Thanks
> Archana
>
I would initially suspect something like your Anti-virus software,
anti-intusion software or firewall is breaking the connection e.g
http://support.microsoft.com/kb/170338/en-us
You may want to also check if you are on a recent SQL Server service pack
see
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html
John
Connection gets lost
Hi,
I have a DSN set-up to access a SQL Server database from another
machine and program.
It is basically an import manager (third party product from an
external company), when I import it loads in a few thousand records
and then after about 2 minutes I get the following error:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server do
es not
exist or access denied.
It then reconnects within a few minutes but misses loading the record
where the error happens.
Can someone help me locate the problem and how to fix it.
The external company has no problems with loading so i can only
imagine it is our SQL Server set-up
Thanks
ArchanaHi
"archanapatelwhite@.googlemail.com" wrote:
> Hi,
> I have a DSN set-up to access a SQL Server database from another
> machine and program.
> It is basically an import manager (third party product from an
> external company), when I import it loads in a few thousand records
> and then after about 2 minutes I get the following error:
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server
does not
> exist or access denied.
> It then reconnects within a few minutes but misses loading the record
> where the error happens.
> Can someone help me locate the problem and how to fix it.
> The external company has no problems with loading so i can only
> imagine it is our SQL Server set-up
> Thanks
> Archana
>
I would initially suspect something like your Anti-virus software,
anti-intusion software or firewall is breaking the connection e.g
http://support.microsoft.com/kb/170338/en-us
You may want to also check if you are on a recent SQL Server service pack
see
http://sqlserver2000.databases.aspf...-m-running.html
John
I have a DSN set-up to access a SQL Server database from another
machine and program.
It is basically an import manager (third party product from an
external company), when I import it loads in a few thousand records
and then after about 2 minutes I get the following error:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server do
es not
exist or access denied.
It then reconnects within a few minutes but misses loading the record
where the error happens.
Can someone help me locate the problem and how to fix it.
The external company has no problems with loading so i can only
imagine it is our SQL Server set-up
Thanks
ArchanaHi
"archanapatelwhite@.googlemail.com" wrote:
> Hi,
> I have a DSN set-up to access a SQL Server database from another
> machine and program.
> It is basically an import manager (third party product from an
> external company), when I import it loads in a few thousand records
> and then after about 2 minutes I get the following error:
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server
does not
> exist or access denied.
> It then reconnects within a few minutes but misses loading the record
> where the error happens.
> Can someone help me locate the problem and how to fix it.
> The external company has no problems with loading so i can only
> imagine it is our SQL Server set-up
> Thanks
> Archana
>
I would initially suspect something like your Anti-virus software,
anti-intusion software or firewall is breaking the connection e.g
http://support.microsoft.com/kb/170338/en-us
You may want to also check if you are on a recent SQL Server service pack
see
http://sqlserver2000.databases.aspf...-m-running.html
John
Thursday, March 8, 2012
Connection Failed: SQl SErver Error 18456
I am runnig a program through Microsoft Access 2000 that uses SQL server and is run on 8 different machines. It has worked great for months but yesterday this message appeared:
Connection Failed:
SQL State: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed for User 'SA'.
And when I try to use Outlook, this message is displayed:
The Microsoft Exchange Server Computer is not available. Either there are network problems or thhe Microsoft Exchange Server is down for mmaintenance.
Obvious problems with the SQL recognition but it seems to be up and running fine.
Any help appreciated.Make sure no change in SA's password and try connecting with other user with ADMIN privileges.
Connection Failed:
SQL State: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed for User 'SA'.
And when I try to use Outlook, this message is displayed:
The Microsoft Exchange Server Computer is not available. Either there are network problems or thhe Microsoft Exchange Server is down for mmaintenance.
Obvious problems with the SQL recognition but it seems to be up and running fine.
Any help appreciated.Make sure no change in SA's password and try connecting with other user with ADMIN privileges.
connection failed
Hi,
I have a program using ms sql. It worked fine for some time, but
now each time the program access the databases it outputs "Connection Failed
SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
After pressing OK it gives an option to input a new password manually, and after
entering it - it works. But only for the current transaction. Next time it'll prompt again.
I've tried to change the password, I've chaned it in the system ODBC drivers, tried
different usernames, but the same error returns.
What could be the problem ?
Thanks.
It depends on the said program. How the program is configured or coded to
connect to the SQL Server database? It sounds the program is configured or
hard-coded (too bad!!!) with "sa/sapassword" to connect. The reason of error
is bacause "sa" account's password has been changed, which is good (maybe
the DB admin knew some apps use "sa" to access the SQL Server, which is bad
practice, and he changed it?).
You must find a way to reconfigure it to use new password. If the password
is hard coded, then you may out luck to change it easily.
"Marius Kaizerman" <marius@.kaizerman.org> wrote in message
news:e9e%23NcDMIHA.4712@.TK2MSFTNGP04.phx.gbl...
Hi,
I have a program using ms sql. It worked fine for some time, but
now each time the program access the databases it outputs "Connection Failed
SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
After pressing OK it gives an option to input a new password manually, and
after
entering it - it works. But only for the current transaction. Next time
it'll prompt again.
I've tried to change the password, I've chaned it in the system ODBC
drivers, tried
different usernames, but the same error returns.
What could be the problem ?
Thanks.
|||Norman,
You were absolutely right.
Thanks alot!
"Norman Yuan" <NoAddress@.NoEmail.fake> wrote in message
news:OonyLvDMIHA.1164@.TK2MSFTNGP02.phx.gbl...
> It depends on the said program. How the program is configured or coded to
> connect to the SQL Server database? It sounds the program is configured or
> hard-coded (too bad!!!) with "sa/sapassword" to connect. The reason of
> error is bacause "sa" account's password has been changed, which is good
> (maybe the DB admin knew some apps use "sa" to access the SQL Server,
> which is bad practice, and he changed it?).
> You must find a way to reconfigure it to use new password. If the password
> is hard coded, then you may out luck to change it easily.
>
> "Marius Kaizerman" <marius@.kaizerman.org> wrote in message
> news:e9e%23NcDMIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have a program using ms sql. It worked fine for some time, but
> now each time the program access the databases it outputs "Connection
> Failed
> SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
> After pressing OK it gives an option to input a new password manually, and
> after
> entering it - it works. But only for the current transaction. Next time
> it'll prompt again.
> I've tried to change the password, I've chaned it in the system ODBC
> drivers, tried
> different usernames, but the same error returns.
> What could be the problem ?
> Thanks.
I have a program using ms sql. It worked fine for some time, but
now each time the program access the databases it outputs "Connection Failed
SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
After pressing OK it gives an option to input a new password manually, and after
entering it - it works. But only for the current transaction. Next time it'll prompt again.
I've tried to change the password, I've chaned it in the system ODBC drivers, tried
different usernames, but the same error returns.
What could be the problem ?
Thanks.
It depends on the said program. How the program is configured or coded to
connect to the SQL Server database? It sounds the program is configured or
hard-coded (too bad!!!) with "sa/sapassword" to connect. The reason of error
is bacause "sa" account's password has been changed, which is good (maybe
the DB admin knew some apps use "sa" to access the SQL Server, which is bad
practice, and he changed it?).
You must find a way to reconfigure it to use new password. If the password
is hard coded, then you may out luck to change it easily.
"Marius Kaizerman" <marius@.kaizerman.org> wrote in message
news:e9e%23NcDMIHA.4712@.TK2MSFTNGP04.phx.gbl...
Hi,
I have a program using ms sql. It worked fine for some time, but
now each time the program access the databases it outputs "Connection Failed
SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
After pressing OK it gives an option to input a new password manually, and
after
entering it - it works. But only for the current transaction. Next time
it'll prompt again.
I've tried to change the password, I've chaned it in the system ODBC
drivers, tried
different usernames, but the same error returns.
What could be the problem ?
Thanks.
|||Norman,
You were absolutely right.
Thanks alot!
"Norman Yuan" <NoAddress@.NoEmail.fake> wrote in message
news:OonyLvDMIHA.1164@.TK2MSFTNGP02.phx.gbl...
> It depends on the said program. How the program is configured or coded to
> connect to the SQL Server database? It sounds the program is configured or
> hard-coded (too bad!!!) with "sa/sapassword" to connect. The reason of
> error is bacause "sa" account's password has been changed, which is good
> (maybe the DB admin knew some apps use "sa" to access the SQL Server,
> which is bad practice, and he changed it?).
> You must find a way to reconfigure it to use new password. If the password
> is hard coded, then you may out luck to change it easily.
>
> "Marius Kaizerman" <marius@.kaizerman.org> wrote in message
> news:e9e%23NcDMIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have a program using ms sql. It worked fine for some time, but
> now each time the program access the databases it outputs "Connection
> Failed
> SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
> After pressing OK it gives an option to input a new password manually, and
> after
> entering it - it works. But only for the current transaction. Next time
> it'll prompt again.
> I've tried to change the password, I've chaned it in the system ODBC
> drivers, tried
> different usernames, but the same error returns.
> What could be the problem ?
> Thanks.
connection failed
Hi,
I have a program using ms sql. It worked fine for some time, but
now each time the program access the databases it outputs "Connection Failed
SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
After pressing OK it gives an option to input a new password manually, and after
entering it - it works. But only for the current transaction. Next time it'll prompt again.
I've tried to change the password, I've chaned it in the system ODBC drivers, tried
different usernames, but the same error returns.
What could be the problem ?
Thanks.
It depends on the said program. How the program is configured or coded to
connect to the SQL Server database? It sounds the program is configured or
hard-coded (too bad!!!) with "sa/sapassword" to connect. The reason of error
is bacause "sa" account's password has been changed, which is good (maybe
the DB admin knew some apps use "sa" to access the SQL Server, which is bad
practice, and he changed it?).
You must find a way to reconfigure it to use new password. If the password
is hard coded, then you may out luck to change it easily.
"Marius Kaizerman" <marius@.kaizerman.org> wrote in message
news:e9e%23NcDMIHA.4712@.TK2MSFTNGP04.phx.gbl...
Hi,
I have a program using ms sql. It worked fine for some time, but
now each time the program access the databases it outputs "Connection Failed
SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
After pressing OK it gives an option to input a new password manually, and
after
entering it - it works. But only for the current transaction. Next time
it'll prompt again.
I've tried to change the password, I've chaned it in the system ODBC
drivers, tried
different usernames, but the same error returns.
What could be the problem ?
Thanks.
|||Norman,
You were absolutely right.
Thanks alot!
"Norman Yuan" <NoAddress@.NoEmail.fake> wrote in message
news:OonyLvDMIHA.1164@.TK2MSFTNGP02.phx.gbl...
> It depends on the said program. How the program is configured or coded to
> connect to the SQL Server database? It sounds the program is configured or
> hard-coded (too bad!!!) with "sa/sapassword" to connect. The reason of
> error is bacause "sa" account's password has been changed, which is good
> (maybe the DB admin knew some apps use "sa" to access the SQL Server,
> which is bad practice, and he changed it?).
> You must find a way to reconfigure it to use new password. If the password
> is hard coded, then you may out luck to change it easily.
>
> "Marius Kaizerman" <marius@.kaizerman.org> wrote in message
> news:e9e%23NcDMIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have a program using ms sql. It worked fine for some time, but
> now each time the program access the databases it outputs "Connection
> Failed
> SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
> After pressing OK it gives an option to input a new password manually, and
> after
> entering it - it works. But only for the current transaction. Next time
> it'll prompt again.
> I've tried to change the password, I've chaned it in the system ODBC
> drivers, tried
> different usernames, but the same error returns.
> What could be the problem ?
> Thanks.
I have a program using ms sql. It worked fine for some time, but
now each time the program access the databases it outputs "Connection Failed
SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
After pressing OK it gives an option to input a new password manually, and after
entering it - it works. But only for the current transaction. Next time it'll prompt again.
I've tried to change the password, I've chaned it in the system ODBC drivers, tried
different usernames, but the same error returns.
What could be the problem ?
Thanks.
It depends on the said program. How the program is configured or coded to
connect to the SQL Server database? It sounds the program is configured or
hard-coded (too bad!!!) with "sa/sapassword" to connect. The reason of error
is bacause "sa" account's password has been changed, which is good (maybe
the DB admin knew some apps use "sa" to access the SQL Server, which is bad
practice, and he changed it?).
You must find a way to reconfigure it to use new password. If the password
is hard coded, then you may out luck to change it easily.
"Marius Kaizerman" <marius@.kaizerman.org> wrote in message
news:e9e%23NcDMIHA.4712@.TK2MSFTNGP04.phx.gbl...
Hi,
I have a program using ms sql. It worked fine for some time, but
now each time the program access the databases it outputs "Connection Failed
SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
After pressing OK it gives an option to input a new password manually, and
after
entering it - it works. But only for the current transaction. Next time
it'll prompt again.
I've tried to change the password, I've chaned it in the system ODBC
drivers, tried
different usernames, but the same error returns.
What could be the problem ?
Thanks.
|||Norman,
You were absolutely right.
Thanks alot!
"Norman Yuan" <NoAddress@.NoEmail.fake> wrote in message
news:OonyLvDMIHA.1164@.TK2MSFTNGP02.phx.gbl...
> It depends on the said program. How the program is configured or coded to
> connect to the SQL Server database? It sounds the program is configured or
> hard-coded (too bad!!!) with "sa/sapassword" to connect. The reason of
> error is bacause "sa" account's password has been changed, which is good
> (maybe the DB admin knew some apps use "sa" to access the SQL Server,
> which is bad practice, and he changed it?).
> You must find a way to reconfigure it to use new password. If the password
> is hard coded, then you may out luck to change it easily.
>
> "Marius Kaizerman" <marius@.kaizerman.org> wrote in message
> news:e9e%23NcDMIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have a program using ms sql. It worked fine for some time, but
> now each time the program access the databases it outputs "Connection
> Failed
> SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
> After pressing OK it gives an option to input a new password manually, and
> after
> entering it - it works. But only for the current transaction. Next time
> it'll prompt again.
> I've tried to change the password, I've chaned it in the system ODBC
> drivers, tried
> different usernames, but the same error returns.
> What could be the problem ?
> Thanks.
Wednesday, March 7, 2012
connection failed
Hi,
I have a program using ms sql. It worked fine for some time, but
now each time the program access the databases it outputs "Connection Failed
SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
After pressing OK it gives an option to input a new password manually, and a
fter
entering it - it works. But only for the current transaction. Next time it'l
l prompt again.
I've tried to change the password, I've chaned it in the system ODBC drivers
, tried
different usernames, but the same error returns.
What could be the problem ?
Thanks.It depends on the said program. How the program is configured or coded to
connect to the SQL Server database? It sounds the program is configured or
hard-coded (too bad!!!) with "sa/sapassword" to connect. The reason of error
is bacause "sa" account's password has been changed, which is good (maybe
the DB admin knew some apps use "sa" to access the SQL Server, which is bad
practice, and he changed it?).
You must find a way to reconfigure it to use new password. If the password
is hard coded, then you may out luck to change it easily.
"Marius Kaizerman" <marius@.kaizerman.org> wrote in message
news:e9e%23NcDMIHA.4712@.TK2MSFTNGP04.phx.gbl...
Hi,
I have a program using ms sql. It worked fine for some time, but
now each time the program access the databases it outputs "Connection Failed
SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
After pressing OK it gives an option to input a new password manually, and
after
entering it - it works. But only for the current transaction. Next time
it'll prompt again.
I've tried to change the password, I've chaned it in the system ODBC
drivers, tried
different usernames, but the same error returns.
What could be the problem ?
Thanks.|||Norman,
You were absolutely right.
Thanks alot!
"Norman Yuan" <NoAddress@.NoEmail.fake> wrote in message
news:OonyLvDMIHA.1164@.TK2MSFTNGP02.phx.gbl...
> It depends on the said program. How the program is configured or coded to
> connect to the SQL Server database? It sounds the program is configured or
> hard-coded (too bad!!!) with "sa/sapassword" to connect. The reason of
> error is bacause "sa" account's password has been changed, which is good
> (maybe the DB admin knew some apps use "sa" to access the SQL Server,
> which is bad practice, and he changed it?).
> You must find a way to reconfigure it to use new password. If the password
> is hard coded, then you may out luck to change it easily.
>
> "Marius Kaizerman" <marius@.kaizerman.org> wrote in message
> news:e9e%23NcDMIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have a program using ms sql. It worked fine for some time, but
> now each time the program access the databases it outputs "Connection
> Failed
> SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
> After pressing OK it gives an option to input a new password manually, and
> after
> entering it - it works. But only for the current transaction. Next time
> it'll prompt again.
> I've tried to change the password, I've chaned it in the system ODBC
> drivers, tried
> different usernames, but the same error returns.
> What could be the problem ?
> Thanks.
I have a program using ms sql. It worked fine for some time, but
now each time the program access the databases it outputs "Connection Failed
SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
After pressing OK it gives an option to input a new password manually, and a
fter
entering it - it works. But only for the current transaction. Next time it'l
l prompt again.
I've tried to change the password, I've chaned it in the system ODBC drivers
, tried
different usernames, but the same error returns.
What could be the problem ?
Thanks.It depends on the said program. How the program is configured or coded to
connect to the SQL Server database? It sounds the program is configured or
hard-coded (too bad!!!) with "sa/sapassword" to connect. The reason of error
is bacause "sa" account's password has been changed, which is good (maybe
the DB admin knew some apps use "sa" to access the SQL Server, which is bad
practice, and he changed it?).
You must find a way to reconfigure it to use new password. If the password
is hard coded, then you may out luck to change it easily.
"Marius Kaizerman" <marius@.kaizerman.org> wrote in message
news:e9e%23NcDMIHA.4712@.TK2MSFTNGP04.phx.gbl...
Hi,
I have a program using ms sql. It worked fine for some time, but
now each time the program access the databases it outputs "Connection Failed
SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
After pressing OK it gives an option to input a new password manually, and
after
entering it - it works. But only for the current transaction. Next time
it'll prompt again.
I've tried to change the password, I've chaned it in the system ODBC
drivers, tried
different usernames, but the same error returns.
What could be the problem ?
Thanks.|||Norman,
You were absolutely right.
Thanks alot!
"Norman Yuan" <NoAddress@.NoEmail.fake> wrote in message
news:OonyLvDMIHA.1164@.TK2MSFTNGP02.phx.gbl...
> It depends on the said program. How the program is configured or coded to
> connect to the SQL Server database? It sounds the program is configured or
> hard-coded (too bad!!!) with "sa/sapassword" to connect. The reason of
> error is bacause "sa" account's password has been changed, which is good
> (maybe the DB admin knew some apps use "sa" to access the SQL Server,
> which is bad practice, and he changed it?).
> You must find a way to reconfigure it to use new password. If the password
> is hard coded, then you may out luck to change it easily.
>
> "Marius Kaizerman" <marius@.kaizerman.org> wrote in message
> news:e9e%23NcDMIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have a program using ms sql. It worked fine for some time, but
> now each time the program access the databases it outputs "Connection
> Failed
> SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'".
> After pressing OK it gives an option to input a new password manually, and
> after
> entering it - it works. But only for the current transaction. Next time
> it'll prompt again.
> I've tried to change the password, I've chaned it in the system ODBC
> drivers, tried
> different usernames, but the same error returns.
> What could be the problem ?
> Thanks.
Saturday, February 25, 2012
Connection Error
Hi
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
Thanks
Hi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan
|||I also have this same error. Did you find the solution?
I searched the entire net but couldnt find a solution.
If you try disabling and enabling the network connection, it will work again. Very strange.
Please do post if you got solution.
Thanks in advance to anybody who can help in this matter
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegro ups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
Thanks
Hi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan
|||I also have this same error. Did you find the solution?
I searched the entire net but couldnt find a solution.
If you try disabling and enabling the network connection, it will work again. Very strange.
Please do post if you got solution.
Thanks in advance to anybody who can help in this matter
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegro ups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
Connection Error
Hi
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
Thanks
Hi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan
|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegro ups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
Thanks
Hi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan
|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegro ups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
Connection Error
Hi
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect(
))
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
ThanksHi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegroups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect(
))
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
ThanksHi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegroups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
Connection Error
Hi
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Conn
ect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
ThanksHi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegroups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Conn
ect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
ThanksHi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegroups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
Connection Error
Hi,
I have developed a program which connects to an SQL Express 2005 server. This worked fine until yesterday when the server failed. I have set up a new server, same name, config, etc and restored the data back into the database.
When the program runs it displays an error:
System.Runtime.InteropServices.COMException (0x800A0E7D): The connection cannot be used to perform this operation. It is either closed or invalid in this context.
Connection code that is erroring:
rs.Open(s, sq, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic)
* s is the search string
* sq is the connection string
sq.open("Provider=SQOLEDB;Data Source=mns-web01\sqlexpress;User ID=WLANClient;Password=password;Initial Catalog=WLAN;")
It also has a 'ghost' user which cannot be removed or re-created. This is the user which the code uses to connect to the database.
Any ideas?
Thanks
Sounds like somewhere in your code you closed or destroyed the connection, and tried to initiate an action after that. Create a simple connection test section of code with a simple select, and then try layering your other code back in. This happens a lot when you're doing looping or calling out to sub procedures.
Buck Woody
Connection Error
Hi
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
Thanks
Hi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan
|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegro ups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
Thanks
Hi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan
|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegro ups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
Connection Error
Hi
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Conn
ect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
ThanksHi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan|||I also have this same error. Did you find the solution?
I searched the entire net but couldnt find a solution.
If you try disabling and enabling the network connection, it will work again
. Very strange.
Please do post if you got solution.
Thanks in advance to anybody who can help in this matter
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegroups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Conn
ect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
ThanksHi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan|||I also have this same error. Did you find the solution?
I searched the entire net but couldnt find a solution.
If you try disabling and enabling the network connection, it will work again
. Very strange.
Please do post if you got solution.
Thanks in advance to anybody who can help in this matter
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegroups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
Friday, February 24, 2012
Connection Error
Hi
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
ThanksHi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegroups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
ThanksHi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegroups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>
Sunday, February 19, 2012
connection and getting data from a logfile?
Hi,
i am writing a program that have to get data from a logfile into a database.
Can anyone tell me how to connect and get data from it?
I am working in asp.vb in the Visual Studio 2005 program.
Thanks
There are lots of ways to get data in SQL Server, here are some ideas;
1/ Make sure the file is in a format that Integration Services can read, call it from code.
2/ Use Log Parser
3/ read the data into a datatable/dataset and then use BulkCopy to load that into SQL Server
4/ Lots more
|||Hi,
thanks for the answer i will shurely try this!
Greetz
Crazydj
Friday, February 17, 2012
Connecting VB Express files to SQL Server Management Studio Express
Really confused ... I created 2 tables in a VB Express program (which went well). Problem is that I can't see/find those tables with MSME. I don't really understand how to connect the MSME to where the tables are. I created the tables under \My Documents\Data and they are DBapp.mdf + DBapp_log.LDF and the tables are Items and Preferences. The VB application can "see" the tables OK.
Do I need to move the tables to C:\Program Files\Microsoft SQL Server\MSQL.1\MSQL\DATA (like the Adventureworks installation which I haven't done) or what?
Please help a newbie
Thanks
George
Are you suing a user instance or a server attached instance ? If you are not sure post the connection string here, that we can see which method you are using. If you are using a user instance, you won′t see them in the managment studio unless you attach the database to the server. Visual Studio can also make them viewable in the Server Explorer.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
The express products can only use the sql express system if it is installed as a instance name called ".\SQLEXPRESS". Also when it does create files it creates them as a user instance. This means that the files are not attached to the actuall engine untill the application starts. If you do want to use these database files from the SQL Management Studio you will have to attach these to the engine. To do this I would copy the files to another directory (Say c:\Data" and then from the Management Studio under the databases tab right click and select attach....
Tuesday, February 14, 2012
connecting to web database from desktop application.
I am thinking of using my web database as the database to use for my program, though not sure how feasible due to connection speeds and having to transfer that info.
what I am using as the connection string is
con.ConnectionString = "Data Source=databse ipadress inserted here; Initial Catalog=databasename here;Integrated Security=True"; with real data obviously inserted into the ip and tables, but when i try and send values there it just hangs and then crashes. I am thinking its not finding the database. Is there something else im to do?
I am using the exact same code as when i use my own machine as the server, and it works great that way, only thing different is the trying to send to the web server.
Verify with your host IF the SQL Server is available outside the firewall -my guess is NOT.
You probably would need to also add the IP port: "Data Source=nnn.nnn.nnn.nnn:1433;..."
Security would be different since I doubt that you are in the same domain -therefore "...;Intetrated Security=True" probably isn't true. You would most likely need a SQL Server login (User/Password).
But first, check with the host to see if it is even worth any more time.
|||I contacted them and it seems like it should be np. They told me where I need to add in the white space the ipaddress its coming from and did all that.
From looking at another site I got a little code from there, but still is wrong. is this any closer?
con.ConnectionString = "Data Source=69.89.20.44:3306; user=buenavi1_test&password=testing; Initial Catalog=buenavi1_Lottery";
This was simply a test table set up and a test user and password and im sending the data from a program i have used before to this database and not the other database I used, so I know the data is good.
Just always times out on the connection string.
|||Rick,
First, a reminder to be cautious when posting security information. You should immediately change your username and password -many hackers will be hitting the connection you posted.
I see this error: "user=buenavi1_test&password=testing" should be "user=buenavi1_test;password=testing" (Semi-colon instead of amperstand.)
But more importantly, since you aren't getting any error messages, I suspect that you may not be making a connection.
Have you verified that your firewall is open and allowing outbound traffic?
|||Thanks for the help, I will review this agin later. Still not going through so I will check firewalls.
Im not needing this as an option was just investigating the feasibility more or less of using it like that.
As far as security, in this point I wasn't too concerned as that database, table, user name and password were all created for no other reason then to test this, they aren't used elsewhere for anything, but I have now deleted all.
Again thanks for the help.
Friday, February 10, 2012
Connecting to SQL server express 2005 from vista
Hi all,
I am having problems with connecting to a SQL Express server running on server 2003. I can connect with the program concerned from a windows xp client without problems. I cannot however connect from a vista machine using the software. In the logs i see the client trying to logon, wich fails with Login failed for user: 'user'. [client: clientIP] severity 14 state 8. On the vista client i have tried everything from disabling the firewall, windows defender, running the app as admin etc. I can connect using sqlcmd or the management tools with the username the app is using. This is a SQL user, we are not using windows users to connect to the DB.I also ran a app like ethereal to see what is happening packet wise, i see the login failed packet on a windows client, from a XP client everything seems fine and it starts using RPC.
Any help appreciated,
FVader
Hi,State 8 , Password mismatch. You have provided a wrong password.
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
HTH, jens K. Suessmeyer.
http://www.sqlserver2005.de
Subscribe to:
Posts (Atom)