Search results for query: *

That worked! I am not sure I understand the error log part? how to I write to a error log the message?

I am using the following cdos code to connect to a remote smtp mail server. it works perfectly when a valid email address is given, if a fake one is given then it errors the page. is their anyway to prevent this? i tried the javascript approach but it still fails sometimes. Const...

:( You guys are right. They told me they do not allow these connection to be done on the web server i am hosted by. Man that stinks, anyway around that? I have a domain www.something.com and need to migrate to a dedicated server i just bought through another company. it is setup and...

The dedicated server has no firewall. The web server may. I did a netstat -an and do not see 1433 listening but it says it is set in sql server manager.

tcp/ip has to be because it works perfeclty on the same server. can you suggest anymore connection strings?

my server does not have a name it is just an ip address. i do not understand that full the dns server stuff you mentioned. how do i get it to authenticate via SQL so this is not an issue?

BB Same result, it just hangs.... This is so frustration because it works perfectly while on the same server? There has to be something wrong somewhere with my code...

Hello, I am using the following connection string on my hosted website plan: dim DbConn Dim dbDir Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionTimeout = 0 dbConn.CommandTimeout = 0 DbConn.Open("DRIVER={SQL Server};SERVER=xx.xx.xx;DATABASE=test;UID=tes;pwd=test;") When...

Hello, I am using the following connection string on my hosted website plan: dim DbConn Dim dbDir Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionTimeout = 0 dbConn.CommandTimeout = 0 DbConn.Open("DRIVER={SQL Server};SERVER=xx.xx.xx;DATABASE=test;UID=tes;pwd=test;") When...

I am using the following code to set a filter on one of my forms: Private Sub Form_Open(Cancel As Integer) 'Set unbound textbox = to login name. Me.LoginName = strUserName 'Apply filter based on Username field. Me.Filter = "[ReportsTo] = '" & Me.LoginName & "'" Me.FilterOn = True End Sub I...

paulha, Will I be able to use CDOs on my asp webpages?

?

I have a Windows 2000 server and a static ip address. I use this a web server for a website. I want to install sometime of email program so i can have email addresses for my website. I use CDOS on asp web pages a lot and want to be able to fire off emails from this web server now. i have no...

I have a Windows 2000 server and a static ip address. I use this a web server for a website. I want to install sometime of email program so i can have email addresses for my website. I use CDOS on asp web pages a lot and want to be able to fire off emails from this web server now. i have no...

sqlsis, sp_changeowner is my new favorite SP. I will be using it 1000 times today.....

they said no way...I am doing it manually :(.............................Any other thoughts....this is a lesson to me like you said ..........

I have noticed when developing in ACCESS project and SQL server 2000 that I get mixed owners of table and views i create and i am not sure why? i login the sameway for both cases as a user that is the DB_Owner? Can someone clearify this process to me so I can stay consistent. i did not notice...

the problem is the view code refers to OLDOWNER.TABLENAME. I have 500 views like that....How would I change the references in mass? I PRAY TO GOD I DO NOT HAVE TO MANUALLY DO THIS........ Any advice on that. Not sure that changing the owner of the view would help this because the select...

jamfool that was a cool script, it did change the name for the tables i have. Will it mess anything up in the master DB that would poor my perfoprmance? i do not like messing around with a db this way but i have no choice and just wanted to make sure that the inner workings do not get messed...

thats for the response drsql and jamfool. i do need more help and am not sure what the code does that you posted? Could you provide more insight?