Please need help a simple question

[Crawlerz]

I wana know how i can acess a Database from SQL of my friend's server, what the code i use...please write below.

And if i wanna do ''whos is online in the server'' in a homepage how i can do it....please write the code below especifing.

PLEASE I need it , if you do..i'll thank you!

[mendhak]

www.w3schools.com/ado/

[Crawlerz]

thanks...if somebody wants to explain better, i will thank

[Danial]

Originally posted by Crawlerz
thanks...if somebody wants to explain better, i will thank

You need to explain yourself better and be more specific, your question is slightly vauge.

Firstly if you wanna connect to a remote SQL Server you do it so by using the IP and the port No of the server. Look up the connection string for remote connection in http://www.able-consulting.com/ADO_Conn.htm.

As for who is online, there is many wasy you can do it, If you are using ASP then you can do so using Application variable and increment/decrement a Counter variable when a new session is started/ended. Search on 4GuysFromRolla.com you should find many example.

Hope this helps.

Danial

[Crawlerz]

HELP PLEASE - im only trying to acess a simple SQL server...nut its not simple for me. need help please.

Help im getting this error:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30037: Character is not valid.

Source Error:



Line 2: <script runat="server">
Line 3:
Line 4: <%
Line 5: Set Conn = Server.CreateObject("ADODB.Connection")
Line 6: Conn.open "DSN=felipeiron.no-ip.com;UID=mine;PWD=mine;DATABASE=MEMB_STAT"

-------------------------------------------------------------------

and my code is:

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSN=felipeiron.no-ip.com;UID=mine;PWD=mine;DATABASE=MEMB_STAT"
strSQL = "SELECT * memb stats"
conn.Open strConexao
rs.Open strSQL, conn
Do While Not rs.EOF
Response.Write rs.Fields("memb stats").Value & "<br>"
Loop
%>
----------------------------------------------------------

and i dunno what can i put in ''DATABASE='' in the code
and ''SELECT * '' too

[Mark Gambo]

Conn.open "DSN=felipeiron.no-ip.com;UID=mine;PWD=mine;DATABASE=MEMB_STAT"
strSQL = "SELECT * memb stats"
conn.Open strConexao

Why are you opening 2 Connections? This maybe your problem. Otherwise your code looks ok.

[Crawlerz]

ok I erased that ...but the error persist
-----------------------------------------------------
now the code is:

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSN=felipeiron.no-ip.com;UID=mine;PWD=mine;DATABASE=MEMB_STAT"
strSQL = "SELECT * memb stats"
rs.Open strSQL, conn
Do While Not rs.EOF
Response.Write rs.Fields("memb stats").Value & "<br>"
Loop
%>

[Mark Gambo]

Do you have a DSN setup on the machine that you are executing this code? If so, what happens when you click on the test connection button in the DSN?

Sent from my Treo 600

[Crawlerz]

May I explain it to you...Im trying to acess a SQL server of my friend, Im only the ''webmaster'' that want to acess it for him from a home page.

Im doing a benefit for him.
I have the DSN, the name of the Table and SQL server, so what code i have to use, what type of code? ASP? if its ASP i using it.

HELP ME ANYONE please.

[Mark Gambo]

Have you tested the dsn? I am sure that you probably know this already but the you have to define the dsn on your machine. If that works then I don't know what problem is

[Crawlerz]

i think DSN is the IP of the Server, isnt it?

[Mark Gambo]

i think DSN is the IP of the Server, isnt it?

No the Data Source Name or DSN for short provides connectivity to a database through an ODBC driver. The DSN contains database name, directory, database driver, UserID, password, and other information. Once you create a DSN for a particular database, you can use the DSN in an application to call information from the database.
There are three types of DSNs:

(1) System DSN -- can be used by anyone who has access to the machine. DSN info is stored in the registry.
(2) User DSN -- created for a specific user. Also stored in the registry.
(3) File DSN -- DSN info is stored in a text file with .DSN extension.

DSN is often used by Active Server Pages (ASP) and Visual Basic programs when a query to a database is necessary to retrieve information.

There is also what is known as a "DSN-less connection." Instead of using a DSN to connect to a database, the developer specifies the necessary information right in the application. With a DSN-less connection the developer is free to use connection standards other than ODBC, such as OLE DB.


Check out this links:

Setting Up a System DSN
Creating a Local DSN
Setting up a System DSN
How to create a System DSN for Microsoft SQL Server[QUOTE]

[Crawlerz]

hey, i did a conection to a sql server below, but i have to put it on a .asp page?? or html?? or .jsp??
when i put it there, on the page, in my case the member satus will open??? the code below is correct???
-----------------------------------
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSN=felipeiron.no-ip.com;UID=mine;PWD=mine;DATABASE=MEMB_STAT"
strSQL = "SELECT * memb stats"
rs.Open strSQL, conn
Do While Not rs.EOF
Response.Write rs.Fields("memb stats").Value & "<br>"
Loop
%>