Asp Connection To Godaddy Mysql Server Problems
I've got a UAPortal (asp freeware intranet) on a godaddy hosting package that comes with a free mysql database. I can't connect the asp site to the godaddy sql server.
They give me the connection strings, but don't tell me where or how to use them! Support does no good, they tell me that is programming, get an expert.
UAPortal comes with an Access database, so when installed it works fine, but its only Access. I want to use the mysql database which is faster, larger and more useful. I opened the Common.asp file and added the info from the connection strings, but now I get an error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver]Access denied for user: 'jwyss@winhostecn82.prod.mesa1.secureserver.net' (Using password: NO)
/Common.asp, line 34
Does anyone know how to do this?
View Complete Forum Thread with Replies
Related Forum Messages:
Database Connection String To MySQL-database On A Different Server
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!! Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
View Replies !
ASP MySQL Connection
I've been messing with this for the past two days trying to get it to work. I know there's a lot missing, so if anyone would take the time to look the following code over, correct errors, add stuff where it needs to go, etc. I would absolutely be thrilled. All I am trying to do is allow a user to login, view pages only if they are logged in, and sign out. I'm not sure how to mix in the sessions and cookies with this. I've got a database "login" and a table "users" The username and password fields are "username" and "password" respectively. Code:
View Replies !
Mysql Connection On Win Xp Pro
I installed mysql on Win XP Pro. So I do the connection to MySQL: <% strCinnection ="driver={MySQL}; server=localhost;uid=;" strConnection = strConnection & "PASSWORD=; database=commerce" Set adoDataConn = Server.CreateObject("ADODB.Connection") adoDataConn.Open strConnection %> So I got the error message below: Error Message: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
View Replies !
MySQL Connection
I am trying to connect mySQL on Localhost system through ASP. but i am getting some problem Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Here is the code: <% set myconn = server.createobject("adodb.connection") connection = "Driver={Mysql}; Server=localhost Database=test; UID=root; PWD=root" myconn.open(connection) %>
View Replies !
ASP And MYSQL Connection String
Ive created an ASP CMS system which works fine locally. Now its time to upload it to my webserver and make it live. Now locally I have been using a DSN to connect to the MySQL database..now i need to use a connection string. How will i do this. At present my DSN connection code is as follows: Code:
View Replies !
Connection String W/4.1.1 MySQL
I'm having a problem connecting to the 4.1.1. mySQL with my existing connection string: var conn ="Driver={MySQL ODBC 3.51 Driver};server=localhost;database=charmspiano;Option=1;UID=Teddy; PWD=Bear; Port=3306; Socket=; Stmt=;"; This was working fine with 4.0 and 3.23 Has anything changed in the 4.1.1 regarding connection strings? I couldn't find anything on the mySQL website. The string will work if I use UID = root without a password "Teddy" is a valid user and has privileges on the database charmspiano
View Replies !
MySQL Connection String Problems
I am using DSN less connection string to connect to a mySQL database: strCon = "Driver={mySQL ODBC 3.51 Driver};Server=mysqlhost;Port=3306;Database=touchinco;Uid=myId;Pwd=myPWD;OPTIO N=3" It works fine with the default.asp page where content is retrieved/displayed: <!-- #include file = "connection/connect.asp" --> <% Dim objRS, strSQL strSQL = "SELECT * FROM tblLanguage WHERE inuse=1;" Set objRS = Server.CreateObject("ADODB.Recordset") objRS.Open strSQL,objCon,3,1 %> But when I move to the next page start.asp, here too I retrieve data to display: Code:
View Replies !
Connection String For A MySQL Database Needed
I'm trying to get asp to conect to a MySQL database, I've tried copying a few examples online that I found [there doesn't seem to be many!!] and I always get a 500 error with the code below. what am i doing wrong? any examples of a working connection string anyone could show me would be fantastic.
View Replies !
SQL Server To MySQL
is there a way to convert a SQLServer DB to MySQL, I want a duplicate of the SQLServer in MySQL. I did not find a free tool to do this, so I was wondering is there a way to do this by asp code?
View Replies !
From PHP/MySQL To ASP/SQL Server Or Access
I have always used PHP and MySQL to do anything database related on the web, however I find myself in a new situation. I've been handed the daunting task of creating a (relatively) simple, partially database driven website for my company's intranet. The one problem I have is that all of our servers are Windows 2000 based because all of the in-house software we have works off of SQL Server... and I've never touched a windows based server, SQL Server, or ASP in my life. Searching through the forums, I've been able to find a few ASP tutorial sites, but everything I've found seems to be either all technical info and no basics or a basic tutorial written for people who are already familiar with Visual Basic, C, or another type of windows programming 'thing'.
View Replies !
Access, SQL Server Or MySQL?
I've been using URL asp shopping cart (free version) for a while with an access database and it worked perfectly. My store is very popular now (more than 200 simultaneous users) and I need to migrate to a professional database. Comersus is compatible with SQL Server and mySQL. Which one do you recommend? My idea was to use mySQL since in that case I can purchase Power Pack Medium ($239) instead of Premium (.$370)
View Replies !
Can't Connect To MySQL Server
I recently got an error message from the Java release: j2rel.4.2_05 regarding c:program filesjavaj2rel.4.2_05injpiexp32.dll This message came in a .log file to my desktop, and since then, every once in a while I get this following error while trying access my pages in which I am creating. Code:
View Replies !
Cdosys And Godaddy
Can someone help me configure my cdosys to work with my godaddy account, i can get it to work my my work mail server but i haven't had any luck with go daddy's.
View Replies !
Godaddy Account
I have an application that references a database on my hard drive, however I am unsure how to transfer the files to the server and keep the integrity of the database reference string. The Current DB is located on C: [CODE] Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:database.mdb;Persist Security Info=False" CODE] If you have any suggestions on where to place my database in my hosting account and the reference code for it.
View Replies !
Aspupload @ Godaddy
anyone have experience with this? godaddy says aspupload is already installed. I am verrrry new to website work and am trying to make http://peppgum.com/peppphotos.htm upload a file to the /images folder so they can be read by the simpleviewer flash dealio. I put the http://www.aspupload.com/manual_simple.html HTML code i found there into the page, and got the box, browse.submit. then i copied the yellow box code for asp script1.asp into notepad and saved as .asp i frontpage ftpd them to godaddy but not working? i need to limit it to .jpg files as simpleviewer only works with .jpgs, how can i do this? and rename the files once uploaded starting at 1-infinity?
View Replies !
Asp.net Connecting To Mysql Database At Ftp Server
currently i m working on a web-based project using asp.net and mysql database. i using MySQL Connector/Net to connect my asp.net page to the to MySQL database server. My database is stored in the ftp server. In short, i m trying to connect my asp.net page to the ftp database server. Code:
View Replies !
Error 553 W/ GoDaddy Email
I'm getting the following error with GoDaddy.com, but customer support tells me I have the correct SMTP address. They can't help me until I've proven the error is on their side. I've used this code on other hosts, and it works just fine. The actual error message is: ...
View Replies !
Problem With GoDaddy And CDONTS
I have an email form on a GoDaddy hosting site. I know that the form data is getting to the ASP file, because my custom error/sent messages work. But, the email never gets to the email address. Right now I have it set so that you can choose where the email goes. I have also tried it with the email address hard coded in there, to no avail. Code:
View Replies !
Connection From ASP To SQL Server
I have two servers: Webserver(WebServer) and Database server(DBServer). In Webserver, i asp to connect to sqlserver in dbserver. but i can not connect it, it show error "No Trust Connection" but the save connection string, when i used it in VB, it is ok. Also i can connect from webserver to dbserver by using Analy Query, it is ok "How to connect it". below is my asp code: <% set cnt=server.createobject("adodb.connection") cnt.open "Provider=SQLOLEDB.1;Data Source=Dbserver;Initial Catalog=MyDB;Uid=dbadmin;pwd=root"
View Replies !
SQL Server Connection
I'm using microsoft SQL server 2000 to create the database for my project.Below is the connection that connect to the SQL server :- set cn = Server.CreateObject("ADODB.connection") cn.Open = "Provider=SQLOLEDB;" & _ "server=SPCH2O;" &_ "Data Source=(Local);" & _ "Database=SPJRK;" & _ "User ID=guest;" & _ "Password=;" But there is an error that i don't understand why i failed to connect to the server.
View Replies !
Connection To SQL Server
I am having a problem connecting to my SQL Server with the following ASP set cn = server.createobject("adodb.connection") cn.connectionstring = "Provider=sqloledb; data source=midatlanticus; Integrated Security=SSPI" cn.open But, if I use the same connection string in a VB program, I connect successfully. The VB code that works successfully is as follows: Code:
View Replies !
SQL Server Connection
i have my sql server 2000 installed properly on the server. everything goes fine yersterday..i can create new database, tables and so on. but i couldn't connect to it since this morning. it keep on prompting the msg" cannot connect to the sql server because of incorrect logon " <something like this> in fact, i never set any passwod in order to connect to the sql server.
View Replies !
Broken Connection With Server
I am designing a site for a friend using dreamweaver and unfortunately my link has gone down to my test server. I use dreamweaver to generate most of my asp but since I can;t do this with a broken connection I wondered if anyone would be kind enough to help me with a very simple bit of code. I simply need an asp page. That reads the first record in a db (db.mdb). the record has two fields ID (whish is 1) and news (a memo field). This memo field then needs can then be updated via a simple html form. Essentially its just a page that allows the user to update the memo field in the first record of the database.
View Replies !
Server Can't Open Connection
I have a site on 1and1. The site has a simple login as well as other asp applications. This site uses an access DB. Last week all the scripts that accessed any database resulted in this error: Code:
View Replies !
Connection To SQL Server Express
I recently moved to Visual Web Developer Express. I need to create a simple page that connects to my Database.mdf and runs a stored procedure. I have tried a million times but i simply cannot create a connection. I need to create an ADODB connection as i need control over the CONNECTION TIMEOUT and the COMMANDTIMEOUT properties. I'm using the following string: Data Source=.SQLEXPRESS;AttachDbFileName=e:dataCusto mers.mdf;Integrated Security=True;User Instance=True
View Replies !
ODBC Connection To SQL Server
I have problem on data connection to a SQL Server by Asp Statement. It's Very strange that my asp statement can connect to one remote SQL server but can't connect to other remote SQL server. The statement written like this : Set DBLBX=Server.CreateObject("ADODB.Connection") DBLBX.Open "DSN=DBWEB;UID=opn;PWD=opn;" It show the follows: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Is that the problem of my Sql server ?
View Replies !
Open Connection To Another Server
I would like to connect to another server and execute my query from my asp page. But how can I initiate the connection string to another server DB? For example Code: ConnString = "dsn=abc;uid=xyz;pwd=123" What will be the way to issue the connection string to another server? Using SQL Server 2000.
View Replies !
SQL Server Connection String
I ALWAYS forget this cause we ALWAYS turn our db connections into COM components. That said... I need one for this project . Here's my base Access one: DBPath ="C:datastoresmediacd.mdb" Set Con = Server.CreateObject( "ADODB.Connection" ) Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DBPath I just don't quite remember the SQL Server variation.
View Replies !
Specify SQL Server Port In Connection String?
We are planning to change the port that SQL Server is listening on at our Web Hosting company(TELUS). Our SQL Server is being attacked. There are thousands of unauthorized attempts to login. Is it possible to specify port number in ASP code? here is my cn: PROVIDER=SQLOLEDB.1;DATA SOURCE=MachineName;INITIAL CATALOG=DatabaseName;USER ID=iserid;PASSWORD=password; How should it look like if let's say our SQL port is 32566?
View Replies !
Connection To SQL Server In ASP, Windows Authentication
My ASP page needs to connect to the SQL using Windows Authentication. I have research this topic and I think the pieces of the puzzle are here, but they are not coming together correctly. Users are separated into groups with different levels of security, Group 1, Group 2, Group 3. Each group can only view, update or delete specific pages. Code:
View Replies !
How To Get DB Connection Using Server.MapPath To Work Everywhere?
I have a site with the directory structure like this: wwwroot (where the default.asp and other pages sit)inc (where the includes are)login (where login pages are)otherDirs (where other pages are)datafiles (where database is) I usually hard code the db connection path but want to use the MapPath now in case in the future my site moves servers (have been though that and having to manually change all db connection strings - Not Fun ) Code:
View Replies !
Connection String Server.mappath Method
Wondered if anyone could help me out with some simple connection string problems I'm having. Ive got this on the page so far and it works: ---------------------------------------------- Dim strConnString set strConnString = server.createobject("adodb.connection") strConnString.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=c:Inetpubwwwrootdlnforumforumadminwwforum.mdb" strConnString.open ----------------------------------------------- But I want to change it to a Server.MapPath method, so I tried the following: ------------------------------------------------ Dim strConnString set strConnString = server.createobject("adodb.connection") strConnString.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & Server.MapPath("forum/admin/wwforum.mdb") strConnString.open --------------------------------------------------- But now I get the following error: ------------------------------------------- Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E) Operation was canceled. Can anyone help me out?
View Replies !
Connection String From Include File ASP To SQL Server 2000
I am working on a App. at my work place, now wanting to set it up at home but for some reason I keep getting this error : ADODB.Command (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. I did some research on the NET but I am still unable to figure out why I cannot connect to my db. Code:
View Replies !
DSN Connection Or Direct Connection
I wanted to know wheather DSN is ok for the connection to a database or direct conection is better? when i started my web project on dreamweaver i had to make a DSN connection as i have followed the books, but as now as i have also asked several questions on this site, i have aslo implemented a direct connection as well on some pages, now i am wondering is this going to have any affects when i uplode the complete site on the server. i have noticed that on my computer when i am testing the site and uploading new records on sections that have DSN connections you can see the new record but on sections that i have implemented direct connection i cannot see it coz it is linked to the local directory database not on the testing server. i have also never experienced uploading to a IIS server with DB connection so its my first time with dynamic websites. so am i in trouble or its ok the way i have done my site..
View Replies !
Use Mysql With VB6
I am trying to connect to a Mysql database in the following manner: Dim conn As ADODB.Connection Set conn = New ADODB.Connection Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset conn.CursorLocation = adUseClient conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=myserver;PORT=3306;DATABASE=mydatabase; USER=myusername;PASSWORD=mypassword;OPTION=3;" however I am getting an error: visual basic run-time error microsoft [odbc driver manager] data source name not found and no default driver specified.
View Replies !
Mysql With ASP
Our website is currently developed in ASP/Mysql 4. The dedicated servers on which it is currently hosted arrive at saturation. Here is their configuration: - 1 server PIV 2,8Ghz 1GB RAM with IIS 5 on Windows 2000 - 1 server Bi-xeon 3Ghz, 512 MB with MySQL 4 on Windows 2003 The website makes approximately 10.000.000 of pages seen and 310.000 visits each month (given by an external statistics tool), increasing by 10% each month. The database is approximately 60 MB. I made, I think, most of the optimizations on the database (cache, indexes...). According to our current web hoster, this saturation is due to a bad management of connections between ASP and MySQL and recommends to us: 1/ to put the site on Windows 2003/IIS 6. 2/ to change our database from MySQL to SQL Server. 3/ to change our PIV to a second Bi-xeon.
View Replies !
|
TRACKER
