Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to specify failover partner name?

  
   Database Forums (Home) -> Server RSS
Next:  Beautifiul Mind: Thinking about Dijkstra  
Author Message
Olav

External


Since: Apr 09, 2006
Posts: 2



(Msg. 1) Posted: Thu Apr 27, 2006 7:55 pm
Post subject: How to specify failover partner name?
Archived from groups: microsoft>public>sqlserver>server (more info?)
I have setup SQL Server 2005 SP1 with database mirroring.

I have a client application connecting to the database via ODBC and I define
the connection under the System DSN tab in the ODBC Data Source
Administrator (launched from Administrative Tools).

How can I specify the failover partner name?

Olav

 >> Stay informed about: How to specify failover partner name? 
Back to top
Login to vote
Olav

External


Since: Apr 09, 2006
Posts: 2



(Msg. 2) Posted: Thu Apr 27, 2006 7:55 pm
Post subject: Re: How to specify failover partner name? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I tried putting this in my connection string:

connectionString="DSN=Commerce;Failover Partner=cheetah"

But, it failed with the following error:

ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string
attribute

Olav

"Olav" wrote in message

>I have setup SQL Server 2005 SP1 with database mirroring.
>
> I have a client application connecting to the database via ODBC and I
> define the connection under the System DSN tab in the ODBC Data Source
> Administrator (launched from Administrative Tools).
>
> How can I specify the failover partner name?
>
> Olav
>

 >> Stay informed about: How to specify failover partner name? 
Back to top
Login to vote
Paul Buxton

External


Since: Oct 21, 2005
Posts: 2



(Msg. 3) Posted: Fri Apr 28, 2006 8:55 am
Post subject: Re: How to specify failover partner name? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Fri, 28 Apr 2006 01:16:52 +0200, Olav wrote:

> I tried putting this in my connection string:
>
> connectionString="DSN=Commerce;Failover Partner=cheetah"
>
> But, it failed with the following error:
>
> ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string
> attribute
>
> Olav
>
> "Olav" wrote in message
>
>>I have setup SQL Server 2005 SP1 with database mirroring.
>>
>> I have a client application connecting to the database via ODBC and I
>> define the connection under the System DSN tab in the ODBC Data Source
>> Administrator (launched from Administrative Tools).
>>
>> How can I specify the failover partner name?
>>
>> Olav
>>


You need to use the ODBC driver SQL Native Client, and not the SQL Server
driver.
 >> Stay informed about: How to specify failover partner name? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL 2005 failover cluster - Hi, I'm about to install a 2005 failover cluster. I've read best practice and I have a question about storage. When installing a sql cluster a shared array is used for data and log files. This shared array usually is resident on a SAN (RAID 10). For..

Passing table variable as input parameter to stored proc - I understand you cannot pass a table variable as input parameter to a stored proc. But what is the alternative in my case? Current DB standards limit access of linked servers to the execution of stored procs and functions, no cross server joins. But...

Need Help in interpreting Lock:Timeout Error in SQL Profil.. - Hi, I need some help in interpreting trace from SQL profiler. I'm seeing a whole bunch of Lock:Timeout events in SQL Profiler Trace. >From the trace, it seems like for spid=118, database issues "SP:StmtStarting" event for opening a cursor f...

Urgent - General Network Error - Hi , I have a subscription that keeps failing to synchronise with the following error : "General Network Error. Check your network documentation" how can i check the cause & resolve ? kindly advise

cannot start MSSQLServerOLAPService....error 1058: the ser.. - sql 2000 w/ sp4 running on w2k3 using sql authenitcation.......olap service account is running under AD admin account and is a member of local OLAP admin group. not sure what else to check.....have looked all over the net. thanks.
   Database Forums (Home) -> Server All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]