PC Review


Reply
Thread Tools Rate Thread

Connection to database

 
 
Leyla
Guest
Posts: n/a
 
      27th Oct 2003
hi,

I have a database on our server that is used by staff via
intranet to search for clients etc.
after 2 years we upgraded our server from NT to windows
server 2003. Since the new server, I have been having
problem with the database. i.e. I can no longer get the
intranet to connect to the database anymore. It looks
like the new server is blocking it. I have tried a few
things and even under IIS we made sure that the anonymous
user can have access to the database via intranet to
retrieve information.

now please let me know what else I can do. here is the
code that connects the database to the intranet.

><%
> Set objCon = Server.CreateObject
>("ADODB.Connection")
> With objCon
> .Provider = "Microsoft.Jet.OLEDB.4.0"
> .Mode=1
> .CursorLocation = 3
> .Open "G:\IT Dept\VIA Database\VIA
>BackEnd Database\VIABackEndDatabase.mdb"
> End With
>%>


Do you think I should be doing something else?

thanks.
 
Reply With Quote
 
 
 
 
Kevin Spencer
Guest
Posts: n/a
 
      27th Oct 2003
Are you sure that the path to the database is correct?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Big Things are made up of
Lots of Little Things.

"Leyla" <(E-Mail Removed)> wrote in message
news:02a701c39cb6$7538e630$(E-Mail Removed)...
> hi,
>
> I have a database on our server that is used by staff via
> intranet to search for clients etc.
> after 2 years we upgraded our server from NT to windows
> server 2003. Since the new server, I have been having
> problem with the database. i.e. I can no longer get the
> intranet to connect to the database anymore. It looks
> like the new server is blocking it. I have tried a few
> things and even under IIS we made sure that the anonymous
> user can have access to the database via intranet to
> retrieve information.
>
> now please let me know what else I can do. here is the
> code that connects the database to the intranet.
>
> ><%
> > Set objCon = Server.CreateObject
> >("ADODB.Connection")
> > With objCon
> > .Provider = "Microsoft.Jet.OLEDB.4.0"
> > .Mode=1
> > .CursorLocation = 3
> > .Open "G:\IT Dept\VIA Database\VIA
> >BackEnd Database\VIABackEndDatabase.mdb"
> > End With
> >%>

>
> Do you think I should be doing something else?
>
> thanks.



 
Reply With Quote
 
Guest
Posts: n/a
 
      27th Oct 2003
yes the path is correct because it was working when we
had NT Server. the databse is still in the same location
on the G drive. so this is due to some security on the
server i believe.
but i don't know how. it is to do with windows 2003
server. I dont' know where to check for the security
issues.
thanks.
>-----Original Message-----
>Are you sure that the path to the database is correct?
>
>--
>HTH,
>
>Kevin Spencer
>Microsoft MVP
>..Net Developer
>http://www.takempis.com
>Big Things are made up of
>Lots of Little Things.
>
>"Leyla" <(E-Mail Removed)> wrote in message
>news:02a701c39cb6$7538e630$(E-Mail Removed)...
>> hi,
>>
>> I have a database on our server that is used by staff

via
>> intranet to search for clients etc.
>> after 2 years we upgraded our server from NT to windows
>> server 2003. Since the new server, I have been having
>> problem with the database. i.e. I can no longer get the
>> intranet to connect to the database anymore. It looks
>> like the new server is blocking it. I have tried a few
>> things and even under IIS we made sure that the

anonymous
>> user can have access to the database via intranet to
>> retrieve information.
>>
>> now please let me know what else I can do. here is the
>> code that connects the database to the intranet.
>>
>> ><%
>> > Set objCon = Server.CreateObject
>> >("ADODB.Connection")
>> > With objCon
>> > .Provider = "Microsoft.Jet.OLEDB.4.0"
>> > .Mode=1
>> > .CursorLocation = 3
>> > .Open "G:\IT Dept\VIA Database\VIA
>> >BackEnd Database\VIABackEndDatabase.mdb"
>> > End With
>> >%>

>>
>> Do you think I should be doing something else?
>>
>> thanks.

>
>
>.
>

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      27th Oct 2003
Note: Windows 2003 ships with many features disabled by default, that in
prior version where enabled by default.

For help, I suggest you post to the Windows 2003 server newsgroup.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

