Geeks With Blogs
Clara's Notes on Technology Notes to me and the world
The adapter can be downloaded from here (gotdotnet).

I found a small but annoying bug in the code that did not even let me start with the adapter.

In file ODBCHelper.cs, line 69, check if the key is null before closing it:

if (keyDsnNames != null) 
   keyDsnNames.Close();

Otherwise, the consequence is "Object reference not set to instance of an object" every time you try to set a new DSN or open the DSN list.

If you don't want to recompile the project you can add the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources to HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources.
Posted on Saturday, December 16, 2006 3:54 PM BizTalk | Back to top


Comments on this post: ODBC Adapter for BizTalk : Bug

# re: ODBC Adapter for BizTalk : Bug
Requesting Gravatar...
I'am unable to insert data into sql database thro' this adapter. only the first character is inserting.

for example,

in the name field if we have "andry",it is inserting only a in the corresponding field.

what might be the wrong. is it working fine with the sql.

please guide me.

thanks
latha
Left by Amrutha on Jan 10, 2007 4:25 AM

# re: ODBC Adapter for BizTalk : Bug
Requesting Gravatar...
If only one character is inserting, it means that the query syntax is ok and that the adapter is working but there is something wrong with the parameter.

I would suspect the length of the parameter (varchar?) is not set correctly. By default, it will be 1, which could explain why only the first character is inserted.

You can check your query from the wizard. In the 'statement information' screen, check the box 'override default query processing' and click 'generate'. You will get a screen were you can test the query and set the parameters type and length.

Left by Clara on Jan 10, 2007 8:08 AM

# re: ODBC Adapter for BizTalk : Bug
Requesting Gravatar...
The Link for gotdotnet is broken, please let me know where i can get this adapter

Thanks

regards
Arun Prasath
Left by Arun Prasath on Dec 15, 2008 7:15 AM

Your comment:
 (will show your gravatar)


Copyright © Clara Oscura | Powered by: GeeksWithBlogs.net