p2p.wrox.com: Archives - asp

asp_databases thread: DSN-less connection string TO web database server

Message #1 by speedguru@m... on Thu, 30 Aug 2001 13:18:49

hi,





this follows my earlier posting "transfer records from table in local d/b 

to Web d/b" at http://p2p.wrox.com/view.asp?list=sql_server_asp&id=97561



i thank all those who responded. but for my requirement I may not be able 

to use DTS. I'm still looking for other ways...





i'm trying to connect TO my web database server from my local IIS machine 

using a DSN-less connection string.



What should my DSN-less connection string look like ?



I read at http://www.powerasp.com/content/hintstips/permissions.asp

that something like the following DSN-less connection string will NOT 

work . so i'm not even trying.



<%

DataConn.Open  "DBQ=http//www.mysite.com/_database/mydatabase.mdb;Driver

{Microsoft Access Driver (*.mdb)}"

%>





i would also like to hear abt other people's experiences with DSN-less 

connection string to the Web Database server



thanks for your time,

:-)rk

Message #2 by Sam Clohesy <sam@e...> on Thu, 30 Aug 2001 13:37:38 +0100

Do you need to do something like this:



strConn = "PROVIDER=SQLOLEDB;Server=yourIPaddress or

servernane;DATABASE=databsename;UID=username;PWD=password"



-----Original Message-----

From: speedguru@m... [mailto:speedguru@m...]

Sent: 30 August 2001 14:19

To: ASP Databases

Subject: [asp_databases] DSN-less connection string TO web database

server





hi,





this follows my earlier posting "transfer records from table in local d/b 

to Web d/b" at http://p2p.wrox.com/view.asp?list=sql_server_asp&id=97561



i thank all those who responded. but for my requirement I may not be able 

to use DTS. I'm still looking for other ways...





i'm trying to connect TO my web database server from my local IIS machine 

using a DSN-less connection string.



What should my DSN-less connection string look like ?



I read at http://www.powerasp.com/content/hintstips/permissions.asp

that something like the following DSN-less connection string will NOT 

work . so i'm not even trying.



<%

DataConn.Open  "DBQ=http//www.mysite.com/_database/mydatabase.mdb;Driver

{Microsoft Access Driver (*.mdb)}"

%>





i would also like to hear abt other people's experiences with DSN-less 

connection string to the Web Database server



thanks for your time,

:-)rk

Message #3 by <hisunilj@y...> on Thu, 30 Aug 2001 19:09:14 +0530

hi



you can generate the connection string from VB, Open a standard EXE and put

MS ADO component onto it, Click on Properties...connection, and Build

String,

Connect to the Web Database from there and VB generates the Connection

String for you.





<%

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

con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User

ID=sa;PWD=super;Initial Catalog=<Database Name>;Data Source=<IP Address of

the Database Server>"

%>



Then use the Recordset objects with this connection object to use the

database tables and fields.



Best Regards



Sunil Jambekar

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

[Sr. Programmer - Web & Software Solutions]





----- Original Message -----

From: <speedguru@m...>

To: "ASP Databases" <asp_databases@p...>

Sent: Thursday, August 30, 2001 1:18 PM

Subject: [asp_databases] DSN-less connection string TO web database server





> hi,

>

>

> this follows my earlier posting "transfer records from table in local d/b

> to Web d/b" at http://p2p.wrox.com/view.asp?list=sql_server_asp&id=97561

>

> i thank all those who responded. but for my requirement I may not be able

> to use DTS. I'm still looking for other ways...

>

>

> i'm trying to connect TO my web database server from my local IIS machine

> using a DSN-less connection string.

>

> What should my DSN-less connection string look like ?

>

> I read at http://www.powerasp.com/content/hintstips/permissions.asp

> that something like the following DSN-less connection string will NOT

> work . so i'm not even trying.

>

> <%

> DataConn.Open  "DBQ=http//www.mysite.com/_database/mydatabase.mdb;Driver

> {Microsoft Access Driver (*.mdb)}"

> %>

>

>

> i would also like to hear abt other people's experiences with DSN-less

> connection string to the Web Database server

>

> thanks for your time,

> :-)rk

Message #4 by "Pat Waddington" <paw@s...> on Thu, 30 Aug 2001 14:14:50 +0100

There is an easy way to generate a datalink in Windows 98 or NT4.0 -

In Windows Explorer select File, New, Microsoft DataLink and fill in the

tabs



For more info, or on how to do it in Win2000, refer to Wrox Beginning Active

Server Pages 3.0, pages 485-488





----- Original Message -----

From: "Sunil Jambekar" <hisunilj@y...>

To: "ASP Databases" <asp_databases@p...>

Sent: Thursday, August 30, 2001 2:39 PM

Subject: [asp_databases] Re: DSN-less connection string TO web database

server





> hi

>

> you can generate the connection string from VB, Open a standard EXE and

put

> MS ADO component onto it, Click on Properties...connection, and Build

> String,

> Connect to the Web Database from there and VB generates the Connection

> String for you.

>

>

> <%

> set con = server.CreateObject ("ADODB.Connection")

> con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User

> ID=sa;PWD=super;Initial Catalog=<Database Name>;Data Source=<IP Address of

> the Database Server>"

> %>

>

> Then use the Recordset objects with this connection object to use the

> database tables and fields.

>

> Best Regards

>

> Sunil Jambekar

> ---------------------------------------

> [Sr. Programmer - Web & Software Solutions]

>

>

> ----- Original Message -----

> From: <speedguru@m...>

> To: "ASP Databases" <asp_databases@p...>

> Sent: Thursday, August 30, 2001 1:18 PM

> Subject: [asp_databases] DSN-less connection string TO web database server

>

>

> > hi,

> >

> >

> > this follows my earlier posting "transfer records from table in local

d/b

> > to Web d/b" at http://p2p.wrox.com/view.asp?list=sql_server_asp&id=97561

> >

> > i thank all those who responded. but for my requirement I may not be

able

> > to use DTS. I'm still looking for other ways...

> >

> >

> > i'm trying to connect TO my web database server from my local IIS

machine

> > using a DSN-less connection string.

> >

> > What should my DSN-less connection string look like ?

> >

> > I read at http://www.powerasp.com/content/hintstips/permissions.asp

> > that something like the following DSN-less connection string will NOT

> > work . so i'm not even trying.

> >

> > <%

> > DataConn.Open

"DBQ=http//www.mysite.com/_database/mydatabase.mdb;Driver

> > {Microsoft Access Driver (*.mdb)}"

> > %>

> >

> >

> > i would also like to hear abt other people's experiences with DSN-less

> > connection string to the Web Database server

> >

> > thanks for your time,

> > :-)rk

Return to Index

P2P Archives