Question of the bizzar SQL server

[jamief]

I have fired up IIS got the SQL server running on my local PC.
I have created a new database and a new table, I would just like to connect
to it....and yes I have no idea

here is a link to a bunch of connection strings.
Can someone give me a hand...please

http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForSQLServer

Thanks
jamie

[giri]

Re: Question of the bizzar SQL server

I am not getting you, Can u be more clear on this please Jamie??

[jamief]

Re: Question of the bizzar SQL server

maybe
Im trying to get the .net (express) SQL server and visual studio up and running
on my desktop.

I have installed all the required "programs"
I started IIS (again on local PC)

I fired up SQL server manager and created a table called phonelist

I also added a few records, now I want to write an asp program to access this
table and Im not exactly sure how.

The sql server name is the default SQLEXPRESS I have security set for windows authentication mode....

I know just need to enter the connection string


its not this!

conn.ConnectionString = "driver=sqloledb; Data Source=T3; Initial Catalog=JamieFlanary; User Id=xxxxxx; Password=xxxxx" 

and i dont have the foggiest what it should be...

might be this

oConn.Open "Driver= sqloledb;" & _ 
           "Server=MyServerName;" & _
           "Database=myDatabaseName;" & _
           "Trusted_Connection=yes" 

jamie