Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
 Posted - 2006-11-13 : 10:09:45
|
| Hi,I've written VBScript functions (.bas), and SQL that uses those functions. When using DTS how does SQL Server know where to look to find the function definitions? If I create a DTS package and place the ActiveX and the SQL in it, will it just know where to look, or do they have to be connected or something?Many thanksDrew |
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-11-13 : 11:02:02
|
| I think I might be misunderstanding how it works, so I'll rephrase the question.In Access, I have written SQL that retrieves data from several tables. This SQL accesses vbscript functions in a .bas file. I want to move from Access to SQL Server. Is there a way I can use these vbcript functions in SQL Server using the same .bas file/vbscript?Thanks againDrew |
 |
|
|
|
|
|
Question from a non developer about active x