I am using MS-SQL Server2000 on my PC & my webhost is also using the same version.
Now the problem is that I have a lot of data in my local database which I want to port my database on my web-server. Since its lots of data, I can't enter it the conventional way of data-entry. Can someone tell me how to do it.
I have created a form that sends email thru my local server. What I want to do is send the email thru our corporate Exchange server. Does anyone know how I can accomplish this task? Please advise. Thanks.
I am not an expert but I am trying to create an application where I need to connect my website to the user's(basically my client) database in access and then I will read the values from the database in the local drive and upload all the values in the database at my webspace. I will have everything like the database name and the password....so how can I do this
An application runs on server, and is used for Hour-registration. Now I want to run the application local, I use SQL Server 2005, and managed to fix connection changes.
But now, I get this error everytime I run the application:
Microsoft VBScript runtime error Error Code :0x800A01CA
Error source : Error Description :Variable uses an Automation type not supported in VBScript
What is the best way to set up a server with MSSQL on your local machine. I have IIS set up, and am wondering if there is some way to get MSSQL for testing purposes for a reduced cost? From what I understand, a typical MSSQL license is around $8,000, am I right
I am using Windows XP Pro, and since I updated to Internet Explorer 7 I am having problems getting web sites to work on my PC in Internet Explorer using the local IIS web server. These web sites are using ASP and Access databases.
The two errors I get are: Operation must use an updateable query or Cannot modify the design of table 'TABLE_NAME'. It is in a read-only database.
Does anyone know how I can get this working so I can test my web sites locally before uploading them to the live sites?
I have a SQL server db set up locally. I have a local DSN set up. I have DW connected to the SQL server db and can create Bindings and use Server Behaviors without any problem. When I try to test the site locally in the browser, I get the following error:
"Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "xxxxxxx" requested by the login. The login failed."
What i want to do is pass strpath1 to my locally ran script which is the bit at the bottom but i cant find a way to do it i have tried request.querystring("strpath1")
im trying to create a intranet site which copies files to the server. im guessing i should use filesystemobject to achieve this but im not sure on how to accompish this.
anyone could assist me in finding an ASP script to find the current playing media in a local Windows Media Services server. Since the particular stream is a broadcast, it will have constantly changing media.
On a remote server running W2K and thus IIS 5 I have session variables declared in a global.asa file in the root of the application which are passed and visible on all pages with no problem. This was also the case on my localhost before (127.0.0.1), also on W2K / IIS 5. But now for some reason one variable doesn't pass through at all and the other is taken as a String on the localhost.
The problem area in question in my Global.asa file (which is identical on the remote and local servers)
<script language="vbscript" runat="server">
Sub Session_OnStart CInt(Session("indx"))=0 CInt(Session("total"))=0 ... End Sub
Having finally mastered freeASPUpload, I really want the files being uploaded to the web server to automatically be forwarded to my local inhouse server. I'm sure there has to be a way.
my current setting is user will click a link in the web page and choose the place that they want to save the file to.
Now i am trying to auto download the file. that means user click the link, it straight away download to for eg. "D:Test". my problem is the web page is at server. user will access the web page thru http, but how am i going to auto download to the user's local drive?
I'm current working on a project which need to upload local data to live server database.
Meanings that, i'm current having a server in my local mechine. I need upload data from local database to live database which host at oversea company. But i really have no idea how to do this in asp.
I have sql server express at my PC-windows xp professional, I try to connect to a table via asp (queryString :"Driver={SQL Server};" &"Server=localhost;" & _ "Database=local;" & "Uid=nikos;" & "Pwd=nikos;" but there is an error Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL server does not exist or there is no permission.
I can login with EMS lite both with sql server Auth. and windows auth.What is fault?
I'm trying to install a simple e-mail form to my webpage; which takes some info from user (like name, phone, e-mail,etc...) and when user pushes submit button e-mails them to me immediately. I've tried to do so with ASP Formmail but I couldn't succeed. . it gives me: Server object error " 'ASP 0177 : 800401f3' Server.CreateObject Failed " error. Can anyone please help me to install my form? Because I need to install it immediately;
I need to read a SQL Server table into a Web Page and within the Web Page to permit my users to make changes to the records, delete or add new records and then save the entire contents back to the SQL Server table back.
The functionality I am looking is almost the same as In the SQL Enterprise Manager whereby I can choose a table open the table and then return all rows and I can maintain the same and save it back to the SQL Server table. I want almost a similar web interface to such a functionality.
Even if not a generic functionality as the SQL Enterprise Manager table maintenance appreciate if somebody can share the code with a sample how I can do it in ASP pages + T-SQL if need be.
I'm just about to start a project that needs to combine the results of a SQL Server query with the results of an Index Server query. The basic idea is that the user enters/selects a bunch of search criteria on a form.
Most of the criteria selected by the user will be used to select records from the database - standard WHERE clause stuff - but the user can also enter free-text that should be searched for in associated uploaded documents.
The documents are sitting in the file-system with file-name pointers only stored in the database (not the document). Only records where the associated free-text is found in the documents should be returned. I'm new to Index Server and am wondering how is this done. Any good references/tutes?
I have an application that needs to pull files from an internal server. This is the setup. The web server is external facing, meaning exposed to the internet. I then have a file server that sits inside our domain. I created a COM object that can impersonate a user to retrieve files from that server. However, I cannot get the application to pull files from the internal server.
I first tried a domain account that could reach both servers. This did not work. I then had the network team create the same account on both machines. This is not working either. I can impersonate the user (I am able to get the user/users authenticated), but the script keeps coming back with and access denied. Code:
I'm stumped by one single thing when using Msxml2.ServerXMLHTTP.4.0. I'm sending an XML-formatted text string to a foreign server and getting a response back (using Windows 2000 Server and IIS). The problem is, when they send any special characters in the response string, my application chokes. Code:
I'm incharge of updating the stats on a chl hockey teams Web Site. I would like to know if there is a way to be able to save the content of the CHL Statistics WebPage on our Server and using it to update our Microsoft Access 2000 database.
If it possible, then I would take the content of that page. Execute some code that will take this information an place it in our database on our server. By doing this, our Team WebSite would be update automaticaly at a time that I specify on our server.
At this time, I have to open the CHL Statistics WebPage. Then Save the HTML page as a txt file, upload it on our server via FTP, then execute my my code that places it in our database.