Can SQL server call predefined vb functions?

[andrefrancis]

I need to convert an Access database to an SQL server database some time soon. However the Access db contains some queries that call vba functions.

Does anyone know whether this will cause problems? I know that SQL server can call so-called UDFs (User Defined Functions) but can it handled pre-defined VBA functions?

I'd appreciate any relevant comments anyone can make.

Thank you in anticipation.

Andre

 

[SQL_Hell]

Hi there,

Short answer.... no, sql server will not know anything about your VB functions, so use either sql injection in conjunction with your VB functions or use UDFs.

.NET classes and assemblys can be referenced in sql server 2005 through the CLR integration, but unless you are willing to re-write your front end in C#.NET (for example) then this isn't muuch use to you.

 

[andrefrancis]

Hi there,

Short answer.... no, sql server will not know anything about your VB functions, so use either sql injection in conjunction with your VB functions or use UDFs.

.NET classes and assemblys can be referenced in sql server 2005 through the CLR integration, but unless you are willing to re-write your front end in C#.NET (for example) then this isn't muuch use to you.

OK. Thanks ... I was sort of resigned to other methods ... which I have now found