Subject | Re: [firebird-support] ASP page |
---|---|
Author | Jason Dodson |
Post date | 2005-07-28T12:19:43Z |
Im not going to do your homework for you...
... but first you need an OLEDB provider
(http://www.zstyle.dp.ua/files/ibfree5.zip).
Your connection string below is obviously an adapted string from opening
an Access database. Assuming you use the ZStyle OLEDB provider, here is
what your string may look like:
'Provider=ZStyle IBOLE Provider;Data
Source=192.168.0.100:c:\databases\mydatabase.fdb;User
ID=SomeRandomUser;Password=smackTHEbologna'
franco wrote:
... but first you need an OLEDB provider
(http://www.zstyle.dp.ua/files/ibfree5.zip).
Your connection string below is obviously an adapted string from opening
an Access database. Assuming you use the ZStyle OLEDB provider, here is
what your string may look like:
'Provider=ZStyle IBOLE Provider;Data
Source=192.168.0.100:c:\databases\mydatabase.fdb;User
ID=SomeRandomUser;Password=smackTHEbologna'
franco wrote:
> It is possibile to use lenguage ASP vbscript with firebird 1.5 ?
>
> How connetct to database and table?
>
> I test
>
> Database name Prova1
>
> Table name elenco
>
>
>
> <%
>
> Set cnHol = Server.CreateObject("ADODB.Connection")
>
> cnStHol = "driver={Firebird/InterBase driver}; dbq=" &
> Server.MapPath("prova1.fdb")
>
> cnHol.Open cnStHol,"",""
>
>
>
> Set rsCat = Server.CreateObject("ADODB.Recordset")
>
> sql = "SELECT * FROM elenco; "
>
> rsCat.Open sql, cnHol, adOpenStatic, adLockReadOnly
>
> %>
>
> someone can write me one script for connect ?
>
> many tanks
>
> Franco