Very Computer

I cannot use the SHAPE command when using UDL file

This problem is outline in the following knowledge base article

http://support.microsoft.com/support/kb/articles/Q208/2/10.ASP

But the problem still occurs when using the Microsoft OLE DB Providor for
Oracle.
IT also doesnt work using the Informix OLE DB provider supplier by informix.

Both Providers work if the full conection string is hard coded in the
application.

I assume it has only been fixed for SQL server.

Anyone know of a work around. I do not want to use hard coded connection
strings
in the application. I am thinking of reading the UDL file using io commands
and building the
string up that way. Anybody done this or got a better solution?

Thanks

Craig

I have to admit I was under the impression that the SHAPE command would only
work with "MSDataShape" provider.

NB.

Quote:> I cannot use the SHAPE command when using UDL file

> This problem is outline in the following knowledge base article

> http://support.microsoft.com/support/kb/articles/Q208/2/10.ASP

> But the problem still occurs when using the Microsoft OLE DB Providor for
> Oracle.
> IT also doesnt work using the Informix OLE DB provider supplier by
informix.

> Both Providers work if the full conection string is hard coded in the
> application.

> I assume it has only been fixed for SQL server.

> Anyone know of a work around. I do not want to use hard coded connection
> strings
> in the application. I am thinking of reading the UDL file using io
commands
> and building the
> string up that way. Anybody done this or got a better solution?

> Thanks

> Craig