connection string

[Dionísio Monteiro]

Hi there,

I have recently changed the connection string on a site that was working
perfectly.
I used an OLE DB connection with this code:

var path = Server.MapPath("/bddir");
var MM_ss_bd_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" + path
+ "\\dbfile.mdb";

and changed it to a Jet DB connection, with this code:

var path = Server.MapPath("/bddir");
var MM_ss_bd_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path
+ "\\dbfile.mdb;"

Everything seemed to work fine, until yesterday, when the client told he
couldn't insert information on one of the tables of the BD.
In fact, changing the connection string, the insert (and update)
functionality now returns an error on that particular table:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/Scripts/agenda-ins.asp, line 97

Line 97 is where the behaviour tryes to execute the query.

The strange thing is that it only happens on this page. I'm using the same
insert functionality on other pages and it works fine.

The query it executes is simple:

insert into agenda (categoriaID,local,texto) values
('seae','wqerwer','rwwqer')

The table agenda has the following structure:

agendaID: autonumber
categoriaID: text
data: date
local: text
texto:texto

Note: field 'data' is not necessary.

Does anyboy have a clew?

Thanx
dio

[Bob Barrows]

I doubt this has anything to do with your connection string.

You need to show some code. Are you building a dynamic sql statement (ugh!),
or running a saved query (recommended)?

If you are using dynamic sql, you will need to response.write the variable
containing the sql statement so you can see what you are sending to the
query engine.

Bob Barrows

Dionísio Monteiro wrote:

> Hi there,
>
> I have recently changed the connection string on a site that was
> working perfectly.
> I used an OLE DB connection with this code:
>
> var path = Server.MapPath("/bddir");
> var MM_ss_bd_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="
> + path + "\\dbfile.mdb";
>
> and changed it to a Jet DB connection, with this code:
>
> var path = Server.MapPath("/bddir");
> var MM_ss_bd_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
> + path + "\\dbfile.mdb;"
>
> Everything seemed to work fine, until yesterday, when the client told
> he couldn't insert information on one of the tables of the BD.
> In fact, changing the connection string, the insert (and update)
> functionality now returns an error on that particular table:
> Microsoft JET Database Engine error '80040e14'
> Syntax error in INSERT INTO statement.
> /Scripts/agenda-ins.asp, line 97
>
> Line 97 is where the behaviour tryes to execute the query.
>
> The strange thing is that it only happens on this page. I'm using the
> same insert functionality on other pages and it works fine.
>
> The query it executes is simple:
>
> insert into agenda (categoriaID,local,texto) values
> ('seae','wqerwer','rwwqer')
>
> The table agenda has the following structure:
>
> agendaID: autonumber
> categoriaID: text
> data: date
> local: text
> texto:texto
>
> Note: field 'data' is not necessary.
>
> Does anyboy have a clew?
>
> Thanx
> dio

[Dionísio Monteiro]

thank you, the fact that one of the DB fields was called 'local' caused the
problem. 'local' is a reserved word on Jet.OLEDB.

best regards,
dio

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:OMZWpCpgDHA.2984@TK2MSFTNGP11.phx.gbl...

> I doubt this has anything to do with your connection string.
>
> You need to show some code. Are you building a dynamic sql statement

(ugh!),

> or running a saved query (recommended)?
>
> If you are using dynamic sql, you will need to response.write the variable
> containing the sql statement so you can see what you are sending to the
> query engine.
>
> Bob Barrows
>
> Dionísio Monteiro wrote:

> > Hi there,
> >
> > I have recently changed the connection string on a site that was
> > working perfectly.
> > I used an OLE DB connection with this code:
> >
> > var path = Server.MapPath("/bddir");
> > var MM_ss_bd_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="
> > + path + "\\dbfile.mdb";
> >
> > and changed it to a Jet DB connection, with this code:
> >
> > var path = Server.MapPath("/bddir");
> > var MM_ss_bd_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
> > + path + "\\dbfile.mdb;"
> >
> > Everything seemed to work fine, until yesterday, when the client told
> > he couldn't insert information on one of the tables of the BD.
> > In fact, changing the connection string, the insert (and update)
> > functionality now returns an error on that particular table:
> > Microsoft JET Database Engine error '80040e14'
> > Syntax error in INSERT INTO statement.
> > /Scripts/agenda-ins.asp, line 97
> >
> > Line 97 is where the behaviour tryes to execute the query.
> >
> > The strange thing is that it only happens on this page. I'm using the
> > same insert functionality on other pages and it works fine.
> >
> > The query it executes is simple:
> >
> > insert into agenda (categoriaID,local,texto) values
> > ('seae','wqerwer','rwwqer')
> >
> > The table agenda has the following structure:
> >
> > agendaID: autonumber
> > categoriaID: text
> > data: date
> > local: text
> > texto:texto
> >
> > Note: field 'data' is not necessary.
> >
> > Does anyboy have a clew?
> >
> > Thanx
> > dio

>
>
>

[John Berman]

Hi

Sorry if I'm off topic but I am a touch desperate

We make use of a mysql 4.x hosted by a third party and we use ASP to access
this data

Our Connection string looks like this:

xDb_Conn_Str="DRIVER=org.gjt.mm.mysql.Driver;URL={ jdbc:mysql://xxxxxxx/xxxxx
xx};uid=xxxxxxx;pwd=xxxxxxxxxx;"

This has worked fine for months but for some reason now we get Cannot Find
Server

I can access the Data Source using MySQL Control Center and via an ODBC
connection from my PC, using the same info thats in the connection string,
our host says nothing has changed.





Any pointers really appreciated.

Regards

John Berman

[email]John_berman@blueyonder.co.uk[/email]

[Pawe³ Janowski]

see @ [url]http://www.connectionstrings.com[/url]

--
-------
Pawel Janowski
[url]http://www.sunrise-tm.com/os_janowski.aspx[/url]

[anonymous]

I have the followng string in my web.config file.
<add key="DBConnInfo" value="Data Source=SQL01;Initial
Catalog=DatabaseName;Trusted_Connection=No;Persist
Security Info=True;User id=sa;password=password;" />
Where I am passing a user id to be connected to a sql db.
Instead of passing a user I would like to get current user
windows id pass to the string.How do I do this?

[Brock Allen]

"server=foo;database=bar;trusted_connection=tr ue;"

-Brock
DevelopMentor
[url]http://staff.develop.com/ballen[/url]

> I have the followng string in my web.config file.
> <add key="DBConnInfo" value="Data Source=SQL01;Initial
> Catalog=DatabaseName;Trusted_Connection=No;Persist
> Security Info=True;User id=sa;password=password;" />
> Where I am passing a user id to be connected to a sql db.
> Instead of passing a user I would like to get current user
> windows id pass to the string.How do I do this?