Can anyone tell me, Connection to Access Data Using ASP

Expand Post »

Hi, I am trying to Write web type application and connect my database (Access) with DNSLess Connection like this

Set conn = server.createobject("adodb.connection")
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=dsntemp & "DBQ=" & server.mappath("Record.mdb")
conn.Open DSNtemp

This is very much like to Connection to Database from VB6, but, I do not know how to include the User name and Password for the above Connection. The above code is correct only for with no Passoword. Can any one tell me.

Also, if any one know whether Connection can be created or not for MySql from VB (This is not MS SQL). I simply know MySql is convenient for php, etc. and not for ASP and VB6. Is this Correct?

kvl

Similar Threads

how to connect ms access with asp vbscript in ASP
Simple ASP.Net Login Page using C# in C#
Updated : Simple ASP.Net Login Page in ASP.NET
my insert.asp cannot connect to access data in Troubleshooting Dead Machines
PHP, ASP, ColdFusion, what's your fav? in IT Professionals' Lounge

K.Vanlalliana

Reputation Points: 10

Solved Threads: 4

Light Poster

Offline

44 posts
since Jul 2008

Permalink

Oct 12th, 2008

Re: Can anyone tell me, Connection to Access Data Using ASP

If I remember right, the connection string is following:

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
"Driver= {MicrosoftAccessDriver(*.mdb)}; DBQ=" & server.mappath("Record.mdb") & "; Uid=Username; Pwd=Password;"
"Driver= {MicrosoftAccessDriver(*.mdb)}; DBQ=" & server.mappath("Record.mdb") & "; Uid=Username; Pwd=Password;"

One way to use MySQL in VB6 is to get MySQL ODBC driver (from MySQL site). The connection string is following:

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)

"DRIVER={MySQL ODBC 3.51 Driver}; SERVER=127.0.0.1; DATABASE=MySample; UID=UserName; PWD=Password"

You may find a never ODBC driver than version 3.51

Teme64

Reputation Points: 218

Solved Threads: 201

Veteran Poster

Offline

1,024 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: How to set Database Applicaion path to crystal Reports

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: End of statment expected??.....

DaniWeb Message

Cancel Changes