This is a multi-part message in MIME format.

------=_NextPart_000_0001_01C1D743.98829580
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,
I am new to SQL and am trying to connect to a database , The DSN does
not seem to have a problem  when I check out the configuration how ever
when I run the code , the page always comes with  Invalid object name
'Martin"
 
This is the code I am using to connect to the DB 
Could some help out with this 
Thanks
Gordon
 
 
dim connect, rs,  connect
set connect = Server.CreateObject("ADODB.Connection")
connect.open "dsn=clint;uid=first;pwd=first;database=martin"
 
set rs = Server.CreateObject("ADODB.recordset")
 
 
 
 
sql1="Select * from martin"
 
rs.open sql1, connect