Poul Jensen
|
Posted: 03/25/2001, 10:05 AM |
|
Hi,
Still trying to test various possibilities with this tool I have
successfully uploaded the Bugtrack example using MySql & PHP.
To test the ASP language I used the same database connection string and
uploaded (to another directory) but get the following error when running
'default.asp':
'VBScript compilation error 1002 :
Syntax error
Common.asp line 22'
Checking 'Common.asp' line 22 reveals the following connection string:
strConn = "Provider=MSDASQL.1;Persist Security Info=False;User
ID=maris3;Mode=Share Deny None;Extended
Properties="DSN=marisoft-web;DB=marisoft;SERVER=www.marisoft.dk;UID=maris3;P
ORT=3306;OPTION=0;STMT=;""
The documentation from my Web-hotel states:
ConnectionString="DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://IP_ADDRES
S:3306/DATABASE_NAME};uid=MySQLUser;pwd=MySQLPassword;" set con =
Server.CreateObject("ADODB.Connection") con.open(ConnectionString)
this I translate to:
strConn="DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://194.216.113.188:33
06/marisoft};User ID=maris3;pwd=xxxxxx;Persist Security
Info=False;Mode=Share Deny None;Extended
Properties="DSN=marisoft-web;DB=marisoft;SERVER=www.marisoft.dk;UID=maris3;P
ORT=3306;OPTION=0;STMT=;""
and:
Set cn = Server.CreateObject("ADODB.Connection")
cn.open strConn, "maris3", "xxxxxx"
but I still get above error.
Back to CodeCharge I go to 'properties' 'database' and try to test the
connection. This now returns an error.
I am confused why the connection that works with 'PHP' doesn't work with
'ASP'.
If anybody got a clue I will be most gratefull
Thanks
Poul Jensen
|
|
|
CodeCharge
|
Posted: 03/26/2001, 1:48 AM |
|
> Back to CodeCharge I go to 'properties' 'database' and try to test the
> connection. This now returns an error.
CodeCharge doesn't distinguish between PHP and ASP when specifying the
database for the design phase.
In both ASP and PHP cases, on the database tab, you should be able to select
"OLE DB Provider for ODBC Drivers", then select your data source name. Your
design connection string will look like:
Provider=MSDASQL.1;Persist Security Info=False;User ID=myuserid;Data
Source=mydatabase
For server connection, please try this string for ASP:
Driver={MySQL};DATABASE=mydatabase;SERVER=mysql.myserver.com;UID=mycompany;P
WD=mypasswd
("mydatabase" should be replaced with your database name,
"mysql.myserver.com" should be replaced with your MySQL server address ,
UID/PWD = login/password)
"Poul Jensen" <developer@marisoft.dk> wrote in message
news:99lc0f$vci$1@mail.tankhill.com...
> Hi,
>
> Still trying to test various possibilities with this tool I have
> successfully uploaded the Bugtrack example using MySql & PHP.
>
> To test the ASP language I used the same database connection string and
> uploaded (to another directory) but get the following error when running
> 'default.asp':
>
> 'VBScript compilation error 1002 :
> Syntax error
> Common.asp line 22'
>
> Checking 'Common.asp' line 22 reveals the following connection string:
> strConn = "Provider=MSDASQL.1;Persist Security Info=False;User
> ID=maris3;Mode=Share Deny None;Extended
>
Properties="DSN=marisoft-web;DB=marisoft;SERVER=www.marisoft.dk;UID=maris3;P
> ORT=3306;OPTION=0;STMT=;""
>
> The documentation from my Web-hotel states:
>
ConnectionString="DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://IP_ADDRES
> S:3306/DATABASE_NAME};uid=MySQLUser;pwd=MySQLPassword;" set con =
> Server.CreateObject("ADODB.Connection") con.open(ConnectionString)
>
> this I translate to:
>
strConn="DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://194.216.113.188:33
> 06/marisoft};User ID=maris3;pwd=xxxxxx;Persist Security
> Info=False;Mode=Share Deny None;Extended
>
Properties="DSN=marisoft-web;DB=marisoft;SERVER=www.marisoft.dk;UID=maris3;P
> ORT=3306;OPTION=0;STMT=;""
>
> and:
> Set cn = Server.CreateObject("ADODB.Connection")
> cn.open strConn, "maris3", "xxxxxx"
>
> but I still get above error.
>
> Back to CodeCharge I go to 'properties' 'database' and try to test the
> connection. This now returns an error.
> I am confused why the connection that works with 'PHP' doesn't work with
> 'ASP'.
>
> If anybody got a clue I will be most gratefull
>
> Thanks
> Poul Jensen
>
>
>
>
>
|
|
|
Poul Jensen
|
Posted: 03/26/2001, 9:42 AM |
|
Thanks - will check it out.
Poul Jensen
"CodeCharge" <support@codecharge.com> skrev i en meddelelse
news:99n38n$67r$1@mail.tankhill.com...
> > Back to CodeCharge I go to 'properties' 'database' and try to test the
> > connection. This now returns an error.
>
> CodeCharge doesn't distinguish between PHP and ASP when specifying the
> database for the design phase.
> In both ASP and PHP cases, on the database tab, you should be able to
select
> "OLE DB Provider for ODBC Drivers", then select your data source name.
Your
> design connection string will look like:
> Provider=MSDASQL.1;Persist Security Info=False;User ID=myuserid;Data
> Source=mydatabase
>
> For server connection, please try this string for ASP:
>
Driver={MySQL};DATABASE=mydatabase;SERVER=mysql.myserver.com;UID=mycompany;P
> WD=mypasswd
> ("mydatabase" should be replaced with your database name,
> "mysql.myserver.com" should be replaced with your MySQL server address ,
> UID/PWD = login/password)
>
>
>
> "Poul Jensen" <developer@marisoft.dk> wrote in message
>news:99lc0f$vci$1@mail.tankhill.com...
> > Hi,
> >
> > Still trying to test various possibilities with this tool I have
> > successfully uploaded the Bugtrack example using MySql & PHP.
> >
> > To test the ASP language I used the same database connection string and
> > uploaded (to another directory) but get the following error when running
> > 'default.asp':
> >
> > 'VBScript compilation error 1002 :
> > Syntax error
> > Common.asp line 22'
> >
> > Checking 'Common.asp' line 22 reveals the following connection string:
> > strConn = "Provider=MSDASQL.1;Persist Security Info=False;User
> > ID=maris3;Mode=Share Deny None;Extended
> >
>
Properties="DSN=marisoft-web;DB=marisoft;SERVER=www.marisoft.dk;UID=maris3;P
> > ORT=3306;OPTION=0;STMT=;""
> >
> > The documentation from my Web-hotel states:
> >
>
ConnectionString="DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://IP_ADDRES
> > S:3306/DATABASE_NAME};uid=MySQLUser;pwd=MySQLPassword;" set con =
> > Server.CreateObject("ADODB.Connection") con.open(ConnectionString)
> >
> > this I translate to:
> >
>
strConn="DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://194.216.113.188:33
> > 06/marisoft};User ID=maris3;pwd=xxxxxx;Persist Security
> > Info=False;Mode=Share Deny None;Extended
> >
>
Properties="DSN=marisoft-web;DB=marisoft;SERVER=www.marisoft.dk;UID=maris3;P
> > ORT=3306;OPTION=0;STMT=;""
> >
> > and:
> > Set cn = Server.CreateObject("ADODB.Connection")
> > cn.open strConn, "maris3", "xxxxxx"
> >
> > but I still get above error.
> >
> > Back to CodeCharge I go to 'properties' 'database' and try to test the
> > connection. This now returns an error.
> > I am confused why the connection that works with 'PHP' doesn't work with
> > 'ASP'.
> >
> > If anybody got a clue I will be most gratefull
> >
> > Thanks
> > Poul Jensen
> >
> >
> >
> >
> >
>
>
|
|
|
|