Home
TeamSite
DNS Error
Bhargav Coca
Hello,
I am on Teamsite 6.5, on win 2003, I am trying to populate the select box from Database and it is giving me the following error, can ayone help me debug this please, i have the same incall command it calls and it works fine there, i guess there is some problem with DNS configuration. Please advice.
Thank you
here is the error
DBI connect('Broadlane','teamsite',...) failed: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000)(DBD: db_login/SQLConnect err=-1) at E:\iw-home\iw-perl\bin\populate1.ipl line 7 Unable to connect: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000)(DBD: db_login/SQLConnect err=-1)
Thank you
Find more posts tagged with
Comments
Migrateduser
If you can refer to the machine via IP, do that. Otherwise, add the following to C:\Windows\System32\drivers\etc\hosts:
<ip_address> teamsite
Obviously, replace <ip_address> with that machine's IP address.
Dave
Current Environments:
(1) TS 6.5 on W2K3 (x2 - diff. imp.)
(3) Vignette V7 Portal on Solaris 9
cliffhanger
If you have access to the teamsite server, you can check the System DSN configuration for the ODBC string you're using in this script, and verify that the database(Database server and database name), username/password is correct.
Edited by cliffhanger on 07/18/05 02:04 PM (server time).
Bhargav Coca
No, it doesn't help either way, let me know if you have somemmore suggestions.
Thank you
Migrateduser
Okay, well this seems like more of a problem with your network environment, not TeamSite Templating. I'd check with them first as to why you're getting a DNS error.
If you're saying that you've tried using the IP address and it still doesn't work, what's the error? It can't possibly be the same error if you're using the IP.
Dave
Current Environments:
(1) TS 6.5 on W2K3 (x2 - diff. imp.)
(3) Vignette V7 Portal on Solaris 9
Bhargav Coca
Yes Miss P, i have checked the username and password, i am refering to a different database now, not as in the dev box, Well our company decided to have different database server for production. So please let me know if there is any other reason for this error to occur.
Thank you
Bhargav Coca
here is the error with the ip address modifications
DBI connect('Broadlane','teamsite',...) failed: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000)(DBD: db_login/SQLConnect err=-1) at E:\iw-home\iw-perl\bin\populate1.ipl line 7 Unable to connect: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000)(DBD: db_login/SQLConnect err=-1)
thank you
Migrateduser
Okay, well the IP address is working better for you than the name. In the meantime, it looks as though your login credentials are bad (?) Are you able to get to the database from a client query tool (independent of TS)?
Dave
Current Environments:
(1) TS 6.5 on W2K3 (x2 - diff. imp.)
(3) Vignette V7 Portal on Solaris 9
cliffhanger
Miss P...hmmm you seem to know me, although I am at a loss...
Anyway, I have had this error messages many times before, usually it turned out to be the ODBC connection string was pointing to a different database than what I assumed.
Is this not working as a result of code promotion to prod from DEV/QA?
Bhargav Coca
Yes, From the query manager , i could login to it, and it retruns what ever i want. But i am surprised, adn why it is not allowing me from inline.
Thanks
Bhargav Coca
I couldn't get my inline to access the database, still gives me the same errror, I have just learned that , the database is behind the firewall, and that might be the reason for this error message. Can any let me know how to work around the firewall to hit the database.
Thank you
Migrateduser
The point of a firewall is to prevent communication and/or to isolate resources and services. So, if you can't have the appropriate people open up a port for you (I don't recall which port is used by SQL Server), I don't see how your customer can expect you to accomplish this.
So, instead of trying to circumvent the firewall, I think the next appropriate step is to have a conversation with the network people in your organization.
Dave
Current Environments:
(1,2) TS 6.5 on W2K3
(3) Vignette V7 Portal on Solaris 9
Migrateduser
make sure the following are set correctly in the perl script:
BEGIN {
$ENV {ORACLE_HOME} =
$ENV {Path} =
$ENV {SystemRoot} =
}
-------------------
World of Warcraft
— Illidan/Horde
Migrateduser
Umm, what does that have to do with anything? She's on SQL Server, not Oracle, which was explained in the initial post.
Dave
Current Environments:
(1,2) TS 6.5 on W2K3
(3) Vignette V7 Portal on Solaris 9
cliffhanger
Even for SQL s/he still need to provide the TMEP and SYSTEMROOT information, isn't it?
lilleywhite, does this script give the same error if you run it independently, not though a callout?
Migrateduser
I'm not sure -- I've made calls to SQL Server without having to specify the usual overhead that Oracle demands, and if the database instance is registered with ODBC, that should make it even more straight-forward.
S/he had indicated that there's a firewall between the app and the database, so I think I concluded to myself that this might be the connection issue.
Dave
Current Environments:
(1,2) TS 6.5 on W2K3
(3) Vignette V7 Portal on Solaris 9
cliffhanger
guess you're right....let's see if s/he comes back with a resolution
Migrateduser
Well, s/he mentioned that it's working properly from an "incall" command, which I take to mean an inline, so that makes me curious. Does this inline reside on the same box as the other mechanism that is not working (presumably, yes)? Maybe there's some problem with his/her SQL that we're not accounting for. Who knows?
Without a response, there's not much we can do
Dave
Current Environments:
(1,2) TS 6.5 on W2K3
(3) Vignette V7 Portal on Solaris 9
Bhargav Coca
hello all,
well just now ,i have figured out that there is no firewall issue, cuz my teamsite and database are on same level. But for some reason it still doesn't like to connect to the database. Ok here from our DBA we have an other option to write a perl script which uses ADO to connect to the database, for this we need win32:
DBC module, i was wondering where i can get this module, Irrespective of s/he can anyone get me this module or help me resolve this issue.
Thanks
Migrateduser
iw-perl comes bundled with Win32:
DBC, DBD:
DBC and DBI::W32ODBC, so you're good there.
Current Environments:
(1,2) TS 6.5 on W2K3
(3) Vignette V7 Portal on Solaris 9
fiquebem
>Even for SQL s/he still need to provide the TMEP and SYSTEMROOT information, isn't it?
I was running into the same difficulty: "SQL Server does not exist or access denied." We are upgrading from TS 5.5.2 on Windows 2000 to TS 6.5 on Windows 2003. The script on the old box was working fine with:
$ENV{SYSTEMROOT} = 'c:/winnt';
The script is working fine on the new box now that:
$ENV{SYSTEMROOT} = 'C:/WINDOWS';
When searching Google, I got the impression that I'd make progress if I specified the connection port in the DNS string somehow. Reading DevNet, I got the better idea of checking the SYSTEMROOT variable. Long live DevNet and Interwoven!
S.
