Boy, I hate to sound dumb here but this is what I have done… I setup separate servers for SQL 2005 and Biztalk. I was told that it was not a good idea to install both on the same server. (Since then, I have seen where this would not be a problem) Anyway, All I have on my Biztalk server that is SQL related is the configuration manager. I also just installed the distributable client found in the setup disks just to make sure I had that covered.
You should also know that I have been interfacing with the SQL database because I have working projects so all that should be straight… its just for some reason, I am getting this one error during the lookup… I guess what I need to know is how do I check if this native client is active? I have the udl file setup to use this… as for the functoid configuration, I believe I have it setup correctly. obviously, I am not so saavy on SQL, I just installed it on a development server just to fill the biztalk installation requirement. nothing fancy
This is exactly what I have in my DB lookup functoid
01 (hardcoded key value just to get the test working)
c:\DBConnection.udl (literal location of file)
dbo.TESTDBF (database table name)
ShipToNumber (table key column for lookup)
The extractor functoid has the lookup input and just the output column
This is the exact contents of my .uld file…
[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;User ID=kb17324dx;Initial Catalog=TESTDB;Data Source=HPSQL05T
Does this give you any better idea what I have and what I dont have?