473,545 Members | 1,714 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need help : DSN connection string

Tee
Hi,

I need some help here for DSN connection string.
I know it's not recommended to use DSN, even I dont like it as well ...
but for now, my situation is I am using a shared hosting. I do not have
write access to my web root folder, I have a folder specialy for database.
I am currently using access, it is just for testing purpose.

here's the info:

ms access database password : testdb
dsn name : testdb

can anyone tell me what is the connection string ?

thanks,
Tee
Nov 18 '05 #1
7 2119
You don't need write access to c:\, to use DSN-less connection strings.

To see sample connection strings, try
www.connectionstrings.com

eg,
"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=\dbdir\d bfile.mdb;User
Id=whatever;Pas sword=testdb;"
"Tee" <th*@streamyx.c om> wrote in message
news:Om******** ******@TK2MSFTN GP12.phx.gbl...
Hi,

I need some help here for DSN connection string.
I know it's not recommended to use DSN, even I dont like it as well ...
but for now, my situation is I am using a shared hosting. I do not have
write access to my web root folder, I have a folder specialy for database.
I am currently using access, it is just for testing purpose.

here's the info:

ms access database password : testdb
dsn name : testdb

can anyone tell me what is the connection string ?

thanks,
Tee

Nov 18 '05 #2
Tee
I know about DNS less connection string ... but now the problem is the
database folder is not inside the wwwroot ...
if I really have to get to that folder, I must use ../db/dbfile.mdb ...
but now another problem comes, I cannot exit the top root by using ../ ...
and if I place the database inside my wwwroot folder, I don't have write
access. I need write data to the database as well.

Thanks,
Tee
"Dino Chiesa [Microsoft]" <di****@online. microsoft.com> wrote in message
news:eP******** ******@TK2MSFTN GP11.phx.gbl...
You don't need write access to c:\, to use DSN-less connection strings.

To see sample connection strings, try
www.connectionstrings.com

eg,
"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=\dbdir\d bfile.mdb;User
Id=whatever;Pas sword=testdb;"
"Tee" <th*@streamyx.c om> wrote in message
news:Om******** ******@TK2MSFTN GP12.phx.gbl...
Hi,

I need some help here for DSN connection string.
I know it's not recommended to use DSN, even I dont like it as well ...
but for now, my situation is I am using a shared hosting. I do not have
write access to my web root folder, I have a folder specialy for database. I am currently using access, it is just for testing purpose.

here's the info:

ms access database password : testdb
dsn name : testdb

can anyone tell me what is the connection string ?

thanks,
Tee


Nov 18 '05 #3
can you not use string manipulation to build the proper folder name?
or Server.MapPath( )
or ..

Your hoster maybe has a FAQ somewhere illustrating how to do this on that
site?
-D
"Tee" <th*@streamyx.c om> wrote in message
news:eK******** ******@TK2MSFTN GP09.phx.gbl...
I know about DNS less connection string ... but now the problem is the
database folder is not inside the wwwroot ...
if I really have to get to that folder, I must use ../db/dbfile.mdb ...
but now another problem comes, I cannot exit the top root by using ../ ...
and if I place the database inside my wwwroot folder, I don't have write
access. I need write data to the database as well.

Thanks,
Tee
"Dino Chiesa [Microsoft]" <di****@online. microsoft.com> wrote in message
news:eP******** ******@TK2MSFTN GP11.phx.gbl...
You don't need write access to c:\, to use DSN-less connection strings.

To see sample connection strings, try
www.connectionstrings.com

eg,
"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=\dbdir\d bfile.mdb;User
Id=whatever;Pas sword=testdb;"
"Tee" <th*@streamyx.c om> wrote in message
news:Om******** ******@TK2MSFTN GP12.phx.gbl...
Hi,

I need some help here for DSN connection string.
I know it's not recommended to use DSN, even I dont like it as well .... but for now, my situation is I am using a shared hosting. I do not have write access to my web root folder, I have a folder specialy for database. I am currently using access, it is just for testing purpose.

here's the info:

ms access database password : testdb
dsn name : testdb

can anyone tell me what is the connection string ?

thanks,
Tee



Nov 18 '05 #4
Tee
I am using server.MapPath ... and it really dont let me exit the root by
using ../ ...

as now the the db folder & wwwroot folder are on the same level ... sorry if
you couldn't understand what I meant ...

