Community
Showing results for 
Search instead for 
Do you mean 
Reply

SQL error when opening dbo.CONTACT view

Copper Contributor
Posts: 61
Country: USA

SQL error when opening dbo.CONTACT view

When I attempt to open the dbo.CONTACT view using Microsoft SQL Server Management Studio, I get this error:

Msg 8169, Level 16, State 2, Line 2
Conversion failed when converting from a character string to uniqueidentifier.

 

Any ideas how I can put this (and other) view(s) on-line? I am using 21.1.187.0, Update 2

 

2.png

Copper Contributor
Posts: 61
Country: USA

Re: SQL error when opening dbo.CONTACT view

I found a couple of solutions to my issue:
1) To retrieve the information I wanted for this project, I executed this SQL query:
SELECT TYPENUM,FIRSTNAME,LASTNAME,SALUTATION,FULLNAME,CATEGORY,COMPANYNAME,BIRTHDATE,USER7,CUST_QB_CustomerName_064457805,CUST_PrimaryContact_101147036,CUST_WedAniv_014154089, Katy.dbo.TBL_EMAIL.ADDRESS
FROM Katy.dbo.TBL_CONTACT
INNER JOIN Katy.dbo.TBL_EMAIL ON Katy.dbo.TBL_CONTACT.CONTACTID=Katy.dbo.TBL_EMAIL.CONTACTID

 

2) To go back to the old way of doing things with the ACT OLE DB Provider for Reporting 2.0:
regsvr32 c:\Program Files (x86)\ACT\Act for Windows\ACTOLEDB2.dll
shutdown -r -t 0 -f