I am getting the following error message in SQL 2K when I try to give
database access to a login Id "LogInId1".
****************************************
*************
Microsoft SQL-DMO(ODBC SQLState:42000)
Error 15023: User or role 'LogInId1' already exists in the current database.
****************************************
************************************
*
The "public" role in the above "current database" has a user Id "LogInId1".
This is the one it is generating the above error message. I can not remove
the above user ID from that role (public).
What I did to generate the above error message?
I restored one user database on SQL 2K (running under windows 2003) from the
backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
database from which back was ran.
How to add database access permissions to the login Id ""LogInId1"?
Thank you,
SmithYou can try:
exec sp_changedbowner 'LogInId1'
"John Smith" wrote:
> I am getting the following error message in SQL 2K when I try to give
> database access to a login Id "LogInId1".
>
> ****************************************
*************
> Microsoft SQL-DMO(ODBC SQLState:42000)
> Error 15023: User or role 'LogInId1' already exists in the current databas
e.
> ****************************************
**********************************
**
> *
>
> The "public" role in the above "current database" has a user Id "LogInId1"
.
> This is the one it is generating the above error message. I can not remove
> the above user ID from that role (public).
>
> What I did to generate the above error message?
> I restored one user database on SQL 2K (running under windows 2003) from t
he
> backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> database from which back was ran.
>
> How to add database access permissions to the login Id ""LogInId1"?
> Thank you,
> Smith
>
>
>|||Take a look at sp_resolve_logins in BOL, etc.
The internal (to the database) user tables have entries that are either not
in the Master SYSLOGINS table or have different pointers to that table. You
need to either repoint(resolve) or remove those logins.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Fahim" wrote:
[vbcol=seagreen]
> You can try:
> exec sp_changedbowner 'LogInId1'
>
> "John Smith" wrote:
>
Showing posts with label odbc. Show all posts
Showing posts with label odbc. Show all posts
Friday, February 24, 2012
Microsoft SQL-DMO(ODBC SQLState:42000)
I am getting the following error message in SQL 2K when I try to give
database access to a login Id "LogInId1".
*****************************************************
Microsoft SQL-DMO(ODBC SQLState:42000)
Error 15023: User or role 'LogInId1' already exists in the current database.
****************************************************************************
*
The "public" role in the above "current database" has a user Id "LogInId1".
This is the one it is generating the above error message. I can not remove
the above user ID from that role (public).
What I did to generate the above error message?
I restored one user database on SQL 2K (running under windows 2003) from the
backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
database from which back was ran.
How to add database access permissions to the login Id ""LogInId1"?
Thank you,
SmithYou can try:
exec sp_changedbowner 'LogInId1'
"John Smith" wrote:
> I am getting the following error message in SQL 2K when I try to give
> database access to a login Id "LogInId1".
>
> *****************************************************
> Microsoft SQL-DMO(ODBC SQLState:42000)
> Error 15023: User or role 'LogInId1' already exists in the current database.
> ****************************************************************************
> *
>
> The "public" role in the above "current database" has a user Id "LogInId1".
> This is the one it is generating the above error message. I can not remove
> the above user ID from that role (public).
>
> What I did to generate the above error message?
> I restored one user database on SQL 2K (running under windows 2003) from the
> backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> database from which back was ran.
>
> How to add database access permissions to the login Id ""LogInId1"?
> Thank you,
> Smith
>
>
>|||Take a look at sp_resolve_logins in BOL, etc.
The internal (to the database) user tables have entries that are either not
in the Master SYSLOGINS table or have different pointers to that table. You
need to either repoint(resolve) or remove those logins.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Fahim" wrote:
> You can try:
> exec sp_changedbowner 'LogInId1'
>
> "John Smith" wrote:
> > I am getting the following error message in SQL 2K when I try to give
> > database access to a login Id "LogInId1".
> >
> >
> >
> > *****************************************************
> >
> > Microsoft SQL-DMO(ODBC SQLState:42000)
> >
> > Error 15023: User or role 'LogInId1' already exists in the current database.
> >
> > ****************************************************************************
> > *
> >
> >
> >
> > The "public" role in the above "current database" has a user Id "LogInId1".
> > This is the one it is generating the above error message. I can not remove
> > the above user ID from that role (public).
> >
> >
> >
> > What I did to generate the above error message?
> >
> > I restored one user database on SQL 2K (running under windows 2003) from the
> > backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> > database from which back was ran.
> >
> >
> >
> > How to add database access permissions to the login Id ""LogInId1"?
> >
> > Thank you,
> >
> > Smith
> >
> >
> >
> >
> >
database access to a login Id "LogInId1".
*****************************************************
Microsoft SQL-DMO(ODBC SQLState:42000)
Error 15023: User or role 'LogInId1' already exists in the current database.
****************************************************************************
*
The "public" role in the above "current database" has a user Id "LogInId1".
This is the one it is generating the above error message. I can not remove
the above user ID from that role (public).
What I did to generate the above error message?
I restored one user database on SQL 2K (running under windows 2003) from the
backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
database from which back was ran.
How to add database access permissions to the login Id ""LogInId1"?
Thank you,
SmithYou can try:
exec sp_changedbowner 'LogInId1'
"John Smith" wrote:
> I am getting the following error message in SQL 2K when I try to give
> database access to a login Id "LogInId1".
>
> *****************************************************
> Microsoft SQL-DMO(ODBC SQLState:42000)
> Error 15023: User or role 'LogInId1' already exists in the current database.
> ****************************************************************************
> *
>
> The "public" role in the above "current database" has a user Id "LogInId1".
> This is the one it is generating the above error message. I can not remove
> the above user ID from that role (public).
>
> What I did to generate the above error message?
> I restored one user database on SQL 2K (running under windows 2003) from the
> backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> database from which back was ran.
>
> How to add database access permissions to the login Id ""LogInId1"?
> Thank you,
> Smith
>
>
>|||Take a look at sp_resolve_logins in BOL, etc.
The internal (to the database) user tables have entries that are either not
in the Master SYSLOGINS table or have different pointers to that table. You
need to either repoint(resolve) or remove those logins.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Fahim" wrote:
> You can try:
> exec sp_changedbowner 'LogInId1'
>
> "John Smith" wrote:
> > I am getting the following error message in SQL 2K when I try to give
> > database access to a login Id "LogInId1".
> >
> >
> >
> > *****************************************************
> >
> > Microsoft SQL-DMO(ODBC SQLState:42000)
> >
> > Error 15023: User or role 'LogInId1' already exists in the current database.
> >
> > ****************************************************************************
> > *
> >
> >
> >
> > The "public" role in the above "current database" has a user Id "LogInId1".
> > This is the one it is generating the above error message. I can not remove
> > the above user ID from that role (public).
> >
> >
> >
> > What I did to generate the above error message?
> >
> > I restored one user database on SQL 2K (running under windows 2003) from the
> > backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> > database from which back was ran.
> >
> >
> >
> > How to add database access permissions to the login Id ""LogInId1"?
> >
> > Thank you,
> >
> > Smith
> >
> >
> >
> >
> >
Microsoft SQL-DMO(ODBC SQLState:42000)
I am getting the following error message in SQL 2K when I try to give
database access to a login Id "LogInId1".
************************************************** ***
Microsoft SQL-DMO(ODBC SQLState:42000)
Error 15023: User or role 'LogInId1' already exists in the current database.
************************************************** **************************
*
The "public" role in the above "current database" has a user Id "LogInId1".
This is the one it is generating the above error message. I can not remove
the above user ID from that role (public).
What I did to generate the above error message?
I restored one user database on SQL 2K (running under windows 2003) from the
backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
database from which back was ran.
How to add database access permissions to the login Id ""LogInId1"?
Thank you,
Smith
You can try:
exec sp_changedbowner 'LogInId1'
"John Smith" wrote:
> I am getting the following error message in SQL 2K when I try to give
> database access to a login Id "LogInId1".
>
> ************************************************** ***
> Microsoft SQL-DMO(ODBC SQLState:42000)
> Error 15023: User or role 'LogInId1' already exists in the current database.
> ************************************************** **************************
> *
>
> The "public" role in the above "current database" has a user Id "LogInId1".
> This is the one it is generating the above error message. I can not remove
> the above user ID from that role (public).
>
> What I did to generate the above error message?
> I restored one user database on SQL 2K (running under windows 2003) from the
> backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> database from which back was ran.
>
> How to add database access permissions to the login Id ""LogInId1"?
> Thank you,
> Smith
>
>
>
|||Take a look at sp_resolve_logins in BOL, etc.
The internal (to the database) user tables have entries that are either not
in the Master SYSLOGINS table or have different pointers to that table. You
need to either repoint(resolve) or remove those logins.
Joseph R.P. Maloney, CSP,CCP,CDP
"Fahim" wrote:
[vbcol=seagreen]
> You can try:
> exec sp_changedbowner 'LogInId1'
>
> "John Smith" wrote:
database access to a login Id "LogInId1".
************************************************** ***
Microsoft SQL-DMO(ODBC SQLState:42000)
Error 15023: User or role 'LogInId1' already exists in the current database.
************************************************** **************************
*
The "public" role in the above "current database" has a user Id "LogInId1".
This is the one it is generating the above error message. I can not remove
the above user ID from that role (public).
What I did to generate the above error message?
I restored one user database on SQL 2K (running under windows 2003) from the
backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
database from which back was ran.
How to add database access permissions to the login Id ""LogInId1"?
Thank you,
Smith
You can try:
exec sp_changedbowner 'LogInId1'
"John Smith" wrote:
> I am getting the following error message in SQL 2K when I try to give
> database access to a login Id "LogInId1".
>
> ************************************************** ***
> Microsoft SQL-DMO(ODBC SQLState:42000)
> Error 15023: User or role 'LogInId1' already exists in the current database.
> ************************************************** **************************
> *
>
> The "public" role in the above "current database" has a user Id "LogInId1".
> This is the one it is generating the above error message. I can not remove
> the above user ID from that role (public).
>
> What I did to generate the above error message?
> I restored one user database on SQL 2K (running under windows 2003) from the
> backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> database from which back was ran.
>
> How to add database access permissions to the login Id ""LogInId1"?
> Thank you,
> Smith
>
>
>
|||Take a look at sp_resolve_logins in BOL, etc.
The internal (to the database) user tables have entries that are either not
in the Master SYSLOGINS table or have different pointers to that table. You
need to either repoint(resolve) or remove those logins.
Joseph R.P. Maloney, CSP,CCP,CDP
"Fahim" wrote:
[vbcol=seagreen]
> You can try:
> exec sp_changedbowner 'LogInId1'
>
> "John Smith" wrote:
Microsoft SQL-DMO (ODBC SQLState: 42000) Error 22022
Hi,
We have recently setup a new cluster server. At the moment
the resources have swapped over so that 1 is running on
node 2 and vice-versa.
However this appears to be causing a problem with the SQL
scheduled tasks. All tasks in the list have (Date and
Time are not available) under 'Next Run Date.' All the
tasks will try and run at their scheduled time however if
we try and manually execute tasks we get the error message
Microsoft SQL-DMO (ODBC SQLState: 42000) Error 22022:
SqlServerAgent Error: Job ... does not exist in the job
cache.
Has anyone seen this error before?
We do not have this problem on our other clustered servers.
Thanks in advance for your help.
Do you have SQL Server Agent starting with a domain account that is valid
on both nodes?
Are there any messages in the SQL Server or SQL Agent logs?
Are there any messages in the event logs?
Do the jobs refer to any files or other objects that only exist on one node?
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
We have recently setup a new cluster server. At the moment
the resources have swapped over so that 1 is running on
node 2 and vice-versa.
However this appears to be causing a problem with the SQL
scheduled tasks. All tasks in the list have (Date and
Time are not available) under 'Next Run Date.' All the
tasks will try and run at their scheduled time however if
we try and manually execute tasks we get the error message
Microsoft SQL-DMO (ODBC SQLState: 42000) Error 22022:
SqlServerAgent Error: Job ... does not exist in the job
cache.
Has anyone seen this error before?
We do not have this problem on our other clustered servers.
Thanks in advance for your help.
Do you have SQL Server Agent starting with a domain account that is valid
on both nodes?
Are there any messages in the SQL Server or SQL Agent logs?
Are there any messages in the event logs?
Do the jobs refer to any files or other objects that only exist on one node?
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft SQL-DMO
I got an error as following while I am trying to restore a database:
Microsoft SQL-DMO (ODBC SQLState:42000)
Device activation error: The physical file name ... may be incorrect.
Please help how to solve this problem. Thanks.Allen,
Check your spelling of the file name you are trying to restore from.
They do not match.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Allen Iverson" wrote:
> I got an error as following while I am trying to restore a database:
> Microsoft SQL-DMO (ODBC SQLState:42000)
> Device activation error: The physical file name ... may be incorrect.
>
> Please help how to solve this problem. Thanks.
>|||Mark,
But I use the browser to open the file. So the spelling should
be OK.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
> Allen,
> Check your spelling of the file name you are trying to restore from. They
> do not match.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> "Allen Iverson" wrote:
>> I got an error as following while I am trying to restore a database:
>> Microsoft SQL-DMO (ODBC SQLState:42000)
>> Device activation error: The physical file name ... may be incorrect.
>>
>> Please help how to solve this problem. Thanks.|||Note that the restore is performed on the server. Are you sitting on the server when you use
explorer to get the file name?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
> Mark,
> But I use the browser to open the file. So the spelling should
> be OK.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
> > Allen,
> >
> > Check your spelling of the file name you are trying to restore from. They
> > do not match.
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602m.html
> >
> >
> > "Allen Iverson" wrote:
> >> I got an error as following while I am trying to restore a database:
> >>
> >> Microsoft SQL-DMO (ODBC SQLState:42000)
> >>
> >> Device activation error: The physical file name ... may be incorrect.
> >>
> >>
> >> Please help how to solve this problem. Thanks.
>|||No, I am working on a client PC. But I did this before and no problem.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Note that the restore is performed on the server. Are you sitting on the
> server when you use
> explorer to get the file name?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
>> Mark,
>> But I use the browser to open the file. So the spelling
>> should
>> be OK.
>> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
>> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
>> > Allen,
>> >
>> > Check your spelling of the file name you are trying to restore from.
>> > They
>> > do not match.
>> >
>> > --
>> > Mark Allison, SQL Server MVP
>> > http://www.markallison.co.uk
>> >
>> > Looking for a SQL Server replication book?
>> > http://www.nwsu.com/0974973602m.html
>> >
>> >
>> > "Allen Iverson" wrote:
>> >> I got an error as following while I am trying to restore a database:
>> >>
>> >> Microsoft SQL-DMO (ODBC SQLState:42000)
>> >>
>> >> Device activation error: The physical file name ... may be incorrect.
>> >>
>> >>
>> >> Please help how to solve this problem. Thanks.
>>
>|||The filename specified is seen from SQL Server's perspective. If the file isn't on the SQL Server
machine you have to specify an UNC path for the file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:OceVUrbqEHA.2764@.TK2MSFTNGP11.phx.gbl...
> No, I am working on a client PC. But I did this before and no problem.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
>> Note that the restore is performed on the server. Are you sitting on the server when you use
>> explorer to get the file name?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> ""Allen Iverson"" <no_spam@.bk.com> wrote in message news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
>> Mark,
>> But I use the browser to open the file. So the spelling should
>> be OK.
>> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
>> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
>> > Allen,
>> >
>> > Check your spelling of the file name you are trying to restore from. They
>> > do not match.
>> >
>> > --
>> > Mark Allison, SQL Server MVP
>> > http://www.markallison.co.uk
>> >
>> > Looking for a SQL Server replication book?
>> > http://www.nwsu.com/0974973602m.html
>> >
>> >
>> > "Allen Iverson" wrote:
>> >> I got an error as following while I am trying to restore a database:
>> >>
>> >> Microsoft SQL-DMO (ODBC SQLState:42000)
>> >>
>> >> Device activation error: The physical file name ... may be incorrect.
>> >>
>> >>
>> >> Please help how to solve this problem. Thanks.
>>
>>
>
Microsoft SQL-DMO (ODBC SQLState:42000)
Device activation error: The physical file name ... may be incorrect.
Please help how to solve this problem. Thanks.Allen,
Check your spelling of the file name you are trying to restore from.
They do not match.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Allen Iverson" wrote:
> I got an error as following while I am trying to restore a database:
> Microsoft SQL-DMO (ODBC SQLState:42000)
> Device activation error: The physical file name ... may be incorrect.
>
> Please help how to solve this problem. Thanks.
>|||Mark,
But I use the browser to open the file. So the spelling should
be OK.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
> Allen,
> Check your spelling of the file name you are trying to restore from. They
> do not match.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> "Allen Iverson" wrote:
>> I got an error as following while I am trying to restore a database:
>> Microsoft SQL-DMO (ODBC SQLState:42000)
>> Device activation error: The physical file name ... may be incorrect.
>>
>> Please help how to solve this problem. Thanks.|||Note that the restore is performed on the server. Are you sitting on the server when you use
explorer to get the file name?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
> Mark,
> But I use the browser to open the file. So the spelling should
> be OK.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
> > Allen,
> >
> > Check your spelling of the file name you are trying to restore from. They
> > do not match.
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602m.html
> >
> >
> > "Allen Iverson" wrote:
> >> I got an error as following while I am trying to restore a database:
> >>
> >> Microsoft SQL-DMO (ODBC SQLState:42000)
> >>
> >> Device activation error: The physical file name ... may be incorrect.
> >>
> >>
> >> Please help how to solve this problem. Thanks.
>|||No, I am working on a client PC. But I did this before and no problem.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Note that the restore is performed on the server. Are you sitting on the
> server when you use
> explorer to get the file name?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
>> Mark,
>> But I use the browser to open the file. So the spelling
>> should
>> be OK.
>> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
>> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
>> > Allen,
>> >
>> > Check your spelling of the file name you are trying to restore from.
>> > They
>> > do not match.
>> >
>> > --
>> > Mark Allison, SQL Server MVP
>> > http://www.markallison.co.uk
>> >
>> > Looking for a SQL Server replication book?
>> > http://www.nwsu.com/0974973602m.html
>> >
>> >
>> > "Allen Iverson" wrote:
>> >> I got an error as following while I am trying to restore a database:
>> >>
>> >> Microsoft SQL-DMO (ODBC SQLState:42000)
>> >>
>> >> Device activation error: The physical file name ... may be incorrect.
>> >>
>> >>
>> >> Please help how to solve this problem. Thanks.
>>
>|||The filename specified is seen from SQL Server's perspective. If the file isn't on the SQL Server
machine you have to specify an UNC path for the file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:OceVUrbqEHA.2764@.TK2MSFTNGP11.phx.gbl...
> No, I am working on a client PC. But I did this before and no problem.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
>> Note that the restore is performed on the server. Are you sitting on the server when you use
>> explorer to get the file name?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> ""Allen Iverson"" <no_spam@.bk.com> wrote in message news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
>> Mark,
>> But I use the browser to open the file. So the spelling should
>> be OK.
>> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
>> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
>> > Allen,
>> >
>> > Check your spelling of the file name you are trying to restore from. They
>> > do not match.
>> >
>> > --
>> > Mark Allison, SQL Server MVP
>> > http://www.markallison.co.uk
>> >
>> > Looking for a SQL Server replication book?
>> > http://www.nwsu.com/0974973602m.html
>> >
>> >
>> > "Allen Iverson" wrote:
>> >> I got an error as following while I am trying to restore a database:
>> >>
>> >> Microsoft SQL-DMO (ODBC SQLState:42000)
>> >>
>> >> Device activation error: The physical file name ... may be incorrect.
>> >>
>> >>
>> >> Please help how to solve this problem. Thanks.
>>
>>
>
Microsoft SQL-DMO
I got an error as following while I am trying to restore a database:
Microsoft SQL-DMO (ODBC SQLState:42000)
Device activation error: The physical file name ... may be incorrect.
Please help how to solve this problem. Thanks.
Allen,
Check your spelling of the file name you are trying to restore from.
They do not match.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Allen Iverson" wrote:
> I got an error as following while I am trying to restore a database:
> Microsoft SQL-DMO (ODBC SQLState:42000)
> Device activation error: The physical file name ... may be incorrect.
>
> Please help how to solve this problem. Thanks.
>
|||Mark,
But I use the browser to open the file. So the spelling should
be OK.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Allen,
> Check your spelling of the file name you are trying to restore from. They
> do not match.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> "Allen Iverson" wrote:
|||Note that the restore is performed on the server. Are you sitting on the server when you use
explorer to get the file name?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
> Mark,
> But I use the browser to open the file. So the spelling should
> be OK.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
>
|||No, I am working on a client PC. But I did this before and no problem.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Note that the restore is performed on the server. Are you sitting on the
> server when you use
> explorer to get the file name?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
>
|||The filename specified is seen from SQL Server's perspective. If the file isn't on the SQL Server
machine you have to specify an UNC path for the file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:OceVUrbqEHA.2764@.TK2MSFTNGP11.phx.gbl...
> No, I am working on a client PC. But I did this before and no problem.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
>
Microsoft SQL-DMO (ODBC SQLState:42000)
Device activation error: The physical file name ... may be incorrect.
Please help how to solve this problem. Thanks.
Allen,
Check your spelling of the file name you are trying to restore from.
They do not match.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Allen Iverson" wrote:
> I got an error as following while I am trying to restore a database:
> Microsoft SQL-DMO (ODBC SQLState:42000)
> Device activation error: The physical file name ... may be incorrect.
>
> Please help how to solve this problem. Thanks.
>
|||Mark,
But I use the browser to open the file. So the spelling should
be OK.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Allen,
> Check your spelling of the file name you are trying to restore from. They
> do not match.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> "Allen Iverson" wrote:
|||Note that the restore is performed on the server. Are you sitting on the server when you use
explorer to get the file name?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
> Mark,
> But I use the browser to open the file. So the spelling should
> be OK.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
>
|||No, I am working on a client PC. But I did this before and no problem.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Note that the restore is performed on the server. Are you sitting on the
> server when you use
> explorer to get the file name?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
>
|||The filename specified is seen from SQL Server's perspective. If the file isn't on the SQL Server
machine you have to specify an UNC path for the file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:OceVUrbqEHA.2764@.TK2MSFTNGP11.phx.gbl...
> No, I am working on a client PC. But I did this before and no problem.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
>
Monday, February 20, 2012
Microsoft SQL Server Login
I'm getting the following message trying to connect through ODBC:
"Connection failed:
SQLState: '01S00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
Connection failed:
SQLState: 'S1T00'
SQL server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired"
I've been troubleshooting for about a month and haven't solve the problem.
Could anyone told me what to do in order to fix the problem?
Thanks in advance.Can you post the connection string you are using?
"Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
> I'm getting the following message trying to connect through ODBC:
> "Connection failed:
> SQLState: '01S00'
> SQL Server Error: 0
> [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
> Connection failed:
> SQLState: 'S1T00'
> SQL server Error: 0
> [Microsoft][ODBC SQL Server Driver]Timeout expired"
> I've been troubleshooting for about a month and haven't solve the problem.
> Could anyone told me what to do in order to fix the problem?
> Thanks in advance.|||Here is the connection string:
OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_CALLISTO;
Someone already suggest me to remove:
OPEN=ODBC
and it didn't connect.
Hope you can help me.
Thanks in advance
"Adam David Moss" wrote:
> Can you post the connection string you are using?
>
> "Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
> news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
> > I'm getting the following message trying to connect through ODBC:
> >
> > "Connection failed:
> > SQLState: '01S00'
> > SQL Server Error: 0
> > [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
> > Connection failed:
> > SQLState: 'S1T00'
> > SQL server Error: 0
> > [Microsoft][ODBC SQL Server Driver]Timeout expired"
> >
> > I've been troubleshooting for about a month and haven't solve the problem.
> >
> > Could anyone told me what to do in order to fix the problem?
> >
> > Thanks in advance.
>
>|||Try removing the database=... Your DSN already specifies this does it not?
"Alexis Robles" <AlexisRobles@.discussions.microsoft.com> wrote in message
news:175EC6DB-10AF-41B0-9DB2-A9AC10D1DCF3@.microsoft.com...
> Here is the connection string:
> OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_CALLISTO;
> Someone already suggest me to remove:
> OPEN=ODBC
> and it didn't connect.
> Hope you can help me.
> Thanks in advance
>
> "Adam David Moss" wrote:
> > Can you post the connection string you are using?
> >
> >
> > "Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in
message
> > news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
> > > I'm getting the following message trying to connect through ODBC:
> > >
> > > "Connection failed:
> > > SQLState: '01S00'
> > > SQL Server Error: 0
> > > [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
> > > Connection failed:
> > > SQLState: 'S1T00'
> > > SQL server Error: 0
> > > [Microsoft][ODBC SQL Server Driver]Timeout expired"
> > >
> > > I've been troubleshooting for about a month and haven't solve the
problem.
> > >
> > > Could anyone told me what to do in order to fix the problem?
> > >
> > > Thanks in advance.
> >
> >
> >|||Just out of curiosity:
If you test the connection using the ODBC admin applet does it successfully
connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||No, connection fail.
"Rand Boyd [MSFT]" wrote:
> Just out of curiosity:
> If you test the connection using the ODBC admin applet does it successfully
> connect?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
"Connection failed:
SQLState: '01S00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
Connection failed:
SQLState: 'S1T00'
SQL server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired"
I've been troubleshooting for about a month and haven't solve the problem.
Could anyone told me what to do in order to fix the problem?
Thanks in advance.Can you post the connection string you are using?
"Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
> I'm getting the following message trying to connect through ODBC:
> "Connection failed:
> SQLState: '01S00'
> SQL Server Error: 0
> [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
> Connection failed:
> SQLState: 'S1T00'
> SQL server Error: 0
> [Microsoft][ODBC SQL Server Driver]Timeout expired"
> I've been troubleshooting for about a month and haven't solve the problem.
> Could anyone told me what to do in order to fix the problem?
> Thanks in advance.|||Here is the connection string:
OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_CALLISTO;
Someone already suggest me to remove:
OPEN=ODBC
and it didn't connect.
Hope you can help me.
Thanks in advance
"Adam David Moss" wrote:
> Can you post the connection string you are using?
>
> "Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
> news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
> > I'm getting the following message trying to connect through ODBC:
> >
> > "Connection failed:
> > SQLState: '01S00'
> > SQL Server Error: 0
> > [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
> > Connection failed:
> > SQLState: 'S1T00'
> > SQL server Error: 0
> > [Microsoft][ODBC SQL Server Driver]Timeout expired"
> >
> > I've been troubleshooting for about a month and haven't solve the problem.
> >
> > Could anyone told me what to do in order to fix the problem?
> >
> > Thanks in advance.
>
>|||Try removing the database=... Your DSN already specifies this does it not?
"Alexis Robles" <AlexisRobles@.discussions.microsoft.com> wrote in message
news:175EC6DB-10AF-41B0-9DB2-A9AC10D1DCF3@.microsoft.com...
> Here is the connection string:
> OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_CALLISTO;
> Someone already suggest me to remove:
> OPEN=ODBC
> and it didn't connect.
> Hope you can help me.
> Thanks in advance
>
> "Adam David Moss" wrote:
> > Can you post the connection string you are using?
> >
> >
> > "Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in
message
> > news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
> > > I'm getting the following message trying to connect through ODBC:
> > >
> > > "Connection failed:
> > > SQLState: '01S00'
> > > SQL Server Error: 0
> > > [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
> > > Connection failed:
> > > SQLState: 'S1T00'
> > > SQL server Error: 0
> > > [Microsoft][ODBC SQL Server Driver]Timeout expired"
> > >
> > > I've been troubleshooting for about a month and haven't solve the
problem.
> > >
> > > Could anyone told me what to do in order to fix the problem?
> > >
> > > Thanks in advance.
> >
> >
> >|||Just out of curiosity:
If you test the connection using the ODBC admin applet does it successfully
connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||No, connection fail.
"Rand Boyd [MSFT]" wrote:
> Just out of curiosity:
> If you test the connection using the ODBC admin applet does it successfully
> connect?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
Microsoft SQL Server Login
I'm getting the following message trying to connect through ODBC:
"Connection failed:
SQLState: '01S00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Invalid connection string attribu
te
Connection failed:
SQLState: 'S1T00'
SQL server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired"
I've been troubleshooting for about a month and haven't solve the problem.
Could anyone told me what to do in order to fix the problem?
Thanks in advance.Can you post the connection string you are using?
"Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
> I'm getting the following message trying to connect through ODBC:
> "Connection failed:
> SQLState: '01S00'
> SQL Server Error: 0
> [Microsoft][ODBC SQL Server Driver]Invalid connection string attri
bute
> Connection failed:
> SQLState: 'S1T00'
> SQL server Error: 0
> [Microsoft][ODBC SQL Server Driver]Timeout expired"
> I've been troubleshooting for about a month and haven't solve the problem.
> Could anyone told me what to do in order to fix the problem?
> Thanks in advance.|||Here is the connection string:
OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_
CALLISTO;
Someone already suggest me to remove:
OPEN=ODBC
and it didn't connect.
Hope you can help me.
Thanks in advance
"Adam David Moss" wrote:
> Can you post the connection string you are using?
>
> "Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
> news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
>
>|||Try removing the database=... Your DSN already specifies this does it not?
"Alexis Robles" <AlexisRobles@.discussions.microsoft.com> wrote in message
news:175EC6DB-10AF-41B0-9DB2-A9AC10D1DCF3@.microsoft.com...[vbcol=seagreen]
> Here is the connection string:
> OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_
CALLISTO;
> Someone already suggest me to remove:
> OPEN=ODBC
> and it didn't connect.
> Hope you can help me.
> Thanks in advance
>
> "Adam David Moss" wrote:
>
message[vbcol=seagreen]
problem.[vbcol=seagreen]|||Just out of curiosity:
If you test the connection using the ODBC admin applet does it successfully
connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||No, connection fail.
"Rand Boyd [MSFT]" wrote:
> Just out of curiosity:
> If you test the connection using the ODBC admin applet does it successfull
y
> connect?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
"Connection failed:
SQLState: '01S00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Invalid connection string attribu
te
Connection failed:
SQLState: 'S1T00'
SQL server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired"
I've been troubleshooting for about a month and haven't solve the problem.
Could anyone told me what to do in order to fix the problem?
Thanks in advance.Can you post the connection string you are using?
"Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
> I'm getting the following message trying to connect through ODBC:
> "Connection failed:
> SQLState: '01S00'
> SQL Server Error: 0
> [Microsoft][ODBC SQL Server Driver]Invalid connection string attri
bute
> Connection failed:
> SQLState: 'S1T00'
> SQL server Error: 0
> [Microsoft][ODBC SQL Server Driver]Timeout expired"
> I've been troubleshooting for about a month and haven't solve the problem.
> Could anyone told me what to do in order to fix the problem?
> Thanks in advance.|||Here is the connection string:
OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_
CALLISTO;
Someone already suggest me to remove:
OPEN=ODBC
and it didn't connect.
Hope you can help me.
Thanks in advance
"Adam David Moss" wrote:
> Can you post the connection string you are using?
>
> "Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
> news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
>
>|||Try removing the database=... Your DSN already specifies this does it not?
"Alexis Robles" <AlexisRobles@.discussions.microsoft.com> wrote in message
news:175EC6DB-10AF-41B0-9DB2-A9AC10D1DCF3@.microsoft.com...[vbcol=seagreen]
> Here is the connection string:
> OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_
CALLISTO;
> Someone already suggest me to remove:
> OPEN=ODBC
> and it didn't connect.
> Hope you can help me.
> Thanks in advance
>
> "Adam David Moss" wrote:
>
message[vbcol=seagreen]
problem.[vbcol=seagreen]|||Just out of curiosity:
If you test the connection using the ODBC admin applet does it successfully
connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||No, connection fail.
"Rand Boyd [MSFT]" wrote:
> Just out of curiosity:
> If you test the connection using the ODBC admin applet does it successfull
y
> connect?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
Microsoft SQL Server Login
I'm getting the following message trying to connect through ODBC:
"Connection failed:
SQLState: '01S00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
Connection failed:
SQLState: 'S1T00'
SQL server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired"
I've been troubleshooting for about a month and haven't solve the problem.
Could anyone told me what to do in order to fix the problem?
Thanks in advance.
Can you post the connection string you are using?
"Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
> I'm getting the following message trying to connect through ODBC:
> "Connection failed:
> SQLState: '01S00'
> SQL Server Error: 0
> [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
> Connection failed:
> SQLState: 'S1T00'
> SQL server Error: 0
> [Microsoft][ODBC SQL Server Driver]Timeout expired"
> I've been troubleshooting for about a month and haven't solve the problem.
> Could anyone told me what to do in order to fix the problem?
> Thanks in advance.
|||Here is the connection string:
OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_CALLISTO;
Someone already suggest me to remove:
OPEN=ODBC
and it didn't connect.
Hope you can help me.
Thanks in advance
"Adam David Moss" wrote:
> Can you post the connection string you are using?
>
> "Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
> news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
>
>
|||Try removing the database=... Your DSN already specifies this does it not?
"Alexis Robles" <AlexisRobles@.discussions.microsoft.com> wrote in message
news:175EC6DB-10AF-41B0-9DB2-A9AC10D1DCF3@.microsoft.com...[vbcol=seagreen]
> Here is the connection string:
> OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_CALLISTO;
> Someone already suggest me to remove:
> OPEN=ODBC
> and it didn't connect.
> Hope you can help me.
> Thanks in advance
>
> "Adam David Moss" wrote:
message[vbcol=seagreen]
problem.[vbcol=seagreen]
|||Just out of curiosity:
If you test the connection using the ODBC admin applet does it successfully
connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||No, connection fail.
"Rand Boyd [MSFT]" wrote:
> Just out of curiosity:
> If you test the connection using the ODBC admin applet does it successfully
> connect?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
"Connection failed:
SQLState: '01S00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
Connection failed:
SQLState: 'S1T00'
SQL server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired"
I've been troubleshooting for about a month and haven't solve the problem.
Could anyone told me what to do in order to fix the problem?
Thanks in advance.
Can you post the connection string you are using?
"Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
> I'm getting the following message trying to connect through ODBC:
> "Connection failed:
> SQLState: '01S00'
> SQL Server Error: 0
> [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
> Connection failed:
> SQLState: 'S1T00'
> SQL server Error: 0
> [Microsoft][ODBC SQL Server Driver]Timeout expired"
> I've been troubleshooting for about a month and haven't solve the problem.
> Could anyone told me what to do in order to fix the problem?
> Thanks in advance.
|||Here is the connection string:
OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_CALLISTO;
Someone already suggest me to remove:
OPEN=ODBC
and it didn't connect.
Hope you can help me.
Thanks in advance
"Adam David Moss" wrote:
> Can you post the connection string you are using?
>
> "Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
> news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
>
>
|||Try removing the database=... Your DSN already specifies this does it not?
"Alexis Robles" <AlexisRobles@.discussions.microsoft.com> wrote in message
news:175EC6DB-10AF-41B0-9DB2-A9AC10D1DCF3@.microsoft.com...[vbcol=seagreen]
> Here is the connection string:
> OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_CALLISTO;
> Someone already suggest me to remove:
> OPEN=ODBC
> and it didn't connect.
> Hope you can help me.
> Thanks in advance
>
> "Adam David Moss" wrote:
message[vbcol=seagreen]
problem.[vbcol=seagreen]
|||Just out of curiosity:
If you test the connection using the ODBC admin applet does it successfully
connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||No, connection fail.
"Rand Boyd [MSFT]" wrote:
> Just out of curiosity:
> If you test the connection using the ODBC admin applet does it successfully
> connect?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
Subscribe to:
Posts (Atom)