it is, when I ftp login, I see 2 folder, wwwroot & db ...
so I cannot exit wwwroot and read data in db folder by using ../db/data.mdb
....

please help ...

thanks.


"Dino Chiesa [Microsoft]" <di****@online. microsoft.com> wrote in message
news:uc******** ******@TK2MSFTN GP11.phx.gbl...
can you not use string manipulation to build the proper folder name?
or Server.MapPath( )
or ..

Your hoster maybe has a FAQ somewhere illustrating how to do this on that
site?
-D
"Tee" <th*@streamyx.c om> wrote in message
news:eK******** ******@TK2MSFTN GP09.phx.gbl...
I know about DNS less connection string ... but now the problem is the
database folder is not inside the wwwroot ...
if I really have to get to that folder, I must use ../db/dbfile.mdb ...
but now another problem comes, I cannot exit the top root by using ../ ....
and if I place the database inside my wwwroot folder, I don't have write
access. I need write data to the database as well.

Thanks,
Tee
"Dino Chiesa [Microsoft]" <di****@online. microsoft.com> wrote in message
news:eP******** ******@TK2MSFTN GP11.phx.gbl...
You don't need write access to c:\, to use DSN-less connection strings.
To see sample connection strings, try
www.connectionstrings.com

eg,
"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=\dbdir\d bfile.mdb;User
Id=whatever;Pas sword=testdb;"
"Tee" <th*@streamyx.c om> wrote in message
news:Om******** ******@TK2MSFTN GP12.phx.gbl...
> Hi,
>
> I need some help here for DSN connection string.
> I know it's not recommended to use DSN, even I dont like it as well

... > but for now, my situation is I am using a shared hosting. I do not have > write access to my web root folder, I have a folder specialy for

database.
> I am currently using access, it is just for testing purpose.
>
> here's the info:
>
> ms access database password : testdb
> dsn name : testdb
>
> can anyone tell me what is the connection string ?
>
> thanks,
> Tee
>
>



Nov 18 '05 #5
If you are using the 1.1 version of the framework, then in help look up OBDC
Data Sources then Connections. I think this will tell you how to do want
you to do.

If you are using the 1.0 framework, you will have to download the ODBC .Net
Data provider from Microsoft at
http://msdn.microsoft.com/library/de...vframework.asp
"Tee" <th*@streamyx.c om> wrote in message
news:Om******** ******@TK2MSFTN GP12.phx.gbl...
Hi,

I need some help here for DSN connection string.
I know it's not recommended to use DSN, even I dont like it as well ...
but for now, my situation is I am using a shared hosting. I do not have
write access to my web root folder, I have a folder specialy for database.
I am currently using access, it is just for testing purpose.

here's the info:

ms access database password : testdb
dsn name : testdb

can anyone tell me what is the connection string ?

thanks,
Tee

Nov 18 '05 #6
All you need to do is find out the absolute file path the the .mdb file and
use that. Ask your hosting service if you don't know it.

--
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Tee" <th*@streamyx.c om> wrote in message
news:Og******** ******@TK2MSFTN GP11.phx.gbl...
I am using server.MapPath ... and it really dont let me exit the root by
using ../ ...

as now the the db folder & wwwroot folder are on the same level ... sorry if you couldn't understand what I meant ...

it is, when I ftp login, I see 2 folder, wwwroot & db ...
so I cannot exit wwwroot and read data in db folder by using .../db/data.mdb ...

please help ...

thanks.


"Dino Chiesa [Microsoft]" <di****@online. microsoft.com> wrote in message
news:uc******** ******@TK2MSFTN GP11.phx.gbl...
can you not use string manipulation to build the proper folder name?
or Server.MapPath( )
or ..

Your hoster maybe has a FAQ somewhere illustrating how to do this on that
site?
-D
"Tee" <th*@streamyx.c om> wrote in message
news:eK******** ******@TK2MSFTN GP09.phx.gbl...
I know about DNS less connection string ... but now the problem is the
database folder is not inside the wwwroot ...
if I really have to get to that folder, I must use ../db/dbfile.mdb .... but now another problem comes, I cannot exit the top root by using ../ ... and if I place the database inside my wwwroot folder, I don't have write access. I need write data to the database as well.