<(E-Mail Removed)> wrote in message
news:048e01c39cc9$d1313b50$(E-Mail Removed)...
> yes the path is correct because it was working when we
> had NT Server. the databse is still in the same location
> on the G drive. so this is due to some security on the
> server i believe.
> but i don't know how. it is to do with windows 2003
> server. I dont' know where to check for the security
> issues.
> thanks.
> >-----Original Message-----
> >Are you sure that the path to the database is correct?
> >
> >--
> >HTH,
> >
> >Kevin Spencer
> >Microsoft MVP
> >..Net Developer
> >http://www.takempis.com
> >Big Things are made up of
> >Lots of Little Things.
> >
> >"Leyla" <(E-Mail Removed)> wrote in message
> >news:02a701c39cb6$7538e630$(E-Mail Removed)...
> >> hi,
> >>
> >> I have a database on our server that is used by staff

> via
> >> intranet to search for clients etc.
> >> after 2 years we upgraded our server from NT to windows
> >> server 2003. Since the new server, I have been having
> >> problem with the database. i.e. I can no longer get the
> >> intranet to connect to the database anymore. It looks
> >> like the new server is blocking it. I have tried a few
> >> things and even under IIS we made sure that the

> anonymous
> >> user can have access to the database via intranet to
> >> retrieve information.
> >>
> >> now please let me know what else I can do. here is the
> >> code that connects the database to the intranet.
> >>
> >> ><%
> >> > Set objCon = Server.CreateObject
> >> >("ADODB.Connection")
> >> > With objCon
> >> > .Provider = "Microsoft.Jet.OLEDB.4.0"
> >> > .Mode=1
> >> > .CursorLocation = 3
> >> > .Open "G:\IT Dept\VIA Database\VIA
> >> >BackEnd Database\VIABackEndDatabase.mdb"
> >> > End With
> >> >%>
> >>
> >> Do you think I should be doing something else?
> >>
> >> thanks.

> >
> >
> >.
> >



 
Reply With Quote
 
Kevin Spencer
Guest
Posts: n/a
 
      27th Oct 2003
It looks like you're using a Mapped Drive letter. Are you sure it's the same
now?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Big Things are made up of
Lots of Little Things.

<(E-Mail Removed)> wrote in message
news:048e01c39cc9$d1313b50$(E-Mail Removed)...
> yes the path is correct because it was working when we
> had NT Server. the databse is still in the same location
> on the G drive. so this is due to some security on the
> server i believe.
> but i don't know how. it is to do with windows 2003
> server. I dont' know where to check for the security
> issues.
> thanks.
> >-----Original Message-----
> >Are you sure that the path to the database is correct?
> >
> >--
> >HTH,
> >
> >Kevin Spencer
> >Microsoft MVP
> >..Net Developer
> >http://www.takempis.com
> >Big Things are made up of
> >Lots of Little Things.
> >
> >"Leyla" <(E-Mail Removed)> wrote in message
> >news:02a701c39cb6$7538e630$(E-Mail Removed)...
> >> hi,
> >>
> >> I have a database on our server that is used by staff

> via
> >> intranet to search for clients etc.
> >> after 2 years we upgraded our server from NT to windows
> >> server 2003. Since the new server, I have been having
> >> problem with the database. i.e. I can no longer get the
> >> intranet to connect to the database anymore. It looks
> >> like the new server is blocking it. I have tried a few
> >> things and even under IIS we made sure that the

> anonymous
> >> user can have access to the database via intranet to
> >> retrieve information.
> >>
> >> now please let me know what else I can do. here is the
> >> code that connects the database to the intranet.
> >>
> >> ><%
> >> > Set objCon = Server.CreateObject
> >> >("ADODB.Connection")
> >> > With objCon
> >> > .Provider = "Microsoft.Jet.OLEDB.4.0"
> >> > .Mode=1
> >> > .CursorLocation = 3
> >> > .Open "G:\IT Dept\VIA Database\VIA
> >> >BackEnd Database\VIABackEndDatabase.mdb"
> >> > End With
> >> >%>
> >>
> >> Do you think I should be doing something else?
> >>
> >> thanks.

> >
> >
> >.
> >



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Question re: Frontpage/Database Connection (protected database) CGeek Microsoft Frontpage 2 20th Jun 2008 03:35 AM
Database Connection - Not Associated With Trusted Connection Mythran Microsoft ASP .NET 5 5th Oct 2005 11:50 PM
Creating Database Connection at runtime and writing Connection String to App.Config.. ROO Microsoft VB .NET 1 12th Apr 2005 09:19 PM
database connection lori Microsoft Access 0 5th Oct 2003 09:35 PM
DataBase connection varun varun Microsoft ASP .NET 1 7th Jul 2003 01:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:12 PM.