Yes, makes perfect sense, especially now that I have a much better idea about the udl files than what I have read.
Unfortunately though, no, still not working.
I did figure out how to hook up an error return functoid and now can see the error, however slightly ambiguous to me…
Format of the initialization string does not conform to specification starting at index 0
after doing some googling on this, it looks like it relates to the connection string. it also looked like it could be a Microsoft bug based on some of the forums I read but not convinced.
In any case, I created the .udl file like you said. and upon testing connection it succeeded. I am slightly lost when you said to use the SQL native client if I had it installed… This is something automatically installed on the SQL 2005 server, so is this also something that maybe needs to be installed onto the same server as Biztalk because currently these are both residing on seperate servers.
does any of this sound familiar or do you have any tips on how I can continue to narrow this issue down?
Thanks again…