Showing posts with label platform. Show all posts
Showing posts with label platform. Show all posts

Sunday, March 11, 2012

connection help

hey im 2006 passed out.,im a trainee in asp platform.,

ive been provided windows authentication and i have a code showing error. could u please help me and i got this code from net only else u giv me a correct code to connect asp and sql2005

my code

<%

set con=server.CreateObject("ADODB.connection")

con.Open dsn="dsn_uma"

set rs=server.CreateObject("ADODB.recordset")

rs.Open "select * from xxtable",con,1,3

while(not rs.EOF)

for i=0 to rs.RecordCount

Response.Write rs(i) & ":"

next

Response.Write "<br>"

rs.MoveNext()

wend

%>

Please check this link http://www.frontpages-web-hosting.net/support/asp.access.database.connection.htm

Make sure your DSN is configured correctly and tell us the exact error msg if you still see errors.

Sunday, February 12, 2012

Connecting to SQL Server from diffrent platform, Please HELP!

Hi,

This is second time that I ask this question in this forum but there was no answer last time I did this :(

What I have to do if I want to connect to MS SQL Server 2000 installed on Windows 2000 when I write a Visual Basic program on a Windows 98?
I mean, If I install a MS SQL Server 2000 on Windows 2000, and I want to connect to server with a Visual Basic programm that I write on a computer with Windows 98 operating system, I got "ACCESS DENIED" error :(
What I have to do to make it works?

Please help me about this problem, any Idea or article, web site and etc. you think it can help me!

Thanks again for you attention ;)Can you give some more details. How do you connect, are your logins correct etc. From your post it's impossible to know what the exact problem is.|||if you have access to where the db's are located the easiest way is to just create a .udl file in it and then you can gui wise select your driver and all that, it then creates the connection string for you when you open it in wordpad

you can see this everywhere, msdn,wrox books, teacher pass it off as their own too, this method has no origin because people always rip it off VERBATIM and never say where they got it from, *shrug*|||You've got response to your first question.

The "Access denied" error may be caused by the missing DCOM functionality (ADO works with ActiveX objects, which are communicating with (D)COM.