sfsilks
Posts: 3
|
| Posted: 04/06/2006, 4:41 AM |
|
I am about to give up on this piece of software and find something else because I cannot get things to work properly and Support just pass the buck! So based on this I thought I would see if someone out there could actualy give me some help with the connection to the data base.
This is the info I gave to support
"what I need to know is what exactly do I need to fill in the connection folders for the database?
This is the info I have
The Template I am using is Forum, I am loading in PHP the connection string is
D:/webspace/jobs-4-bloggers.com/db/Internet.mdb"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=
The Database I have uploaded and assume is correct for this template is Internet.mdb file and is in the db folder on the web
The Data Source Name is IntranetDB
Microsoft Access File: \db \Internet.mdb
Any help would be appreciated
Regards
Stephen"
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 04/06/2006, 7:18 AM |
|
sfsilks
Try this link: http://docs.codecharge.com/studio3/html/UserGuide/Worki...Connection.html
NOTE:
- Many of us here are very supportive of the support that Yes Software gives.
- First empressions mean a lot
CONSIDER:
- Maybe your request was not clear
- Have you fully read the documentation??
|
|
|
|
jm
|
| Posted: 04/06/2006, 8:05 AM |
|
I think you over reacting I personally learning the software and I have found it is one of the most easy to work with and the most productive and learn at the same time the support is quite nice and very cleaver of solving issues as most of the times is me and nothing else. By the way I am not a programmer just a shop owner
|
|
|
|
sfsilks
Posts: 3
|
| Posted: 04/06/2006, 8:21 AM |
|
I do not think I am over reacting I also know it is me but I am obviously not as intelligent as you!!
|
|
|
|
jm
|
| Posted: 04/06/2006, 8:52 AM |
|
No please do not put your self down I am not more intelligent but perhaps more patience as I have grown older I am not here to offend you but to help and so all
others be kind, persist, patients and all will be fine trust the process
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 04/07/2006, 11:11 AM |
|
First of all, Yes Support is far from useless.
Obviously, you have never had to support software. I can tell you that what
may be overly clear to you when asking for help is meaningless to the person
on the other side. Furthermore, don't blame Yes for your lack of basic
undertsnaing of database development. CodeCharge is an extremely powerful
tool in the hands of people who have an understanding of database
development and web development. If you expect this to be a click and go,
then you are out of luck. Codecharge cannot know your webserver
configuration, etc.
To be truthful, the problem is that the information you supplied is
absolutely useless to give you a resolution.
That being said and out of the way, let me start that I, who happen to
develop commercial software and provide support to over 100 clients of our
applications, do not have enough information from yuor post to be able to
help you, so lets start a little bit of triage in the hope that we will be
able to pull the needed information from you.
1. Are you having problems in the development cycle (CodeCharge cannot
connect to the database in develoment) or when deployed.
2. You mention your target language is PHP, yet the code you supplied is
actually ASP!
In order to get your questions answered, I will make some assumptions. I
assume that your problem is on the server side.
To begin withm you are going to have to use an ODBC connection to access
your data on the webserver.
So, sart out by creating a System DSN on the web server pointing to the
database. Then, use that DSN as your datasource for the server.
Not to be rude, but don't blame Yes support for your inability to
communicate your problem and the apparent total lack of understanding of
software development. If you do not understand the underlying technologies,
you will not be able to get much done in CodeCharge or any other tool for
that matter.
|
|
|
|
cringwall
Posts: 11
|
| Posted: 04/07/2006, 1:56 PM |
|
Thanks Yes for still being nice to customers who do their homework before we call support- I don't see how you keep your cool with knuckleheads like this guy.
|
|
|
|
WKempees
|
| Posted: 04/07/2006, 3:17 PM |
|
Agreed, except to the "knucklehead".
Walter
"cringwall" <cringwall@forum.codecharge> schreef in bericht
news:24436d1f517587@news.codecharge.com...
> Thanks Yes for still being nice to customers who do their homework before
> we
> call support- I don't see how you keep your cool with knuckleheads like
> this
> guy.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
DonB
|
| Posted: 04/09/2006, 3:05 PM |
|
Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\your\own\path\Internet.mdb;Persist Security Info=False
goes in the 'User Connection String" field of the Connection dialog box. A
more complete answer could be given by one of us if you'd describe what
isn't working or what error you get. The confusing aspect of your
information is that you mention PHP, yet you give what is clearly ASP syntax
for the conneciton.
The double-edged sword of CCS is that it's ease of use grabs those with
limited knowledge of what I'll call 'basic principles' of application design
and related tools. I think CCS does require a bit of technical background
for the peripheral issues, like database connectivity, although people with
nearly zero web design experience can produce highly functional
applications.
The novice users can find getting started is more frustrating than the more
experience user would.
--
DonB
http://www.gotodon.com/ccbth
"sfsilks" <sfsilks@forum.codecharge> wrote in message
news:24434fe6722dc8@news.codecharge.com...
> I am about to give up on this piece of software and find something else
because
> I cannot get things to work properly and Support just pass the buck! So
based
> on this I thought I would see if someone out there could actualy give me
some
> help with the connection to the data base.
>
> This is the info I gave to support
>
> "what I need to know is what exactly do I need to fill in the connection
> folders for the database?
>
> This is the info I have
>
> The Template I am using is Forum, I am loading in PHP the connection
string is
>
>
> D:/webspace/jobs-4-bloggers.com/db/Internet.mdb"
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=
>
> The Database I have uploaded and assume is correct for this template is
> Internet.mdb file and is in the db folder on the web
>
> The Data Source Name is IntranetDB
> Microsoft Access File: \db \Internet.mdb
>
> Any help would be appreciated
> Regards
> Stephen"
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
marcwolf
Posts: 361
|
| Posted: 04/09/2006, 6:08 PM |
|
Hi have to agree with Donb here.
Being a professional programmer both in ASP and in Visual Basic I am often faced by the issue where someone with little skills had got Microsoft Access and has tries to build an enterproze (the Proze if for Prozac I need after fixing the mess :>) solution.
The results are pretty catastrophic and that is usually when I am called in to clean up the mess.
What I find most advantagous about CCS is not its ease of use, but rather with a few clicks I can get most of the grunt work out of the way.
Most database tables require a basic Search, List, Insert, Update set of screens. With CCS I can get these out of the way in a matter of minutes, leaving me to concerntrate on the more delicate tasks such as the business rules and speciality screens.
CCS also gives me an easy way to create a style and implementing throughout the entire application with ease.
To the unwary or the people with more basic skills - CCS seems to offer an easy path to web development but it is important to understand the foundations you are building on.
To often I am asked the very basics of "But if the user is seeing that why can they not just click and get the new information". It instantly shows that the person has little concept of a disconnected Client/Server technology which the web has been based on since inception (I won't digress into AJAX, Web 2 or other techniques I use to get around this).
With the support issue - I have been very happy with the level of support that CCS staff have given in regards to their product. BUT!! they are not there to teach the basics of web development.
Just my 2 bits worth....
Dave
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
|
|
