Is it possible to connect Flash and SQL Server with ASP?

[awinnn]

Hi,
I'm getting problem with connecting Flash and SQL Server with ASP. Most of the articles or samples on the Net is using Access not SQL Server. Anybody can give me some example or any link so that i can study on myself?
Can you help me?
Thanx in advance..

 

[wangbar]

It's basically the same process connecting to SQLServer as Access, it should just be a matter of changing the connection string within the ASP script - the actual SQL queries etc will work for both types of database.

Here's a generic SQL server connection, fill in the relevant database names, passwords etc:

strconn="Provider=sqloledb;Data Source="&DB_host&" ;Initial Catalog="&DB_name&";UID="&DB_userid&";Password="&DB_password&";"
set oConn = server.createobject("adodb.connection")
oConn.open strconn