Community
Showing results for 
Search instead for 
Do you mean 
Reply

Conversion failed when converting from a character string to uniqueidentifier.

Accepted Solution Solved
New Member
Posts: 3
Country: India
Accepted Solution

Conversion failed when converting from a character string to uniqueidentifier.

Hi,

 

I'm using Act! Premium Version 17.0.151.0.

Using ACTReader utility I had reset the password of ACTREADER account.

 

I'm trying to access one of the views dbo.CONTACT using sql server management studio, I'm still getting the error mentioned in subject line.

What can I do to make it work?

 

I need to write some complex queries in sql server management studio, I just need to read data and not write anything.

 

<MAC>


Accepted Solutions
Solution
Accepted by topic author macj21
‎09-25-2015 03:20 AM
New Member
Posts: 3
Country: India

Re: Conversion failed when converting from a character string to uniqueidentifier.

ok, so after a lot of trial and erros I've finally figuered it out.

 

you just need to go into the dbo.TBL_ACCESSOR table, pick up an accessor_id and put it in the additional connection parameters window of the connection tab.

Over there you need to put it as Application Name = accessor_id which you picked up above.

 

 

View solution in original post


All Replies
New Member
Posts: 3
Country: India

Re: Conversion failed when converting from a character string to uniqueidentifier.

Hello Guys,

 

It would be great if someone could help me out on this.

 

Please please Smiley Happy

 

Mac

Solution
Accepted by topic author macj21
‎09-25-2015 03:20 AM
New Member
Posts: 3
Country: India

Re: Conversion failed when converting from a character string to uniqueidentifier.

ok, so after a lot of trial and erros I've finally figuered it out.

 

you just need to go into the dbo.TBL_ACCESSOR table, pick up an accessor_id and put it in the additional connection parameters window of the connection tab.

Over there you need to put it as Application Name = accessor_id which you picked up above.