ASP Development
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Remember me

Go Back   Dev Articles Community ForumsProgrammingASP Development

Add This Thread To:   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
Unread Dev Articles Community Forums Sponsor:
Old April 8th, 2002, 09:53 AM
preet preet is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
Join Date: Apr 2002
Posts: 3 preet User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Lightbulb ASP with remote mysql on PC

I guess we have mysql installed on linux server.
I am able to connect that server through following ado connection string and
through system dsn too.
I installed Myodbc from mysql web site and it is working, because I am able
to insert into database.
Now my problem is,
If I execute following asp code on Win 2000 pc using Personal web server
(PWS) to "select * from webusers". It does not return any rows.
Can you please help to find out what is the problem ?(I am strugling from
last one week)
I installed odbc driver 4 times. This same code works fine on server, that
is linux server and using chillisoft asp to execute asp(if I am not wrong).
But this is not
working on my local machine. I need to run asp pages on local machine (win2k
with pws) for development and testing purpose.
Code which I am using

dim cnn, rs, strcnn, sqlstr
set cnn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
'cnn.ConnectionString = "DSN=mysqldsn" ''' I tried system dsn and complete
connection string too
'cnn.Open "DSN=mysqldsn"
strcnn =
"driver={mySQL};SERVER=;DATABASE=LQMTes t;UID=admin;PWD=lqmadmin;
cnn.Open strcnn
if cnn.Errors.Count <> 0 then
Response.Write "<br>could not connect<br>"
Response.Write "<br>connected<br>" ''' I always received
connected message on browser
rs.ActiveConnection = cnn
rs.Open "select * from webusers"
if not rs.eof then
response.write " it is not eof "
response.write " it is eof "
end if
end if

'''' I always received "it is eof", but on server "it is not eof". I have 10
'''' If I use mysql client on my m/c to connect remote server, then webusers
table returns me 10 rows.
'''' I inserted row through above conenction string too. THAT IS WORKING.
Why It is not returning rows ?
============================= end of code

Reply With Quote

Viewing: Dev Articles Community ForumsProgrammingASP Development > ASP with remote mysql on PC

Developer Shed Advertisers and Affiliates

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.

© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap