[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access deni

Hi

I wrote an inline callout, which retrieves the values from db - table .

the ipl is executing perfectly at the command prompt.

but it is not executing from Teamsite ui, ie, when i do NewForm entry, it is giving the following error.

Root cause:
DBI connect('MSSQL-asterisk','xxxx',...) failed: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000) at C:\Interwoven\TeamSite\httpd\iw-bin\connectToDb.ipl line 19 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000) at C:\Interwoven\TeamSite\httpd\iw-bin\connectToDb.ipl line 19.

attached the ipl program as well.

any help.
thanks, bala

Find more posts tagged with

Comments

Migrateduser

Did you set up your DSN as a User DSN or a System DSN? It should be a System DSN or it will only be available to you to use when you are using RDP or are physically on the computer.

Balaveera Thatikonda

using the system dsn.

Any way the problem resolved by adding the evnironment variable:

$ENV{'SystemRoot'}="C:/WINDOWS";

thanks, balaveera