SQLState: IM002 Native Error Code: 0 [INTERSOLV][ODBC lib] Data source name not found and no default driver specified
------------------
strconn ="DSN=dsnname ; UID=username ; PWD=password" set conn = Server.Createobject("adodb.connection") conn.Mode= 3 conn.open strconn the error is in the last line. THANX
Mircosoft OLE DB Provider for ODBC Drivers [0x80004005] [Mircosoft] [ODBC Driver Manager]
Data source name not found and default driver specified
This is the connection string im using and ive install an odbc driver connect_string = "Driver={Mysql}; Server=localhost; Database=Tester; " set dbConn = server.createObject("ADODB.connection")
I have knowledge of programming ASP pages, HTML, Vbscript and making/connecting to MySQL databases with SQL queries. I am prepared to learn new things if they are required, but ideally if it can be done using the above, or slight additions to the above it would be great!
I would like to get data off of the web. What I mean by this is that there might be a site that has a table on it. Is it possible to make a script take data out of the browser window (just thinking about it sounds difficult!).
If not, is there an easy way to get a script to dump the information (i.e. the source code of the page) into a .txt file or something that can be read by a script. Alternatively, would automating the pasting of the table into an excel spreadsheet be possible. Code:
So i get this error and i have no idea what it means. So if someone could help let me know what this error is coming up for it would be nice. Im just starting asp today because my work has a client who has an asp site. Thank you
Error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I have a couple fields in an Access DB that have parenthesis in the name:
EST(Minutes), EST(Seconds)
When I try and populate the dataset and then bind the datagrid it claims there is no field having that name. Can parenthesis be used in fieldnames. If so, can you please tell me the correct syntax please.
We had a web site that works in windows NT very good with a DB in Access. Our clients migrate to Win 2000 and now the connection to the DB doesn't work ... the error is this:
Error: Access is Denied. Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
When I try it on original server, it works, but when I moved everything to a different server it does not work. I have checked the dsn name, userid and passs. But no luck.
Error [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
We hosted our asp based application under windows 2000 server with sql server 2000 as backend. All the asp module works fine with internet explorer version 5 but same application is giving odbc error when we run the application in IE 6.
The exact error is : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified xxxxxxxx/login.asp, line 27
Our web server crashed and I had to move all web sites to backup server. Installed Internet service and it appears to work OK on html files, but ASP files are not functioning - what is wrong? I have lost so many brain cells that I need a fresh mind to see the obvisous.
Those pages does not output any thing if I use IE and If I access the pages from machines running Windows 2000 Server, XP or Windows NT Server. Opera outputs as per session variables name.
IIS server is running Windows 2000 server. I've checked the cookie settings which was set to accept cookies.
For win2k adv server/iis5.0 trying to run an external program from my asp routine that has multiple parameters, see following.
set shell = server.createobject("wscript.shell") shell.Run """f:phsDatahtmldochtmldoc.exe"" --webpage -f phsnew.pdf phsnew.htm"
program either doesn't get invoked, or has an error, but since it has no error log i can't check that, so not sure why not getting a result i have run the program successfully from the command line in that directory, so know it can be run in the first place and the asp program creates and writes files in the same directory so i don't think its a permission problem. asp doesn't complain with any errors.
I am trying to debug an issue with sessions in my ASP 3.0 web application, which runs fine on WIN2K Pro and WINXP Pro, yet fails to function correctly on WIN2K Advanced Server.
My actual application is using sessions to store username, and security level (permissions) for my application. The default.asp page is the login, where these values are set. I have triple and quadruple checked my IIS Settings to make sure "Enable Session State" is checked, and the session.timeout is set to 120.
Now if I remove my application, recreate it in IIS admin, stop and start the IIS services, and run my application, the session variables seem to be saved across the first redirect to my main_menu.asp page. Here I have several menu choices, which are dependent on the session("seclevel") to determine which they can or cannot access.
Here is where it seems my session vars are lost, since when I click on any choice, I get redirected to the log_out.asp page, which abandons the session and returns the user to the login (default.asp) page. Code:
I was wondering if there are any known problems when using an apple macintosh to upload files and put text in a database via an ASP page that could cause either database error pages or simply some data not being written to the database. I have had this problem on a couple of sites now, and not been able to recreate the errors on my PC.
I have several ASP pages, and some of them are using the same access Database and table. Can I put the connection string somewhere centralized, so I can link to it ?
I have been using php for a while now but have recently had to start using asp. I have purchased some hosting from webfusion.co.uk but have been having trouble connecting to the sql server, could someone possible help me here as I don't know what is the correct code to use to start with let alone know where I have gone wrong.
I want to pull 2 different recordsets using 2 different stored procedures using the same Data Connection. Below is the code that I currently have, but I'm getting an 'Object Required' error message. Am I doing this correctly, or at least headed in the right direction? Can someone tell me the most efficient way (provide a code example) to pull 2 different recordsets from the same Data Connection? Code:
I need to do is display results of a command I run in UNIX, for example:
In the ASP page I'd have a textbox in which the user would type an UNIX command like "cat unixFile", after the user hits the "Execute Button" the results would be displayed in another textbox.
Basically my question is, how can I login to an UNIX server from ASP, send UNIX commands and capture the result?
Is there a way to create directories using vb or jscript in IIS to a unix machine? I want to have the aility to upload files through my Win2k Web Server, and have those files stored on my Mac OS X Server under new directories based on date and Upload ID's from the Db.
I'm working on a proof of concept for ASP. I've already done it using Windows 2k server, IIS, using open source [no initial cost involved]. I'm looking to doing the same using a linux box. Does anyone know if this can be done without buying any additional tools?
i have got someone who is interested in moving a ASP site to my hosting setup but my host is a UNIX platform. Actually i can see no reason for his site to be ASP cause it looks like a flat html site with .asp encoded pages.I just wondered what the experts think of running ASP on UNIX.
In my pages i have to read a text file which is created in Unix format through my asp code. The problem is that the readline command reads the whole file and not line by line as the file is in Unix format. Is there a way to convert it using asp code and then read it or any other solution to this problem?
As the file is created by an application not controlled by myself it is impossible to force the application developer to do this job so i have to do it during runtime. So what are your suggestions?
This returns the timestamp: 1096329600, and when you decode that it comes to: 27 Sep 2004 20:00. I want to set the time too, ie. show for example: 27 Sep 2004 16:15
I need to access a database on a MS SQL Sever from my unix apache web server.I would preferably want to continue to use ASP rather than go to PHP or Perl - I know that I need to build unixODBC on the web box, but do I need to do anything else other than reference the SQL server in unixODBC?
Has anyone used unixODBC? The console & CLI seem fairly self-explanatory... Do you need extra drivers to connect to a MS SQL box? Can I still use the same server.createobject & ADODB statements in my ASP code? Or do they need to change? Syntax etc?
I'm new to ASP so please forgive my ignorance. Our IT department says that there is no way that what I suggest can be done. I disagree because it should be possible (if not there is a massive hole in the market), but don't have the technical knowledge to back myself.
We have an Windows/IIS web server for our public website. Internally for our intranet we have a Unix box with and Oracle database. What I want to know is: Is it possible to query that database from the windows server using ASP? Are there any clients/COM/APIs etc that this would require? Can anyone direct me to a webpage that has more info?
I currently use ADO (adoConn.Provider = "ADSDSOObject") to access user information in the domain Active Directory. I want to expand my application to be able to access user information in other LDAP compatable user lists (LINUX or UNIX for example). I did some searching on deja.com (google groups) and microsoft's newsgroups, but couldn't find anything.
I am working on a small project which requires XML data to be read from ASP.
I am successful at using XML/DOM objects. But when the data size goes up, sequential access will tax the web server. I would like to retrieve the data in the xml file like a MSAccess DB.
I read somewhere that XML source can be provided as data stream in ADO. If anyone has knowledge on this, please provide me links. If possible, answer to these queries will also be appreciated. 1. Which version of IIS supports this. 2. Which version of ADO 3. Additional components needed at the server ?
I found the following link at MS. http://support.microsoft.com/default.aspx?scid=KB;en-us;q263247
I am looking for an open source, very simple CMS that allows an administrator to add pages, news articles, and maybe a staff directory. We don't need new users to signup, or comment, or anything along those lines. Maybe a wysiwyg editor included. Just for a homepage, a news section (that may include many sub-cats, pages).
