I am using a userdefined assembly funciton which is basically defined in VB.net and calling it from SQL Server 2008. Now, when it did call it then SQL server gives me error.
My code is as following:
select dbo.geocode('2650, college place','Fullerton','CA','92831','USA')
Where geocode is the function, originally defined in VB>net which convert any address into its longitude and lattitude. So basically when I am writting the query mentioned above then I am expecting the out put to be some thing like this (33.994278,-117.887951) where the values are Longotude and Lattitude of that address respectively.
And I am getting follwoing error:
Trying to convert return value or output parameter of size 48 bytes to a T-SQL type with a smaller size limit of 2 bytes.
I think there is come converison problem but how to deal with that??