User684337954 posted
Hello, I am trying to connect to a remedy server through visual studio. I was using access database to try to connect to a server using the AR connection but the connection kept timing out.
I am NO Longer using an Access Database. I have heard that using visual studios is much more effecient so i am attempting to usie it for my query. I am having some problems with it.
When i first log on, i get a strange error message
"Column 'TABLE_CAT' does not belong to table Tables."
The second problem I have is trying to figure out how to convert a field from 1 type to another. I am unsure of the datatype but it appears to be a datetime with am/pm. It could also be a string. Anyone have a good website or suggestion on how to convert
as when i try
CONVERT(datetime, name_of_datefield, 101) = '12/01/2010')
I get another error :
"Expected Lexical element not found:)
