flipandboef
Posts: 107
|
Posted: 05/20/2008, 7:27 AM |
|
I've always used MS Access databases for my projects that were so far never a problem, as most projects did not need a huge DB..
However,
I have purchased a shopping cart (ProductCart from EarlyImpact) and like to connect to that database so I can create some reports for my own use...
The problem is: I have no idea how to setup the connection within CodeCharge
I have tried several things but it seems like there's not a real good explanation on how to connect to an external SQL database...
The information I have for the database (hosted with GoDaddy.com) that I find back in one of the files for the cart:
<%private const scCrypPass="CPHGFWTIAUENBTKZN6371670531582008421145314"
private const scDSN="Provider=sqloledb;Data Source=whsql-v24.prod.mesa1.secureserver.net,1433;Initial Catalog=STORE;User Id=USER;Password=XXXX"
private const scDB="SQL"
private const scStoreURL="http://www.MyServer.com/"%>
Can anyone help me out with this to get this connection setup in CCS?
|
|
|
TheunisP
Posts: 342
|
Posted: 05/21/2008, 5:04 AM |
|
in your connection change the type to sql server then use this as your connection string
Provider=sqloledb;Data Source=whsql-v24.prod.mesa1.secureserver.net,1433;Initial Catalog=STORE;User Id=USER;Password=XXXX
use the password & user en the authenticate also below the connection string and under server tab select same as design
|
|
|
flipandboef
Posts: 107
|
Posted: 07/02/2008, 2:44 PM |
|
Thanks for the reply Theunis,
Sorry for the late late responds.. Been out of it for a while...
I've tried your reply, but no luck so far... Guess I'm a little clueless here...
This is the info I have and tried to implement in your string:
DSN : mssql_someone.dsn (found this later on my host)
and of cos the code I took out of the cart that creates the connection:
%private const scCrypPass="CPHGFWTIAUENBTKZN6371670531582008421145314"
private const scDSN="Provider=sqloledb;Data Source=whsql-v24.prod.mesa1.secureserver.net,1433;Initial Catalog=STORE;User Id=USER;Password=XXXX"
private const scDB="SQL"
private const scStoreURL="http://www.MyServer.com/"%>
Can you help me any further with this? (or someone else perhaps?)
Also I have tried finding some documentation on how to setup a SQL connection (step-by-step) on the forum and KB, but could not find anything.... Does it exist?
|
|
|
|