|
 |
activex_data_objects thread: ADO and SQL server
Message #1 by "Sasi Vellolil" <sasiv@a...> on Fri, 15 Nov 2002 00:55:32
|
|
am working on W2K with IIS 5.0 and ODBC installed.
Created and ASP page using vb script and need to acces Network server
hosting SQL database.
ATL_SPC1 is the name of the server.
webleads_data.mdf is the database I am trying to access
My questions are regarding how to specify the DATA SOURCE and how
to use open?
Do I need to map the remote server in my local machine?
If not how to specify the path for the data source?
When using open, how specify the parameter?
When I try the follwin code I get :
Microsoft JET Database Engine (0x80004005)
Could not find file 'C:\WINNT\system32\Webleads_data'.
/Update/autoversioncheck.asp, line 19
Line 19 is: conn.open Webleads_data:
Any help will be greatly appreciated.
Thanks
Sasi
set conn = Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
\Webleads_data.mdf"
conn.open "Webleads_data"
set rs = Server.CreateObject("ADODB.recordset")
conn.Open "Select * from RegDiagUpdates",conn
rs.close
conn.close
Message #2 by Thomas Bellavia <TBellavia@V...> on Fri, 15 Nov 2002 09:16:57 -0500
|
|
Change your open string to: "Provider=SQLOLEDB; Initial Catalog=ATL_SPC1;
UserID=blah; Password=blah"
Thomas Bellavia
Software Engineering
-----Original Message-----
From: Sasi Vellolil [mailto:sasiv@a...]
Sent: Thursday, November 14, 2002 7:56 PM
To: ActiveX_Data_Objects
Subject: [activex_data_objects] ADO and SQL server
am working on W2K with IIS 5.0 and ODBC installed.
Created and ASP page using vb script and need to acces Network server
hosting SQL database.
ATL_SPC1 is the name of the server.
webleads_data.mdf is the database I am trying to access
My questions are regarding how to specify the DATA SOURCE and how
to use open?
Do I need to map the remote server in my local machine?
If not how to specify the path for the data source?
When using open, how specify the parameter?
When I try the follwin code I get :
Microsoft JET Database Engine (0x80004005)
Could not find file 'C:\WINNT\system32\Webleads_data'.
/Update/autoversioncheck.asp, line 19
Line 19 is: conn.open Webleads_data:
Any help will be greatly appreciated.
Thanks
Sasi
set conn = Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
\Webleads_data.mdf"
conn.open "Webleads_data"
set rs = Server.CreateObject("ADODB.recordset")
conn.Open "Select * from RegDiagUpdates",conn
rs.close
conn.close
Message #3 by Sasi Vellolil <sasiv@a...> on Fri, 15 Nov 2002 11:51:57 -0500
|
|
Dear Thomas,
Thank you so much for your help.
I tried out what you suggested.
It is still not working.
The error message now is:
Microsoft OLE DB provider for SQL server( 0x80004005)
[DBNMPNTW]Specified SQL server not found
line 20
set conn = Server.CreateObject("ADODB.Connection")
conn.Provider="SQLOLEDB;Initial Catalog=ATL_SPC1;UserID=sasiv;
Password=atchan"
conn.open "Webleads_data " 'line20
Please help me.
Thanks
Sasi
> -----Original Message-----
> From: Thomas Bellavia [SMTP:TBellavia@V...]
> Sent: Friday, November 15, 2002 9:17 AM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Change your open string to: "Provider=SQLOLEDB; Initial Catalog=ATL_SPC1;
> UserID=blah; Password=blah"
>
> Thomas Bellavia
> Software Engineering
> -----Original Message-----
> From: Sasi Vellolil [mailto:sasiv@a...]
> Sent: Thursday, November 14, 2002 7:56 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] ADO and SQL server
>
> am working on W2K with IIS 5.0 and ODBC installed.
> Created and ASP page using vb script and need to acces Network server
> hosting SQL database.
>
> ATL_SPC1 is the name of the server.
> webleads_data.mdf is the database I am trying to access
>
> My questions are regarding how to specify the DATA SOURCE and how
> to use open?
>
> Do I need to map the remote server in my local machine?
> If not how to specify the path for the data source?
> When using open, how specify the parameter?
> When I try the follwin code I get :
>
> Microsoft JET Database Engine (0x80004005)
> Could not find file 'C:\WINNT\system32\Webleads_data'.
> /Update/autoversioncheck.asp, line 19
>
> Line 19 is: conn.open Webleads_data:
>
> Any help will be greatly appreciated.
>
> Thanks
> Sasi
>
> set conn = Server.CreateObject("ADODB.Connection")
> conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
> \Webleads_data.mdf"
>
> conn.open "Webleads_data"
>
> set rs = Server.CreateObject("ADODB.recordset")
> conn.Open "Select * from RegDiagUpdates",conn
>
> rs.close
> conn.close
>
>
>
>
>
>
Message #4 by Thomas Bellavia <TBellavia@V...> on Fri, 15 Nov 2002 11:57:11 -0500
|
|
Sounds like the SQL server cannot be accessed from that computer.
Thomas Bellavia
Software Engineering
-----Original Message-----
From: Sasi Vellolil [mailto:sasiv@a...]
Sent: Friday, November 15, 2002 11:52 AM
To: ActiveX_Data_Objects
Subject: [activex_data_objects] RE: ADO and SQL server
Dear Thomas,
Thank you so much for your help.
I tried out what you suggested.
It is still not working.
The error message now is:
Microsoft OLE DB provider for SQL server( 0x80004005)
[DBNMPNTW]Specified SQL server not found
line 20
set conn = Server.CreateObject("ADODB.Connection")
conn.Provider="SQLOLEDB;Initial Catalog=ATL_SPC1;UserID=sasiv;
Password=atchan"
conn.open "Webleads_data " 'line20
Please help me.
Thanks
Sasi
> -----Original Message-----
> From: Thomas Bellavia [SMTP:TBellavia@V...]
> Sent: Friday, November 15, 2002 9:17 AM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Change your open string to: "Provider=SQLOLEDB; Initial Catalog=ATL_SPC1;
> UserID=blah; Password=blah"
>
> Thomas Bellavia
> Software Engineering
> -----Original Message-----
> From: Sasi Vellolil [mailto:sasiv@a...]
> Sent: Thursday, November 14, 2002 7:56 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] ADO and SQL server
>
> am working on W2K with IIS 5.0 and ODBC installed.
> Created and ASP page using vb script and need to acces Network server
> hosting SQL database.
>
> ATL_SPC1 is the name of the server.
> webleads_data.mdf is the database I am trying to access
>
> My questions are regarding how to specify the DATA SOURCE and how
> to use open?
>
> Do I need to map the remote server in my local machine?
> If not how to specify the path for the data source?
> When using open, how specify the parameter?
> When I try the follwin code I get :
>
> Microsoft JET Database Engine (0x80004005)
> Could not find file 'C:\WINNT\system32\Webleads_data'.
> /Update/autoversioncheck.asp, line 19
>
> Line 19 is: conn.open Webleads_data:
>
> Any help will be greatly appreciated.
>
> Thanks
> Sasi
>
> set conn = Server.CreateObject("ADODB.Connection")
> conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
> \Webleads_data.mdf"
>
> conn.open "Webleads_data"
>
> set rs = Server.CreateObject("ADODB.recordset")
> conn.Open "Select * from RegDiagUpdates",conn
>
> rs.close
> conn.close
>
>
>
>
>
>
Message #5 by Sasi Vellolil <sasiv@a...> on Fri, 15 Nov 2002 12:23:21 -0500
|
|
I can access the server and the database through MSAccess installed on my
W2K
> -----Original Message-----
> From: Thomas Bellavia [SMTP:TBellavia@V...]
> Sent: Friday, November 15, 2002 11:57 AM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Sounds like the SQL server cannot be accessed from that computer.
>
>
> Thomas Bellavia
> Software Engineering
>
> -----Original Message-----
> From: Sasi Vellolil [mailto:sasiv@a...]
> Sent: Friday, November 15, 2002 11:52 AM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Dear Thomas,
>
> Thank you so much for your help.
>
> I tried out what you suggested.
> It is still not working.
>
> The error message now is:
>
> Microsoft OLE DB provider for SQL server( 0x80004005)
> [DBNMPNTW]Specified SQL server not found
> line 20
>
> set conn = Server.CreateObject("ADODB.Connection")
> conn.Provider="SQLOLEDB;Initial Catalog=ATL_SPC1;UserID=sasiv;
> Password=atchan"
> conn.open "Webleads_data " 'line20
>
> Please help me.
>
> Thanks
> Sasi
>
>
>
> > -----Original Message-----
> > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > Sent: Friday, November 15, 2002 9:17 AM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: ADO and SQL server
> >
> > Change your open string to: "Provider=SQLOLEDB; Initial
> Catalog=ATL_SPC1;
> > UserID=blah; Password=blah"
> >
> > Thomas Bellavia
> > Software Engineering
> > -----Original Message-----
> > From: Sasi Vellolil [mailto:sasiv@a...]
> > Sent: Thursday, November 14, 2002 7:56 PM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] ADO and SQL server
> >
> > am working on W2K with IIS 5.0 and ODBC installed.
> > Created and ASP page using vb script and need to acces Network server
> > hosting SQL database.
> >
> > ATL_SPC1 is the name of the server.
> > webleads_data.mdf is the database I am trying to access
> >
> > My questions are regarding how to specify the DATA SOURCE and how
> > to use open?
> >
> > Do I need to map the remote server in my local machine?
> > If not how to specify the path for the data source?
> > When using open, how specify the parameter?
> > When I try the follwin code I get :
> >
> > Microsoft JET Database Engine (0x80004005)
> > Could not find file 'C:\WINNT\system32\Webleads_data'.
> > /Update/autoversioncheck.asp, line 19
> >
> > Line 19 is: conn.open Webleads_data:
> >
> > Any help will be greatly appreciated.
> >
> > Thanks
> > Sasi
> >
> > set conn = Server.CreateObject("ADODB.Connection")
> > conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
> > \Webleads_data.mdf"
> >
> > conn.open "Webleads_data"
> >
> > set rs = Server.CreateObject("ADODB.recordset")
> > conn.Open "Select * from RegDiagUpdates",conn
> >
> > rs.close
> > conn.close
> >
> >
> >
> >
> >
> >
>
>
>
Message #6 by Paul McIntyre <pmcIntyre@s...> on Fri, 15 Nov 2002 16:58:41 -0000
|
|
Try changing your connection string from:
conn.Provider="SQLOLEDB;Initial
Catalog=ATL_SPC1;UserID=sasiv;Password=atchan"
to
conn.Provider="SQLOLEDB; Data Source=<SERVERNAME>; Initial
Catalog=ATL_SPC1;UserID=sasiv;Password=atchan"
Good luck
Paul
-----Original Message-----
From: Sasi Vellolil [mailto:sasiv@a...]
Sent: 15 November 2002 16:52
To: ActiveX_Data_Objects
Subject: [activex_data_objects] RE: ADO and SQL server
Dear Thomas,
Thank you so much for your help.
I tried out what you suggested.
It is still not working.
The error message now is:
Microsoft OLE DB provider for SQL server( 0x80004005)
[DBNMPNTW]Specified SQL server not found
line 20
set conn = Server.CreateObject("ADODB.Connection")
conn.Provider="SQLOLEDB;Initial Catalog=ATL_SPC1;UserID=sasiv;
Password=atchan"
conn.open "Webleads_data " 'line20
Please help me.
Thanks
Sasi
> -----Original Message-----
> From: Thomas Bellavia [SMTP:TBellavia@V...]
> Sent: Friday, November 15, 2002 9:17 AM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Change your open string to: "Provider=SQLOLEDB; Initial
Catalog=ATL_SPC1;
> UserID=blah; Password=blah"
>
> Thomas Bellavia
> Software Engineering
> -----Original Message-----
> From: Sasi Vellolil [mailto:sasiv@a...]
> Sent: Thursday, November 14, 2002 7:56 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] ADO and SQL server
>
> am working on W2K with IIS 5.0 and ODBC installed.
> Created and ASP page using vb script and need to acces Network server
> hosting SQL database.
>
> ATL_SPC1 is the name of the server.
> webleads_data.mdf is the database I am trying to access
>
> My questions are regarding how to specify the DATA SOURCE and how
> to use open?
>
> Do I need to map the remote server in my local machine?
> If not how to specify the path for the data source?
> When using open, how specify the parameter?
> When I try the follwin code I get :
>
> Microsoft JET Database Engine (0x80004005)
> Could not find file 'C:\WINNT\system32\Webleads_data'.
> /Update/autoversioncheck.asp, line 19
>
> Line 19 is: conn.open Webleads_data:
>
> Any help will be greatly appreciated.
>
> Thanks
> Sasi
>
> set conn = Server.CreateObject("ADODB.Connection")
> conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
> \Webleads_data.mdf"
>
> conn.open "Webleads_data"
>
> set rs = Server.CreateObject("ADODB.recordset")
> conn.Open "Select * from RegDiagUpdates",conn
>
> rs.close
> conn.close
>
>
>
>
>
>
Message #7 by Paul McIntyre <pmcIntyre@s...> on Fri, 15 Nov 2002 17:05:43 -0000
|
|
Sorry, also change your initial catalog value in your connection string
to your database name.
-----Original Message-----
From: Sasi Vellolil [mailto:sasiv@a...]
Sent: 15 November 2002 16:52
To: ActiveX_Data_Objects
Subject: [activex_data_objects] RE: ADO and SQL server
Dear Thomas,
Thank you so much for your help.
I tried out what you suggested.
It is still not working.
The error message now is:
Microsoft OLE DB provider for SQL server( 0x80004005)
[DBNMPNTW]Specified SQL server not found
line 20
set conn = Server.CreateObject("ADODB.Connection")
conn.Provider="SQLOLEDB;Initial Catalog=ATL_SPC1;UserID=sasiv;
Password=atchan"
conn.open "Webleads_data " 'line20
Please help me.
Thanks
Sasi
> -----Original Message-----
> From: Thomas Bellavia [SMTP:TBellavia@V...]
> Sent: Friday, November 15, 2002 9:17 AM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Change your open string to: "Provider=SQLOLEDB; Initial
Catalog=ATL_SPC1;
> UserID=blah; Password=blah"
>
> Thomas Bellavia
> Software Engineering
> -----Original Message-----
> From: Sasi Vellolil [mailto:sasiv@a...]
> Sent: Thursday, November 14, 2002 7:56 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] ADO and SQL server
>
> am working on W2K with IIS 5.0 and ODBC installed.
> Created and ASP page using vb script and need to acces Network server
> hosting SQL database.
>
> ATL_SPC1 is the name of the server.
> webleads_data.mdf is the database I am trying to access
>
> My questions are regarding how to specify the DATA SOURCE and how
> to use open?
>
> Do I need to map the remote server in my local machine?
> If not how to specify the path for the data source?
> When using open, how specify the parameter?
> When I try the follwin code I get :
>
> Microsoft JET Database Engine (0x80004005)
> Could not find file 'C:\WINNT\system32\Webleads_data'.
> /Update/autoversioncheck.asp, line 19
>
> Line 19 is: conn.open Webleads_data:
>
> Any help will be greatly appreciated.
>
> Thanks
> Sasi
>
> set conn = Server.CreateObject("ADODB.Connection")
> conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
> \Webleads_data.mdf"
>
> conn.open "Webleads_data"
>
> set rs = Server.CreateObject("ADODB.recordset")
> conn.Open "Select * from RegDiagUpdates",conn
>
> rs.close
> conn.close
>
>
>
>
>
>
Message #8 by Sasi Vellolil <sasiv@a...> on Fri, 15 Nov 2002 13:08:21 -0500
|
|
Paul
I changed the code to the following, I still get the same error message as
before:
set conn = Server.CreateObject("ADODB.Connection")
conn.Provider="SQLOLEDB;Data Source =ATL_SPC1;Initial
Catalog=Webleads_data.mdf;UserID=sasiv;Password=atchan"
conn.open "Webleads_data"
Thanks
sasi
> -----Original Message-----
> From: Paul McIntyre [SMTP:pmcIntyre@s...]
> Sent: Friday, November 15, 2002 12:06 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Sorry, also change your initial catalog value in your connection string
> to your database name.
>
>
> -----Original Message-----
> From: Sasi Vellolil [mailto:sasiv@a...]
> Sent: 15 November 2002 16:52
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
>
> Dear Thomas,
>
> Thank you so much for your help.
>
> I tried out what you suggested.
> It is still not working.
>
> The error message now is:
>
> Microsoft OLE DB provider for SQL server( 0x80004005)
> [DBNMPNTW]Specified SQL server not found
> line 20
>
> set conn = Server.CreateObject("ADODB.Connection")
> conn.Provider="SQLOLEDB;Initial Catalog=ATL_SPC1;UserID=sasiv;
> Password=atchan"
> conn.open "Webleads_data " 'line20
>
> Please help me.
>
> Thanks
> Sasi
>
>
>
> > -----Original Message-----
> > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > Sent: Friday, November 15, 2002 9:17 AM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: ADO and SQL server
> >
> > Change your open string to: "Provider=SQLOLEDB; Initial
> Catalog=ATL_SPC1;
> > UserID=blah; Password=blah"
> >
> > Thomas Bellavia
> > Software Engineering
> > -----Original Message-----
> > From: Sasi Vellolil [mailto:sasiv@a...]
> > Sent: Thursday, November 14, 2002 7:56 PM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] ADO and SQL server
> >
> > am working on W2K with IIS 5.0 and ODBC installed.
> > Created and ASP page using vb script and need to acces Network server
> > hosting SQL database.
> >
> > ATL_SPC1 is the name of the server.
> > webleads_data.mdf is the database I am trying to access
> >
> > My questions are regarding how to specify the DATA SOURCE and how
> > to use open?
> >
> > Do I need to map the remote server in my local machine?
> > If not how to specify the path for the data source?
> > When using open, how specify the parameter?
> > When I try the follwin code I get :
> >
> > Microsoft JET Database Engine (0x80004005)
> > Could not find file 'C:\WINNT\system32\Webleads_data'.
> > /Update/autoversioncheck.asp, line 19
> >
> > Line 19 is: conn.open Webleads_data:
> >
> > Any help will be greatly appreciated.
> >
> > Thanks
> > Sasi
> >
> > set conn = Server.CreateObject("ADODB.Connection")
> > conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
> > \Webleads_data.mdf"
> >
> > conn.open "Webleads_data"
> >
> > set rs = Server.CreateObject("ADODB.recordset")
> > conn.Open "Select * from RegDiagUpdates",conn
> >
> > rs.close
> > conn.close
> >
> >
> >
> >
> >
> >
>
>
>
Message #9 by Thomas Bellavia <TBellavia@V...> on Fri, 15 Nov 2002 14:31:20 -0500
|
|
Change your open string to: "Provider=SQLOLEDB; Data Source=ATL_SPC1;Initial
Catalog=webleads_data;UserID=sasiv; Password=atchan"
I'm assuming that the catalog name is 'webleads_data'. This you will have to
check on your own.
Thomas Bellavia
Software Engineering
-----Original Message-----
From: Sasi Vellolil [mailto:sasiv@a...]
Sent: Friday, November 15, 2002 12:23 PM
To: ActiveX_Data_Objects
Subject: [activex_data_objects] RE: ADO and SQL server
I can access the server and the database through MSAccess installed on my
W2K
> -----Original Message-----
> From: Thomas Bellavia [SMTP:TBellavia@V...]
> Sent: Friday, November 15, 2002 11:57 AM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Sounds like the SQL server cannot be accessed from that computer.
>
>
> Thomas Bellavia
> Software Engineering
>
> -----Original Message-----
> From: Sasi Vellolil [mailto:sasiv@a...]
> Sent: Friday, November 15, 2002 11:52 AM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Dear Thomas,
>
> Thank you so much for your help.
>
> I tried out what you suggested.
> It is still not working.
>
> The error message now is:
>
> Microsoft OLE DB provider for SQL server( 0x80004005)
> [DBNMPNTW]Specified SQL server not found
> line 20
>
> set conn = Server.CreateObject("ADODB.Connection")
> conn.Provider="SQLOLEDB;Initial Catalog=ATL_SPC1;UserID=sasiv;
> Password=atchan"
> conn.open "Webleads_data " 'line20
>
> Please help me.
>
> Thanks
> Sasi
>
>
>
> > -----Original Message-----
> > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > Sent: Friday, November 15, 2002 9:17 AM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: ADO and SQL server
> >
> > Change your open string to: "Provider=SQLOLEDB; Initial
> Catalog=ATL_SPC1;
> > UserID=blah; Password=blah"
> >
> > Thomas Bellavia
> > Software Engineering
> > -----Original Message-----
> > From: Sasi Vellolil [mailto:sasiv@a...]
> > Sent: Thursday, November 14, 2002 7:56 PM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] ADO and SQL server
> >
> > am working on W2K with IIS 5.0 and ODBC installed.
> > Created and ASP page using vb script and need to acces Network server
> > hosting SQL database.
> >
> > ATL_SPC1 is the name of the server.
> > webleads_data.mdf is the database I am trying to access
> >
> > My questions are regarding how to specify the DATA SOURCE and how
> > to use open?
> >
> > Do I need to map the remote server in my local machine?
> > If not how to specify the path for the data source?
> > When using open, how specify the parameter?
> > When I try the follwin code I get :
> >
> > Microsoft JET Database Engine (0x80004005)
> > Could not find file 'C:\WINNT\system32\Webleads_data'.
> > /Update/autoversioncheck.asp, line 19
> >
> > Line 19 is: conn.open Webleads_data:
> >
> > Any help will be greatly appreciated.
> >
> > Thanks
> > Sasi
> >
> > set conn = Server.CreateObject("ADODB.Connection")
> > conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
> > \Webleads_data.mdf"
> >
> > conn.open "Webleads_data"
> >
> > set rs = Server.CreateObject("ADODB.recordset")
> > conn.Open "Select * from RegDiagUpdates",conn
> >
> > rs.close
> > conn.close
> >
> >
> >
> >
> >
> >
>
>
>
Message #10 by Sasi Vellolil <sasiv@a...> on Fri, 15 Nov 2002 14:52:37 -0500
|
|
Thomas'
It is getting better.
I changed the code to:
conn.open " Provider=SQLOLEDB;Data Source =ATL_SPC1;Initial
Catalog=Webleads_data;UserID=sasiv;Password=atchan"
Now the error message is:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'IUSR_SASIVELLOLIL'.
I can connect to this database with MSaccess(same userId and Pwd) on the
same sytem where I have this ASP page.
Thanks
sasi
> -----Original Message-----
> From: Thomas Bellavia [SMTP:TBellavia@V...]
> Sent: Friday, November 15, 2002 2:31 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Change your open string to: "Provider=SQLOLEDB; Data
> Source=ATL_SPC1;Initial
> Catalog=webleads_data;UserID=sasiv; Password=atchan"
> I'm assuming that the catalog name is 'webleads_data'. This you will have
> to
> check on your own.
>
> Thomas Bellavia
> Software Engineering
> -----Original Message-----
> From: Sasi Vellolil [mailto:sasiv@a...]
> Sent: Friday, November 15, 2002 12:23 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> I can access the server and the database through MSAccess installed on my
> W2K
>
> > -----Original Message-----
> > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > Sent: Friday, November 15, 2002 11:57 AM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: ADO and SQL server
> >
> > Sounds like the SQL server cannot be accessed from that computer.
> >
> >
> > Thomas Bellavia
> > Software Engineering
> >
> > -----Original Message-----
> > From: Sasi Vellolil [mailto:sasiv@a...]
> > Sent: Friday, November 15, 2002 11:52 AM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: ADO and SQL server
> >
> > Dear Thomas,
> >
> > Thank you so much for your help.
> >
> > I tried out what you suggested.
> > It is still not working.
> >
> > The error message now is:
> >
> > Microsoft OLE DB provider for SQL server( 0x80004005)
> > [DBNMPNTW]Specified SQL server not found
> > line 20
> >
> > set conn = Server.CreateObject("ADODB.Connection")
> > conn.Provider="SQLOLEDB;Initial Catalog=ATL_SPC1;UserID=sasiv;
> > Password=atchan"
> > conn.open "Webleads_data " 'line20
> >
> > Please help me.
> >
> > Thanks
> > Sasi
> >
> >
> >
> > > -----Original Message-----
> > > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > > Sent: Friday, November 15, 2002 9:17 AM
> > > To: ActiveX_Data_Objects
> > > Subject: [activex_data_objects] RE: ADO and SQL server
> > >
> > > Change your open string to: "Provider=SQLOLEDB; Initial
> > Catalog=ATL_SPC1;
> > > UserID=blah; Password=blah"
> > >
> > > Thomas Bellavia
> > > Software Engineering
> > > -----Original Message-----
> > > From: Sasi Vellolil [mailto:sasiv@a...]
> > > Sent: Thursday, November 14, 2002 7:56 PM
> > > To: ActiveX_Data_Objects
> > > Subject: [activex_data_objects] ADO and SQL server
> > >
> > > am working on W2K with IIS 5.0 and ODBC installed.
> > > Created and ASP page using vb script and need to acces Network server
> > > hosting SQL database.
> > >
> > > ATL_SPC1 is the name of the server.
> > > webleads_data.mdf is the database I am trying to access
> > >
> > > My questions are regarding how to specify the DATA SOURCE and how
> > > to use open?
> > >
> > > Do I need to map the remote server in my local machine?
> > > If not how to specify the path for the data source?
> > > When using open, how specify the parameter?
> > > When I try the follwin code I get :
> > >
> > > Microsoft JET Database Engine (0x80004005)
> > > Could not find file 'C:\WINNT\system32\Webleads_data'.
> > > /Update/autoversioncheck.asp, line 19
> > >
> > > Line 19 is: conn.open Webleads_data:
> > >
> > > Any help will be greatly appreciated.
> > >
> > > Thanks
> > > Sasi
> > >
> > > set conn = Server.CreateObject("ADODB.Connection")
> > > conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
> > > \Webleads_data.mdf"
> > >
> > > conn.open "Webleads_data"
> > >
> > > set rs = Server.CreateObject("ADODB.recordset")
> > > conn.Open "Select * from RegDiagUpdates",conn
> > >
> > > rs.close
> > > conn.close
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
Message #11 by Thomas Bellavia <TBellavia@V...> on Fri, 15 Nov 2002 14:51:28 -0500
|
|
Time to do some database administration tasks with permissions and such
Thomas Bellavia
Software Engineering
-----Original Message-----
From: Sasi Vellolil [mailto:sasiv@a...]
Sent: Friday, November 15, 2002 2:53 PM
To: ActiveX_Data_Objects
Subject: [activex_data_objects] RE: ADO and SQL server
Thomas'
It is getting better.
I changed the code to:
conn.open " Provider=SQLOLEDB;Data Source =ATL_SPC1;Initial
Catalog=Webleads_data;UserID=sasiv;Password=atchan"
Now the error message is:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'IUSR_SASIVELLOLIL'.
I can connect to this database with MSaccess(same userId and Pwd) on the
same sytem where I have this ASP page.
Thanks
sasi
> -----Original Message-----
> From: Thomas Bellavia [SMTP:TBellavia@V...]
> Sent: Friday, November 15, 2002 2:31 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Change your open string to: "Provider=SQLOLEDB; Data
> Source=ATL_SPC1;Initial
> Catalog=webleads_data;UserID=sasiv; Password=atchan"
> I'm assuming that the catalog name is 'webleads_data'. This you will have
> to
> check on your own.
>
> Thomas Bellavia
> Software Engineering
> -----Original Message-----
> From: Sasi Vellolil [mailto:sasiv@a...]
> Sent: Friday, November 15, 2002 12:23 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> I can access the server and the database through MSAccess installed on my
> W2K
>
> > -----Original Message-----
> > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > Sent: Friday, November 15, 2002 11:57 AM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: ADO and SQL server
> >
> > Sounds like the SQL server cannot be accessed from that computer.
> >
> >
> > Thomas Bellavia
> > Software Engineering
> >
> > -----Original Message-----
> > From: Sasi Vellolil [mailto:sasiv@a...]
> > Sent: Friday, November 15, 2002 11:52 AM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: ADO and SQL server
> >
> > Dear Thomas,
> >
> > Thank you so much for your help.
> >
> > I tried out what you suggested.
> > It is still not working.
> >
> > The error message now is:
> >
> > Microsoft OLE DB provider for SQL server( 0x80004005)
> > [DBNMPNTW]Specified SQL server not found
> > line 20
> >
> > set conn = Server.CreateObject("ADODB.Connection")
> > conn.Provider="SQLOLEDB;Initial Catalog=ATL_SPC1;UserID=sasiv;
> > Password=atchan"
> > conn.open "Webleads_data " 'line20
> >
> > Please help me.
> >
> > Thanks
> > Sasi
> >
> >
> >
> > > -----Original Message-----
> > > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > > Sent: Friday, November 15, 2002 9:17 AM
> > > To: ActiveX_Data_Objects
> > > Subject: [activex_data_objects] RE: ADO and SQL server
> > >
> > > Change your open string to: "Provider=SQLOLEDB; Initial
> > Catalog=ATL_SPC1;
> > > UserID=blah; Password=blah"
> > >
> > > Thomas Bellavia
> > > Software Engineering
> > > -----Original Message-----
> > > From: Sasi Vellolil [mailto:sasiv@a...]
> > > Sent: Thursday, November 14, 2002 7:56 PM
> > > To: ActiveX_Data_Objects
> > > Subject: [activex_data_objects] ADO and SQL server
> > >
> > > am working on W2K with IIS 5.0 and ODBC installed.
> > > Created and ASP page using vb script and need to acces Network server
> > > hosting SQL database.
> > >
> > > ATL_SPC1 is the name of the server.
> > > webleads_data.mdf is the database I am trying to access
> > >
> > > My questions are regarding how to specify the DATA SOURCE and how
> > > to use open?
> > >
> > > Do I need to map the remote server in my local machine?
> > > If not how to specify the path for the data source?
> > > When using open, how specify the parameter?
> > > When I try the follwin code I get :
> > >
> > > Microsoft JET Database Engine (0x80004005)
> > > Could not find file 'C:\WINNT\system32\Webleads_data'.
> > > /Update/autoversioncheck.asp, line 19
> > >
> > > Line 19 is: conn.open Webleads_data:
> > >
> > > Any help will be greatly appreciated.
> > >
> > > Thanks
> > > Sasi
> > >
> > > set conn = Server.CreateObject("ADODB.Connection")
> > > conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
> > > \Webleads_data.mdf"
> > >
> > > conn.open "Webleads_data"
> > >
> > > set rs = Server.CreateObject("ADODB.recordset")
> > > conn.Open "Select * from RegDiagUpdates",conn
> > >
> > > rs.close
> > > conn.close
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
Message #12 by Sasi Vellolil <sasiv@a...> on Fri, 15 Nov 2002 15:11:29 -0500
|
|
I think I have the permission to access the database.
The reason I am saying this is because I can access the database from
MSaccess.
Does the Administrator need to setup anything special for access from ASP?
I have alreday talked to the DB administrator for access and he has set up
the
account with the user name and password .
Sorry to keep bothering you. I don't have anybody here with ASP/database
knowledge and
I need to get this connection working as soon as possible so that I can
proceed with the rest
of the ASP page development. I am stuck and you were the only one that has
provided some hope
so far.
Regards
Sasi
> -----Original Message-----
> From: Thomas Bellavia [SMTP:TBellavia@V...]
> Sent: Friday, November 15, 2002 2:51 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Time to do some database administration tasks with permissions and such
>
>
> Thomas Bellavia
> Software Engineering
>
> -----Original Message-----
> From: Sasi Vellolil [mailto:sasiv@a...]
> Sent: Friday, November 15, 2002 2:53 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Thomas'
>
> It is getting better.
>
> I changed the code to:
>
> conn.open " Provider=SQLOLEDB;Data Source =ATL_SPC1;Initial
> Catalog=Webleads_data;UserID=sasiv;Password=atchan"
>
> Now the error message is:
>
> Microsoft OLE DB Provider for SQL Server (0x80040E4D)
> Login failed for user 'IUSR_SASIVELLOLIL'.
>
> I can connect to this database with MSaccess(same userId and Pwd) on the
> same sytem where I have this ASP page.
>
> Thanks
> sasi
>
> > -----Original Message-----
> > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > Sent: Friday, November 15, 2002 2:31 PM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: ADO and SQL server
> >
> > Change your open string to: "Provider=SQLOLEDB; Data
> > Source=ATL_SPC1;Initial
> > Catalog=webleads_data;UserID=sasiv; Password=atchan"
> > I'm assuming that the catalog name is 'webleads_data'. This you will
> have
> > to
> > check on your own.
> >
> > Thomas Bellavia
> > Software Engineering
> > -----Original Message-----
> > From: Sasi Vellolil [mailto:sasiv@a...]
> > Sent: Friday, November 15, 2002 12:23 PM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: ADO and SQL server
> >
> > I can access the server and the database through MSAccess installed on
> my
> > W2K
> >
> > > -----Original Message-----
> > > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > > Sent: Friday, November 15, 2002 11:57 AM
> > > To: ActiveX_Data_Objects
> > > Subject: [activex_data_objects] RE: ADO and SQL server
> > >
> > > Sounds like the SQL server cannot be accessed from that computer.
> > >
> > >
> > > Thomas Bellavia
> > > Software Engineering
> > >
> > > -----Original Message-----
> > > From: Sasi Vellolil [mailto:sasiv@a...]
> > > Sent: Friday, November 15, 2002 11:52 AM
> > > To: ActiveX_Data_Objects
> > > Subject: [activex_data_objects] RE: ADO and SQL server
> > >
> > > Dear Thomas,
> > >
> > > Thank you so much for your help.
> > >
> > > I tried out what you suggested.
> > > It is still not working.
> > >
> > > The error message now is:
> > >
> > > Microsoft OLE DB provider for SQL server( 0x80004005)
> > > [DBNMPNTW]Specified SQL server not found
> > > line 20
> > >
> > > set conn = Server.CreateObject("ADODB.Connection")
> > > conn.Provider="SQLOLEDB;Initial Catalog=ATL_SPC1;UserID=sasiv;
> > > Password=atchan"
> > > conn.open "Webleads_data " 'line20
> > >
> > > Please help me.
> > >
> > > Thanks
> > > Sasi
> > >
> > >
> > >
> > > > -----Original Message-----
> > > > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > > > Sent: Friday, November 15, 2002 9:17 AM
> > > > To: ActiveX_Data_Objects
> > > > Subject: [activex_data_objects] RE: ADO and SQL server
> > > >
> > > > Change your open string to: "Provider=SQLOLEDB; Initial
> > > Catalog=ATL_SPC1;
> > > > UserID=blah; Password=blah"
> > > >
> > > > Thomas Bellavia
> > > > Software Engineering
> > > > -----Original Message-----
> > > > From: Sasi Vellolil [mailto:sasiv@a...]
> > > > Sent: Thursday, November 14, 2002 7:56 PM
> > > > To: ActiveX_Data_Objects
> > > > Subject: [activex_data_objects] ADO and SQL server
> > > >
> > > > am working on W2K with IIS 5.0 and ODBC installed.
> > > > Created and ASP page using vb script and need to acces Network
> server
> > > > hosting SQL database.
> > > >
> > > > ATL_SPC1 is the name of the server.
> > > > webleads_data.mdf is the database I am trying to access
> > > >
> > > > My questions are regarding how to specify the DATA SOURCE and how
> > > > to use open?
> > > >
> > > > Do I need to map the remote server in my local machine?
> > > > If not how to specify the path for the data source?
> > > > When using open, how specify the parameter?
> > > > When I try the follwin code I get :
> > > >
> > > > Microsoft JET Database Engine (0x80004005)
> > > > Could not find file 'C:\WINNT\system32\Webleads_data'.
> > > > /Update/autoversioncheck.asp, line 19
> > > >
> > > > Line 19 is: conn.open Webleads_data:
> > > >
> > > > Any help will be greatly appreciated.
> > > >
> > > > Thanks
> > > > Sasi
> > > >
> > > > set conn = Server.CreateObject("ADODB.Connection")
> > > > conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
> > > > \Webleads_data.mdf"
> > > >
> > > > conn.open "Webleads_data"
> > > >
> > > > set rs = Server.CreateObject("ADODB.recordset")
> > > > conn.Open "Select * from RegDiagUpdates",conn
> > > >
> > > > rs.close
> > > > conn.close
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
Message #13 by Thomas Bellavia <TBellavia@V...> on Fri, 15 Nov 2002 16:38:44 -0500
|
|
I'm not fluent in the security aspect of the SQL server and OS. If anyone
else can help, that would be great!
Thomas Bellavia
Software Engineering
-----Original Message-----
From: Sasi Vellolil [mailto:sasiv@a...]
Sent: Friday, November 15, 2002 3:11 PM
To: ActiveX_Data_Objects
Subject: [activex_data_objects] RE: ADO and SQL server
I think I have the permission to access the database.
The reason I am saying this is because I can access the database from
MSaccess.
Does the Administrator need to setup anything special for access from ASP?
I have alreday talked to the DB administrator for access and he has set up
the
account with the user name and password .
Sorry to keep bothering you. I don't have anybody here with ASP/database
knowledge and
I need to get this connection working as soon as possible so that I can
proceed with the rest
of the ASP page development. I am stuck and you were the only one that has
provided some hope
so far.
Regards
Sasi
> -----Original Message-----
> From: Thomas Bellavia [SMTP:TBellavia@V...]
> Sent: Friday, November 15, 2002 2:51 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Time to do some database administration tasks with permissions and such
>
>
> Thomas Bellavia
> Software Engineering
>
> -----Original Message-----
> From: Sasi Vellolil [mailto:sasiv@a...]
> Sent: Friday, November 15, 2002 2:53 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> Thomas'
>
> It is getting better.
>
> I changed the code to:
>
> conn.open " Provider=SQLOLEDB;Data Source =ATL_SPC1;Initial
> Catalog=Webleads_data;UserID=sasiv;Password=atchan"
>
> Now the error message is:
>
> Microsoft OLE DB Provider for SQL Server (0x80040E4D)
> Login failed for user 'IUSR_SASIVELLOLIL'.
>
> I can connect to this database with MSaccess(same userId and Pwd) on the
> same sytem where I have this ASP page.
>
> Thanks
> sasi
>
> > -----Original Message-----
> > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > Sent: Friday, November 15, 2002 2:31 PM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: ADO and SQL server
> >
> > Change your open string to: "Provider=SQLOLEDB; Data
> > Source=ATL_SPC1;Initial
> > Catalog=webleads_data;UserID=sasiv; Password=atchan"
> > I'm assuming that the catalog name is 'webleads_data'. This you will
> have
> > to
> > check on your own.
> >
> > Thomas Bellavia
> > Software Engineering
> > -----Original Message-----
> > From: Sasi Vellolil [mailto:sasiv@a...]
> > Sent: Friday, November 15, 2002 12:23 PM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: ADO and SQL server
> >
> > I can access the server and the database through MSAccess installed on
> my
> > W2K
> >
> > > -----Original Message-----
> > > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > > Sent: Friday, November 15, 2002 11:57 AM
> > > To: ActiveX_Data_Objects
> > > Subject: [activex_data_objects] RE: ADO and SQL server
> > >
> > > Sounds like the SQL server cannot be accessed from that computer.
> > >
> > >
> > > Thomas Bellavia
> > > Software Engineering
> > >
> > > -----Original Message-----
> > > From: Sasi Vellolil [mailto:sasiv@a...]
> > > Sent: Friday, November 15, 2002 11:52 AM
> > > To: ActiveX_Data_Objects
> > > Subject: [activex_data_objects] RE: ADO and SQL server
> > >
> > > Dear Thomas,
> > >
> > > Thank you so much for your help.
> > >
> > > I tried out what you suggested.
> > > It is still not working.
> > >
> > > The error message now is:
> > >
> > > Microsoft OLE DB provider for SQL server( 0x80004005)
> > > [DBNMPNTW]Specified SQL server not found
> > > line 20
> > >
> > > set conn = Server.CreateObject("ADODB.Connection")
> > > conn.Provider="SQLOLEDB;Initial Catalog=ATL_SPC1;UserID=sasiv;
> > > Password=atchan"
> > > conn.open "Webleads_data " 'line20
> > >
> > > Please help me.
> > >
> > > Thanks
> > > Sasi
> > >
> > >
> > >
> > > > -----Original Message-----
> > > > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > > > Sent: Friday, November 15, 2002 9:17 AM
> > > > To: ActiveX_Data_Objects
> > > > Subject: [activex_data_objects] RE: ADO and SQL server
> > > >
> > > > Change your open string to: "Provider=SQLOLEDB; Initial
> > > Catalog=ATL_SPC1;
> > > > UserID=blah; Password=blah"
> > > >
> > > > Thomas Bellavia
> > > > Software Engineering
> > > > -----Original Message-----
> > > > From: Sasi Vellolil [mailto:sasiv@a...]
> > > > Sent: Thursday, November 14, 2002 7:56 PM
> > > > To: ActiveX_Data_Objects
> > > > Subject: [activex_data_objects] ADO and SQL server
> > > >
> > > > am working on W2K with IIS 5.0 and ODBC installed.
> > > > Created and ASP page using vb script and need to acces Network
> server
> > > > hosting SQL database.
> > > >
> > > > ATL_SPC1 is the name of the server.
> > > > webleads_data.mdf is the database I am trying to access
> > > >
> > > > My questions are regarding how to specify the DATA SOURCE and how
> > > > to use open?
> > > >
> > > > Do I need to map the remote server in my local machine?
> > > > If not how to specify the path for the data source?
> > > > When using open, how specify the parameter?
> > > > When I try the follwin code I get :
> > > >
> > > > Microsoft JET Database Engine (0x80004005)
> > > > Could not find file 'C:\WINNT\system32\Webleads_data'.
> > > > /Update/autoversioncheck.asp, line 19
> > > >
> > > > Line 19 is: conn.open Webleads_data:
> > > >
> > > > Any help will be greatly appreciated.
> > > >
> > > > Thanks
> > > > Sasi
> > > >
> > > > set conn = Server.CreateObject("ADODB.Connection")
> > > > conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
> > > > \Webleads_data.mdf"
> > > >
> > > > conn.open "Webleads_data"
> > > >
> > > > set rs = Server.CreateObject("ADODB.recordset")
> > > > conn.Open "Select * from RegDiagUpdates",conn
> > > >
> > > > rs.close
> > > > conn.close
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
Message #14 by Sasi Vellolil <sasiv@a...> on Fri, 15 Nov 2002 17:11:35 -0500
|
|
Thomas,
Thanks for all the help.
I found out what was happening.
http://www.webmasterworld.com/forum47/217.htm
"In IIS, each user who hits a web page is logging into the server as
IUSR_<computername>, where <computername> is the name of your computer. You
need to give this user permissions to access your your sql server database."
So I had to have the DB administrator setup an account with
IUSR_SASIVELLOLIL as the userID
And I changed the string as follows and it worked!!!
conn.open " Provider=SQLOLEDB;Data Source =ATL_SPC1;Initial
Catalog=Webleads_data;UserID=IUSR_SASIVELLOLIL;Password=atchan"
A million thanks to you and Paul for getting me this far.
Regards
Sasi vellolil
> -----Original Message-----
> From: Thomas Bellavia [SMTP:TBellavia@V...]
> Sent: Friday, November 15, 2002 4:39 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> I'm not fluent in the security aspect of the SQL server and OS. If anyone
> else can help, that would be great!
>
>
> Thomas Bellavia
> Software Engineering
> -----Original Message-----
> From: Sasi Vellolil [mailto:sasiv@a...]
> Sent: Friday, November 15, 2002 3:11 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: ADO and SQL server
>
> I think I have the permission to access the database.
> The reason I am saying this is because I can access the database from
> MSaccess.
>
> Does the Administrator need to setup anything special for access from ASP?
> I have alreday talked to the DB administrator for access and he has set up
> the
> account with the user name and password .
>
> Sorry to keep bothering you. I don't have anybody here with ASP/database
> knowledge and
> I need to get this connection working as soon as possible so that I can
> proceed with the rest
> of the ASP page development. I am stuck and you were the only one that has
> provided some hope
> so far.
>
> Regards
> Sasi
>
> > -----Original Message-----
> > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > Sent: Friday, November 15, 2002 2:51 PM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: ADO and SQL server
> >
> > Time to do some database administration tasks with permissions and such
> >
> >
> > Thomas Bellavia
> > Software Engineering
> >
> > -----Original Message-----
> > From: Sasi Vellolil [mailto:sasiv@a...]
> > Sent: Friday, November 15, 2002 2:53 PM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: ADO and SQL server
> >
> > Thomas'
> >
> > It is getting better.
> >
> > I changed the code to:
> >
> > conn.open " Provider=SQLOLEDB;Data Source =ATL_SPC1;Initial
> > Catalog=Webleads_data;UserID=sasiv;Password=atchan"
> >
> > Now the error message is:
> >
> > Microsoft OLE DB Provider for SQL Server (0x80040E4D)
> > Login failed for user 'IUSR_SASIVELLOLIL'.
> >
> > I can connect to this database with MSaccess(same userId and Pwd) on the
> > same sytem where I have this ASP page.
> >
> > Thanks
> > sasi
> >
> > > -----Original Message-----
> > > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > > Sent: Friday, November 15, 2002 2:31 PM
> > > To: ActiveX_Data_Objects
> > > Subject: [activex_data_objects] RE: ADO and SQL server
> > >
> > > Change your open string to: "Provider=SQLOLEDB; Data
> > > Source=ATL_SPC1;Initial
> > > Catalog=webleads_data;UserID=sasiv; Password=atchan"
> > > I'm assuming that the catalog name is 'webleads_data'. This you will
> > have
> > > to
> > > check on your own.
> > >
> > > Thomas Bellavia
> > > Software Engineering
> > > -----Original Message-----
> > > From: Sasi Vellolil [mailto:sasiv@a...]
> > > Sent: Friday, November 15, 2002 12:23 PM
> > > To: ActiveX_Data_Objects
> > > Subject: [activex_data_objects] RE: ADO and SQL server
> > >
> > > I can access the server and the database through MSAccess installed on
> > my
> > > W2K
> > >
> > > > -----Original Message-----
> > > > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > > > Sent: Friday, November 15, 2002 11:57 AM
> > > > To: ActiveX_Data_Objects
> > > > Subject: [activex_data_objects] RE: ADO and SQL server
> > > >
> > > > Sounds like the SQL server cannot be accessed from that computer.
> > > >
> > > >
> > > > Thomas Bellavia
> > > > Software Engineering
> > > >
> > > > -----Original Message-----
> > > > From: Sasi Vellolil [mailto:sasiv@a...]
> > > > Sent: Friday, November 15, 2002 11:52 AM
> > > > To: ActiveX_Data_Objects
> > > > Subject: [activex_data_objects] RE: ADO and SQL server
> > > >
> > > > Dear Thomas,
> > > >
> > > > Thank you so much for your help.
> > > >
> > > > I tried out what you suggested.
> > > > It is still not working.
> > > >
> > > > The error message now is:
> > > >
> > > > Microsoft OLE DB provider for SQL server( 0x80004005)
> > > > [DBNMPNTW]Specified SQL server not found
> > > > line 20
> > > >
> > > > set conn = Server.CreateObject("ADODB.Connection")
> > > > conn.Provider="SQLOLEDB;Initial
> Catalog=ATL_SPC1;UserID=sasiv;
> > > > Password=atchan"
> > > > conn.open "Webleads_data " 'line20
> > > >
> > > > Please help me.
> > > >
> > > > Thanks
> > > > Sasi
> > > >
> > > >
> > > >
> > > > > -----Original Message-----
> > > > > From: Thomas Bellavia [SMTP:TBellavia@V...]
> > > > > Sent: Friday, November 15, 2002 9:17 AM
> > > > > To: ActiveX_Data_Objects
> > > > > Subject: [activex_data_objects] RE: ADO and SQL server
> > > > >
> > > > > Change your open string to: "Provider=SQLOLEDB; Initial
> > > > Catalog=ATL_SPC1;
> > > > > UserID=blah; Password=blah"
> > > > >
> > > > > Thomas Bellavia
> > > > > Software Engineering
> > > > > -----Original Message-----
> > > > > From: Sasi Vellolil [mailto:sasiv@a...]
> > > > > Sent: Thursday, November 14, 2002 7:56 PM
> > > > > To: ActiveX_Data_Objects
> > > > > Subject: [activex_data_objects] ADO and SQL server
> > > > >
> > > > > am working on W2K with IIS 5.0 and ODBC installed.
> > > > > Created and ASP page using vb script and need to acces Network
> > server
> > > > > hosting SQL database.
> > > > >
> > > > > ATL_SPC1 is the name of the server.
> > > > > webleads_data.mdf is the database I am trying to access
> > > > >
> > > > > My questions are regarding how to specify the DATA SOURCE and how
> > > > > to use open?
> > > > >
> > > > > Do I need to map the remote server in my local machine?
> > > > > If not how to specify the path for the data source?
> > > > > When using open, how specify the parameter?
> > > > > When I try the follwin code I get :
> > > > >
> > > > > Microsoft JET Database Engine (0x80004005)
> > > > > Could not find file 'C:\WINNT\system32\Webleads_data'.
> > > > > /Update/autoversioncheck.asp, line 19
> > > > >
> > > > > Line 19 is: conn.open Webleads_data:
> > > > >
> > > > > Any help will be greatly appreciated.
> > > > >
> > > > > Thanks
> > > > > Sasi
> > > > >
> > > > > set conn = Server.CreateObject("ADODB.Connection")
> > > > > conn.Provider="Microsoft.jet.OLEDB.4.0;DATASOURCE=ATL_SPC1
> > > > > \Webleads_data.mdf"
> > > > >
> > > > > conn.open "Webleads_data"
> > > > >
> > > > > set rs = Server.CreateObject("ADODB.recordset")
> > > > > conn.Open "Select * from RegDiagUpdates",conn
> > > > >
> > > > > rs.close
> > > > > conn.close
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
|
|
|
View Cart