Thanks,
Tee
"Dino Chiesa [Microsoft]" <di****@online. microsoft.com> wrote in message news:eP******** ******@TK2MSFTN GP11.phx.gbl...
> You don't need write access to c:\, to use DSN-less connection strings. >
> To see sample connection strings, try
> www.connectionstrings.com
>
> eg,
> "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=\dbdir\d bfile.mdb;User
> Id=whatever;Pas sword=testdb;"
>
>
> "Tee" <th*@streamyx.c om> wrote in message
> news:Om******** ******@TK2MSFTN GP12.phx.gbl...
> > Hi,
> >
> > I need some help here for DSN connection string.
> > I know it's not recommended to use DSN, even I dont like it as

well ...
> > but for now, my situation is I am using a shared hosting. I do not

have
> > write access to my web root folder, I have a folder specialy for
database.
> > I am currently using access, it is just for testing purpose.
> >
> > here's the info:
> >
> > ms access database password : testdb
> > dsn name : testdb
> >
> > can anyone tell me what is the connection string ?
> >
> > thanks,
> > Tee
> >
> >
>
>



Nov 18 '05 #7
That should have read ODBC Data Sources

"William LaMartin" <la******@tampa bay.rr.com> wrote in message
news:Os******** ******@TK2MSFTN GP10.phx.gbl...
If you are using the 1.1 version of the framework, then in help look up OBDC Data Sources then Connections. I think this will tell you how to do want
you to do.

If you are using the 1.0 framework, you will have to download the ODBC ..Net Data provider from Microsoft at
http://msdn.microsoft.com/library/de...vframework.asp

"Tee" <th*@streamyx.c om> wrote in message
news:Om******** ******@TK2MSFTN GP12.phx.gbl...
Hi,

I need some help here for DSN connection string.
I know it's not recommended to use DSN, even I dont like it as well ...
but for now, my situation is I am using a shared hosting. I do not have
write access to my web root folder, I have a folder specialy for database. I am currently using access, it is just for testing purpose.

here's the info:

ms access database password : testdb
dsn name : testdb

can anyone tell me what is the connection string ?

thanks,
Tee


Nov 18 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
2433
by: cider123 | last post by:
I'm coding a project using the following article as reference: http://www.codeproject.com/csharp/DynamicPluginManager.asp In this type of project, plugins are loaded dynamically into a Plugin Manager. Your main application then hooks into the Plugin Manager. What I'm trying to figure out is how to impliment some form of raising
5
1333
by: roopeman | last post by:
i wrote the below code , just want got local machine application Eventlog 's message , and write to MDB.but it 's can not write the message to Mdb, somebody can check it for me? thanks! //----------------------------------------------------------------------- //Wrote by Michael April 30 2005...
6
1403
by: Chad A. Beckner | last post by:
Does anyone know how to make common database connections "common" in all aspx files? In other words, instead of creating a SQLConnection, then a DataAdapter in every ASPX file for my application, I would like to "include" them, or "import", say an ascx file. In ASP, all you needed to to was include another .asp file to do this. Many...
6
1497
by: Mike L. | last post by:
Hi, Pls, beware that I'm new to this :) I've developed several web appl, either with ASP or ASP.NET. All using SQL server as the back end. In my development environment, I have a single server running Win2K, which serves as Web Server and SQL server as well. And, since my hosting (production server) using the same config; ie: using a...
15
4570
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to communicate with a MySQL database table on a web server, from inside of my company's Access-VBA application. I know VBA pretty well but have never...
3
1352
by: thejamie | last post by:
My question: "What is the correct connection object to use in VS 2005 for a text connection?" will need some background. I am placing code at the end showing how I am reading data from a text file (comma delimited) into a dataset. My problem is that the connection object I have used in the past seems to be outdated: I want to use the...
13
5766
by: PinkBishop | last post by:
I am using VS 2005 with a formview control trying to insert a record to my access db. The data is submitted to the main table no problem, but I need to carry the catID to the bridge table CatalogImage where imgID also needs to be placed. Below is my code behind to carry the catID using the Select @@Identity and insert imgID to the bridge...
6
2968
by: zaina | last post by:
hi everybody i am nwebie in this forum but i think it is useful for me and the member are helpful my project is about connecting client with the server to start exchanging messages between them. to be more clear we process this purpose we serve this to the student in the university. how?? student will send a message that contains his...
0
7453
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7647
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7802
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7742
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5958
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3441
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3436
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1865
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
692
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.